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