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