public ActionResult ReceivePapers(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { long uid = long.Parse(TGSession.ClientInfo.UID); long cID = 0; long.TryParse(collection.Get("LegalNoteID"), out cID); var papers = collection.Get("papers"); // var legalID = collection.Get("papers"); TemplateData[] res = JsonConvert.DeserializeObject <TemplateData[]>(papers); var papersRec = from p in database.Legal_Papers where p.LegalNoteID == cID select p; foreach (var item in papersRec) { var pap = from r in res where long.Parse(r.id) == item.ID select r; if (pap.ToList().Count > 0) { Legal_Paper updPaper = database.Legal_Papers.FirstOrDefault(p => p.ID == item.ID); updPaper.IsRecived = true; database.SubmitChanges(); } } var legalNote = database.LegalNotes.FirstOrDefault(l => l.ID == cID); legalNote.LegalID = uid; var track = (from t in database.Tracks where t.ID == legalNote.TrakID select t).FirstOrDefault(); if (track != null) { track.LegalReceivDate = DateTime.Now; track.SendLegalState = 3; track.Status = 3; database.SubmitChanges(); } } var jsonObj = new { Message = "Legal Info Sended" }; return(Json(jsonObj)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj)); } }
public ActionResult SendDataToLegal(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { LegalNote upd = new LegalNote(); long cID = 0; long.TryParse(collection.Get("TrakID"), out cID); upd.TrakID = cID; upd.EmpNotes = collection.Get("EmpNotes"); var papers = collection.Get("papers"); TemplateData[] res = JsonConvert.DeserializeObject <TemplateData[]>(papers); // upd.LegalID = long.Parse(collection.Get("legalID")); upd.TrakerID = long.Parse(TGSession.ClientInfo.UID); upd.Legal_Action = collection.Get("Legal_Action"); upd.SendingDate = DateTime.Now; Track tr = database.Tracks.FirstOrDefault(t => t.ID == cID); tr.SendLegalState = 2; database.LegalNotes.InsertOnSubmit(upd); database.SubmitChanges(); foreach (var item in res) { Legal_Paper paper = new Legal_Paper(); paper.LegalNoteID = upd.ID; paper.paperName = item.text; database.Legal_Papers.InsertOnSubmit(paper); database.SubmitChanges(); } } var jsonObj = new { Message = "Legal Info Sended" }; return(Json(jsonObj)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj)); } }