private int SaveActions(decimal incidentId, List <INCFORM_ACTION> itemList)
{
PSsqmEntities entities = new PSsqmEntities();
int status = 0;
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_ACTION WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_ACTION item in itemList)
{
var newItem = new INCFORM_ACTION();
if (!string.IsNullOrEmpty(item.ITEM_DESCRIPTION))
{
seq = seq + 1;
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_SEQ = seq;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.ASSIGNED_PERSON_ID = item.ASSIGNED_PERSON_ID;
newItem.START_DATE = item.START_DATE;
newItem.COMPLETION_DATE = item.COMPLETION_DATE;
newItem.IsCompleted = item.IsCompleted;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = DateTime.Now;
entities.AddToINCFORM_ACTION(newItem);
status = entities.SaveChanges();
DateTime dueDate = newItem.START_DATE.HasValue ? (DateTime)newItem.START_DATE : DateTime.Now.AddDays(2);
EHSIncidentMgr.CreateOrUpdateTask(incidentId, (decimal)item.ASSIGNED_PERSON_ID, 40, dueDate, item.ITEM_DESCRIPTION);
}
}
return(status);
}
public int AddUpdateINCFORM_ACTION(decimal incidentId)
{
var itemList = new List <INCFORM_ACTION>();
int seqnumber = 0;
int status = 0;
foreach (RepeaterItem containtem in rptAction.Items)
{
var item = new INCFORM_ACTION();
TextBox tbca = (TextBox)containtem.FindControl("tbFinalAction");
RadDropDownList rddlp = (RadDropDownList)containtem.FindControl("rddlActionPerson");
Label lb = (Label)containtem.FindControl("lbItemSeq");
RadDatePicker sd = (RadDatePicker)containtem.FindControl("rdpFinalStartDate");
RadDatePicker cd = (RadDatePicker)containtem.FindControl("rdpFinalCompleteDate");
CheckBox ic = (CheckBox)containtem.FindControl("cbFinalIsComplete");
seqnumber = seqnumber + 1;
item.ITEM_DESCRIPTION = tbca.Text;
item.ASSIGNED_PERSON_ID = (String.IsNullOrEmpty(rddlp.SelectedValue)) ? 0 : Convert.ToInt32(rddlp.SelectedValue);
item.ITEM_SEQ = seqnumber;
item.START_DATE = sd.SelectedDate;
item.COMPLETION_DATE = cd.SelectedDate;
item.IsCompleted = ic.Checked;
itemList.Add(item);
}
if (itemList.Count > 0)
{
status = SaveActions(incidentId, itemList);
}
return(status);
}
protected void rptAction_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandArgument == "AddAnother")
{
var itemList = new List <INCFORM_ACTION>();
int seqnumber = 0;
foreach (RepeaterItem actionitem in rptAction.Items)
{
var item = new INCFORM_ACTION();
TextBox tbca = (TextBox)actionitem.FindControl("tbFinalAction");
RadDropDownList rddlp = (RadDropDownList)actionitem.FindControl("rddlActionPerson");
Label lb = (Label)actionitem.FindControl("lbItemSeq");
RadDatePicker sd = (RadDatePicker)actionitem.FindControl("rdpFinalStartDate");
RadDatePicker cd = (RadDatePicker)actionitem.FindControl("rdpFinalCompleteDate");
CheckBox ic = (CheckBox)actionitem.FindControl("cbFinalIsComplete");
rddlp.Items.Add(new DropDownListItem("[Select One]", ""));
var personList = new List <PERSON>();
personList = SQMModelMgr.SelectPlantPersonList(SessionManager.UserContext.WorkingLocation.Company.COMPANY_ID, SessionManager.UserContext.WorkingLocation.Plant.PLANT_ID);
foreach (PERSON p in personList)
{
if (!String.IsNullOrEmpty(p.EMAIL))
{
string displayName = string.Format("{0}, {1} ({2})", p.LAST_NAME, p.FIRST_NAME, p.EMAIL);
rddlp.Items.Add(new DropDownListItem(displayName, Convert.ToString(p.PERSON_ID)));
}
}
if (!string.IsNullOrEmpty(rddlp.SelectedValue) && (rddlp.SelectedValue != "[Select One]"))
{
item.ASSIGNED_PERSON_ID = Convert.ToInt32(rddlp.SelectedValue);
}
seqnumber = Convert.ToInt32(lb.Text);
item.ITEM_DESCRIPTION = tbca.Text;
item.ITEM_SEQ = seqnumber;
item.START_DATE = sd.SelectedDate;
item.COMPLETION_DATE = cd.SelectedDate;
item.IsCompleted = ic.Checked;
itemList.Add(item);
}
var emptyItem = new INCFORM_ACTION();
emptyItem.ITEM_DESCRIPTION = "";
emptyItem.ITEM_SEQ = seqnumber + 1;
emptyItem.ASSIGNED_PERSON_ID = null;
emptyItem.START_DATE = null;
emptyItem.COMPLETION_DATE = null;
emptyItem.IsCompleted = false;
itemList.Add(emptyItem);
rptAction.DataSource = itemList;
rptAction.DataBind();
}
else if (e.CommandArgument.ToString() == "Delete")
{
int delId = e.Item.ItemIndex;
var itemList = new List <INCFORM_ACTION>();
int seqnumber = 0;
foreach (RepeaterItem actionitem in rptAction.Items)
{
var item = new INCFORM_ACTION();
TextBox tbca = (TextBox)actionitem.FindControl("tbFinalAction");
RadDropDownList rddlp = (RadDropDownList)actionitem.FindControl("rddlActionPerson");
Label lb = (Label)actionitem.FindControl("lbItemSeq");
RadDatePicker sd = (RadDatePicker)actionitem.FindControl("rdpFinalStartDate");
RadDatePicker cd = (RadDatePicker)actionitem.FindControl("rdpFinalCompleteDate");
CheckBox ic = (CheckBox)actionitem.FindControl("cbFinalIsComplete");
rddlp.Items.Add(new DropDownListItem("[Select One]", ""));
var personList = new List <PERSON>();
personList = SQMModelMgr.SelectPlantPersonList(SessionManager.UserContext.WorkingLocation.Company.COMPANY_ID, SessionManager.UserContext.WorkingLocation.Plant.PLANT_ID);
foreach (PERSON p in personList)
{
if (!String.IsNullOrEmpty(p.EMAIL))
{
string displayName = string.Format("{0}, {1} ({2})", p.LAST_NAME, p.FIRST_NAME, p.EMAIL);
rddlp.Items.Add(new DropDownListItem(displayName, Convert.ToString(p.PERSON_ID)));
}
}
if (!string.IsNullOrEmpty(rddlp.SelectedValue) && (rddlp.SelectedValue != "[Select One]"))
{
item.ASSIGNED_PERSON_ID = Convert.ToInt32(rddlp.SelectedValue);
}
if (Convert.ToInt32(lb.Text) != delId + 1)
{
seqnumber = seqnumber + 1;
item.ITEM_DESCRIPTION = tbca.Text;
item.ITEM_SEQ = seqnumber;
item.START_DATE = sd.SelectedDate;
item.COMPLETION_DATE = cd.SelectedDate;
item.IsCompleted = ic.Checked;
itemList.Add(item);
}
}
rptAction.DataSource = itemList;
rptAction.DataBind();
decimal incidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
int status = SaveActions(incidentId, itemList);
}
}
public void rptAction_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
int minRowsToValidate = 1;
try
{
INCFORM_ACTION action = (INCFORM_ACTION)e.Item.DataItem;
TextBox tbca = (TextBox)e.Item.FindControl("tbFinalAction");
RadDropDownList rddlp = (RadDropDownList)e.Item.FindControl("rddlActionPerson");
Label lb = (Label)e.Item.FindControl("lbItemSeq");
RadDatePicker sd = (RadDatePicker)e.Item.FindControl("rdpFinalStartDate");
RadDatePicker cd = (RadDatePicker)e.Item.FindControl("rdpFinalCompleteDate");
CheckBox ic = (CheckBox)e.Item.FindControl("cbFinalIsComplete");
RadButton itmdel = (RadButton)e.Item.FindControl("btnItemDelete");
RequiredFieldValidator rvfca = (RequiredFieldValidator)e.Item.FindControl("rfvFinalAction");
RequiredFieldValidator rvfcp = (RequiredFieldValidator)e.Item.FindControl("rfvActionPerson");
RequiredFieldValidator rvfsd = (RequiredFieldValidator)e.Item.FindControl("rvfFinalStartDate");
rvfca.ValidationGroup = ValidationGroup;
rvfcp.ValidationGroup = ValidationGroup;
rvfsd.ValidationGroup = ValidationGroup;
rddlp.Items.Add(new DropDownListItem("[Select One]", ""));
var personList = new List <PERSON>();
personList = SQMModelMgr.SelectPlantPersonList(SessionManager.UserContext.WorkingLocation.Company.COMPANY_ID, SessionManager.UserContext.WorkingLocation.Plant.PLANT_ID);
foreach (PERSON p in personList)
{
if (!String.IsNullOrEmpty(p.EMAIL))
{
string displayName = string.Format("{0}, {1} ({2})", p.LAST_NAME, p.FIRST_NAME, p.EMAIL);
rddlp.Items.Add(new DropDownListItem(displayName, Convert.ToString(p.PERSON_ID)));
}
}
if (action.ASSIGNED_PERSON_ID != null)
{
rddlp.SelectedValue = action.ASSIGNED_PERSON_ID.ToString();
}
lb.Text = action.ITEM_SEQ.ToString();
tbca.Text = action.ITEM_DESCRIPTION;
sd.SelectedDate = action.START_DATE;
cd.SelectedDate = action.COMPLETION_DATE;
ic.Checked = action.IsCompleted;
// Set user access:
tbca.Enabled = ActionAccess;
rddlp.Enabled = ActionAccess;
sd.Enabled = ActionAccess;
cd.Enabled = ActionAccess;
ic.Enabled = ActionAccess;
itmdel.Visible = ActionAccess;
rvfca.Enabled = ActionAccess;
rvfcp.Enabled = ActionAccess;
rvfsd.Enabled = ActionAccess;
if (action.ITEM_SEQ > minRowsToValidate)
{
rvfca.Enabled = false;
rvfcp.Enabled = false;
rvfsd.Enabled = false;
}
}
catch { }
}
if (e.Item.ItemType == ListItemType.Footer)
{
Button addanother = (Button)e.Item.FindControl("btnAddFinal");
addanother.Visible = ActionAccess;
}
}
