HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class UserRepository : BaseRepository

    {

        public UserRepository(string connectionStr) : base(connectionStr) {}

        public IEnumerable<UserInfo> GetAllUserInfo()

        {

            string query = $@"select * from dbo.Users order by [Name]";

            return Query<UserInfo>(query);

        }

        public UserInfo GetUserInfo(string userId, string userPW)

        {

            string query = $@"

select * from dbo.Users where ID=@userId and Password=@userPW";

            return Query<UserInfo>(query, new { userId, userPW }).FirstOrDefault();

        }

    }

}