public IEnumerable <SelectListItem> GetTimeZone(TimeZone_VM Model)
{
var query = new TimeZoneRepository().GetData(null);
IEnumerable <SelectListItem> list = query.Select(x => new SelectListItem()
{
Text = x.Descriptions, Value = x.TimeZoneID.ToString()
}).ToList();
return(list);
}
public List <TimeZone_VM> GetData(TimeZone_VM Model)
{
var query = new List <TimeZone_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] { };
ds = db.ExecuteDataSet("GetTimeZone", par);
query = ConvertToList <TimeZone_VM>(ds.Tables[0]);
}
}
catch (Exception ex)
{
logger.Error("UOMRepository_GetData: ", ex);
throw;
}
return(query);
}
