public ActionResult CreateProject(ProjectModel newProject) { try { var Id = DBHelper.Instance.CreateProject(newProject); return Json(new { success = Messages.ProjectCreatedSuccessfully, Id = Id }); } catch (Exception ex) { return Json(new { errors = ex.Message }); } }
public void ProjectModel_GetDateDisplay() { DateTime StartDate = new DateTime(2016, 5, 11); DateTime EndDate = new DateTime(2016, 5, 12); string expectedStartDateDisplay = "5/11/2016"; string expectedEndDateDisplay = "5/12/2016"; ProjectModel model = new ProjectModel { StartDate = StartDate, EndDate = EndDate }; string actualStartDateDisplay = model.StartDateDisplay; string actualEndDateDisplay = model.EndDateDisplay; Assert.AreEqual(expectedStartDateDisplay, actualStartDateDisplay); Assert.AreEqual(expectedEndDateDisplay, actualEndDateDisplay); }
public void UpdateProject(ProjectModel model) { try { using (ProjectsDB db = new ProjectsDB()) { var project = db.ProjectInfo.Where(p => p.ProjectId == model.ProjectId).FirstOrDefault(); project.ClientCompanyName = model.ClientCompanyName; project.ExecutiveCompanyName = model.ExecutiveCompanyName; project.Priority = model.Priority; project.StartDate = model.StartDate; project.EndDate = model.EndDate; project.Comment = model.Comment; project.ProjectManagerId = model.ProjectManagerId; db.Entry(project).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { throw new DBException("UpdateProject(): ", ex.ToString()); } }
public int CreateProject(ProjectModel model) { try { var Mapper = MapperHelper.CreateMap<ProjectModel, ProjectInfo>(); var project = Mapper.Map<ProjectInfo>(model); using (ProjectsDB db = new ProjectsDB()) { db.ProjectInfo.Add(project); db.SaveChanges(); int Id = db.ProjectInfo.Where(p => p.ClientCompanyName == model.ClientCompanyName && p.StartDate == model.StartDate).Select(s => s.ProjectId).FirstOrDefault(); AddProjectExecutor(Id, model.ProjectManagerId); return Id; } } catch (Exception ex) { throw new DBException("CreateProject(): ", ex.ToString()); } }
public ActionResult UpdateProject(ProjectModel model) { try { DBHelper.Instance.UpdateProject(model); if (DBHelper.Instance.ValidateProjectExecutor(model.ProjectId, model.ProjectManagerId)) { DBHelper.Instance.AddProjectExecutor(model.ProjectId, model.ProjectManagerId); } return Json(new { success = Messages.ProjectDetailsUpdatedSuccessfully }); } catch (Exception ex) { return Json(new { errors = ex.Message }); } }