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