public JsonResult BookForGrid(string sidx, string sord, int page, int rows, int authorId)
{
/*if (!isAuth)
* return new JsonResult();*/
if (string.IsNullOrWhiteSpace(sidx))
{
sidx = "ISBN";
}
JqGridDataList jqGridDataList = new JqGridDataList();
List <Book> list = jqGridDataList.GetBooksByAuthor(sidx, sord, page, rows, authorId);
var jsonData = new
{
total = jqGridDataList.Total,
page = jqGridDataList.Page,
records = list.Count,
rows = (
from books in list
select new
{
books.ISBN,
books.Name,
Cost = (books.Cost != null) ? books.Cost.Value.ToString() : ""
}
).ToArray()
};
return(Json(jsonData
, JsonRequestBehavior.AllowGet));
}
public JsonResult OrdersForGrid(string sidx, string sord, int page, int rows)
{
if (!isAuth)
{
return(new JsonResult());
}
if (string.IsNullOrWhiteSpace(sidx))
{
sidx = "Id";
}
JqGridDataList jqGridDataList = new JqGridDataList();
List <Order> list = jqGridDataList.GetOrdersByUser(sidx, sord, page, rows, CurrentUser.Id);
var jsonData = new
{
total = jqGridDataList.Total,
page = jqGridDataList.Page,
records = list.Count,
rows = (
from order in list
select new
{
order.Id,
Creation_Date = order.Creation_Date.ToString(),
order.Cost
}
).ToArray()
};
return(Json(jsonData
, JsonRequestBehavior.AllowGet));
}
public JsonResult BookForGrid(string sidx, string sord, int page, int rows)
{
if (!isAuth)
{
return(new JsonResult());
}
if (string.IsNullOrWhiteSpace(sidx))
{
sidx = "ISBN";
}
JqGridDataList jqGridDataList = new JqGridDataList();
List <Book> list = jqGridDataList.GetBooks(sidx, sord, page, rows);
var jsonData = new
{
total = jqGridDataList.Total,
page,
records = list.Count,
rows = (
from books in list
select new
{
books.ISBN,
books.FilePath,
books.ISBN_Tome,
books.Description,
NextPart = (books.Nextpart == null ? "" : books.Nextpart.Name),
PreviousPart = (books.PreviousBook == null ? "" : books.PreviousBook.Name),
books.RealiseYear,
books.Cover,
books.Name,
Cost = (books.Cost != null) ? books.Cost.Value.ToString() : "",
Authors = (from ab in books.Authors_Books
select new
{
ab.Author_Id,
Name = string.Format("{0} {1}", ab.Author.Person.Name, ab.Author.Person.Surname)
})
}
).ToArray()
};
return(Json(jsonData
, JsonRequestBehavior.AllowGet));
}
public JsonResult AuthorForGrid(string sidx, string sord, int page, int rows)
{
if (!isAuth)
{
return(new JsonResult());
}
if (string.IsNullOrWhiteSpace(sidx))
{
sidx = "Id";
}
JqGridDataList jqGridDataList = new JqGridDataList();
List <Author> list = jqGridDataList.GetAuthors(sidx, sord, page, rows);
var jsonData = new
{
total = jqGridDataList.Total,
page = page,
records = list.Count,
rows = (
from a in list
select new
{
AuthorId = a.Id,
a.Person.Name,
a.Person.Surname,
Books = (from ab in a.Authors_Books
select new
{
ab.Book_Id,
ab.Book.Name
}).ToArray()
}
).ToArray()
};
return(Json(jsonData
, JsonRequestBehavior.AllowGet));
}
public JsonResult UsersForGrid(string sidx, string sord, int page, int rows)
{
if (!isAuth)
{
return(new JsonResult());
}
if (string.IsNullOrWhiteSpace(sidx))
{
sidx = "Id";
}
JqGridDataList jqGridDataList = new JqGridDataList();
List <User> list = jqGridDataList.GetUsers(sidx, sord, page, rows);
var jsonData = new
{
total = jqGridDataList.Total,
page,
records = list.Count,
rows = (
from user in list
select new
{
user.Id,
user.Person.Name,
user.Person.Surname,
Birthday = user.Person.BirthDay.ToString("yyyy MM dd"),
user.Email,
user.CartNumber,
Role = user.Role.Value
}
).ToArray()
};
return(Json(jsonData
, JsonRequestBehavior.AllowGet));
}