public ActionResult Index() { ViewBag.userName = Session["userName"]; ViewBag.logged = Session["LoggedIN"]; Product_Report re = Report.report(); ReportDetails reDetails = new ReportDetails(); reDetails.productName = product.Get(re.Product_ID).Product_Name; reDetails.category = category.Get(product.Get(re.Product_ID).Category_ID).Category_Name; reDetails.subCategory = subCategory.Get(product.Get(re.Product_ID).Sub_Category_ID).Sub_Category_Name; reDetails.productPicture = product.Get(re.Product_ID).Product_Picture; reDetails.productPrice = product.Get(re.Product_ID).Product_Price; reDetails.totalSellingQuantity = re.Selling_Quantity; int summation = 0, x = 0; IEnumerable <Product_Report> reportList = Report.GetAllValues(); foreach (Product_Report r in reportList) { x = product.Get(r.Product_ID).Product_Price *r.Selling_Quantity; summation += x; } ViewBag.totalSellingPrice = summation; return(View(reDetails)); }
public int Delete(int id) { Product_Report proRE = this.context.Product_Report.SingleOrDefault(x => x.Product_ID == id); this.context.Product_Report.Remove(proRE); return(this.context.SaveChanges()); }
public int Update(Product_Report product_report) { Product_Report proRe = this.context.Product_Report.SingleOrDefault(x => x.Product_ID == product_report.Product_ID); proRe.Selling_Quantity = product_report.Selling_Quantity; return(this.context.SaveChanges()); }
public int Update(Product_Report Product_Report) { return(this.data.Update(Product_Report)); }
public int Insert(Product_Report Product_Report) { return(this.data.Insert(Product_Report)); }
// // GET: /BuyingConfimation/ public ActionResult Index() { ViewBag.userName = Session["userName"]; ViewBag.logged = Session["LoggedIN"]; iCart_Service cart = Service_Center.GetCart_Service(); iProduct_Service productAll = Service_Center.GetProduct_Service();// iBuying_History_Service buyingHistory = Service_Center.GetBuying_History_Service(); iProduct_Report_Service report = Service_Center.GetProduct_Report_Service(); IEnumerable <Cart> FullCart = cart.Get(Session["userName"].ToString()); foreach (Cart c in FullCart) { Product pro = new Product(); IEnumerable <Product> proAll = productAll.GetAllValues(); foreach (Product p in proAll) { if (p.Id == c.ProductID) { int before = productAll.Get(p.Id).Product_Quantity; int after = before - c.BuyingQuantity; pro.Id = p.Id; pro.Product_Quantity = after; int y = productAll.Update(pro); } } Buying_History buy = new Buying_History(); Product_Report rep = new Product_Report(); buy.Product_ID = c.ProductID; buy.User_Name = Session["userName"].ToString(); buy.Buying_Quantity = c.BuyingQuantity; buy.Buying_Date = DateTime.Now.ToLocalTime(); IEnumerable <Product_Report> proReport = report.GetAllValues(); bool check = false; int productID = 0; foreach (Product_Report r in proReport) { if (r.Product_ID == c.ProductID) { check = true; productID = r.Product_ID; break; } } if (check == true) { int beforeQuantity = report.Get(productID).Selling_Quantity; int afterQuantity = beforeQuantity + c.BuyingQuantity; rep.Product_ID = productID; rep.Selling_Quantity = afterQuantity; int p = report.Update(rep); } else { rep.Product_ID = c.ProductID; rep.Selling_Quantity = c.BuyingQuantity; int j = report.Insert(rep); } int i = buyingHistory.Insert(buy); } int de = cart.DeleteUserCart(Session["userName"].ToString()); //ViewBag.row = cartRow; return(View()); }
public int Insert(Product_Report product_report) { this.context.Product_Report.Add(product_report); return(this.context.SaveChanges()); }