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();

        }

        public bool SetUserInfo(UserInfo userInfo, DMLType dmlType)

        {

            bool isSuccess = false;

            try

            {

                using (var transaction = base.BeginTransaction())

                {

                    string query = string.Empty;

                    if (dmlType == DMLType.DELETE)

                    {

                        query = $@"delete from dbo.Users where [UID]=@UID;";

                    }

                    else

                    {

                        if (userInfo.UID == null)

                        {

                            query = $@"

insert into dbo.Users([UID], ID, [Name], RefProjectID, [Password], [Role])

values (lower(newid()), @ID, @Name, @RefProjectID, @Password, @Role);";

                        }

                        else

                        {

                            query = $@"

update dbo.Users

set    Password=@Password

,Role=@Role

where  [UID]=@UID;";

                        }

                    }

                    Execute(query, userInfo, transaction);

                    transaction.Commit();

                    isSuccess = true;

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return isSuccess;

        }

    }

}