public IEnumerable <Maintenance> GetLocations() { List <Maintenance> tickets = new List <Maintenance>(); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd; cmd = new SqlCommand("SELECT ID, Location FROM [DB].[dbo].[MaintenanceLocations];", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Maintenance Details = new Maintenance(); Details.LocationID = Convert.ToInt32(rdr["ID"]); Details.Location = rdr["Location"].ToString(); tickets.Add(Details); } } return(tickets); }
public IEnumerable <Maintenance> GetIncompleteAuditReport() { List <Maintenance> auditReport = new List <Maintenance>(); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd; cmd = new SqlCommand("SELECT distinct reportID FROM [DB].[dbo].[MaintenanceAuditTable] where Completed = 0;", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Maintenance Details = new Maintenance(); Details.ReportID = rdr["ReportID"].ToString(); auditReport.Add(Details); } } return(auditReport); }