public void AddRACAPCorrespondence(int id, string commentCap, string corId, string outputFileName, int loggedInUser, int iD) { var currentHoursAndMinutes = DateTime.Now.Hour.ToString("0#") + DateTime.Now.Minute.ToString("0#") + DateTime.Now.Millisecond.ToString("0#"); RACAPPrintLetter Model = new RACAPPrintLetter(); var parentPersonalinformation = Model.GetparentPersonalinformation(id); var racapCorTable = new RACAP_Correspondence(); racapCorTable.RACAP_Correspondence_Comments = commentCap; racapCorTable.RACAP_Case_Id = id; racapCorTable.RACAP_Correspondence_Type_Id = Convert.ToInt32(corId); racapCorTable.RACAP_Correspondence_FileName = iD + "_" + Convert.ToInt32(corId) + ".pdf"; racapCorTable.RACAP_Correspondence_Date_Created = DateTime.Now; var userModel = new UserModel(); racapCorTable.RACAP_Correspondence_Created_By = loggedInUser; racapCorTable.RACAP_Correspondence_FilePath = "RACAPDocumentPath"; _db.RACAP_Correspondence.Add(racapCorTable); _db.SaveChanges(); }
public void UpdateRACAPCorrespondence(int id, string commentCap, string corId, string outputFileName, int loggedInUser, int iD) { int CId = Convert.ToInt32(corId); var racapCorTable = (from r in _db.RACAP_Correspondence where r.RACAP_Case_Id == id && r.RACAP_Correspondence_FileName == (iD + "_" + CId + ".pdf") select r).FirstOrDefault(); RACAPPrintLetter Model = new RACAPPrintLetter(); var parentPersonalinformation = Model.GetparentPersonalinformation(id); if (racapCorTable != null) { racapCorTable.RACAP_Correspondence_Comments = commentCap; racapCorTable.RACAP_Case_Id = id; racapCorTable.RACAP_Correspondence_Type_Id = Convert.ToInt32(corId); racapCorTable.RACAP_Correspondence_FileName = iD + "_" + Convert.ToInt32(corId) + ".pdf"; racapCorTable.RACAP_Correspondence_Date_Modified = DateTime.Now; racapCorTable.RACAP_Correspondence_Modified_By = loggedInUser; racapCorTable.RACAP_Correspondence_FilePath = "RACAPDocumentPath"; _db.SaveChanges(); } }