public IActionResult GetDSMatHangBanChayNhat_LinQ([FromBody] ProductsReq req)
{
var res = new SingleRsp();
res.Data = _svc.GetDSMatHangBanChayNhat_LinQ(req.size, req.page, req.month, req.year);
return(Ok(res));
}
public IActionResult GetDanhSachProductKhongCoDonHangTrongNgay([FromBody] ProductsReq req)
{
var res = new SingleRsp();
res.Data = _svc.GetDanhSachProductKhongCoDonHangTrongNgay(req.size, req.page, req.date);
return(Ok(res));
}
public IActionResult SanPham_Select_by_Id([FromBody] ProductsReq req)
{
var res = new SingleRsp();
res.Data = _svc.SanPham_Select_by_Id(req.IdLoai);
return(Ok(res));
}
public IActionResult GetSP_ProductAccessories([FromBody] ProductsReq req)
{
var res = new SingleRsp();
var hist = _svc.GetSP_ProductAccessories(req.Keyword, req.Page, req.Size);
res.Data = hist;
return(Ok(res));
}
public SingleRsp UpdateProduct(ProductsReq pro)
{
var res = new SingleRsp();
SanPham products = new SanPham();
products.IdSanPham = pro.IdSanPham;
products.IdLoai = pro.IdLoai;
products.Ten = pro.Ten;
products.MoTa = pro.MoTa;
products.Gia = pro.Gia;
res = _rep.UpdateProduct(products);
return(res);
}
//===========================================================
//===========================================================
#region -- Create Product --
public SingleRsp CreateProduct(ProductsReq pro)
{
var res = new SingleRsp();
Products product = new Products();
product.CategoryId = pro.CategoryId;
product.ProductName = pro.ProductName;
product.Photo = pro.Photo;
product.Description = pro.Description;
product.ProductSlug = pro.ProductSlug;
product.IsActive = pro.IsActive;
// we must to save a new product before.
// if we don't, we will not have productID to do anything.
res = _rep.CreateProduct(product);
// ProductsReq pro have Options is a list.
// so we get those options and store it into database.
foreach (var po in pro.Options)
{
using (var context = new EatWellDBContext())
{
using (var tran = context.Database.BeginTransaction())
{
try
{
ProductOptions product_option = new ProductOptions();
product_option.ProductId = product.ProductId;
product_option.OptionId = po.OptionId;
product_option.Price = po.Price;
// add a new record in to ProductOptions table
var t = context.ProductOptions.Add(product_option);
context.SaveChanges();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
res.SetError(ex.StackTrace);
}
}
}
}
return(res);
}
public SingleRsp UpdateProduct(ProductsReq pro)
{
var res = new SingleRsp();
Products products = new Products();
products.ProductId = pro.ProductId;
products.CategoryId = pro.CategoryId;
products.ProductName = pro.ProductName;
products.Price = pro.Price;
products.Stock = pro.Stock;
products.DateCreate = pro.DateCreate;
products.Description = pro.Description;
products.ImageSource = pro.ImageSource;
products.PromotionId = pro.PromotionId;
res = _rep.UpdateProduct(products);
return(res);
}
public SingleRsp UpdateProduct(ProductsReq pro)
{
var res = new SingleRsp();
Products products = new Products();
products.ProductId = pro.ProductId;
products.ProductName = pro.ProductName;
products.SupplierId = pro.SupplierId;
products.CategoryId = pro.CategoryId;
products.QuantityPerUnit = pro.QuantityPerUnit;
products.UnitPrice = pro.UnitPrice;
products.UnitsInStock = pro.UnitsInStock;
products.UnitsOnOrder = pro.UnitsOnOrder;
products.ReorderLevel = pro.ReorderLevel;
products.Discontinued = pro.Discontinued;
res = _rep.UpdateProduct(products);
res.Data = products;
return(res);
}
// hàm create product
public SimpleRsp CreateProduct(ProductsReq pro)
{
var res = new SimpleRsp();
//gán đối tượng từ rep sang đối tượng database
Products products = new Products();
products.ProductId = pro.ProductId;
products.ProductName = pro.ProductName;
products.SupplierId = pro.SupplierId;
products.CategoryId = pro.CategoryId;
products.QuantityPerUnit = pro.QuantityPerUnit;
products.UnitPrice = pro.UnitPrice;
products.UnitsInStock = pro.UnitsInStock;
products.ReorderLevel = pro.ReorderLevel;
products.Discontinued = pro.Discontinued;
// xử lý create
res = _rep.CreateProduct(products);
return(res);
}
public object UpdateProduct(ProductsReq req)
{
var res = new SimpleRsp();
//gán đối tượng từ rep sang đối tượng database
Products products = new Products();
products.ProductId = req.ProductId;
products.ProductName = req.ProductName;
products.SupplierId = req.SupplierId;
products.CategoryId = req.CategoryId;
products.QuantityPerUnit = req.QuantityPerUnit;
products.UnitPrice = req.UnitPrice;
products.UnitsInStock = req.UnitsInStock;
products.ReorderLevel = req.ReorderLevel;
products.Discontinued = req.Discontinued;
//xử lý update
res = _rep.UpdateProduct(products);
return(res);
}
//===========================================================
//===========================================================
#region -- Update Product --
public SingleRsp UpdateProduct(ProductsReq pro)
{
var res = new SingleRsp();
var product = All.Where(x => x.ProductId == pro.ProductId).FirstOrDefault();
if (product != null)
{
product.CategoryId = pro.CategoryId;
product.ProductName = pro.ProductName;
product.Photo = pro.Photo;
product.Description = pro.Description;
product.ProductSlug = pro.ProductSlug;
product.IsActive = pro.IsActive;
res = _rep.UpdateProduct(product);
foreach (var po in product.ProductOptions)
{
EatWellDBContext db = new EatWellDBContext();
var productoption = new ProductOptions();
productoption.ProductId = product.ProductId;
productoption.OptionId = po.OptionId;
productoption.Price = po.Price;
db.ProductOptions.Update(productoption);
db.SaveChangesAsync();
}
}
else
{
}
return(res);
}
public IActionResult UpdateProduct([FromBody] ProductsReq req)
{
var res = _svc.UpdateProduct(req);
return(Ok(res));
}
public IActionResult CreateProduct([FromBody] ProductsReq req)
{
var pros = _svc.CreateProduct(req);
return(Ok(req));
}
