public void SaveDescOfWork(string desctext, int wfNumber) { DashDBContext db = new DashDBContext(); workflows wf = (from x in db.workflows where x.wfNumber == wfNumber select x).First(); wf.descofwork = desctext; db.SaveChanges(); LogWFEdits(User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1), wfNumber, "Description of work change"); return; }
public void SaveDeadlineDate(DateTime deadlineDate, int wfNumber) { DashDBContext db = new DashDBContext(); workflows wf = (from x in db.workflows where x.wfNumber == wfNumber select x).First(); wf.deadline = deadlineDate; db.SaveChanges(); LogWFEdits(User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1), wfNumber, "Deadline date change"); return; }
public void SaveClientMatter(string ClientMatter, int wfNumber) { DashDBContext db = new DashDBContext(); workflows wf = (from x in db.workflows where x.wfNumber == wfNumber select x).First(); wf.clientmatters = ClientMatter; db.SaveChanges(); LogWFEdits(User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1), wfNumber, "Client Matter change"); return; }
public void SaveFilesToWorkflow(int wfid) { //now that the workflow has been created we need to clean up the files that they uploaded and put the workflow ID on them using (var db = new DashDBContext()) { foreach (var wffiles in db.workflowfiles.Where(x => x.wfsessionid.Equals(Session.SessionID.ToString())).ToList()) { wffiles.wfID = wfid; } db.SaveChanges(); } return; }
public void SaveWFTSNewTimeStamp(DateTime newTSDate, Guid wfTSID, string reason) { DashDBContext db = new DashDBContext(); workflowtimestamps wf = (from x in db.workflowtimestamps where x.wftsid == wfTSID select x).First(); wf.stamp = newTSDate; db.SaveChanges(); LogWFEdits(User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1), wf.wfNumber, wfTSID + " had the date changed because of " + reason); AddNewNote(wfTSID + " had the date changed because of " + reason, wf.wfNumber); return; }
public void SaveAttorneyName(string attyID, int wfNumber) { DashDBContext db = new DashDBContext(); workflows wf = (from x in db.workflows where x.wfNumber == wfNumber select x).First(); wf.Requestor = attyID; db.SaveChanges(); LogWFEdits(User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1), wfNumber, "Requesting attorney change"); return; }
public void SaveDocumentToDB(string filename, string uniquename) { DashDBContext db = new DashDBContext(); workflowfiles wff = new workflowfiles { filename = filename, wfsessionid = Session.SessionID.ToString(), upload_dtim = DateTime.Now, uniquefilename = uniquename }; db.workflowfiles.Add(wff); db.SaveChanges(); return; }
public void AddNewNote(string newnotetext, int wfNumber) { DashDBContext db = new DashDBContext(); workflownotes wfnote = new workflownotes { wfID = wfNumber, wfnote = newnotetext, author = User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1).ToString(), notetimestamp = DateTime.Now }; db.workflownotes.Add(wfnote); db.SaveChanges(); return; }
public void ChangeWorkflowStatus(int newstatus, int wfNumber) { DashDBContext db = new DashDBContext(); workflowtimestamps wfts = new workflowtimestamps { wfNumber = wfNumber, workflowstatusID = newstatus, stamp = DateTime.Now, participant = User.Identity.Name.Substring(User.Identity.Name.LastIndexOf('\\') + 1).ToString() }; db.workflowtimestamps.Add(wfts); db.SaveChanges(); return; }
private void LogWFEdits(string tkinit, int wfNumber, string changeevent) { DashDBContext db = new DashDBContext(); Edit_Log el = new Edit_Log { wfNumber = wfNumber, dtim = DateTime.Now, tkinit = tkinit, changeevent = changeevent }; db.Edit_Log.Add(el); db.SaveChanges(); return; }
private void SaveTimeStamp(int wfNumber, int wfstatus, string participant) { DashDBContext db = new DashDBContext(); workflowtimestamps t = new workflowtimestamps { wfNumber = wfNumber, workflowstatusID = wfstatus, participant = participant, stamp = DateTime.Now }; db.workflowtimestamps.Add(t); db.SaveChanges(); return; }
public ActionResult Create([Bind(Exclude = "wfNumber, startdate, enddate", Include = "wfTitle, Requestor, Submitter, createddate, clientmatters, descofwork, deadline")] workflows workflow) { DashDBContext db = new DashDBContext(); if (ModelState.IsValid) { workflow.createddate = DateTime.Now; db.workflows.Add(workflow); try { db.SaveChanges(); int wfid = workflow.wfNumber; SaveTimeStamp(wfid, 1, Request.Form["Submitter"].ToString()); SaveFilesToWorkflow(wfid); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(View()); }