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)); }