public async Task <bool> Delete(TicketOfDepartment TicketOfDepartment)
{
if (await ValidateId(TicketOfDepartment))
{
}
return(TicketOfDepartment.IsValidated);
}
public async Task <bool> Delete(TicketOfDepartment TicketOfDepartment)
{
await DataContext.TicketOfDepartment.Where(x => x.Id == TicketOfDepartment.Id).UpdateFromQueryAsync(x => new TicketOfDepartmentDAO {
DeletedAt = StaticParams.DateTimeNow
});
return(true);
}
public async Task <TicketOfDepartment> Get(long Id)
{
TicketOfDepartment TicketOfDepartment = await UOW.TicketOfDepartmentRepository.Get(Id);
if (TicketOfDepartment == null)
{
return(null);
}
return(TicketOfDepartment);
}
public async Task <bool> Create(TicketOfDepartment TicketOfDepartment)
{
TicketOfDepartmentDAO TicketOfDepartmentDAO = new TicketOfDepartmentDAO();
TicketOfDepartmentDAO.Id = TicketOfDepartment.Id;
TicketOfDepartmentDAO.Notes = TicketOfDepartment.Notes;
TicketOfDepartmentDAO.DepartmentId = TicketOfDepartment.DepartmentId;
TicketOfDepartmentDAO.TicketId = TicketOfDepartment.TicketId;
TicketOfDepartmentDAO.TicketStatusId = TicketOfDepartment.TicketStatusId;
TicketOfDepartmentDAO.CreatedAt = StaticParams.DateTimeNow;
TicketOfDepartmentDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.TicketOfDepartment.Add(TicketOfDepartmentDAO);
await DataContext.SaveChangesAsync();
TicketOfDepartment.Id = TicketOfDepartmentDAO.Id;
await SaveReference(TicketOfDepartment);
return(true);
}
public async Task <bool> Update(TicketOfDepartment TicketOfDepartment)
{
TicketOfDepartmentDAO TicketOfDepartmentDAO = DataContext.TicketOfDepartment.Where(x => x.Id == TicketOfDepartment.Id).FirstOrDefault();
if (TicketOfDepartmentDAO == null)
{
return(false);
}
TicketOfDepartmentDAO.Id = TicketOfDepartment.Id;
TicketOfDepartmentDAO.Notes = TicketOfDepartment.Notes;
TicketOfDepartmentDAO.DepartmentId = TicketOfDepartment.DepartmentId;
TicketOfDepartmentDAO.TicketId = TicketOfDepartment.TicketId;
TicketOfDepartmentDAO.TicketStatusId = TicketOfDepartment.TicketStatusId;
TicketOfDepartmentDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(TicketOfDepartment);
return(true);
}
public async Task <bool> ValidateId(TicketOfDepartment TicketOfDepartment)
{
TicketOfDepartmentFilter TicketOfDepartmentFilter = new TicketOfDepartmentFilter
{
Skip = 0,
Take = 10,
Id = new IdFilter {
Equal = TicketOfDepartment.Id
},
Selects = TicketOfDepartmentSelect.Id
};
int count = await UOW.TicketOfDepartmentRepository.Count(TicketOfDepartmentFilter);
if (count == 0)
{
TicketOfDepartment.AddError(nameof(TicketOfDepartmentValidator), nameof(TicketOfDepartment.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
public async Task <TicketOfDepartment> Update(TicketOfDepartment TicketOfDepartment)
{
if (!await TicketOfDepartmentValidator.Update(TicketOfDepartment))
{
return(TicketOfDepartment);
}
try
{
var oldData = await UOW.TicketOfDepartmentRepository.Get(TicketOfDepartment.Id);
await UOW.Begin();
await UOW.TicketOfDepartmentRepository.Update(TicketOfDepartment);
await UOW.Commit();
TicketOfDepartment = await UOW.TicketOfDepartmentRepository.Get(TicketOfDepartment.Id);
await Logging.CreateAuditLog(TicketOfDepartment, oldData, nameof(TicketOfDepartmentService));
return(TicketOfDepartment);
}
catch (Exception ex)
{
await UOW.Rollback();
if (ex.InnerException == null)
{
await Logging.CreateSystemLog(ex, nameof(TicketOfDepartmentService));
throw new MessageException(ex);
}
else
{
await Logging.CreateSystemLog(ex.InnerException, nameof(TicketOfDepartmentService));
throw new MessageException(ex.InnerException);
}
}
}
private async Task SaveReference(TicketOfDepartment TicketOfDepartment)
{
}
public async Task <TicketOfDepartment> Get(long Id)
{
TicketOfDepartment TicketOfDepartment = await DataContext.TicketOfDepartment.AsNoTracking()
.Where(x => x.Id == Id).Select(x => new TicketOfDepartment()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
Notes = x.Notes,
DepartmentId = x.DepartmentId,
TicketId = x.TicketId,
TicketStatusId = x.TicketStatusId,
Department = x.Department == null ? null : new Organization
{
Id = x.Department.Id,
Code = x.Department.Code,
Name = x.Department.Name,
ParentId = x.Department.ParentId,
Path = x.Department.Path,
Level = x.Department.Level,
StatusId = x.Department.StatusId,
Phone = x.Department.Phone,
Email = x.Department.Email,
Address = x.Department.Address,
},
Ticket = x.Ticket == null ? null : new Ticket
{
Id = x.Ticket.Id,
Name = x.Ticket.Name,
Phone = x.Ticket.Phone,
CustomerId = x.Ticket.CustomerId,
UserId = x.Ticket.UserId,
ProductId = x.Ticket.ProductId,
ReceiveDate = x.Ticket.ReceiveDate,
ProcessDate = x.Ticket.ProcessDate,
FinishDate = x.Ticket.FinishDate,
Subject = x.Ticket.Subject,
Content = x.Ticket.Content,
TicketIssueLevelId = x.Ticket.TicketIssueLevelId,
TicketPriorityId = x.Ticket.TicketPriorityId,
TicketStatusId = x.Ticket.TicketStatusId,
TicketSourceId = x.Ticket.TicketSourceId,
TicketNumber = x.Ticket.TicketNumber,
DepartmentId = x.Ticket.DepartmentId,
RelatedTicketId = x.Ticket.RelatedTicketId,
SLA = x.Ticket.SLA,
RelatedCallLogId = x.Ticket.RelatedCallLogId,
ResponseMethodId = x.Ticket.ResponseMethodId,
StatusId = x.Ticket.StatusId,
Used = x.Ticket.Used,
},
TicketStatus = x.TicketStatus == null ? null : new TicketStatus
{
Id = x.TicketStatus.Id,
Name = x.TicketStatus.Name,
OrderNumber = x.TicketStatus.OrderNumber,
ColorCode = x.TicketStatus.ColorCode,
StatusId = x.TicketStatus.StatusId,
Used = x.TicketStatus.Used,
},
}).FirstOrDefaultAsync();
if (TicketOfDepartment == null)
{
return(null);
}
return(TicketOfDepartment);
}
public async Task <bool> Create(TicketOfDepartment TicketOfDepartment)
{
return(TicketOfDepartment.IsValidated);
}
