public ActionResult AddTestOutComments(TestOutputRemarks details) { TestOutputRemarks saveComments = pdDBContext.Remarks.FirstOrDefault(d => d.TestOutputID == details.TestOutputID); //var chckRemarks = saveComments[0].Remarks; HistoricalRemarks addRemarksLogs = new HistoricalRemarks(); if (details.Remarks != null) { addRemarksLogs.GUID = System.Guid.NewGuid().ToString().ToUpper(); addRemarksLogs.Department = "TEST"; addRemarksLogs.Operation = "MovesToFG"; addRemarksLogs.ConnectorID = details.TestOutputID; addRemarksLogs.OriginalRemarks = details.Remarks; addRemarksLogs.UpdatedRemarks = null; addRemarksLogs.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); addRemarksLogs.DateAdded = DateTime.Now; pdDBContext.RemarksLogs.Attach(addRemarksLogs); pdDBContext.RemarksLogs.Add(addRemarksLogs); pdDBContext.SaveChanges(); } if (saveComments == null) { if (ModelState.IsValid) { details.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); details.DateCreated = DateTime.Now; pdDBContext.Remarks.Attach(details); pdDBContext.Remarks.Add(details); pdDBContext.SaveChanges(); } } else { return(RedirectToAction("UpdateComments", details)); } return(View()); }
public ActionResult UpdateComments(TestOutputRemarks comments) { TestOutputRemarks updateComments = pdDBContext.Remarks.FirstOrDefault(c => c.TestOutputID == comments.TestOutputID); HistoricalRemarks addRemarksLogs = new HistoricalRemarks(); if (comments.Remarks != null) { addRemarksLogs.GUID = System.Guid.NewGuid().ToString().ToUpper(); addRemarksLogs.Department = "TEST"; addRemarksLogs.Operation = "MovesToFG"; addRemarksLogs.ConnectorID = comments.TestOutputID; addRemarksLogs.UpdatedRemarks = comments.Remarks; addRemarksLogs.OriginalRemarks = updateComments.Remarks; addRemarksLogs.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); addRemarksLogs.DateAdded = DateTime.Now; pdDBContext.RemarksLogs.Attach(addRemarksLogs); pdDBContext.RemarksLogs.Add(addRemarksLogs); pdDBContext.SaveChanges(); } if (updateComments != null) { updateComments.ModifiedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); updateComments.DateModified = DateTime.Now; updateComments.Remarks = comments.Remarks; } using (var dbContext = new ProductionDashboardDBContext()) { dbContext.Entry(updateComments).State = System.Data.EntityState.Modified; dbContext.SaveChanges(); } return(View()); }
public ActionResult AddAssyOutComments(AssemblyOutputRemarks detailsAssy) { AssemblyOutputRemarks saveAssyComments = pdDBContext.AssemblyRemarks.FirstOrDefault(d => d.AssemblyOutsID == detailsAssy.AssemblyOutsID && d.Operation == detailsAssy.Operation); if (saveAssyComments == null) { HistoricalRemarks addAssyRemarksLogs = new HistoricalRemarks(); if (detailsAssy.Remarks != null) { addAssyRemarksLogs.GUID = System.Guid.NewGuid().ToString().ToUpper(); addAssyRemarksLogs.Department = "ASSEMBLY"; addAssyRemarksLogs.Operation = detailsAssy.Operation; addAssyRemarksLogs.ConnectorID = detailsAssy.AssemblyOutsID; addAssyRemarksLogs.OriginalRemarks = detailsAssy.Remarks; addAssyRemarksLogs.UpdatedRemarks = null; addAssyRemarksLogs.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); addAssyRemarksLogs.DateAdded = DateTime.Now; pdDBContext.RemarksLogs.Attach(addAssyRemarksLogs); pdDBContext.RemarksLogs.Add(addAssyRemarksLogs); pdDBContext.SaveChanges(); } detailsAssy.GUID = System.Guid.NewGuid().ToString().ToUpper(); if (ModelState.IsValid) { pdDBContext.AssemblyRemarks.Attach(detailsAssy); pdDBContext.AssemblyRemarks.Add(detailsAssy); pdDBContext.SaveChanges(); } return(Json("addSuccess", JsonRequestBehavior.AllowGet)); } else { HistoricalRemarks addAssyUpdateRemarksLogs = new HistoricalRemarks(); //HistoricalRemarks checkAssyUpdateRemarksLogs = pdDBContext.RemarksLogs.FirstOrDefault(d => d.ConnectorID == detailsAssy.AssemblyOutsID && d.Department == "ASSEMBLY"); //if (checkAssyUpdateRemarksLogs == null) //{ // addAssyUpdateRemarksLogs.OriginalRemarks = saveAssyComments.Remarks; //} //else { // addAssyUpdateRemarksLogs.OriginalRemarks = saveAssyComments.Remarks; //} if (detailsAssy.Remarks != null) { addAssyUpdateRemarksLogs.GUID = System.Guid.NewGuid().ToString().ToUpper(); addAssyUpdateRemarksLogs.Department = "ASSEMBLY"; addAssyUpdateRemarksLogs.Operation = detailsAssy.Operation; addAssyUpdateRemarksLogs.ConnectorID = detailsAssy.AssemblyOutsID; addAssyUpdateRemarksLogs.UpdatedRemarks = detailsAssy.Remarks; addAssyUpdateRemarksLogs.OriginalRemarks = saveAssyComments.Remarks; addAssyUpdateRemarksLogs.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username); addAssyUpdateRemarksLogs.DateAdded = DateTime.Now; pdDBContext.RemarksLogs.Attach(addAssyUpdateRemarksLogs); pdDBContext.RemarksLogs.Add(addAssyUpdateRemarksLogs); pdDBContext.SaveChanges(); } saveAssyComments.Remarks = detailsAssy.Remarks; saveAssyComments.ModifiedBy = detailsAssy.CreatedBy; saveAssyComments.DateModified = DateTime.Now; saveAssyComments.Operation = detailsAssy.Operation; pdDBContext.Entry(saveAssyComments).State = System.Data.EntityState.Modified; pdDBContext.SaveChanges(); return(Json("updateSuccess", JsonRequestBehavior.AllowGet)); } // return View(); }