public int EditTask(int id, HelpDesk_Tasks task)
{
HelpDesk_Tasks oldTask = _context.HelpDesk_Tasks.FirstOrDefault(x => x.Id == id);
try
{
if (oldTask != null)
{
oldTask.TicketID = task.TicketID;
oldTask.Title = task.Title;
oldTask.AssignedTo = task.AssignedTo;
oldTask.Description = task.Description;
oldTask.StatusID = task.StatusID;
oldTask.StatusChangedDateTime = task.StatusChangedDateTime;
oldTask.RelatedTaskIds = task.RelatedTaskIds;
}
_context.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(task.Id);
}
public int CreateTask(HelpDesk_Tasks task)
{
HelpDesk_Tickets ticket = _context.HelpDesk_Tickets.First(x => x.TicketNumber == task.TicketID);
task.TicketID = ticket.Id;
_context.HelpDesk_Tasks.Add(task);
_context.SaveChanges();
return(task.Id);
}
private HelpDesk_Tasks mapViewModelToEntityTask(HelpDesk_Tasks_vm VMTask)
{
ServiceDesk_Users assignedTo = _nsUserRepository.GetUserByUserName(VMTask.AssignedToUserName);
var tasks = new HelpDesk_Tasks
{
Id = VMTask.Id,
TicketID = VMTask.TicketID,
Title = VMTask.Title,
Description = VMTask.Description,
StatusID = VMTask.StatusID,
CreatedDateTime = VMTask.CreatedDateTime,
StatusChangedDateTime = VMTask.StatusChangedDateTime,
AssignedTo = assignedTo.Id
};
return(tasks);
}
private HelpDesk_Tasks_View_vm mapEntityToViewModelTask(HelpDesk_Tasks EFTask)
{
_logger.Debug("Mapping Entity to Task View Model.");
var vmT = new HelpDesk_Tasks_View_vm
{
Id = EFTask.Id,
Title = EFTask.Title,
TicketID = EFTask.TicketID,
Description = EFTask.Description,
Status = EFTask.HelpDesk_TaskStatus.Status,
CreatedDateTime = EFTask.CreatedDateTime,
StatusChangedDateTime = EFTask.StatusChangedDateTime,
AssignedTo = EFTask.ServiceDesk_Users == null ? "" : (EFTask.ServiceDesk_Users.FirstName + " " + EFTask.ServiceDesk_Users.LastName),
};
return(vmT);
}
public bool DeleteTask(int id)
{
bool result = false;
try
{
HelpDesk_Tasks task = _context.HelpDesk_Tasks.FirstOrDefault(x => x.Id == id);
_context.HelpDesk_Tasks.Remove(task);
_context.SaveChanges();
result = true;
_logger.Info("Task with id " + id + " was deleted.");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(result);
}
private HelpDesk_Tasks_vm mapEntityToViewModelSingleTask(HelpDesk_Tasks EFTask)
{
_logger.Debug("Mapping Entity to Task View Model.");
var vmT = new HelpDesk_Tasks_vm
{
Id = EFTask.Id,
Title = EFTask.Title,
TicketID = EFTask.TicketID,
Description = EFTask.Description,
StatusID = EFTask.StatusID,
CreatedDateTime = EFTask.CreatedDateTime,
StatusChangedDateTime = EFTask.StatusChangedDateTime,
AssignedToUserName = EFTask.ServiceDesk_Users == null ? null : EFTask.ServiceDesk_Users.UserName,
ServiceDesk_Users_AssignedTo = EFTask.ServiceDesk_Users == null ? null : new Task_User()
{
SID = EFTask.ServiceDesk_Users.SID,
UserName = EFTask.ServiceDesk_Users.UserName,
DisplayName = EFTask.ServiceDesk_Users.FirstName + " " + EFTask.ServiceDesk_Users.LastName
}
};
return(vmT);
}
public HelpDesk_Tasks GetTaskById(int id)
{
HelpDesk_Tasks task = _context.HelpDesk_Tasks.FirstOrDefault(x => x.Id == id);
return(task);
}
