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