private int SaveLostTime(decimal incidentId, List <INCFORM_LOSTTIME_HIST> itemList)
{
int status = 0;
PSsqmEntities entities = new PSsqmEntities();
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_LOSTTIME_HIST WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_LOSTTIME_HIST item in itemList)
{
var newItem = new INCFORM_LOSTTIME_HIST();
if (!String.IsNullOrEmpty(item.WORK_STATUS) && item.WORK_STATUS != "")
{
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.WORK_STATUS = item.WORK_STATUS;
newItem.BEGIN_DT = item.BEGIN_DT;
newItem.RETURN_TOWORK_DT = item.RETURN_TOWORK_DT;
newItem.NEXT_MEDAPPT_DT = item.NEXT_MEDAPPT_DT;
newItem.RETURN_EXPECTED_DT = item.RETURN_EXPECTED_DT;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ);
entities.AddToINCFORM_LOSTTIME_HIST(newItem);
status = entities.SaveChanges();
}
}
if (seq > 0)
{
EHSIncidentMgr.UpdateIncidentStatus(incidentId, IncidentStepStatus.workstatus, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
/*
* if (status > -1)
* {
* EHSNotificationMgr.NotifyIncidentStatus(WorkStatusIncident, ((int)SysPriv.update).ToString(), "Work status updated");
* }
*/
return(status);
}
private int SaveLostTime(decimal incidentId, List <INCFORM_LOSTTIME_HIST> itemList)
{
int status = 0;
PSsqmEntities entities = new PSsqmEntities();
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_LOSTTIME_HIST WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_LOSTTIME_HIST item in itemList)
{
var newItem = new INCFORM_LOSTTIME_HIST();
if (!String.IsNullOrEmpty(item.WORK_STATUS) && item.WORK_STATUS != "[Select One]")
{
seq = seq + 1;
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_SEQ = seq;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.WORK_STATUS = item.WORK_STATUS;
newItem.BEGIN_DT = item.BEGIN_DT;
newItem.RETURN_TOWORK_DT = item.RETURN_TOWORK_DT;
newItem.NEXT_MEDAPPT_DT = item.NEXT_MEDAPPT_DT;
newItem.RETURN_EXPECTED_DT = item.RETURN_EXPECTED_DT;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = DateTime.Now;
entities.AddToINCFORM_LOSTTIME_HIST(newItem);
status = entities.SaveChanges();
}
}
return(status);
}
