public static User DtoToEntity(UserDto dto, MainDBModelContainer db)
{
var entity = new User
{
Username = dto.Username,
Passkey = dto.Passkey,
Email = dto.Email,
Firstname = dto.Firstname,
DateOfBirth = dto.DateOfBirth,
LastActivity = dto.LastActivity,
Roles = dto.Roles
};
if (dto.TeamId != 0)
{
entity.Team = db.TeamSet.Find(dto.TeamId);
}
if (dto.TaskId != 0)
{
entity.Task_Id = dto.TaskId;
}
return(entity);
}
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 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 List <ClientDto> ReadAll()
{
using (var db = new MainDBModelContainer())
{
var list = db.ClientSet.ToList();
return(list.Select(ClientMapper.EntityToDto).ToList());
}
}
public static List <ProjectStatusDto> ReadAll()
{
using (var db = new MainDBModelContainer())
{
var list = db.ProjectStatusSet.ToList();
return(list.Select(ProjectStatusMapper.EntityToDto).ToList());
}
}
public static List <TaskPriorityDto> ReadAll()
{
using (var db = new MainDBModelContainer())
{
var list = db.TaskPrioritySet.ToList();
return(list.Select(TaskPriorityMapper.EntityToDto).ToList());
}
}
public static List <MilestoneDto> ReadAll()
{
using (var db = new MainDBModelContainer())
{
var list = db.MilestoneSet.ToList();
return(list.Select(MilestoneMapper.EntityToDto).ToList());
}
}
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.ProjectSet.Find(id);
db.ProjectSet.Remove(toDelete);
db.SaveChanges();
}
}
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 Create(ProjectDto dto)
{
using (var db = new MainDBModelContainer())
{
var entity = ProjectMapper.DtoToEntity(dto, db);
db.ProjectSet.Add(entity);
db.SaveChanges();
}
}
public static ClientDto Read(int id)
{
using (var db = new MainDBModelContainer())
{
var data = db.ClientSet.Find(id);
if (data != null)
{
return(ClientMapper.EntityToDto(data));
}
throw new ElementNotFoundException();
}
}
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 Commit DtoToEntity(CommitDto dto, MainDBModelContainer db)
{
var entity = new Commit
{
Id = dto.Id,
CommitHash = dto.CommitHash,
CommitDateTime = dto.CommitDateTime
};
if (dto.TaskId != 0)
{
var task = db.TaskSet.Find(dto.TaskId);
entity.Task = task;
}
return(entity);
}
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 Milestone DtoToEntity(MilestoneDto dto, MainDBModelContainer db)
{
var entity = new Milestone
{
Id = dto.Id,
Name = dto.Name,
EndDate = dto.EndDate
};
if (dto.ProjectId != 0)
{
var project = db.ProjectSet.Find(dto.ProjectId);
entity.Project = project;
}
return(entity);
}
public static TaskLog DtoToEntity(TaskLogDto dto, MainDBModelContainer db)
{
var entity = new TaskLog
{
Id = dto.Id,
Event = dto.Event,
EntryDate = dto.EntryDate
};
if (dto.TaskId != 0)
{
var task = db.TaskSet.Find(dto.TaskId);
entity.Task = task;
}
return(entity);
}
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(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(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(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();
}
}
}
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 Project DtoToEntity(ProjectDto dto, MainDBModelContainer db)
{
var entity = new Project
{
Id = dto.Id,
Name = dto.Name,
CreatedOn = dto.CreatedOn,
ProjectManager = dto.ProjectManager,
};
if (dto.ProjectStatusId != 0)
{
var status = db.ProjectStatusSet.Find(1);
entity.Status = status.Name;
entity.ProjectStatus = status;
}
else
{
entity.Status = "pradėtas";
entity.ProjectStatus = db.ProjectStatusSet.Find(1);
}
var teams = db.TeamSet.Find(dto.TeamIds);
var col = new Collection <Team>();
col.Add(teams);
entity.Team = col;
if (dto.ClientId != 0)
{
var client = db.ClientSet.Find(dto.ClientId);
entity.Client = client.Name;
entity.Client1 = client;
}
return(entity);
}
public static Task DtoToEntity(TaskDto dto, MainDBModelContainer db)
{
var entity = new Task
{
Id = dto.Id,
Slug = dto.Slug,
Name = dto.Name,
Description = dto.Description,
CreatedOn = dto.CreatedOn,
Estimate = dto.Estimate,
EndDate = dto.EndDate
};
if (dto.ProjectId != 0)
{
var project = db.ProjectSet.Find(dto.ProjectId);
entity.Project = project;
}
if (dto.MilestoneId != 0)
{
var milestone = db.MilestoneSet.Find(dto.MilestoneId);
entity.Milestone = milestone;
}
if (dto.TaskStatusId != 0)
{
var taskStatus = db.TaskStatusSet.Find(dto.TaskStatusId);
entity.TaskStatus = taskStatus;
}
if (dto.TaskPriorityId != 0)
{
var taskPriority = db.TaskPrioritySet.Find(dto.TaskPriorityId);
entity.TaskPriority = taskPriority;
}
return(entity);
}