public PagedList <ProductModel> SearchProduct(string search, int?categoryId = 0, int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
IQueryable <ProductModel> query;
try
{
if (categoryId != 0 && categoryId != null)
{
query = _context.Products.Where(x => (x.categoryId == categoryId) && (x.productName.Contains(search) || x.productBrand.Contains(search) || x.productDesc.Contains(search)));
}
else
{
query = _context.Products.Where(x => (x.productName.Contains(search) || x.productBrand.Contains(search) || x.productDesc.Contains(search)));
}
return(new PagedList <ProductModel>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
public PagedList <OrderDTO> GetOrders(int?userId = 0, int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
IQueryable <OrderDTO> query;
try
{
//var query = userId == 0 || userId == null ? _context.Orders : _context.Orders.Where(x => x.userID == userId);
if (userId == 0 || userId == null)
{
query = _context.Orders.Select(s => new OrderDTO {
OrderId = s.OrderId,
address = s.address,
deliveryCharges = s.deliveryCharges,
weightScale = s.weightScale,
orderStatus = s.orderStatus,
shopperId = s.shopperId,
subTotal = s.subTotal,
totalAmount = s.totalAmount,
totalTax = s.totalTax,
insertedOn = s.insertedOn
});
}
else
{
query = from a in Context.Orders
join c in Context.Users
on a.userID equals c.userId
where a.userID == userId
select new OrderDTO
{
OrderId = a.OrderId,
address = a.address,
deliveryCharges = a.deliveryCharges,
weightScale = a.weightScale,
orderStatus = a.orderStatus,
shopperId = a.shopperId,
subTotal = a.subTotal,
totalAmount = a.totalAmount,
totalTax = a.totalTax,
insertedOn = a.insertedOn,
orderByUser = c.firstName + " " + c.lastName
};
}
return(new PagedList <OrderDTO>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
public Paged <TEntity> GetPaginated(int?pageNumber = 1, int?pageSize = 10) // For Pagination only No data
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
var query = Entities.AsQueryable();
return(new Paged <TEntity>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
public Paged <TEntity> GetPaginated(Expression <Func <TEntity, bool> > where, int?pageNumber = 1, int?pageSize = 10) // For Pagination only No data
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
//var query = Entities.AsQueryable();
var query = Entities.Where(where).AsQueryable();
return(new Paged <TEntity>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
public PagedList <ProductModel> GetProductsByCategoryId(int categoryId, int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
try
{
var query = _context.Products.Where(x => x.categoryId == categoryId);
return(new PagedList <ProductModel>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
public PagedList <ProductModel> GetProducts(int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
try
{
var query = _context.Products;
return(new PagedList <ProductModel>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
public PagedList <NotificationModel> GetNotifications(int?userId = 0, int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
try
{
var query = _context.Notifications.Where(x => x.UserId == userId);
return(new PagedList <NotificationModel>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
public PagedList <UserDTO> GetAllUsers(int?RoleId = 0, int?pageNumber = 1, int?pageSize = 10)
{
PagingParamsDTO pagingParams = new PagingParamsDTO();
pagingParams.PageNumber = pageNumber;
pagingParams.PageSize = pageSize;
IQueryable <UserDTO> query;
try
{
if (RoleId == 0)
{
query = from a in _context.Users
join b in _context.UserRoles
on a.userId equals b.userId
join c in _context.Roles
on b.roleId equals c.roleId
where a.isActive == true
select new UserDTO
{
firstName = a.firstName,
lastName = a.lastName,
userEmail = a.userEmail,
userPhone = a.contact,
userAddress = a.userAddress,
userZipCode = a.userZipCode,
userId = a.userId,
userProfileImage = a.userProfileImage,
Role = new UserRoleDTO {
userRole = c.roleId, userRoleName = c.roleName
}
};
}
else
{
query = from a in _context.Users
join b in _context.UserRoles
on a.userId equals b.userId
join c in _context.Roles
on b.roleId equals c.roleId
where c.roleId == RoleId &&
a.isActive == true
select new UserDTO
{
firstName = a.firstName,
lastName = a.lastName,
userEmail = a.userEmail,
userPhone = a.contact,
userAddress = a.userAddress,
userZipCode = a.userZipCode,
userId = a.userId,
userProfileImage = a.userProfileImage,
Role = new UserRoleDTO {
userRole = c.roleId, userRoleName = c.roleName
}
};
}
//var query = _context.Users.Select( x => new UserDTO
// {
// firstName = x.firstName,
// lastName = x.lastName,
// userAddress = x.userAddress,
// userEmail = x.userEmail,
// userId = x.userId,
// userPhone = x.userPhone,
// userProfileImage = x.userProfileImage,
// userZipCode = x.userZipCode,
// //userRoles = GetRoles(x.userId, RoleId)
//});
return(new PagedList <UserDTO>(
query, pagingParams.PageNumber, pagingParams.PageSize));
}
catch (Exception exc)
{
throw exc;
}
}
