public ActionResult Index(String EMailToSearch) { tblUser t = null; List <tblOrder> ord = null; if (!String.IsNullOrEmpty(EMailToSearch)) { using (dbOrdersEntities ctx = new dbOrdersEntities()) { t = ctx .tblUsers .SingleOrDefault <tblUser>(x => x.customerEmail == EMailToSearch); if (null != t) { ord = ctx.tblOrders .Include("tblProduct") .Where <tblOrder>(x => x.customerFK == t.idAutoPK) .ToList <tblOrder>(); } } } CSearchViewModel cs = new CSearchViewModel() { EMailToSearch = EMailToSearch, User = t, Orders = ord }; return(View(cs)); }
public ActionResult EditInvoice(int?id, tblOrder t, string redirectTo) { tblOrder tb = null; using (dbOrdersEntities ctx = new dbOrdersEntities()) { tb = ctx.tblOrders.Include("tblUser").SingleOrDefault <tblOrder>(x => x.idAutoPK == id); tb.invoiceAmount = t.invoiceAmount; tb.productCodeFK = t.productCodeFK; ctx.SaveChanges(); } if ("PrintInvoice" == redirectTo) { return(RedirectToAction("PrintInvoice", new { id = id })); } else { return(RedirectToAction("Index", "SearchCustomer", new { EMailToSearch = tb.tblUser.customerEmail })); } }
private void FillProducts(dbOrdersEntities ctxt) { ViewBag.Products = ctxt.tblProducts.ToList <tblProduct>(); ViewBag.Products.Insert(0, new tblProduct() { productCode = "", productName = "[-Select-]" }); }
public ActionResult EditCustomer(int?id) { tblUser t = null; using (dbOrdersEntities ctxt = new dbOrdersEntities()) { t = ctxt.tblUsers.SingleOrDefault <tblUser>(x => x.idAutoPK == id); } return(View(t)); }
public ActionResult AutoComplete(String term) { using (dbOrdersEntities ctx = new dbOrdersEntities()) { var arr = ctx.tblUsers .Where <tblUser>(x => x.customerEmail.StartsWith(term)) .Select <tblUser, string>(x => x.customerEmail) .ToArray <string>(); return(Json(arr, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditInvoice(int?id) { tblOrder t = null; using (dbOrdersEntities ctx = new dbOrdersEntities()) { FillProducts(ctx); t = ctx.tblOrders.Include("tblUser").SingleOrDefault <tblOrder>(x => x.idAutoPK == id); } return(View(t)); }
public ActionResult Index(int?id) { tblOrder t = new tblOrder(); using (dbOrdersEntities ctxt = new dbOrdersEntities()) { FillProducts(ctxt); t.tblUser = ctxt.tblUsers.SingleOrDefault <tblUser>(x => x.idAutoPK == id); } return(View(t)); }
public ActionResult EditCustomer(int?id, tblUser t) { using (dbOrdersEntities ctxt = new dbOrdersEntities()) { t.idAutoPK = id ?? 0; ctxt.tblUsers.Attach(t); ctxt.Entry(t).State = System.Data.EntityState.Modified; ctxt.SaveChanges(); } return(RedirectToAction("Index", "SearchCustomer", new { EMailToSearch = t.customerEmail })); }
public ActionResult IsEMailAvailable(String customerEMail, String hfSuppressRemote) { bool bRet = false; using (dbOrdersEntities ctx = new dbOrdersEntities()) { bRet = ( null == ctx.tblUsers.SingleOrDefault(x => x.customerEmail == customerEMail) ); } return(Json(hfSuppressRemote == "1" ? true : bRet, JsonRequestBehavior.AllowGet)); }
public ActionResult ShowLastTenInvoices() { List <tblOrder> ret = null; using (dbOrdersEntities ctxt = new dbOrdersEntities()) { ret = ctxt.tblOrders .Include("tblProduct") .Include("tblUser") .OrderByDescending <tblOrder, DateTime>(x => x.orderDate) .Take <tblOrder>(10).ToList <tblOrder>(); } return(View(ret)); }
public ActionResult Index(int?id, tblOrder t) { using (dbOrdersEntities ctxt = new dbOrdersEntities()) { if (ModelState.IsValid) { t.customerFK = id ?? 0; t.orderDate = DateTime.Now; ctxt.tblOrders.Add(t); ctxt.SaveChanges(); } } return(RedirectToAction("PrintInvoice", new { id = t.idAutoPK })); }
public ActionResult Index(tblUser t) { if (ModelState.IsValid) { using (dbOrdersEntities ctxt = new dbOrdersEntities()) { ctxt.tblUsers.Add(t); ctxt.SaveChanges(); } ViewBag.Message = "Record Saved"; ModelState.Clear(); } return(View()); }
public ActionResult ShowTopTenCustomers() { List <CCustomerOrderReport> ret = null; using (dbOrdersEntities ctxt = new dbOrdersEntities()) { var orders = ctxt.tblOrders; ret = ctxt.tblUsers .GroupJoin <tblUser, tblOrder, int, CCustomerOrderReport>(orders, x => x.idAutoPK, y => y.customerFK, (h, k) => new CCustomerOrderReport() { CustomerName = h.customerEmail, TotalOrderAmount = k.Sum <tblOrder>(x => x.invoiceAmount), TotalNumberOfOrders = k.Count <tblOrder>() }) .OrderByDescending(z => z.TotalOrderAmount) .ToList <CCustomerOrderReport>(); return(View(ret)); } }