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