private void SaveValveManipulation() { try { CarDetails objCarDetails = new CarDetails(); CarUpdates objCarUpdates = new CarUpdates(); objCarUpdates.CarNumber = Convert.ToInt32(Request.QueryString["CarID"]); objCarUpdates.CreatedBy = txtUpdateBy.Text; objCarUpdates.Details = txtDetails.Text; objCarUpdates.DateCreated = DateTime.Parse(System.DateTime.Now.ToString()); if (objCarDetails.AddNewUpdates(objCarUpdates) == true) { Page.ClientScript.RegisterStartupScript(this.GetType(), "JsFunc", "javascript:RefreshParent();", true); } else { lblErr.Text = "Error is with model"; lblErr.Visible = true; } } catch (Exception err) { lblErr.Text = "Error is " + err.ToString(); lblErr.Visible = true; } }
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; } }
public Boolean AddNewUpdates(CarUpdates _CarUpdates) { try { IncidentEntities db = new IncidentEntities(); db.CarUpdates.Add(_CarUpdates); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); throw; } }
public void UpdateActualCompletionDateTime(int id, string _UserName, ActMonitor objActMonitor) { try { IncidentEntities db = new IncidentEntities(); ActMonitor _ActMonitor = db.ActMonitors.Find(id); _ActMonitor.Actual_Date_and_Time_of_Completion = objActMonitor.Actual_Date_and_Time_of_Completion; _ActMonitor.Status = objActMonitor.Status; db.SaveChanges(); CarUpdates _CarUpdates = new CarUpdates(); _CarUpdates.CarNumber = id; _CarUpdates.CreatedBy = _UserName; _CarUpdates.Details = "As of " + objActMonitor.Actual_Date_and_Time_of_Completion.ToString() + " Car Incident has been completed"; _CarUpdates.DateCreated = objActMonitor.Actual_Date_and_Time_of_Completion; db.CarUpdates.Add(_CarUpdates); db.SaveChanges(); } catch (Exception e) { } }
public void CancelActMonitor(int id, string _UserName, ActMonitor objActMonitor) { try { IncidentEntities db = new IncidentEntities(); ActMonitor _ActMonitor = db.ActMonitors.Find(id); _ActMonitor.Status = objActMonitor.Status; _ActMonitor.Actual_Date_and_Time_of_Service_Interruption = objActMonitor.Actual_Date_and_Time_of_Service_Interruption; db.SaveChanges(); CarUpdates _CarUpdates = new CarUpdates(); _CarUpdates.CarNumber = id; _CarUpdates.CreatedBy = _UserName; _CarUpdates.Details = "As of " + objActMonitor.Actual_Date_and_Time_of_Service_Interruption.ToString() + " Car Incident has been Cancelled"; _CarUpdates.DateCreated = DateTime.Parse(objActMonitor.Actual_Date_and_Time_of_Service_Interruption); db.CarUpdates.Add(_CarUpdates); db.SaveChanges(); } catch (Exception e) { } }