public async Task <bool> DeleteProduct(long productId)
{
using (ASMContext db = new ASMContext())
{
Database.EntityModels.Product product =
db.Products.Where(x => x.ProductId == productId).FirstOrDefault();
if (product != null)
{
db.Products.Remove(product);
}
return(await db.SaveChangesAsync() >= 1);
}
}
public async Task <ProductDto> Get(long webCompanyId, long productId)
{
// var d = await db.Employee.FirstOrDefaultAsync(x => x.FirstName == "Jack");
// _mapper.Map<User>(entity)
using (ASMContext db = new ASMContext())
{
var product = await db.Products
.Include(p => p.WebCompany)
.FirstOrDefaultAsync(m => m.ProductId == productId && m.WebCompanyId == webCompanyId);
var productDto = _mapper.Map <ProductDto>(product);
return(productDto);
}
}
public async Task <ProductDto> SaveProduct(ProductDto productDto)
{
using (ASMContext db = new ASMContext())
{
Database.EntityModels.Product p = db.Products.Where
(x => x.ProductId == productDto.ProductId).FirstOrDefault();
if (p == null)
{
p = new Product()
{
Name = productDto.Name,
Description = productDto.Description,
ProductCode = productDto.ProductCode,
ProductCodeOther = productDto.ProductCodeOther,
Barcode = productDto.Barcode,
PackSize = productDto.PackSize,
WebCompanyId = productDto.WebCompanyId
};
db.Products.Add(p);
}
else
{
p.Name = productDto.Name;
p.Description = productDto.Description;
p.ProductCode = productDto.ProductCode;
p.ProductCodeOther = productDto.ProductCodeOther;
p.Barcode = productDto.Barcode;
p.PackSize = productDto.PackSize;
p.WebCompanyId = productDto.WebCompanyId;
}
await db.SaveChangesAsync();
productDto = await Get(productDto.WebCompanyId, productDto.ProductId);
return(productDto);
}
}
public async Task <List <ProductDto> > Get(long webCompanyId)
{
List <ProductDto> productsDto = new List <ProductDto>();
// _mapper.Map<User>(entity)
using (ASMContext context = new ASMContext())
{
var products = await context.Products.Where(p => p.WebCompanyId == webCompanyId).AsNoTracking().ToListAsync();
var webCompany = await context.WebCompanies.Where(c => c.WebCompanyId == webCompanyId).AsNoTracking().ToListAsync();
var productDto = _mapper.Map <ProductDto>(products);
productsDto = Mapper.Map <List <ProductDto> >(products)
.Map(webCompany);
/*
* products = await (from p in db.Products.AsNoTracking()
*
*
* select new ProductDto
* {
* ProductId = p.ProductId,
* Name = p.Name,
* Description = p.Description,
* ProductCode = p.ProductCode,
* ProductCodeOther = p.ProductCodeOther,
* Barcode = p.Barcode,
* PackSize = p.PackSize,
* CompanyName = p.WebCompany.CompanyName,
* WebCompanyId = p.WebCompanyId
* }).ToListAsync();
*/
}
return(productsDto);
}
public AccessGroupAssignmentRepository(ASMContext asmContext) : base(asmContext)
{
_asmContext = asmContext ?? throw new ArgumentNullException(nameof(asmContext));
}
public ApplicationSecurityRepository(ASMContext asmContext)
{
_asmContext = asmContext ?? throw new ArgumentNullException(nameof(asmContext));
}
public ModuleTypeRepository(ASMContext asmContext) : base(asmContext)
{
_asmContext = asmContext ?? throw new ArgumentNullException(nameof(asmContext));
}
public AssetRepository(ASMContext context) : base(context)
{
_context = context;
}
public RepositoryBase(ASMContext context)
{
_context = context;
}
