public ActionResult Login(string TenDN, string MatKhau) { using (var db = new WebBanHang1.Models.BanHang()) { var emp = db.Employees.SingleOrDefault(x => x.TenDN == TenDN); if (emp != null) { emp = db.Employees.SingleOrDefault(x => x.TenDN == TenDN && x.MatKhau == MatKhau); if (emp != null) { Session["employee"] = emp; return(RedirectToAction("Index", "/Trangchu")); } else { TempData["err_matkhau"] = "<script>swal('sai mật khẩu!');</script>"; } } else { TempData["err_tendangnhap"] = "<script>swal('sai tên đăng nhập!');</script>"; } } return(View()); }
public ActionResult GetData() { var query = new WebBanHang1.Models.BanHang().Database.SqlQuery <tam>("select top(10) month(OrderDate) [name],SUM(TotalMoney) [count] " + "from Orders where DATEDIFF(MONTH, OrderDate, GETDATE()) <= 11 " + "group by YEAR(OrderDate), MONTH(OrderDate) order by month(OrderDate) ").ToList(); var b = query.Count; // Order_Details.Include("Products"). //GroupBy(p => p.Products.ProductName) //.Select(g => new { name = g.Key, count = g.FirstOrDefault().Quantity }); return(Json(query, JsonRequestBehavior.AllowGet)); }