public IEnumerable <WriterEntity> GetAllWriter()
{
var allWriter = writerRepository.GetAll();
if (allWriter == null)
{
throw new ArgumentException($"The list is empty! ");
}
return(allWriter);
}
private IEnumerable <Writer> GetData(GridSettings grid, out int totalRecords, bool allData = false)
{
IEnumerable <Writer> data;
var query = _writerRepository.GetAll();
//filtring
if (grid.Where != null)
{
if (grid.Where.groupOp == "AND")
{
foreach (var rule in grid.Where.rules)
{
query = query.Where(rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
}
}
else
{
//Or
var temp = (new List <Writer>()).AsQueryable();
foreach (var rule in grid.Where.rules)
{
var t = query.Where(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
temp = temp.Concat(t);
}
//remove repeating records
query = temp.Distinct();
}
}
query = query.Where(c => c.UserType == UserType.Writer);
//sorting
if (!string.IsNullOrEmpty(grid.SortColumn))
{
query = query.OrderBy(grid.SortColumn, grid.SortOrder);
}
totalRecords = query.Count();
if (!allData)
{
data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize);
}
else
{
data = query.AsEnumerable().ToList();
}
return(data);
}
public BookDetailsDTO Get(int id)
{
Book Book = IBookRepository.Get(id);
BookDetailsDTO MyBook = new BookDetailsDTO()
{
Name = Book.Name,
Popularity = Book.Popularity,
PublicationYear = Book.PublicationYear
};
IEnumerable <BookWriter> MyBookWriters = IBookWriterRepository.GetAll().Where(x => x.BookId == Book.Id);
if (MyBookWriters != null)
{
List <string> BookWriterList = new List <string>();
foreach (BookWriter MyBookWriter in MyBookWriters)
{
Writer MyWriter = IWriterRepository.GetAll().SingleOrDefault(x => x.Id == MyBookWriter.Id);
BookWriterList.Add(MyWriter.Name);
}
MyBook.WriterName = BookWriterList;
}
IEnumerable <BookLibrary> MyLibraryBooks = IBookLibraryRepository.GetAll().Where(x => x.BookId == Book.Id);
if (MyLibraryBooks != null)
{
List <string> LibraryBookList = new List <string>();
foreach (BookLibrary MyLibraryBook in MyLibraryBooks)
{
Library MyLibrary = ILibraryRepository.GetAll().SingleOrDefault(x => x.Id == MyLibraryBook.Id);
LibraryBookList.Add(MyLibrary.Name);
}
MyBook.LibraryName = LibraryBookList;
}
IEnumerable <BookPublisher> MyPublisherBooks = IBookPublisherRepository.GetAll().Where(x => x.BookId == Book.Id);
if (MyPublisherBooks != null)
{
List <string> PublisherBookList = new List <string>();
foreach (BookPublisher MyPublisherBook in MyPublisherBooks)
{
Publisher MyPublisher = IPublisherRepository.GetAll().SingleOrDefault(x => x.Id == MyPublisherBook.Id);
PublisherBookList.Add(MyPublisher.Name);
}
MyBook.PublisherName = PublisherBookList;
}
return(MyBook);
}
