private List <ListItem> GetTools() { List <ListItem> items = new List <ListItem>(); using (var reader = SchedulerTool.GetAllToolsFromScheduler()) { while (reader.Read()) { items.Add(new ListItem(reader["ResourceName"].ToString(), reader["ResourceID"].ToString())); } reader.Close(); } List <ListItem> result = items.OrderBy(x => x.Text).ToList(); result.Insert(0, new ListItem("-- Select --", "0")); return(result); }
//Create the table that shows repair/maintenace status for every tool in next 7 days private void BindFutureStatusTable() { gvFuture.DataSource = SchedulerTool.GetFutureToolStatus(); gvFuture.DataBind(); }