public async Task <SLAAlertPhone> Get(long Id)
{
SLAAlertPhone SLAAlertPhone = await DataContext.SLAAlertPhone.AsNoTracking()
.Where(x => x.Id == Id).Select(x => new SLAAlertPhone()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
SLAAlertId = x.SLAAlertId,
Phone = x.Phone,
SLAAlert = x.SLAAlert == null ? null : new SLAAlert
{
Id = x.SLAAlert.Id,
TicketIssueLevelId = x.SLAAlert.TicketIssueLevelId,
IsNotification = x.SLAAlert.IsNotification,
IsMail = x.SLAAlert.IsMail,
IsSMS = x.SLAAlert.IsSMS,
Time = x.SLAAlert.Time,
TimeUnitId = x.SLAAlert.TimeUnitId,
IsAssignedToUser = x.SLAAlert.IsAssignedToUser,
IsAssignedToGroup = x.SLAAlert.IsAssignedToGroup,
SmsTemplateId = x.SLAAlert.SmsTemplateId,
MailTemplateId = x.SLAAlert.MailTemplateId,
},
}).FirstOrDefaultAsync();
if (SLAAlertPhone == null)
{
return(null);
}
return(SLAAlertPhone);
}
public async Task <bool> Delete(SLAAlertPhone SLAAlertPhone)
{
if (await ValidateId(SLAAlertPhone))
{
}
return(SLAAlertPhone.IsValidated);
}
public async Task <bool> Delete(SLAAlertPhone SLAAlertPhone)
{
await DataContext.SLAAlertPhone.Where(x => x.Id == SLAAlertPhone.Id).UpdateFromQueryAsync(x => new SLAAlertPhoneDAO {
DeletedAt = StaticParams.DateTimeNow
});
return(true);
}
public async Task <SLAAlertPhone> Get(long Id)
{
SLAAlertPhone SLAAlertPhone = await UOW.SLAAlertPhoneRepository.Get(Id);
if (SLAAlertPhone == null)
{
return(null);
}
return(SLAAlertPhone);
}
public TicketIssueLevel_SLAAlertPhoneDTO(SLAAlertPhone SLAAlertPhone)
{
this.Id = SLAAlertPhone.Id;
this.SLAAlertId = SLAAlertPhone.SLAAlertId;
this.Phone = SLAAlertPhone.Phone;
this.SLAAlert = SLAAlertPhone.SLAAlert == null ? null : new TicketIssueLevel_SLAAlertDTO(SLAAlertPhone.SLAAlert);
this.CreatedAt = SLAAlertPhone.CreatedAt;
this.UpdatedAt = SLAAlertPhone.UpdatedAt;
this.Errors = SLAAlertPhone.Errors;
}
public async Task <bool> Create(SLAAlertPhone SLAAlertPhone)
{
SLAAlertPhoneDAO SLAAlertPhoneDAO = new SLAAlertPhoneDAO();
SLAAlertPhoneDAO.Id = SLAAlertPhone.Id;
SLAAlertPhoneDAO.SLAAlertId = SLAAlertPhone.SLAAlertId;
SLAAlertPhoneDAO.Phone = SLAAlertPhone.Phone;
SLAAlertPhoneDAO.CreatedAt = StaticParams.DateTimeNow;
SLAAlertPhoneDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.SLAAlertPhone.Add(SLAAlertPhoneDAO);
await DataContext.SaveChangesAsync();
SLAAlertPhone.Id = SLAAlertPhoneDAO.Id;
await SaveReference(SLAAlertPhone);
return(true);
}
public async Task <bool> Update(SLAAlertPhone SLAAlertPhone)
{
SLAAlertPhoneDAO SLAAlertPhoneDAO = DataContext.SLAAlertPhone.Where(x => x.Id == SLAAlertPhone.Id).FirstOrDefault();
if (SLAAlertPhoneDAO == null)
{
return(false);
}
SLAAlertPhoneDAO.Id = SLAAlertPhone.Id;
SLAAlertPhoneDAO.SLAAlertId = SLAAlertPhone.SLAAlertId;
SLAAlertPhoneDAO.Phone = SLAAlertPhone.Phone;
SLAAlertPhoneDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(SLAAlertPhone);
return(true);
}
public async Task <bool> ValidateId(SLAAlertPhone SLAAlertPhone)
{
SLAAlertPhoneFilter SLAAlertPhoneFilter = new SLAAlertPhoneFilter
{
Skip = 0,
Take = 10,
Id = new IdFilter {
Equal = SLAAlertPhone.Id
},
Selects = SLAAlertPhoneSelect.Id
};
int count = await UOW.SLAAlertPhoneRepository.Count(SLAAlertPhoneFilter);
if (count == 0)
{
SLAAlertPhone.AddError(nameof(SLAAlertPhoneValidator), nameof(SLAAlertPhone.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
public async Task <SLAAlertPhone> Update(SLAAlertPhone SLAAlertPhone)
{
if (!await SLAAlertPhoneValidator.Update(SLAAlertPhone))
{
return(SLAAlertPhone);
}
try
{
var oldData = await UOW.SLAAlertPhoneRepository.Get(SLAAlertPhone.Id);
await UOW.Begin();
await UOW.SLAAlertPhoneRepository.Update(SLAAlertPhone);
await UOW.Commit();
SLAAlertPhone = await UOW.SLAAlertPhoneRepository.Get(SLAAlertPhone.Id);
await Logging.CreateAuditLog(SLAAlertPhone, oldData, nameof(SLAAlertPhoneService));
return(SLAAlertPhone);
}
catch (Exception ex)
{
await UOW.Rollback();
if (ex.InnerException == null)
{
await Logging.CreateSystemLog(ex, nameof(SLAAlertPhoneService));
throw new MessageException(ex);
}
else
{
await Logging.CreateSystemLog(ex.InnerException, nameof(SLAAlertPhoneService));
throw new MessageException(ex.InnerException);
}
}
}
public async Task <bool> Create(SLAAlertPhone SLAAlertPhone)
{
return(SLAAlertPhone.IsValidated);
}
private async Task SaveReference(SLAAlertPhone SLAAlertPhone)
{
}
