// Get Master Users internal List <MasterUserEntity> GetUsersPaging(int SortOrder, int PageNumber, int PageSize, out int TotalCount) { TotalCount = 0; List <MasterUserEntity> results = new List <MasterUserEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetUsersPaging"; sproc.StoredProceduresParameter.Add(GetParam("@SortOrder", SortOrder.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PageNumber.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalCount.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output)); string outParam = ""; DataTable dt; dt = sql.ExecuteDataTableWithOutputParam(CommandType.StoredProcedure, sproc, out outParam); if (dt != null && dt.Rows.Count > 0) { results = new MasterUserAdapter().Adapt(dt); } TotalCount = Convert.ToInt32(outParam); } catch (Exception) { throw; } return(results); }
internal List <MasterUserEntity> GetAll() { List <MasterUserEntity> results = new List <MasterUserEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetUsers"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MasterUserAdapter().Adapt(dt); foreach (MasterUserEntity comp in results) { results = new MasterUserAdapter().Adapt(dt); } } } catch (Exception) { //Put log to db here throw; } return(results); }
internal MasterUserEntity Create(string username) { List <MasterUserEntity> results = new List <MasterUserEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetUserByEmail"; sproc.StoredProceduresParameter.Add(GetParam("@EmailAddress", username.ToString(), SQLServerDatatype.NvarcharDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MasterUserAdapter().Adapt(dt); foreach (MasterUserEntity comp in results) { results = new MasterUserAdapter().Adapt(dt); } } } catch (Exception) { //Put log to db here throw; } return(results.FirstOrDefault()); }
internal MasterUserEntity GetUserBySMALUser(string SSOUser) { List <MasterUserEntity> results = new List <MasterUserEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetUserBySMALUser"; sproc.StoredProceduresParameter.Add(GetParam("@SSOUser", SSOUser.ToString().Trim(), SQLServerDatatype.VarcharDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MasterUserAdapter().Adapt(dt); } } catch (Exception) { //Put log to db here throw; } return(results.FirstOrDefault()); }