public IEnumerable <CategoryListPagingModel> GetAllWithPaging(out int totalItemCount)
{
var result = _dapperRepository.LoadData <CategoryListPagingModel>("spGetAllCategoriesPaging");
totalItemCount = result.Any() ? result.First().TotalRows : 0;
return(result);
}
public IEnumerable <PublisherListModel> SearchPublisherByNameWithPaging(string searchText, int pageNumber, int pageSize, out int totalItemCount)
{
if (searchText == null)
{
searchText = "";
}
var parameters = new { Name = searchText, PageNumber = pageNumber, PageSize = pageSize };
var result = _dapperRepository.LoadData <PublisherListModel>("spSearchPublisherByNameWithPaging", parameters);
totalItemCount = result.Any() ? result.First().TotalRows : 0;
return(result);
}
public IEnumerable <BookListModel> GetBookListForShopPage(int page, int pageSize, string sortBy, out int totalItemCount)
{
var parameters = new { PageNumber = page, PageSize = pageSize, SortBy = sortBy };
var result = _dapperRepository.LoadData <BookListModel>("spGetAllBooksForShopList", parameters);
totalItemCount = result.Any() ? result.First().TotalRows : 0;
return(result);
}
public IEnumerable <BookImage> GetBookImages(int id)
{
var parameters = new { BookId = id };
return(_repository.LoadData("spGetBookImages", parameters));
}
public CartItem GetByBookIdAndShoppingCartId(int bookId, int shoppingCartId)
{
var parameters = new { BookId = bookId, ShoppingCartId = shoppingCartId };
return(_repository.LoadData("spGetCartItemByBookAndCartId", parameters).FirstOrDefault());
}
public Publisher CheckByName(string name)
{
var parameters = new { Name = name };
return(_repository.LoadData("spCheckPublisherExistanceByName", parameters).FirstOrDefault());
}
public User GetById(string id)
{
var parameters = new { Id = id };
return(_repository.LoadData("spGetUser", parameters).FirstOrDefault());
}
public InsertBookModel GetById(int id)
{
var parameters = new { Id = id };
return(_repository.LoadData <InsertBookModel>("spGetBook", parameters).FirstOrDefault());
}
public ShoppingCart GetByUserId(string userId)
{
var parameters = new { UserId = userId };
return(_repository.LoadData("spGetShoppingCartByUserId", parameters).FirstOrDefault());
}
public IEnumerable <Category> GetAll()
{
return(_repository.LoadData("spGetAllCategories"));
}
