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