public ActionResult CountBooks() { if (Session["CurUsr"] == null) { Response.Redirect("SignIn"); } ViewData["People"] = DM.Rd.readers().ToList(); ViewData["Counts"] = (from t in DM.Rd.readers() select t.BookGiving.Count).ToList(); var values = (from t in DM.Rd.readers() select new NamePlusCountBooks(t.FIO, t.Library_Card, t.Phone_Number, t.Email, t.Registration_Date, t.BookGiving.Count)). OrderBy(p => p.Count). Reverse(). ToList(); ViewData["AllCounts"] = values; string path = Server.MapPath("~/Files/CountBooks.xlsx"); ExcelExecuter.XLOutput_NamePlusCountBooks(path, values); return(View()); }
public ActionResult Debtors() { if (Session["CurUsr"] == null) { Response.Redirect("SignIn"); } List <NamePlusCountBooks> NP = (from t in DM.Rd.readers() let countB = (from p in DM.BG.bookGivings() where (p.Reader.Id == t.Id && p.BookReturning == null && p.Expected_Return_Date < DateTime.Today) select p).Count() where countB > 0 select new NamePlusCountBooks(t.FIO, t.Library_Card, t.Phone_Number, t.Email, t.Registration_Date, countB)).ToList(); ViewData.Model = NP; ViewData["Debtors"] = ViewData.Model; string path = Server.MapPath("~/Files/Debt.xlsx"); ExcelExecuter.XLOutput_NamePlusCountBooks(path, NP); return(View()); }