public ActionResult AddAssyOutsComments1(AssemblyOutputRemarks assyRemarks)
{
var isExistAssyRemarks = (from assyRemarks1 in pdDBContext.AssemblyRemarks
where assyRemarks1.AssemblyOutsID == assyRemarks.AssemblyOutsID
select new
{
Remarks = assyRemarks1.Remarks
}).ToList();
if (ModelState.IsValid)
{
if (isExistAssyRemarks.Count == 0)
{
AssemblyOutputRemarks addAssyRemarks = new AssemblyOutputRemarks();
addAssyRemarks.AssemblyOutsID = assyRemarks.AssemblyOutsID;
addAssyRemarks.Remarks = assyRemarks.Remarks;
addAssyRemarks.Operation = assyRemarks.Operation;
addAssyRemarks.CreatedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username);
addAssyRemarks.DateCreated = DateTime.Now;
addAssyRemarks.ModifiedBy = null;
addAssyRemarks.DateModified = null;
pdDBContext.AssemblyRemarks.Attach(addAssyRemarks);
pdDBContext.AssemblyRemarks.Add(addAssyRemarks);
pdDBContext.SaveChanges();
}
else
{
AssemblyOutputRemarks updateAssyRemarks = pdDBContext.AssemblyRemarks.FirstOrDefault(assy => assy.AssemblyOutsID == assyRemarks.AssemblyOutsID);
updateAssyRemarks.Remarks = assyRemarks.Remarks;
updateAssyRemarks.Operation = assyRemarks.Operation;
updateAssyRemarks.ModifiedBy = Common.GetWebCurrentUser(Common.WebUserInformation.Username);
updateAssyRemarks.DateModified = DateTime.Now;
pdDBContext.Entry(updateAssyRemarks).State = System.Data.EntityState.Modified;
pdDBContext.SaveChanges();
}
}
//if (addAssyRemarks == null)
//{
//}
//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());
}
