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