public static void Update(ProjectDto dto) { using (var db = new MainDBModelContainer()) { var newData = ProjectMapper.DtoToEntity(dto, db); var oldData = db.ProjectSet.Find(dto.Id); if (oldData != null) { oldData.Name = newData.Name; oldData.CreatedOn = newData.CreatedOn; oldData.ProjectManager = newData.ProjectManager; oldData.ProjectStatus = newData.ProjectStatus; oldData.Client1 = newData.Client1; oldData.Status = newData.ProjectStatus.Name; oldData.Client = newData.Client1.Name; oldData.Team = newData.Team; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(UserDto dto) { using (var db = new MainDBModelContainer()) { var newUserData = UserMapper.DtoToEntity(dto, db); var oldUserData = db.UserSet.Find(dto.Id); if (oldUserData != null) { oldUserData.Username = newUserData.Username; oldUserData.Passkey = newUserData.Passkey; oldUserData.Email = newUserData.Email; oldUserData.Firstname = newUserData.Firstname; oldUserData.DateOfBirth = newUserData.DateOfBirth; oldUserData.LastActivity = newUserData.LastActivity; oldUserData.Roles = newUserData.Roles; oldUserData.Team = newUserData.Team; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(TaskDto dto) { using (var db = new MainDBModelContainer()) { var newData = TaskMapper.DtoToEntity(dto, db); var oldData = db.TaskSet.Find(dto.Id); if (oldData != null) { oldData.Slug = newData.Slug; oldData.Name = newData.Name; oldData.Description = newData.Description; oldData.CreatedOn = newData.CreatedOn; oldData.Estimate = newData.Estimate; oldData.EndDate = newData.EndDate; oldData.Project = newData.Project; oldData.Milestone = newData.Milestone; oldData.TaskStatus = newData.TaskStatus; oldData.TaskPriority = newData.TaskPriority; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Create(ClientDto dto) { using (var db = new MainDBModelContainer()) { var entity = ClientMapper.DtoToEntity(dto); db.ClientSet.Add(entity); db.SaveChanges(); } }
public static void Create(TaskPriorityDto dto) { using (var db = new MainDBModelContainer()) { var entity = TaskPriorityMapper.DtoToEntity(dto); db.TaskPrioritySet.Add(entity); db.SaveChanges(); } }
public static void Delete(int id) { using (var db = new MainDBModelContainer()) { var toDelete = db.ProjectSet.Find(id); db.ProjectSet.Remove(toDelete); db.SaveChanges(); } }
public static void Create(ProjectDto dto) { using (var db = new MainDBModelContainer()) { var entity = ProjectMapper.DtoToEntity(dto, db); db.ProjectSet.Add(entity); db.SaveChanges(); } }
public static void Create(MilestoneDto dto) { using (var db = new MainDBModelContainer()) { var entity = MilestoneMapper.DtoToEntity(dto, db); db.MilestoneSet.Add(entity); db.SaveChanges(); } }
public static void Create(UserDto dto) { using (var db = new MainDBModelContainer()) { var entity = UserMapper.DtoToEntity(dto, db); db.UserSet.Add(entity); db.SaveChanges(); } }
public static void Delete(int id) { using (var db = new MainDBModelContainer()) { var toDelete = db.ClientSet.Find(id); if (toDelete != null) { db.ClientSet.Remove(toDelete); db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(TaskStatusDto dto) { using (var db = new MainDBModelContainer()) { var newData = TaskStatusMapper.DtoToEntity(dto); var oldData = db.TaskStatusSet.Find(dto.Id); if (oldData != null) { oldData.Name = newData.Name; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(RoleDto dto) { using (var db = new MainDBModelContainer()) { var newData = RoleMapper.DtoToEntity(dto); var oldData = db.RoleSet.Find(dto.Id); if (oldData != null) { oldData.FriendlyName = newData.FriendlyName; oldData.SysRole = newData.SysRole; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(ClientDto dto) { using (var db = new MainDBModelContainer()) { var newData = ClientMapper.DtoToEntity(dto); var oldData = db.ClientSet.Find(dto.Id); if (oldData != null) { oldData.Name = newData.Name; oldData.Email = newData.Email; oldData.Phone = newData.Phone; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(MilestoneDto dto) { using (var db = new MainDBModelContainer()) { var newData = MilestoneMapper.DtoToEntity(dto, db); var oldData = db.MilestoneSet.Find(dto.Id); if (oldData != null) { oldData.Name = newData.Name; oldData.EndDate = newData.EndDate; oldData.Project = newData.Project; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(TaskLogDto dto) { using (var db = new MainDBModelContainer()) { var newData = TaskLogMapper.DtoToEntity(dto, db); var oldData = db.TaskLogSet.Find(dto.Id); if (oldData != null) { oldData.Event = newData.Event; oldData.EntryDate = newData.EntryDate; oldData.Task = newData.Task; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }
public static void Update(CommitDto dto) { using (var db = new MainDBModelContainer()) { var newData = CommitMapper.DtoToEntity(dto, db); var oldData = db.CommitSet.Find(dto.Id); if (oldData != null) { oldData.CommitHash = newData.CommitHash; oldData.CommitDateTime = newData.CommitDateTime; oldData.Task = newData.Task; db.SaveChanges(); } else { throw new ElementNotFoundException(); } } }