public ActionResult CompleteCheckout() { string cardNum = Convert.ToString(Request["cardNum"].ToString().Trim()); int expMonth = Convert.ToInt32(Request["cardExpMo"].ToString().Trim()); int expYear = Convert.ToInt32(Request["cardExpYe"].ToString().Trim()); var custInvoice = new Invoice { Total = ES.total, CardNumber = cardNum, ExpirationMonth = expMonth, ExpirationYear = expYear, SellerID = ES.SellerID, Email = ES.Email, OrderDate = DateTime.Now }; Invoice newInvoice = db.Invoices.Add(custInvoice); db.SaveChanges(); var customerList = from m in db.Customers where m.Email == ES.Email select m; foreach (var item in ES.magList) { db.InvoiceContains.Add(new InvoiceContain { InvoiceNumber = newInvoice.InvoiceNumber, MID = item.MID }); customerList.First().SubscriptionsBought = customerList.First().SubscriptionsBought + 1; db.SaveChanges(); } CompleteInvoice CI = new CompleteInvoice { inv = newInvoice, magList = ES.magList }; return View(CI); }
public ActionResult InvoiceDetails(Invoice inv) { CompleteInvoice cInv = new CompleteInvoice(); cInv.inv = inv; var magazineList = from n in db.InvoiceContains join m in db.Magazines on n.MID equals m.MID where n.InvoiceNumber == inv.InvoiceNumber select m; cInv.magList = magazineList.ToList(); return View(cInv); }