public void UpdateMilestone(Details_Milestones _Milestones, string _UserName, string _Status)
{
try
{
IncidentEntities db = new IncidentEntities();
db = new IncidentEntities();
var varMilestone = (from x in db.Details_Milestones
where x.CarNo == _Milestones.CarNo && x.MilestoneNumber == _Milestones.MilestoneNumber
select x).FirstOrDefault();
varMilestone.Actual = _Milestones.Actual;
varMilestone.EndTime = _Milestones.EndTime;
db.SaveChanges();
CarUpdates _CarUpdates = new CarUpdates();
_CarUpdates.CarNumber = _Milestones.CarNo;
_CarUpdates.CreatedBy = _UserName;
if (_Status == "Start")
{
_CarUpdates.Details = "As of " + _Milestones.Actual.ToString() + " Milestone " + _Milestones.MilestoneNumber + " has been started";
}
else
{
_CarUpdates.Details = "As of " + _Milestones.EndTime.ToString() + " Milestone " + _Milestones.MilestoneNumber + " has been completed";
}
_CarUpdates.DateCreated = _Milestones.Actual;
db.CarUpdates.Add(_CarUpdates);
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
private void SetProposedDate()
{
try
{
Int32 intCarID = Convert.ToInt32(Request.QueryString["DtlID"]);
CarDetails objCarDetails = new CarDetails();
Details_Milestones objMileStones = new Details_Milestones();
objMileStones.CarID = intCarID;
objMileStones.Propsed = Convert.ToDateTime(txtPropDate.Text);
//objValveManipulation.Size = txtSize.Text;
//objValveManipulation.PresentStatus = txtPresentStatus.Text;
//objValveManipulation.Proposed_Status = txtProposedStatus.Text;
//objValveManipulation.Status_After_the_Activity = txtStatusAfActivity.Text;
if (objCarDetails.SetProposedDate(objMileStones) == true)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "JsFunc", "javascript:RefreshParent();", true);
}
else
{
}
}
catch (Exception err)
{
}
}
public bool SetProposedDate(Details_Milestones objMilestone)
{
try
{
IncidentEntities db = new IncidentEntities();
db = new IncidentEntities();
var varMilestone = (from x in db.Details_Milestones
where x.CarID == objMilestone.CarID
select x).FirstOrDefault();
varMilestone.Propsed = objMilestone.Propsed;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
//Created by PS2019
//Private Method to update milestone
private void UpdateMileStone(int intMilestone, DateTime dtActual, DateTime dtEndDate)
{
CarDetails objCarDetails = new CarDetails();
Details_Milestones objdtlMilestone = new Details_Milestones();
objdtlMilestone.CarNo = Convert.ToInt32(Request.QueryString["ID"].ToString());
objdtlMilestone.MilestoneNumber = intMilestone;
objdtlMilestone.Actual = dtActual;
if (dtEndDate != DateTime.Parse("1/1/0001"))
{
objdtlMilestone.EndTime = dtEndDate;
objCarDetails.UpdateMilestone(objdtlMilestone, Session["UserName"].ToString(), "Complete");
}
else
{
objCarDetails.UpdateMilestone(objdtlMilestone, Session["UserName"].ToString(), "Start");
}
grvUpdates.DataBind();
}
public bool InsertActMonitor(ActMonitor actmonitor, ref string errMsg)
{
try
{
IncidentEntities db = new IncidentEntities();
db.ActMonitors.Add(actmonitor);
db.SaveChanges();
var maxID = db.Details_Milestones.OrderByDescending(x => x.ID).FirstOrDefault().ID;
Details_Milestones milestone1 = new Details_Milestones()
{
CarNo = actmonitor.CAR_Number, MilestoneNumber = 1, ID = maxID + 1
};
Details_Milestones milestone2 = new Details_Milestones()
{
CarNo = actmonitor.CAR_Number, MilestoneNumber = 2, ID = maxID + 2
};
Details_Milestones milestone3 = new Details_Milestones()
{
CarNo = actmonitor.CAR_Number, MilestoneNumber = 3, ID = maxID + 3
};
Details_Milestones milestone4 = new Details_Milestones()
{
CarNo = actmonitor.CAR_Number, MilestoneNumber = 4, ID = maxID + 4
};
db.Details_Milestones.Add(milestone1);
db.Details_Milestones.Add(milestone2);
db.Details_Milestones.Add(milestone3);
db.Details_Milestones.Add(milestone4);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
errMsg = "Error" + e;
return(false);
}
}
//Created by PS2019
//Handle RowCommand event for MileStone grid for handling Start/Complete operation
protected void grdMilestones_RowCommand(Object sender, GridViewCommandEventArgs e)
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = grdMilestones.Rows[index];
CarDetails objCarDetails = new CarDetails();
Details_Milestones objdtlMilestone = new Details_Milestones();
Button buttonCancel = (Button)row.Cells[7].Controls[0];
Button buttonControl = (Button)row.Cells[6].Controls[0];
if (e.CommandName == "Start")
{
switch (((Button)row.Cells[6].Controls[0]).Text)
{
case "Cancel":
CancelMileStone(row.Cells[2].Text.ToString());
break;
default:
if (ViewState["MileStoneStatus"].ToString() != "Complete")
{
row.Cells[5].Text = "In progress";
row.Cells[2].Text = System.DateTime.Now.ToString();
row.Cells[4].Text = SetDuration(DateTime.Now, DateTime.Parse(row.Cells[2].Text));
((Button)row.Cells[6].Controls[0]).Text = "Cancel";
UpdateMileStone(Convert.ToInt32(row.Cells[0].Text), DateTime.Parse(row.Cells[2].Text), DateTime.Parse("1/1/0001"));
}
if (index == 0)
{
UpdateActualStartDateTime(DateTime.Parse(row.Cells[2].Text));
}
else if (index == 1)
{
((Button)grdMilestones.Rows[0].Cells[6].Controls[0]).Text = "Completed on time";
((Button)grdMilestones.Rows[0].Cells[6].Controls[0]).Enabled = false;
grdMilestones.Rows[0].Cells[3].Text = System.DateTime.Now.ToString();
grdMilestones.Rows[0].Cells[4].Text = Convert.ToString((DateTime.Parse(grdMilestones.Rows[0].Cells[3].Text) - DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text)).Seconds);
SetStatus(DateTime.Parse(grdMilestones.Rows[0].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text), 0);
UpdateMileStone(Convert.ToInt32(grdMilestones.Rows[0].Cells[0].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[3].Text));
grdMilestones.Rows[0].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[0].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text));
}
else if (index == 2)
{
((Button)grdMilestones.Rows[0].Cells[6].Controls[0]).Text = "Completed on time";
((Button)grdMilestones.Rows[0].Cells[6].Controls[0]).Enabled = false;
((Button)grdMilestones.Rows[1].Cells[6].Controls[0]).Text = "Completed on time";
((Button)grdMilestones.Rows[1].Cells[6].Controls[0]).Enabled = false;
grdMilestones.Rows[1].Cells[3].Text = System.DateTime.Now.ToString();
grdMilestones.Rows[1].Cells[4].Text = Convert.ToString((DateTime.Parse(grdMilestones.Rows[1].Cells[3].Text) - DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text)).Seconds);
SetStatus(DateTime.Parse(grdMilestones.Rows[0].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text), 0);
SetStatus(DateTime.Parse(grdMilestones.Rows[1].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text), 1);
UpdateMileStone(Convert.ToInt32(grdMilestones.Rows[1].Cells[0].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[3].Text));
grdMilestones.Rows[0].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[0].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text));
grdMilestones.Rows[1].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[1].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text));
}
else if (index == 3)
{
((Button)grdMilestones.Rows[0].Cells[6].Controls[0]).Enabled = false;
((Button)grdMilestones.Rows[1].Cells[6].Controls[0]).Enabled = false;
((Button)grdMilestones.Rows[2].Cells[6].Controls[0]).Enabled = false;
((Button)grdMilestones.Rows[3].Cells[6].Controls[0]).Text = "Complete";
SetStatus(DateTime.Parse(grdMilestones.Rows[0].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text), 0);
SetStatus(DateTime.Parse(grdMilestones.Rows[1].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text), 1);
SetStatus(DateTime.Parse(grdMilestones.Rows[2].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[2].Cells[2].Text), 2);
if (ViewState["MileStoneStatus"].ToString() == "Complete")
{
row.Cells[3].Text = System.DateTime.Now.ToString();
row.Cells[4].Text = SetDuration(DateTime.Now, DateTime.Parse(row.Cells[2].Text));
SetStatus(DateTime.Parse(grdMilestones.Rows[3].Cells[1].Text), DateTime.Parse(grdMilestones.Rows[3].Cells[2].Text), 3);
((Button)grdMilestones.Rows[3].Cells[6].Controls[0]).Enabled = false;
buttonCancel.Visible = false;
ActMonitorModel model = new ActMonitorModel();
ActMonitor objActMonitor = new ActMonitor();
int id = Convert.ToInt32(txtCarID.Text);
objActMonitor.CAR_Number = Convert.ToInt32(txtCarID.Text);
objActMonitor.Actual_Date_and_Time_of_Completion = DateTime.Parse(System.DateTime.Now.ToString());
if ((grdMilestones.Rows[0].Cells[5].Text == "Delayed") || (grdMilestones.Rows[1].Cells[5].Text == "Delayed") ||
(grdMilestones.Rows[2].Cells[5].Text == "Delayed") || (grdMilestones.Rows[3].Cells[5].Text == "Delayed"))
{
objActMonitor.Status = "Delayed";
}
else
{
objActMonitor.Status = "Completed on time";
}
UpdateMileStone(Convert.ToInt32(row.Cells[0].Text), DateTime.Parse(row.Cells[2].Text), DateTime.Parse(System.DateTime.Now.ToString()));
model.UpdateActualCompletionDateTime(id, Session["UserName"].ToString(), objActMonitor);
grvUpdates.DataBind();
disableScreen();
}
else
{
buttonCancel.Visible = true;
grdMilestones.Rows[2].Cells[3].Text = System.DateTime.Now.ToString();
grdMilestones.Rows[2].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[2].Cells[3].Text), DateTime.Parse(row.Cells[2].Text));
grdMilestones.Rows[0].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[0].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[0].Cells[2].Text));
grdMilestones.Rows[1].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[1].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[1].Cells[2].Text));
grdMilestones.Rows[2].Cells[4].Text = SetDuration(DateTime.Parse(grdMilestones.Rows[2].Cells[3].Text), DateTime.Parse(grdMilestones.Rows[2].Cells[2].Text));
UpdateMileStone(Convert.ToInt32(grdMilestones.Rows[2].Cells[0].Text), DateTime.Parse(grdMilestones.Rows[2].Cells[2].Text), DateTime.Parse(grdMilestones.Rows[2].Cells[3].Text));
ViewState["MileStoneStatus"] = "Complete";
}
}
break;
}
}
else if (e.CommandName == "Cancel")
{
CancelMileStone(row.Cells[2].Text.ToString());
}
hidTAB.Value = "#tab0default";
}
