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