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