public List <MasUserModel> GetMasUserList(MasUserRequestModel pMasUser = null)
{
List <MasUserModel> lUserList = new List <MasUserModel>();
try
{
if (pMasUser == null)
{
pMasUser = new MasUserRequestModel();
}
var l_sql = "select * from vw_getusers " +
" where user_cd like ( case when @p_user_cd = 0 then '%' else @p_user_cd end ) and " +
" user_nm like( case when coalesce(@p_user_nm, '') = '' or @p_user_nm = '' then '%' else concat(@p_user_nm, '%') end) ";
using (var conn = openConnection())
{
lUserList = conn.Query <MasUserModel>(l_sql, new { p_user_cd = pMasUser.USER_ID, p_user_nm = pMasUser.USER_NM }).ToList();
}
}
catch (SqlException ex)
{
throw ex;
}
return(lUserList);
}
private MasUserRequestModel Authenticate(LoginModel login)
{
try
{
MasUserRequestModel lMasUser = null;
var o = _masUserService.CheckLogin(login);
if (o.Result.Count > 0)
{
lMasUser = o.Result[0];
}
return(lMasUser);
}
catch
{
return(new MasUserRequestModel());
}
}
public async Task <List <MasUserModel> > GetMasUserList(MasUserRequestModel pMasUser)
{
return(await Task.Run(() => MasUserManager.Instance.GetMasUserList(pMasUser)));
}
