public async Task <bool> Delete(VariationGrouping VariationGrouping)
{
if (await ValidateId(VariationGrouping))
{
}
return(VariationGrouping.IsValidated);
}
public async Task <VariationGrouping> Update(VariationGrouping VariationGrouping)
{
if (!await VariationGroupingValidator.Update(VariationGrouping))
{
return(VariationGrouping);
}
try
{
var oldData = await UOW.VariationGroupingRepository.Get(VariationGrouping.Id);
await UOW.Begin();
await UOW.VariationGroupingRepository.Update(VariationGrouping);
await UOW.Commit();
var newData = await UOW.VariationGroupingRepository.Get(VariationGrouping.Id);
await UOW.AuditLogRepository.Create(newData, oldData, nameof(VariationGroupingService));
return(newData);
}
catch (Exception ex)
{
await UOW.Rollback();
await UOW.SystemLogRepository.Create(ex, nameof(VariationGroupingService));
throw new MessageException(ex);
}
}
public async Task <VariationGrouping> Get(long Id)
{
VariationGrouping VariationGrouping = await DataContext.VariationGrouping.Where(x => x.Id == Id).Select(VariationGroupingDAO => new VariationGrouping()
{
Id = VariationGroupingDAO.Id,
Name = VariationGroupingDAO.Name,
ProductId = VariationGroupingDAO.ProductId,
Product = VariationGroupingDAO.Product == null ? null : new Product
{
Id = VariationGroupingDAO.Product.Id,
Code = VariationGroupingDAO.Product.Code,
Name = VariationGroupingDAO.Product.Name,
Description = VariationGroupingDAO.Product.Description,
TypeId = VariationGroupingDAO.Product.TypeId,
StatusId = VariationGroupingDAO.Product.StatusId,
MerchantId = VariationGroupingDAO.Product.MerchantId,
CategoryId = VariationGroupingDAO.Product.CategoryId,
BrandId = VariationGroupingDAO.Product.BrandId,
WarrantyPolicy = VariationGroupingDAO.Product.WarrantyPolicy,
ReturnPolicy = VariationGroupingDAO.Product.ReturnPolicy,
ExpiredDate = VariationGroupingDAO.Product.ExpiredDate,
ConditionOfUse = VariationGroupingDAO.Product.ConditionOfUse,
MaximumPurchaseQuantity = VariationGroupingDAO.Product.MaximumPurchaseQuantity,
},
}).FirstOrDefaultAsync();
return(VariationGrouping);
}
public async Task <VariationGrouping> Delete(VariationGrouping VariationGrouping)
{
if (!await VariationGroupingValidator.Delete(VariationGrouping))
{
return(VariationGrouping);
}
try
{
await UOW.Begin();
await UOW.VariationGroupingRepository.Delete(VariationGrouping);
await UOW.Commit();
await UOW.AuditLogRepository.Create("", VariationGrouping, nameof(VariationGroupingService));
return(VariationGrouping);
}
catch (Exception ex)
{
await UOW.Rollback();
await UOW.SystemLogRepository.Create(ex, nameof(VariationGroupingService));
throw new MessageException(ex);
}
}
public async Task <bool> Delete(VariationGrouping VariationGrouping)
{
VariationGroupingDAO VariationGroupingDAO = await DataContext.VariationGrouping.Where(x => x.Id == VariationGrouping.Id).FirstOrDefaultAsync();
DataContext.VariationGrouping.Remove(VariationGroupingDAO);
await DataContext.SaveChangesAsync();
return(true);
}
public VariationGrouping ConvertDTOToEntity(VariationGroupingDetail_VariationGroupingDTO VariationGroupingDetail_VariationGroupingDTO)
{
VariationGrouping VariationGrouping = new VariationGrouping();
VariationGrouping.Id = VariationGroupingDetail_VariationGroupingDTO.Id;
VariationGrouping.Name = VariationGroupingDetail_VariationGroupingDTO.Name;
VariationGrouping.ProductId = VariationGroupingDetail_VariationGroupingDTO.ProductId;
return(VariationGrouping);
}
public async Task <VariationGrouping> Get(long Id)
{
VariationGrouping VariationGrouping = await UOW.VariationGroupingRepository.Get(Id);
if (VariationGrouping == null)
{
return(null);
}
return(VariationGrouping);
}
public async Task <bool> Update(VariationGrouping VariationGrouping)
{
VariationGroupingDAO VariationGroupingDAO = DataContext.VariationGrouping.Where(x => x.Id == VariationGrouping.Id).FirstOrDefault();
VariationGroupingDAO.Id = VariationGrouping.Id;
VariationGroupingDAO.Name = VariationGrouping.Name;
VariationGroupingDAO.ProductId = VariationGrouping.ProductId;
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <VariationGroupingMaster_VariationGroupingDTO> Get([FromBody] VariationGroupingMaster_VariationGroupingDTO VariationGroupingMaster_VariationGroupingDTO)
{
if (!ModelState.IsValid)
{
throw new MessageException(ModelState);
}
VariationGrouping VariationGrouping = await VariationGroupingService.Get(VariationGroupingMaster_VariationGroupingDTO.Id);
return(new VariationGroupingMaster_VariationGroupingDTO(VariationGrouping));
}
public async Task <bool> Create(VariationGrouping VariationGrouping)
{
VariationGroupingDAO VariationGroupingDAO = new VariationGroupingDAO();
VariationGroupingDAO.Id = VariationGrouping.Id;
VariationGroupingDAO.Name = VariationGrouping.Name;
VariationGroupingDAO.ProductId = VariationGrouping.ProductId;
await DataContext.VariationGrouping.AddAsync(VariationGroupingDAO);
await DataContext.SaveChangesAsync();
VariationGrouping.Id = VariationGroupingDAO.Id;
return(true);
}
public async Task <bool> ValidateId(VariationGrouping VariationGrouping)
{
VariationGroupingFilter VariationGroupingFilter = new VariationGroupingFilter
{
Skip = 0,
Take = 10,
Id = new LongFilter {
Equal = VariationGrouping.Id
},
Selects = VariationGroupingSelect.Id
};
int count = await UOW.VariationGroupingRepository.Count(VariationGroupingFilter);
if (count == 0)
{
VariationGrouping.AddError(nameof(VariationGroupingValidator), nameof(VariationGrouping.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
public async Task <ActionResult <VariationGroupingDetail_VariationGroupingDTO> > Update([FromBody] VariationGroupingDetail_VariationGroupingDTO VariationGroupingDetail_VariationGroupingDTO)
{
if (!ModelState.IsValid)
{
throw new MessageException(ModelState);
}
VariationGrouping VariationGrouping = ConvertDTOToEntity(VariationGroupingDetail_VariationGroupingDTO);
VariationGrouping = await VariationGroupingService.Update(VariationGrouping);
VariationGroupingDetail_VariationGroupingDTO = new VariationGroupingDetail_VariationGroupingDTO(VariationGrouping);
if (VariationGrouping.IsValidated)
{
return(VariationGroupingDetail_VariationGroupingDTO);
}
else
{
return(BadRequest(VariationGroupingDetail_VariationGroupingDTO));
}
}
public async Task <VariationGrouping> Get(long Id)
{
VariationGrouping VariationGrouping = await DataContext.VariationGrouping.Where(x => x.Id == Id).Select(x => new VariationGrouping()
{
Id = x.Id,
Name = x.Name,
ProductId = x.ProductId,
Product = x.Product == null ? null : new Product
{
Id = x.Product.Id,
Code = x.Product.Code,
Name = x.Product.Name,
Description = x.Product.Description,
ScanCode = x.Product.ScanCode,
ProductTypeId = x.Product.ProductTypeId,
BrandId = x.Product.BrandId,
UnitOfMeasureId = x.Product.UnitOfMeasureId,
UnitOfMeasureGroupingId = x.Product.UnitOfMeasureGroupingId,
SalePrice = x.Product.SalePrice,
RetailPrice = x.Product.RetailPrice,
TaxTypeId = x.Product.TaxTypeId,
StatusId = x.Product.StatusId,
},
}).FirstOrDefaultAsync();
if (VariationGrouping == null)
{
return(null);
}
VariationGrouping.Variations = await DataContext.Variation.Where(x => x.VariationGroupingId == Id).Select(x => new Variation
{
Id = x.Id,
Code = x.Code,
Name = x.Name,
VariationGroupingId = x.VariationGroupingId,
}).ToListAsync();
return(VariationGrouping);
}
public async Task <bool> Create(VariationGrouping VariationGrouping)
{
return(VariationGrouping.IsValidated);
}
public ProductMaster_VariationGroupingDTO(VariationGrouping VariationGrouping)
{
this.Id = VariationGrouping.Id;
this.Name = VariationGrouping.Name;
this.ProductId = VariationGrouping.ProductId;
}
public VariationGroupingDetail_VariationGroupingDTO(VariationGrouping VariationGrouping)
{
this.Id = VariationGrouping.Id;
this.Name = VariationGrouping.Name;
this.ProductId = VariationGrouping.ProductId;
}
