partial void DeletePrice(Price instance);
partial void InsertPrice(Price instance);
partial void UpdatePrice(Price instance);
public IList<Item> GetListItems(InitDataModel inputObject) { if (inputObject.ShowCd == Logics.CD_SHOW_ITEMS_NEW) return GetListNewItems(); if (inputObject.ShowCd == Logics.CD_SHOW_ITEMS_OFFER) return GetListOfferItems(); if (inputObject.ShowCd == Logics.CD_SHOW_ITEMS_HOT) return GetListHotItems(); if (inputObject.ShowCd == Logics.CD_SHOW_ITEMS_GROUP) return GetListGroupItems(inputObject.OfferGroupCd); // Get price var price = (from tbl in EntityManager.Prices where tbl.PriceCd == inputObject.PriceCd && tbl.DeleteFlag == false select tbl).SingleOrDefault(); if (price == null) price = new Price(); var listItemOfferByPrice = from tbl in GetListOffers() where tbl.OfferDiv == Logics.CD_OFFER_DIV_DISCOUNT && EntityManager.Items.Any(sub => sub.ItemCd == tbl.ItemCd && decimal.Subtract(sub.SalesPrice.Value, decimal.Multiply(sub.SalesPrice.Value, tbl.Percent.Value / 100)) >= price.PriceStart && (decimal.Subtract(sub.SalesPrice.Value, decimal.Multiply(sub.SalesPrice.Value, tbl.Percent.Value / 100)) < price.PriceEnd || price.PriceDiv == Logics.CD_PRICE_DIV_MORE)) select tbl.ItemCd; var listResult = from tbl in EntityManager.Items where (tbl.ItemName.Contains(inputObject.SearchText) || tbl.ItemSearchName.Contains(inputObject.SearchText) || tbl.Category.CategoryName.Contains(inputObject.SearchText) || tbl.Category.CategorySearchName.Contains(inputObject.SearchText) || tbl.Brand.BrandName.Contains(inputObject.SearchText) || tbl.Brand.BrandSearchName.Contains(inputObject.SearchText) || DataCheckHelper.IsNull(inputObject.SearchText)) && (tbl.CategoryCd == inputObject.CategoryCd || DataCheckHelper.IsNull(inputObject.CategoryCd)) && (tbl.AgeCd == inputObject.AgeCd || DataCheckHelper.IsNull(inputObject.AgeCd)) && (tbl.GenderCd == inputObject.GenderCd || DataCheckHelper.IsNull(inputObject.GenderCd)) && (tbl.BrandCd == inputObject.BrandCd || DataCheckHelper.IsNull(inputObject.BrandCd)) && (DataCheckHelper.IsNull(inputObject.PriceCd) || (!(from sub1 in GetListOffers() where sub1.OfferDiv == Logics.CD_OFFER_DIV_DISCOUNT select sub1.ItemCd).Contains(tbl.ItemCd) && tbl.SalesPrice >= price.PriceStart && (tbl.SalesPrice < price.PriceEnd || price.PriceDiv == Logics.CD_PRICE_DIV_MORE)) || listItemOfferByPrice.Contains(tbl.ItemCd)) && tbl.DeleteFlag == false orderby tbl.SortKey ascending select tbl; return listResult.ToList(); }