/// <summary> /// Add new Ticket /// </summary> /// <param name="ticket"></param> /// <returns></returns> public async Task <TicketDTO> Add(TicketDTO ticket) { await Task.Run((Action)(() => { //var ticketOwnerID = _ctx.AspNetUsers.FirstOrDefault(x => x.IDNumber == idNumber).Id; var newTicket = new Grievance.DAL.Ticket() { CreatedDate = DateTime.Now, CreatedBy = ticket.CreatedBy, DepartmentId = ticket.DepartmentId, TicketTypeId = ticket.TicketTypeId, ReferenceNumber = GenerateRefNumber(ticket), TicketPriorityId = ticket.TicketPriorityId, TicketStatusId = 1, TicketOwnerId = ticket.TicketOwnerId, Description = ticket.Description, Name = ticket.Name, UpdatedBy = ticket.UpdatedBy, UpdatedDate = DateTime.Now, AssignedTo = ticket.AssignedTo,// "0d64e363-89b0-4de2-8bb5-81994efc53c7", TicketCategoryId = ticket.TicketCategoryId, TicketIssueId = ticket.TicketIssueId }; _ctx.Tickets.Add(newTicket); _ctx.SaveChanges(); ticket.Id = newTicket.Id; ticket.ReferenceNumber = newTicket.ReferenceNumber; })); return(ticket); }
/// <summary> /// Add new Ticket /// </summary> /// <param name="ticket"></param> /// <returns></returns> public async Task <TicketDTO> Add(TicketDTO ticket) { await Task.Run((Action)(() => { var newTicket = new Grievance.DAL.Ticket() { CreatedDate = ticket.CreatedDate, CreatedBy = ticket.CreatedBy, DepartmentId = ticket.DepartmentId, TicketTypeId = ticket.TicketTypeId, ReferenceNumber = GenerateRefNumber(ticket), TicketPriorityId = ticket.TicketPriorityId, TicketStatusId = 1, TicketOwnerId = ticket.TicketOwnerId, Description = ticket.Description, Name = ticket.Name, UpdatedBy = ticket.UpdatedBy, UpdatedDate = ticket.UpdatedDate, AssignedTo = ticket.AssignedTo, TicketCategoryId = ticket.TicketCategoryId, TicketIssueId = ticket.TicketIssueId }; _ctx.Tickets.Add(newTicket); _ctx.SaveChanges(); ticket.Id = newTicket.Id; ticket.ReferenceNumber = newTicket.ReferenceNumber; })); return(ticket); }
public async Task <TicketStatusDTO> Add(TicketStatusDTO ticketStatus) { await Task.Run(() => { var newTicketStatus = new Grievance.DAL.TicketStatus() { CreatedBy = ticketStatus.CreatedBy, CreatedDate = ticketStatus.CreatedDate, Description = ticketStatus.Description, Name = ticketStatus.Name, UpdatedBy = ticketStatus.UpdatedBy, UpdatedDate = ticketStatus.UpdatedDate }; _ctx.TicketStatuses.Add(newTicketStatus); _ctx.SaveChanges(); }); return(ticketStatus); }
public async Task <TicketPriorityDTO> Add(TicketPriorityDTO ticketPriority) { await Task.Run(() => { var newTicketPriority = new Grievance.DAL.TicketPriority() { CreatedBy = ticketPriority.CreatedBy, CreatedDate = ticketPriority.CreatedDate, Description = ticketPriority.Description, Name = ticketPriority.Name, UpdatedBy = ticketPriority.UpdatedBy, UpdatedDate = ticketPriority.UpdatedDate }; _ctx.TicketPriorities.Add(newTicketPriority); _ctx.SaveChanges(); }); return(ticketPriority); }
public async Task <TicketTypeDTO> Add(TicketTypeDTO type) { await Task.Run(() => { var newTicketType = new Grievance.DAL.TicketType() { CreatedBy = type.CreatedBy, CreatedDate = type.CreatedDate, Description = type.Description, Name = type.Name, UpdatedBy = type.UpdatedBy, UpdatedDate = type.UpdatedDate }; _ctx.TicketTypes.Add(newTicketType); _ctx.SaveChanges(); }); return(type); }
public async Task <CategoryDTO> Add(CategoryDTO category) { await Task.Run(() => { var newTicketCategory = new Grievance.DAL.TicketCategory() { CreatedBy = category.CreatedBy, CreatedDate = category.CreatedDate, Description = category.Description, Name = category.Name, UpdatedBy = category.UpdatedBy, UpdatedDate = category.UpdatedDate }; _ctx.TicketCategories.Add(newTicketCategory); _ctx.SaveChanges(); }); return(category); }
/// <summary> /// Add new Ticket /// </summary> /// <param name="ticket"></param> /// <returns></returns> public async Task <TicketDTO> Add(TicketDTO ticket) { await Task.Run(() => { var newTicket = new Ticket() { CreatedDate = DateTime.Now, LastModifiedDate = DateTime.Now, Description = ticket.Description, Name = ticket.Name, Organization = ticket.Organization, Remarks = ticket.Remarks }; _ctx.Tickets.Add(newTicket); _ctx.SaveChanges(); ticket.Id = newTicket.Id; }); return(ticket); }
public async Task <DepartmentDTO> Add(DepartmentDTO department) { await Task.Run(() => { var newDepartment = new Department() { AlternativeNumber = department.AlternativeNumber, ContactPerson = department.ContactPerson, CreatedBy = department.CreatedBy, CreatedDate = department.CreatedDate, EmailAddress = department.EmailAddress, HOD = department.HOD, Name = department.Name, TellNumber = department.TellNumber, UpdatedBy = department.UpdatedBy, UpdatedDate = department.UpdatedDate }; _ctx.Departments.Add(newDepartment); _ctx.SaveChanges(); }); return(department); }
/// <summary> /// Add remarks of type Image /// </summary> /// <param name="imageRemark"></param> /// <returns></returns> public async Task <TicketRemarkDTO> AddRemark(TicketRemarkDTO ticketRemark) { await Task.Run(() => { var newTicketRemark = new TicketRemark() { CreatedBy = ticketRemark.CreatedBy, CreatedDate = ticketRemark.CreatedDate, Type = ticketRemark.Type, TicketId = ticketRemark.TicketId, Desription = ticketRemark.Desription, UpdatedBy = ticketRemark.UpdatedBy, UpdatedDate = ticketRemark.UpdatedDate }; _ctx.TicketRemarks.Add(newTicketRemark); _ctx.SaveChanges(); ticketRemark.Id = newTicketRemark.Id; }); return(ticketRemark); }
public async Task <TicketRemarkDTO> Add(TicketRemarkDTO ticketRemark, int id) { await Task.Run(() => { var newTicketRemark = new TicketRemark() { CreatedBy = ticketRemark.CreatedBy, CreatedDate = ticketRemark.CreatedDate, Desription = ticketRemark.Desription, // ImageName = ticketRemark.ImageName, TicketId = id,//ticketRemark.TicketId, UpdatedBy = ticketRemark.UpdatedBy, UpdatedDate = ticketRemark.UpdatedDate, // VoiceRecordName = ticketRemark.VoiceRecordName }; _ctx.TicketRemarks.Add(newTicketRemark); _ctx.SaveChanges(); }); return(ticketRemark); }