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