public static Task <List <Models.Lookup> > GetLookupList(LookupTypeIdEnum lookupType) { List <Models.Lookup> results = new List <Models.Lookup>(); try { SqlDataReader rdr = CommonDAL.GetQueryData(DatabaseIdEnum.QueryDataType_LookupTable, ((int)lookupType).ToString()); if (rdr != null) { while (rdr.Read()) { results.Add(new Models.Lookup { LookupId = SqlDataHelper.GetDataReaderValue <int>(rdr, "LookupId"), Descr = SqlDataHelper.GetDataReaderValue <string>(rdr, "Descr"), Value = SqlDataHelper.GetDataReaderValue <string>(rdr, "Value") }); } rdr.Close(); } } catch (Exception ex) { CommonDAL.InsertExceptionLog(DatabaseIdEnum.LogType_SiteException, SiteUtils.GetPageName(), null, ex.Message, ex.StackTrace, ((int)lookupType).ToString()); } return(Task.FromResult(results)); }
public static Task <List <ApplicationRole> > GetUserRoles(int userId) { List <ApplicationRole> roles = new List <ApplicationRole>(); try { SqlDataReader rdr = CommonDAL.GetQueryData(DatabaseIdEnum.QueryDataType_GetUserRoles, userId.ToString()); if (rdr != null) { while (rdr.Read()) { roles.Add(new ApplicationRole { Id = SqlDataHelper.GetDataReaderValue <int>(rdr, "Id"), Name = SqlDataHelper.GetDataReaderValue <string>(rdr, "Name"), Description = SqlDataHelper.GetDataReaderValue <string>(rdr, "Description") }); } rdr.Close(); } } catch (Exception ex) { CommonDAL.InsertExceptionLog(DatabaseIdEnum.LogType_SiteException, SiteUtils.GetPageName(), null, ex.Message, ex.StackTrace, userId.ToString()); } return(Task.FromResult(roles)); }