public DataSourceResult ShopOffersInView(KendoFilterDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var dataSourceResult = context.Offers.Where(x => x.IsActive == true && x.ShopId == Request.ShopId)
.Select(x => new OfferDto
{
Id = x.Id,
Tittle = x.Tittle,
Image = x.Image,
Percentage = x.Percentage,
IsActive = x.IsActive,
ShopId = x.ShopId,
IsPercentage = x.IsPercentage,
Shop = new ShopDto
{
Id = x.Shop != null ? x.Shop.Id : 0,
Name = x.Shop != null ? x.Shop.Name : "",
},
}).OrderByDescending(x => x.Id).ToDataSourceResult(Request);
DataSourceResult kendoResponseDto = new DataSourceResult();
kendoResponseDto.Data = dataSourceResult.Data;
kendoResponseDto.Aggregates = dataSourceResult.Aggregates;
kendoResponseDto.Total = dataSourceResult.Total;
return(kendoResponseDto);
}
}
public DataSourceResult ShopItemsInView(KendoFilterDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var dataSourceResult = context.Items.Where(x => x.IsActive == true && x.ShopId == Request.ShopId)
.Select(x => new ItemDto
{
Id = x.Id,
Name = x.Name,
IsActive = x.IsActive,
Image = x.Image,
TagLine = x.TagLine,
Description = x.Description,
Price = x.Price,
CommissionPercentage = x.CommissionPercentage,
ShopId = x.ShopId,
Preference = x.Preference,
ItemCategoryId = x.ItemCategoryId,
OfferId = x.OfferId,
OfferPrice = x.OfferPrice,
InActive = x.InActive,
Shop = new ShopDto
{
Name = x.Shop.Name,
Id = x.Shop.Id,
DeliveryCharge = x.Shop.DeliveryCharge,
},
ItemsCategory = new ItemCategoryDto
{
Name = x.ItemsCategory.Name,
Id = x.ItemsCategory.Id,
},
Offer = new OfferDto
{
Id = x.Offer != null ? x.Offer.Id : 0,
Image = x.Offer != null ? x.Offer.Image : "",
Tittle = x.Offer != null ? x.Offer.Tittle : "",
Percentage = x.Offer != null ? x.Offer.Percentage : 0,
},
}).OrderByDescending(x => x.Id).ToDataSourceResult(Request);
DataSourceResult kendoResponseDto = new DataSourceResult();
kendoResponseDto.Data = dataSourceResult.Data;
kendoResponseDto.Aggregates = dataSourceResult.Aggregates;
kendoResponseDto.Total = dataSourceResult.Total;
return(kendoResponseDto);
}
}
public List <MEDItemDto> MEDItemsWithFilter(KendoFilterDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var dataList = context.MEDItems.Where(x => x.IsActive && !x.IsAvailable);
if (Request.Keyword != null && Request.Keyword != "")
{
dataList = dataList.Where(x => x.Name.Contains(Request.Keyword));
}
if (Request.MinPrice > 0)
{
dataList = dataList.Where(x => x.OfferPrice > Request.MinPrice && x.OfferPrice < Request.MaxPrice);
}
if (Request.MEDSubCategoryId > 0)
{
dataList = dataList.Where(x => x.MEDSubCategoryId == Request.MEDSubCategoryId);
}
if (Request.MEDBrandId > 0)
{
dataList = dataList.Where(x => x.MEDBrandId == Request.MEDBrandId);
}
var retdata = new List <MEDItemDto>();
if (Request.SortBy == 2)
{
retdata = dataList
.Select(x => new MEDItemDto
{
Id = x.Id,
Name = x.Name,
IsActive = x.IsActive,
Image1 = x.Image1,
Tagline = x.Tagline,
Description = x.Description,
Price = x.Price,
Image2 = x.Image2,
Image3 = x.Image3,
Image4 = x.Image4,
MEDOfferId = x.MEDOfferId,
IsAvailable = x.IsAvailable,
OfferPrice = x.OfferPrice,
MEDShopId = x.MEDShopId,
MEDShop = new MEDShopDto
{
Id = x.MEDShop != null ? x.MEDShop.Id : 0,
Name = x.MEDShop != null ? x.MEDShop.Name : "",
},
Bookings = x.Bookings,
MEDBrand = new MEDBrandDto
{
Id = x.MEDBrand != null ? x.MEDBrand.Id : 0,
Name = x.MEDBrand != null ? x.MEDBrand.Name : "",
},
MEDOffer = new MEDOfferDto
{
Id = x.MEDOffer != null ? x.MEDOffer.Id : 0,
Title = x.MEDOffer != null ? x.MEDOffer.Title : "",
},
}).OrderBy(x => x.OfferPrice).Skip(Request.Skip).Take(20).ToList();
}
else if (Request.SortBy == 1)
{
retdata = dataList
.Select(x => new MEDItemDto
{
Id = x.Id,
Name = x.Name,
IsActive = x.IsActive,
Image1 = x.Image1,
Tagline = x.Tagline,
Description = x.Description,
Price = x.Price,
Image2 = x.Image2,
Image3 = x.Image3,
Image4 = x.Image4,
MEDOfferId = x.MEDOfferId,
IsAvailable = x.IsAvailable,
MEDShopId = x.MEDShopId,
MEDShop = new MEDShopDto
{
Id = x.MEDShop != null ? x.MEDShop.Id : 0,
Name = x.MEDShop != null ? x.MEDShop.Name : "",
},
OfferPrice = x.OfferPrice,
Bookings = x.Bookings,
MEDBrand = new MEDBrandDto
{
Id = x.MEDBrand != null ? x.MEDBrand.Id : 0,
Name = x.MEDBrand != null ? x.MEDBrand.Name : "",
},
MEDOffer = new MEDOfferDto
{
Id = x.MEDOffer != null ? x.MEDOffer.Id : 0,
Title = x.MEDOffer != null ? x.MEDOffer.Title : "",
},
}).OrderByDescending(x => x.OfferPrice).Skip(Request.Skip).Take(20).ToList();
}
else
{
retdata = dataList
.Select(x => new MEDItemDto
{
Id = x.Id,
Name = x.Name,
IsActive = x.IsActive,
Image1 = x.Image1,
Tagline = x.Tagline,
Description = x.Description,
Price = x.Price,
Image2 = x.Image2,
Image3 = x.Image3,
Image4 = x.Image4,
MEDOfferId = x.MEDOfferId,
IsAvailable = x.IsAvailable,
MEDShopId = x.MEDShopId,
MEDShop = new MEDShopDto
{
Id = x.MEDShop != null ? x.MEDShop.Id : 0,
Name = x.MEDShop != null ? x.MEDShop.Name : "",
},
OfferPrice = x.OfferPrice,
Bookings = x.Bookings,
MEDBrand = new MEDBrandDto
{
Id = x.MEDBrand != null ? x.MEDBrand.Id : 0,
Name = x.MEDBrand != null ? x.MEDBrand.Name : "",
},
MEDOffer = new MEDOfferDto
{
Id = x.MEDOffer != null ? x.MEDOffer.Id : 0,
Title = x.MEDOffer != null ? x.MEDOffer.Title : "",
},
}).OrderByDescending(x => x.Bookings).Skip(Request.Skip).Take(20).ToList();
}
return(retdata);
}
}
