public ActionResult Index([Bind(Include = "SaleKey")] string sk)
{
var resultMessage = new Message();
Sale sl;
if (Request["SaleKey"] == "")
{
sl = new Sale();
sl.SaleDate = DateTime.Now;
db.Sales.Add(sl);
}
else
{
sl = db.Sales.Find(Int32.Parse(Request["SaleKey"]));
}
if (ModelState.IsValid)
{
var slDet = new SaleDetail();
sl.CustomerKey = Int32.Parse(Request["CustomerKey"]);
sl.EmployeeKey = Int32.Parse(Request["EmployeeKey"]);
slDet.ProductKey = Int32.Parse(Request["Products"]);
slDet.SaleDetailPriceCharged = db.Products.Find(Int32.Parse(Request["Products"])).ProductPrice;
slDet.SaleDetailQuantity = Request["Quantity"] == "" ? 0 : Int32.Parse(Request["Quantity"]);
slDet.SaleDetailDiscount = Request["Discount"] == "" ? 0 : Int32.Parse(Request["Discount"]);
slDet.SaleDetailSaleTaxPercent = 10;
slDet.SaleDetailEatInTax = 20;
sl.SaleDetails.Add(slDet);
db.SaveChanges();
if (Request["addmore"] == "Confirm and Add Another Product")
{
return(View(sl));
}
else
{
db.Entry(sl).Reference(r => r.Person).Load();
db.Entry(sl).Reference(r => r.Employee).Load();
db.Entry(sl.Employee).Reference(r => r.Person).Load();
return(View("Receipt", sl));
}
}
else
{
resultMessage.MessageText = "We're so sorry, something seems to have gone wrong. Please try again.";
return(View("Result", resultMessage));
}
}
public ActionResult Edit([Bind(Include = "PersonKey,PersonLastName,PersonFirstName,PersonEmail,PersonPhone,PersonDateAdded")] Person person)
{
if (ModelState.IsValid)
{
db.Entry(person).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(person));
}
public ActionResult Edit([Bind(Include = "ProductKey,ProductName,ProductPrice")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Edit([Bind(Include = "ProductKey,ProductName,ProductPrice,SaleKey,SaleDate,CustomerKey,EmployeeKey")] Sale sale)
{
if (ModelState.IsValid)
{
db.Entry(sale).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductKey = new SelectList(db.Sales, "ProductKey", "ProductName", sale.ProductKey);
ViewBag.EmployeeKey = new SelectList(db.Employees, "EmployeeKey", "EmployeeTitle", sale.EmployeeKey);
ViewBag.CustomerKey = new SelectList(db.People, "PersonKey", "PersonLastName", sale.CustomerKey);
return(View(sale));
}