public async Task <BusinessLicense> CreateAsync(BusinessLicense model)
{
var transaction = await dbContext.Database.BeginTransactionAsync();
try
{
model.DTIssued = model.DTIssued;
dbContext.BusinessLicenses.Add(model);
await dbContext.SaveChangesAsync();
await dbContext.Database.ExecuteSqlRawAsync(DeactivateActiveBusinesLicense());
await dbContext.Database.ExecuteSqlRawAsync(ActivateLatestBusinessLicense());
await transaction.CommitAsync();
CheckExpiration();
return(dbContext.BusinessLicenses.FirstOrDefault(a => a.BusinessLicenseId == model.BusinessLicenseId));
}
catch (AggregateException ex)
{
await transaction.RollbackAsync();
throw new Exception(ex.GetExceptionMessages());
}
catch (Exception ex)
{
await transaction.RollbackAsync();
throw new Exception(ex.GetExceptionMessages());
}
}
public async Task <IActionResult> Put([FromBody] BusinessLicense model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
var validationResult = await Task <bool> .Run(() => validateEntity(model));
if (validationResult == false)
{
return(InvalidModelStateResult());
}
var result = await repository.UpdateAsync(model);
return(Accepted(result));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.UpdateError));
}
}
private bool validateEntity(BusinessLicense model)
{
//var validCode = repository.ValidateName(model);
//if (!validCode) ModelState.AddModelError(nameof(BaleType.BaleTypeCode), Constants.ErrorMessages.EntityExists("Code"));
//var validName = repository.ValidateName(model);
//if (!validName) ModelState.AddModelError(nameof(BaleType.BaleTypeDesc), Constants.ErrorMessages.EntityExists("Name"));
return(ModelState.ErrorCount == 0);
}
public IActionResult Get([FromQuery] BusinessLicense parameters = null)
{
try
{
var model = repository.Get(parameters);
return(Ok(model));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.FetchError));
}
}
private void LoadDataFromServer()
{
string message = string.Empty;
BusinessLicense = PharmacyDatabaseService.GetBusinessLicense(out message, guid);
if (BusinessLicense == null)
{
BusinessLicense = new BusinessLicense();
BusinessLicense.Id = Guid.Empty;
BusinessLicense.IssuanceDate = DateTime.Now;
BusinessLicense.StartDate = DateTime.Now;
BusinessLicense.OutDate = DateTime.Now.AddYears(1);
BusinessLicense.EstablishmentDate = DateTime.Now;
BusinessLicense.UnitName = Name;
BusinessLicense.RegAddress = Address;
}
}
public async Task <BusinessLicense> UpdateAsync(BusinessLicense model)
{
var entity = dbContext.BusinessLicenses.Where(a => a.BusinessLicenseId == model.BusinessLicenseId).AsNoTracking().FirstOrDefault();
var transaction = await dbContext.Database.BeginTransactionAsync();
try
{
entity.IssuedTo = model.IssuedTo;
entity.IssueNum = model.IssueNum;
entity.DTIssued = model.DTIssued;
entity.RegActivity = model.RegActivity;
dbContext.BusinessLicenses.Update(model);
await dbContext.SaveChangesAsync();
await dbContext.Database.ExecuteSqlRawAsync(DeactivateActiveBusinesLicense());
await dbContext.Database.ExecuteSqlRawAsync(ActivateLatestBusinessLicense());
await transaction.CommitAsync();
CheckExpiration();
return(dbContext.BusinessLicenses.FirstOrDefault(a => a.BusinessLicenseId == model.BusinessLicenseId));;
}
catch (AggregateException ex)
{
await transaction.RollbackAsync();
throw new Exception(ex.GetExceptionMessages());
}
catch (Exception ex)
{
await transaction.RollbackAsync();
throw new Exception(ex.GetExceptionMessages());
}
}
public bool Delete(BusinessLicense model)
{
dbContext.BusinessLicenses.Remove(model);
dbContext.SaveChanges();
return(true);
}
public BusinessLicense Create(BusinessLicense model) => throw new NotImplementedException();
public SqlRawParameter GetSqlRawParameter(BusinessLicense parameters)
{
throw new NotImplementedException();
}
public IQueryable <BusinessLicense> Get(BusinessLicense model = null)
{
return(dbContext.BusinessLicenses.OrderBy(a => a.DTIssued).AsNoTracking());
}
public bool ValidateName(BusinessLicense model)
{
throw new NotImplementedException();
}
