public ActionResult MoveIndexs(int indexs, int id, bool flag = false, string TextSearch = null, int idPoick = -1) { List <Book> books = new List <Book>(); if (!flag && idPoick == -1) { int max = categoryid; books = db.Books.Where(b => b.Category_ID == id).Select(b => b).OrderByDescending(d => d.Name).Skip(indexs).Take(5).ToList(); MoveIndexMax = db.Books.Where(b => b.Category_ID == id).Count(); ViewBag.Flag = false; } else if (flag && idPoick == -1) { int max = categoryid; books = db.Books.Where(b => b.Category_ID == id).Select(b => b).OrderBy(d => d.Name).Skip(indexs).Take(5).ToList(); MoveIndexMax = db.Books.Where(b => b.Category_ID == id).Count(); ViewBag.Flag = true; } else if (idPoick != -1) { if (idPoick == 0) { ViewBag.FlagF = true; ViewBag.OjectScrin = 0; foreach (Auftor auftorr in db.Auftors.Where(auftorr => auftorr.FIO.ToUpper().StartsWith(TextSearch))) { books.AddRange(db.Books.Where(d => d.Auftor_ID == auftorr.ID && d.Category_ID == id).OrderBy(n => n.Name).Skip(indexs).Take(5).Select(b => b).ToList()); } } else { ViewBag.FlagF = true; ViewBag.OjectScrin = 1; books = db.Books.Where(b => b.Name.ToUpper().StartsWith(TextSearch) && b.Category_ID == id).OrderBy(n => n.Name).Skip(indexs).Take(5).Select(b => b).ToList(); } } ViewBag.Books = books; ViewBag.MoveIndexMax = MoveIndexMax; var category = db.Categoryis.ToList(); ViewBag.Category = category; Categoryi categoryi = db.Categoryis.Find(id); ViewBag.ID = categoryi; return(View("Category")); }
public ActionResult Category(int id, string ClasSearch, string TextSearch) { categoryid = id; List <Book> books = new List <Book>(); ViewBag.TextSearch = TextSearch; if (ClasSearch == "Автор") { ViewBag.OjectScrin = 0; List <int> di = new List <int>(); foreach (Auftor auftorr in db.Auftors.Where(auftorr => auftorr.FIO.ToUpper().StartsWith(TextSearch))) { di.Add(auftorr.ID); } foreach (int g in di) { books = db.Books.Where(d => d.Auftor_ID == g && d.Category_ID == id).OrderBy(n => n.Name).Take(5).Select(b => b).ToList(); } } else { ViewBag.OjectScrin = 1; books = db.Books.Where(b => b.Name.ToUpper().StartsWith(TextSearch) && b.Category_ID == id).OrderBy(n => n.Name).Take(5).Select(b => b).ToList(); }/* * if (false) * { * } * else * { * books = books.OrderByDescending(n => n.Name).Select(b => b).ToList(); * }*/ MoveIndexMax = db.Books.Where(b => b.Name.ToUpper().StartsWith(TextSearch)).Count(); ViewBag.MoveIndexMax = MoveIndexMax; ViewBag.Flag = false; ViewBag.FlagF = true; ViewBag.Books = books; Categoryi categoryi = db.Categoryis.Find(id); ViewBag.ID = categoryi; var category = db.Categoryis.ToList(); ViewBag.Category = category; return(View("Category")); }
public ActionResult Category(int id = -1, bool flag = false) { if (id != -1) { categoryid = id; List <Book> books = new List <Book>(); if (flag) { books = db.Books.Where(b => b.Category_ID == id).OrderBy(n => n.Name).Take(5).Select(b => b).ToList(); } else { books = db.Books.Where(b => b.Category_ID == id).OrderByDescending(n => n.Name).Take(5).Select(b => b).ToList(); } MoveIndexMax = db.Books.Where(b => b.Category_ID == id).Count(); ViewBag.MoveIndexMax = MoveIndexMax; ViewBag.Flag = flag; ViewBag.FlagF = false; ViewBag.Books = books; Categoryi categoryi = db.Categoryis.Find(id); ViewBag.ID = categoryi; var category = db.Categoryis.ToList(); ViewBag.Category = category; return(View()); } else { var books = db.Books.ToList(); ViewBag.Books = books; var auftors = db.Auftors.ToList(); ViewBag.Aufrots = auftors; var category = db.Categoryis.ToList(); ViewBag.Category = category; return(View("Index")); } }