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