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