public ActionResult Orders()
{
dbQuanlycuahangdienmayEntities1 db = new dbQuanlycuahangdienmayEntities1();
//List<Tbl_Invoice> allinvoice = _unitOfWork.GetRepositoryInstance<Tbl_Invoice>().GetAllRecordsIQueryable().ToList();
var order = db.Tbl_Invoice.ToList();
return(View(order));
}
public ActionResult OrderDetail(int id)
{
dbQuanlycuahangdienmayEntities1 db = new dbQuanlycuahangdienmayEntities1();
//var orderdetail = db.Tbl_InvoiceDetail.Where(x => x.InvoiceID == id).ToList();
//var orderdetail = db.Tbl_InvoiceDetail.Include(x => x.)
var orderModels = from a in db.Tbl_InvoiceDetail
join b in db.Tbl_Product
on a.ProductID equals b.ProductID
select new OrderModel()
{
ProductID = b.ProductID,
InvoiceID = a.InvoiceID,
Price = b.Price,
ProductImage = b.ProductImage,
ProductName = b.ProductName,
Quantity = a.Quantity
};
var OrderDetail = orderModels.Where(x => x.InvoiceID == id).ToList();
return(View(OrderDetail));
}
public ActionResult Login(Tbl_Login model, string returnUrl)
{
dbQuanlycuahangdienmayEntities1 db = new dbQuanlycuahangdienmayEntities1();
//var dataItem = db.Tbl_Login.Where(x=>x.Username == model.Username && x.Password).First();
var dataItem = db.Tbl_Login.Where(x => x.Username == model.Username && x.Password == model.Password).SingleOrDefault();
if (dataItem != null)
{
if (dataItem.Role == "user")
{
HttpCookie cookie = new HttpCookie("userName", dataItem.Username);
//cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
return(Redirect("/"));
}
else
{
HttpCookie cookie = new HttpCookie("userName", dataItem.Username);
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
return(Redirect("/Admin/Dashboard"));
}
//FormsAuthentication.SetAuthCookie(dataItem.Username, false);
//if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/")
// && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("//"))
//{
// return Redirect(returnUrl);
//}
//else
//{
// return Redirect("/Admin/Dashboard");
//}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
public GenericRepository(dbQuanlycuahangdienmayEntities1 DBEntity)
{
_DBEntity = DBEntity;
_dbSet = DBEntity.Set <Tbl_Entity>();
}
