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