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