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();
}
