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