public async Task <PaginatedResultBase <SellProduct> > GetSellProductItemsByConsumerId(int userId, int consumerId, int pageIndex, int pageSize)
{
IQueryable <SellProduct> products = this._context.SellPrducts.Include(p => p.Consumer).Where(p => p.UserId == userId &&
p.ConsumerId == consumerId && p.IsActive).OrderByDescending(p => p.CreatedDate).AsQueryable();
return(await PaginatedResultBase <SellProduct> .CreateAsync(products.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <Product> > GetProductItemsByVendorId(int userId, int vendorId, int pageIndex, int pageSize, bool isActive)
{
IQueryable <Product> products = this._context.Products.Include(p => p.Category).Include(p => p.Brand).Include(p => p.Vendor).Where(p => p.UserId == userId &&
p.VendorId == vendorId && p.IsActive == isActive)
.OrderByDescending(p => p.CreatedDate).AsQueryable();
return(await PaginatedResultBase <Product> .CreateAsync(products.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <ProductBrand> > GetBrandTypes(int userId, int pageIndex, int pageSize)
{
IQueryable <ProductBrand> categories = null;
categories = this._context.ProductBrands.Where(p => p.UserId == userId).AsQueryable();
return(await PaginatedResultBase <ProductBrand> .CreateAsync(categories.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <ProductBrand> > GetSearchBrandTypes(int userId, string searchKey, int pageIndex, int pageSize)
{
IQueryable <ProductBrand> categories = null;
if (!String.IsNullOrWhiteSpace(searchKey))
{
categories = this._context.ProductBrands.Where(p => p.UserId == userId && (p.Name.ToLower().Contains(searchKey.ToLower()))).AsQueryable();
}
else
{
categories = this._context.ProductBrands.Where(p => p.UserId == userId).AsQueryable();
}
return(await PaginatedResultBase <ProductBrand> .CreateAsync(categories.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <Vendor> > GetSearchVendors(int userId, string searchKeyword, int pageIndex, int pageSize)
{
IQueryable <Vendor> vendors = null;
if (!String.IsNullOrWhiteSpace(searchKeyword))
{
vendors = this._context.Vendors.Where(p => p.UserId == userId &&
(p.Name.ToLower().Contains(searchKeyword.ToLower()) || p.MobileNumber.ToLower().Contains(searchKeyword.ToLower()))).AsQueryable();
}
else
{
vendors = this._context.Vendors.Where(p => p.UserId == userId).AsQueryable();
}
return(await PaginatedResultBase <Vendor> .CreateAsync(vendors.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <Product> > GetSearchProductItems(int userId, string searchKey, int pageIndex, int pageSize, bool isActive)
{
IQueryable <Product> products = null;
if (!String.IsNullOrWhiteSpace(searchKey))
{
products = this._context.Products.Include(p => p.Category).Include(p => p.Brand).Include(p => p.Vendor).Where(p => p.UserId == userId &&
(p.Code.Contains(searchKey) || p.Name.Contains(searchKey)) && p.IsActive == isActive)
.OrderByDescending(p => p.CreatedDate).AsQueryable();
}
else
{
products = this._context.Products.Include(p => p.Category).Include(p => p.Brand).Include(p => p.Vendor).Where(p => p.UserId == userId && p.IsActive == isActive).OrderByDescending(p => p.CreatedDate).AsQueryable();
}
return(await PaginatedResultBase <Product> .CreateAsync(products.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <SellProduct> > GetSellProducts(int userId, string searchKeyword, int pageIndex, int pageSize)
{
IQueryable <SellProduct> products = null;
if (!String.IsNullOrWhiteSpace(searchKeyword))
{
products = this._context.SellPrducts.Include(p => p.Consumer).Where(p => p.UserId == userId &&
(p.Id.ToString().Contains(searchKeyword) || p.Consumer.Name.Contains(searchKeyword) || p.Consumer.MobileNumber.Contains(searchKeyword)) && p.IsActive)
.OrderByDescending(p => p.CreatedDate).AsQueryable();
}
else
{
products = this._context.SellPrducts.Include(p => p.Consumer).Where(p => p.UserId == userId && p.IsActive).OrderByDescending(p => p.CreatedDate).AsQueryable();
}
return(await PaginatedResultBase <SellProduct> .CreateAsync(products.AsNoTracking(), pageIndex, pageSize));
}
public async Task <PaginatedResultBase <SellProductHistory> > GetSellProductHistoryById(int saleId, int pageIndex, int pageSize)
{
IQueryable <SellProductHistory> productItems = this._context.SellPrductHistory.Include(p => p.Product).Where(p => Property <int>(p, "SellProductId") == saleId && p.IsActive).OrderByDescending(p => p.CreatedDate).AsQueryable();
return(await PaginatedResultBase <SellProductHistory> .CreateAsync(productItems.AsNoTracking(), pageIndex, pageSize));
}