public ActionResult Purchase([Bind(Include = "ID,PRODUCT_ID,UNIT_SOLD,SOLD_PRICE,SOLD_BY,SOLD_ON,STUDENT_NAME,STUDENT_CONTACT_NO,MONEY_RECEIVED_BY,IS_DEPOSITED,IS_ACT,IS_DEL,CREATED_AT,UPDATED_AT")] STORE_PURCHAGE_CART sTORE_PURCHAGE_cART) { if (ModelState.IsValid) { sTORE_PURCHAGE_cART.IS_DEL = "N"; sTORE_PURCHAGE_cART.CREATED_AT = DateTime.Now; sTORE_PURCHAGE_cART.UPDATED_AT = DateTime.Now; db.STORE_PURCHAGE_CART.Add(sTORE_PURCHAGE_cART); db.SaveChanges(); STORE_PRODUCTS sTOREpRODUCT = db.STORE_PRODUCTS.Find(sTORE_PURCHAGE_cART.PRODUCT_ID); sTOREpRODUCT.UPDATED_AT = DateTime.Now; sTOREpRODUCT.UNIT_LEFT = sTOREpRODUCT.UNIT_LEFT - sTORE_PURCHAGE_cART.UNIT_SOLD; db.Entry(sTOREpRODUCT).State = EntityState.Modified; db.SaveChanges(); ViewBag.CartItems = (from t in db.STORE_PURCHAGE_CART select t).Count(); return(RedirectToAction("ViewAll")); } ViewBag.PRODUCT_ID = new SelectList(db.STORE_PRODUCTS, "PRODUCT_ID", "NAME", sTORE_PURCHAGE_cART.PRODUCT_ID); return(View(sTORE_PURCHAGE_cART)); }
// GET: Purchase/Create public ActionResult Purchase(int?id) { //ViewBag.PRODUCT_ID = new SelectList(db.STORE_PRODUCTS.Where(o => o.PRODUCT_ID == id).ToList(), "PRODUCT_ID", "NAME"); //ViewBag.CartItems = (from t in db.STORE_PURCHAGE_CART // select t).Count(); STORE_PRODUCTS sTOREpRODUCT = db.STORE_PRODUCTS.Find(id); var sTORE_PURCHAGE_cART = new STORE_PURCHAGE_CART() { PRODUCT_ID = sTOREpRODUCT.PRODUCT_ID, UNIT_SOLD = 1, SOLD_PRICE = sTOREpRODUCT.SELL_PRICE_PER_UNIT, SOLD_BY = this.Session["UserId"].ToString(), SOLD_ON = DateTime.Now, STUDENT_NAME = null, STUDENT_CONTACT_NO = null, MONEY_RECEIVED_BY = null, IS_DEPOSITED = null, IS_ACT = null, IS_DEL = null, CREATED_AT = DateTime.Now, UPDATED_AT = DateTime.Now }; db.STORE_PURCHAGE_CART.Add(sTORE_PURCHAGE_cART); db.SaveChanges(); sTOREpRODUCT.UPDATED_AT = DateTime.Now; sTOREpRODUCT.UNIT_LEFT = sTOREpRODUCT.UNIT_LEFT - 1; db.Entry(sTOREpRODUCT).State = EntityState.Modified; db.SaveChanges(); ViewBag.CartItems = (from t in db.STORE_PURCHAGE_CART select t).Count(); return(RedirectToAction("ViewAll")); }