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