private int SaveCase(CaseModels.NewCase Model) { int siteCoID = siteusercompanyid; ProjectCases newCase = new ProjectCases() { CaseID = Model.CaseID ?? 0, SiteCoID = siteusercompanyid, CreatedByUserID = Model.CreatorID, ProjectID = Model.JobID, SiteUserID = Model.ResourceID ?? siteuserid, Subject = Model.Concern, StatusID = Model.StatusID, DueDate = Model.Due, Notes = Model.Notes, Priority = Model.Priority, DateCreated = Model.Created ?? DateTime.Now, CaseTypeID = Model.TypeID }; BOL.Repository.CommonRepository repo = new BOL.Repository.CommonRepository(); int caseID = repo.SaveCase(newCase); if (caseID > 0) { return(caseID); } else { return(0); } }
public ActionResult Edit(int?id, int?contactid, int?projectid) { ProjectCases _case = db.ProjectCases.Where(p => p.CaseID == (id ?? 0)).FirstOrDefault(); if (_case == null) { return(HttpNotFound()); } if (projectid.HasValue) { BOL.Repository.CommonRepository repo = new BOL.Repository.CommonRepository(); contactid = repo.GetContactIdByProjectID(projectid.Value); } ViewBag.Jobs = new SelectList(db.GetJobsByContactID_WithLockFalse(contactid).ToList(), "ViewID", "Project", _case.ProjectID); ViewBag.CaseTypes = new SelectList(repo.GetCaseTypesBySiteCoID(siteusercompanyid), "CaseTypeID", "CaseType", _case.CaseTypeID); ViewBag.Priorities = new SelectList(repo.GetPrioritiesList(), "Item2", "Item2", _case.Priority); ViewBag.Status = new SelectList(repo.GetActivityStatus(siteusercompanyid), "StatusID", "StatusName", _case.StatusID); var siteUsers = db.SiteUsers.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.UserDisplayName); ViewBag.Resource = new SelectList(siteUsers, "SiteUserID", "UserDisplayName"); ViewBag.Creator = new SelectList(siteUsers, "SiteUserID", "UserDisplayName", siteuserid); ViewBag.IsFieldsReadOnly = true; CaseModels.NewCase model = new CaseModels.NewCase(); model = new CaseModels.NewCase() { CaseID = _case.CaseID, CreatorID = _case.CreatedByUserID, ResourceID = _case.SiteUserID, JobID = _case.ProjectID, Concern = _case.Subject, StatusID = _case.StatusID, Due = _case.DueDate, Notes = _case.Notes, Priority = _case.Priority, Created = _case.DateCreated }; ViewBag.SelectedContactID = contactid; return(View("_Edit", model)); }