public ActionResult EditSelling([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 sTORE_PURCHASE) { if (ModelState.IsValid) { STORE_PURCHAGE sTORE_PURCHASE_UPD = db.STORE_PURCHAGE.Find(sTORE_PURCHASE.ID); sTORE_PURCHASE_UPD.PRODUCT_ID = sTORE_PURCHASE.PRODUCT_ID; sTORE_PURCHASE_UPD.UNIT_SOLD = sTORE_PURCHASE.UNIT_SOLD; sTORE_PURCHASE_UPD.SOLD_PRICE = sTORE_PURCHASE.SOLD_PRICE; sTORE_PURCHASE_UPD.SOLD_BY = sTORE_PURCHASE.SOLD_BY; sTORE_PURCHASE_UPD.SOLD_ON = sTORE_PURCHASE.SOLD_ON; sTORE_PURCHASE_UPD.STUDENT_NAME = sTORE_PURCHASE.STUDENT_NAME; sTORE_PURCHASE_UPD.STUDENT_CONTACT_NO = sTORE_PURCHASE.STUDENT_CONTACT_NO; sTORE_PURCHASE_UPD.MONEY_RECEIVED_BY = sTORE_PURCHASE.MONEY_RECEIVED_BY; sTORE_PURCHASE_UPD.IS_DEPOSITED = sTORE_PURCHASE.IS_DEPOSITED; sTORE_PURCHASE_UPD.IS_ACT = sTORE_PURCHASE.IS_ACT; sTORE_PURCHASE_UPD.UPDATED_AT = DateTime.Now; db.Entry(sTORE_PURCHASE_UPD).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ViewAllSelling")); } ViewBag.PRODUCT_ID = new SelectList(db.STORE_PRODUCTS, "PRODUCT_ID", "NAME", sTORE_PURCHASE.PRODUCT_ID); DateTime SDate = Convert.ToDateTime(sTORE_PURCHASE.SOLD_ON); ViewBag.SOLD_ON = SDate.ToShortDateString(); return(View(sTORE_PURCHASE)); }
// GET: Store/Edit/5 public ActionResult EditSelling(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } STORE_PURCHAGE sTORE_PURCHASE = db.STORE_PURCHAGE.Find(id); if (sTORE_PURCHASE == null) { return(HttpNotFound()); } ViewBag.PRODUCT_ID = new SelectList(db.STORE_PRODUCTS, "PRODUCT_ID", "NAME", sTORE_PURCHASE.PRODUCT_ID); DateTime SDate = Convert.ToDateTime(sTORE_PURCHASE.SOLD_ON); ViewBag.SOLD_ON = SDate.ToShortDateString(); return(View(sTORE_PURCHASE)); }
// GET: Student //[HttpGet] public ActionResult Payment(string PAYMENT_MODE, string STUDENT_NAME, decimal?PAYMENT_AMOUNT, long?PHONE_NUMBER, DateTime?PURCHAGE_DATE) { ViewBag.STUDENT_NAME = STUDENT_NAME; ViewBag.PHONE_NUMBER = PHONE_NUMBER; ViewBag.PURCHAGE_DATE = PURCHAGE_DATE; ViewBag.PAYMENT_MODE = PAYMENT_MODE; ViewBag.CartItems = (from t in db.STORE_PURCHAGE_CART select t).Count(); var TotalPriceSel = db.STORE_PURCHAGE_CART.GroupBy(o => o.ID) .Select(g => new { membername = g.Key, total = g.Sum(p => p.SOLD_PRICE) }); int TCost = 0; foreach (var group in TotalPriceSel) { TCost = TCost + Convert.ToInt32(group.total); } ViewBag.PaidPrice = TCost.ToString(); ViewBag.TotalPrice = 0; if (PHONE_NUMBER == null) { PHONE_NUMBER = 9967803589; } var IDList = new int[20]; int i = 0; var pURcART = (from res in db.STORE_PURCHAGE_CART select res).ToList(); foreach (var PurCarList in pURcART) { STORE_PURCHAGE StorePur = db.STORE_PURCHAGE.Find(PurCarList.ID); StorePur.PRODUCT_ID = PurCarList.PRODUCT_ID; StorePur.UNIT_SOLD = PurCarList.UNIT_SOLD; StorePur.SOLD_PRICE = PurCarList.SOLD_PRICE; StorePur.SOLD_BY = PurCarList.MONEY_RECEIVED_BY; StorePur.SOLD_ON = PURCHAGE_DATE; StorePur.STUDENT_NAME = STUDENT_NAME; StorePur.STUDENT_CONTACT_NO = PHONE_NUMBER; StorePur.MONEY_RECEIVED_BY = PAYMENT_MODE; StorePur.IS_DEPOSITED = "N"; StorePur.IS_ACT = "Y"; StorePur.IS_DEL = "N"; StorePur.CREATED_AT = PurCarList.CREATED_AT; StorePur.UPDATED_AT = PurCarList.UPDATED_AT; db.STORE_PURCHAGE.Add(StorePur); db.SaveChanges(); IDList[i] = StorePur.ID; i++; } var payments = from p in db.STORE_PURCHAGE.Where(a => IDList.Any(s => a.ID.Equals(s))) group p by p.PRODUCT_ID into g select new { ProductNo = g.Key, UNIT_SOLD = g.Count(), AMNT = g.Sum(x => x.SOLD_PRICE), PUR_DATE = DateTime.Now }; var ProductS = (from pd in db.STORE_PRODUCTS join ct in db.STORE_CATEGORY on pd.CATEGORY_ID equals ct.ID join pct in payments on pd.PRODUCT_ID equals pct.ProductNo orderby pd.NAME, ct.NAME select new Models.PurchaseCart { ProductData = pd, CategoryData = ct, UNIT_SOLD = pct.UNIT_SOLD, SOLD_AMNT = pct.AMNT, PUR_DATE = pct.PUR_DATE }).Distinct(); db.Database.ExecuteSqlCommand("DELETE FROM STORE_PURCHAGE_CART"); return(View("_ListPurchagedProducts", ProductS.ToList())); }