public ActionResult Edit(int?id) //SoID
        {
            ProjectSOs so = db.ProjectSOs.Where(p => p.SoID == (id ?? 0)).FirstOrDefault();

            if (so == null)
            {
                return(HttpNotFound());
            }

            var model = new SOModels.NewSO()
            {
                SOID     = so.SoID,
                Name     = so.SoName,
                SONumber = so.SoNumber,
                JobID    = so.ProjectID,
                TermID   = so.SoTermID,
                StatusID = so.SoStatusID,
                Date     = so.SoDate,
                Creator  = repo.GetUserDisplayName(so.CreatedByUserID ?? siteuserid)
            };

            int siteCoID = siteusercompanyid;

            ViewBag.Jobs   = new SelectList(db.GetJobsBySiteCoID(siteCoID), nameof(GetJobsBySiteCoID_Result.ViewID), nameof(GetJobsBySiteCoID_Result.Project), model.JobID);
            ViewBag.Terms  = new SelectList(db.GetSoTermsBySiteCoID(siteCoID), nameof(GetSoTermsBySiteCoID_Result.ViewID), nameof(GetSoTermsBySiteCoID_Result.Name), model.TermID);
            ViewBag.Status = new SelectList(db.GetSoStatusBySiteCoID(siteCoID), nameof(GetSoStatusBySiteCoID_Result.ViewID), nameof(GetSoStatusBySiteCoID_Result.Name), model.StatusID);

            return(View("_Edit", model));
        }
        private int SaveCOR(SOModels.NewSO Model)
        {
            int siteCoID = siteusercompanyid;
            var so       = new ProjectSOs()
            {
                SoID            = Model.SOID ?? 0,
                SiteCoID        = siteusercompanyid,
                ProjectID       = Model.JobID,
                SoName          = Model.Name,
                SoNumber        = Model.SONumber,
                SoDate          = Model.Date,
                SoStatusID      = Model.StatusID,
                SoTermID        = Model.TermID,
                CreatedByUserID = siteuserid
            };

            var soId = repo.SaveSO(so);

            return(soId);
        }