public List <Incident> GetAllIncidents()
{
List <Incident> lstIncidents = new List <Incident>();
DataTable dtAllIncidents = new DataTable();
IncidentDAL incDal = new IncidentDAL();
dtAllIncidents = incDal.RetrieveAllIncidents();
foreach (DataRow dr in dtAllIncidents.Rows)
{
Incident anIncident = new Incident();
anIncident.IncidentID = (int)dr["IncidentID"];
anIncident.CustomerID = (int)dr["CustomerID"];
anIncident.ProductCode = (string)dr["ProductCode"];
anIncident.TechID = dr["TechID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dr["TechID"]);
anIncident.DateOpened = (DateTime)dr["DateOpened"];
anIncident.DateClosed = dr["DateClosed"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["DateClosed"]);
anIncident.Title = dr["Title"].ToString();
anIncident.Description = dr["Description"].ToString();
lstIncidents.Add(anIncident);
}
return(lstIncidents);
}
public List <Incident> GetAllIncidents()
{
List <Incident> lstIncidents = new List <Incident>();
DataTable dtAllIncidents = new DataTable();
IncidentDAL incidentDAL = new IncidentDAL();
dtAllIncidents = incidentDAL.RetrieveAllIncidents();
foreach (DataRow dr in dtAllIncidents.Rows)
{
Incident incidentA = new Incident();
incidentA.IncidentID = (int)dr["IncidentID"];
incidentA.CustomerID = (int)dr["CustomerID"];
incidentA.ProductCode = dr["ProductCode"].ToString();
//Need to account for if the TechID value returns a null value.
if (dr["TechID"] == DBNull.Value)
{
incidentA.TechID = null;
}
else
{
incidentA.TechID = (int?)dr["TechID"];
}
incidentA.DateOpened = (DateTime)dr["DateOpened"];
if (dr["DateClosed"] == DBNull.Value)
{
incidentA.DateClosed = null;
}
else
{
incidentA.DateClosed = (DateTime?)dr["DateClosed"];
}
incidentA.Title = dr["Title"].ToString();
incidentA.Description = dr["Description"].ToString();
lstIncidents.Add(incidentA);
}
return(lstIncidents);
}