/// <summary>
/// 房间有玩家财富变更同步更新，uid：变更得uid，dto：变更得财富
/// </summary>
public override void playerWeathUpdate(long uid, ItemListDto dto)
{
if (PlayerCache.loginInfo.uid == uid)
{
// PlayerCache.SetWealthUpdate(dto.items,true);
}
}
public async Task UpdateAsync_ValidData_Successful()
{
// Arrange.
Seed(TripFlipDbContext, ValidUser);
Seed(TripFlipDbContext, TripEntityToSeed);
Seed(TripFlipDbContext, RouteEntityToSeed);
Seed(TripFlipDbContext, ItemListEntityToSeed);
Seed(TripFlipDbContext, TripSubscriberEntitiesToSeed);
Seed(TripFlipDbContext, RouteSubscriberEntitiesToSeed);
Seed(TripFlipDbContext, RouteRoleEntitiesToSeed);
Seed(TripFlipDbContext, RouteSubscriberEditorRoleEntityToSeed);
CurrentUserService = CreateCurrentUserService(ValidUser.Id,
ValidUser.Email);
var updateItemListDto = GetUpdateItemListDto();
var itemListService = new ItemListService(TripFlipDbContext, Mapper, CurrentUserService);
// Act.
var resultItemListDto =
await itemListService.UpdateAsync(updateItemListDto);
var expectedItemListDto = new ItemListDto()
{
Id = updateItemListDto.Id,
Title = updateItemListDto.Title,
RouteId = resultItemListDto.RouteId // UpdateItemListDto doesn't contain this field, so it initialized like that.
};
var comparer = new ItemListDtoComparer();
// Assert.
Assert.AreEqual(0,
comparer.Compare(resultItemListDto, expectedItemListDto));
}
private void Form1_Load(object sender, EventArgs e)
{
apikey = apikeyBox.Text;
try
{
// Get static data
Champions = Get_Champions(apikey);
ChampionsInv = Get_Champions(apikey, databyid: true);
Masteries = Get_Masteries(apikey);
Runes = Get_Runes(apikey);
Items = Get_Items(apikey);
List<string> ver = Get_Version(apikey);
verLabel.Text = ver.First();
// Get images/initalize image boxes
Get_Mastery_Images();
initPictureBoxes();
}
catch (Exception error)
{
Show_Error(error.Message);
}
// Temp fix of placement errors
// Add options to combobox
selectFunctionComboBox.BeginUpdate();
selectFunctionComboBox.Items.Add("Mastery Page By Summoner Champion");
selectFunctionComboBox.Items.Add("Mastery Page By Summoner");
selectFunctionComboBox.Items.Add("Rune Page By Summoner");
selectFunctionComboBox.EndUpdate();
}
private void Form1_Load(object sender, EventArgs e)
{
items = JSON.Deserialize <ItemListDto>(
File.ReadAllText(Client.STATIC_PATH + "items.txt")
);
var descriptions = items.data.Select(
i => i.Value.description + i.Value.sanitizedDescription
).ToList();
var descStats = descriptions.FindAll(d => Regex.IsMatch(d, sanDescStatsPat, rgxOpts, DEFAULT_TIMEOUT))
.SelectMany(
d => Regex.Matches(d, sanDescStatsPat, rgxOpts, DEFAULT_TIMEOUT).Cast <Match>()
).GroupBy(
s => s.Groups[3].Value.Trim() + s.Groups[2].Value
).Select(g => g.First()).OrderBy(m => m.Groups[3].Value)
.ToDictionary(m => m.Groups[3].Value + m.Groups[2].Value, m => m.Groups[1].Value);
/*var descStatGroups = descStats.GroupBy(
* s => s.Value
* );
*
* descStats = descStatGroups.Select(g => g.First()).ToDictionary(
* m => m.Key, m => m.Value
* );*/
}
private void Form1_Load(object sender, EventArgs e)
{
apikey = apikeyBox.Text;
try
{
// Get static data
Champions = Get_Champions(apikey);
ChampionsInv = Get_Champions(apikey, databyid: true);
Masteries = Get_Masteries(apikey);
Runes = Get_Runes(apikey);
Items = Get_Items(apikey);
List <string> ver = Get_Version(apikey);
verLabel.Text = ver.First();
// Get images/initalize image boxes
Get_Mastery_Images();
initPictureBoxes();
}
catch (Exception error)
{
Show_Error(error.Message);
}
// Temp fix of placement errors
// Add options to combobox
selectFunctionComboBox.BeginUpdate();
selectFunctionComboBox.Items.Add("Mastery Page By Summoner Champion");
selectFunctionComboBox.Items.Add("Mastery Page By Summoner");
selectFunctionComboBox.Items.Add("Rune Page By Summoner");
selectFunctionComboBox.EndUpdate();
}
/// <summary>
/// 同步玩家财富
/// </summary>
/// <param name="uid"></param>
/// <param name="dto"></param>
public override void playerWeathUpdate(long uid, ItemListDto dto)
{
if (dto.items != null)
{
if (PlayerCache.roomPlayerObjDic.ContainsKey(uid))
{
PlayerCache.roomPlayerObjDic[uid].UpdatePlayerGold(dto.items[0].itemCount);
}
}
}
public static Item GetItem(this ItemListDto itemDto)
{
return(new Item
{
Color = itemDto.ItemColor,
Height = itemDto.Height,
Name = itemDto.Name,
Price = itemDto.Price,
Width = itemDto.Width
});
}
protected override bool NeedToUpdate()
{
try
{
var oldVersion = ItemList.version;
ItemList = BaronReplays.RiotAPI.Services.Request.GetStaticData("na/v1.2/item?itemListData=image&locale=" + Request.ApiLanguage, typeof(ItemListDto), DirectoryPath + InfoFile);
return(ItemList.version.CompareTo(oldVersion) != 0);
}
catch (Exception)
{
return(false);
}
}
public void UpdateUIData(ItemListDto itemListDto)
{
//坐驾数量
if (itemListDto != null)
{
if (itemListDto.items.Count > 0)
{
foreach (var item in itemListDto.items)
{
carNumberList[item.itemId].text = "X" + item.itemCount;
}
}
}
}
private async Task <List <ItemDto> > GetFromList(List <int> ids)
{
List <ItemDto> items = new List <ItemDto>();
if (ids.Count > 0)
{
ItemListDto itemList = await this._riotStaticData.GetItemsAsync();
foreach (int id in ids)
{
items.Add(itemList.Data.Values.FirstOrDefault(x => x.Id.Equals(id)));
}
}
return(items);
}
private async Task <List <ItemDto> > GetMatchingItemsAsync(string name)
{
name = name.ToLower();
ItemListDto itemList = await this._riotStaticData.GetItemsAsync();
List <ItemDto> matches = new List <ItemDto>();
if (itemList != null)
{
matches = itemList.Data.Values
.Where(x => x.Name.ToLower().Contains(name) || StripName(x.Name).ToLower().Contains(name)).ToList();
}
matches.Sort((a, b) => a.Name.CompareTo(b.Name));
return(matches);
}
public static ItemDto ReadItemFromStaticFile(string name)
{
if (StaticFileExists(StaticData.Items))
{
ItemListDto items = ReadFromStaticFile <ItemListDto>(StaticData.Items);
foreach (ItemDto item in items.data.Values)
{
if (item.name == name)
{
return(item);
}
}
}
return(new ItemDto());
}
/// <summary>
/// 点击领取奖励
/// </summary>
/// <param name="j"></param>
private void BtnGetAward(Button button)
{
AudioManager.Instance.PlaySound("button");
Text text = button.GetComponentInChildren <Text>();
if (text.text == "立即开始")
{
//开始任务，调到经典场 选择类型
UIManager.Instance.Clear();
XUIUtils.LoadSceneX((int)SceneType.ClassicZJH);
}
else if (text.text == "领取")
{
ItemListDto itemListDto = dbGiftBagOperation.receiveAward(PlayerCache.loginInfo.uid);
if (itemListDto != null)
{
PlayerCache.SetWealthUpdate(itemListDto.items, true);
text.text = "已领取";
}
}
}
public static List <Item> ToItems(this ItemListDto itemListDto)
{
var items = new List <Item>();
foreach (KeyValuePair <string, ItemDto> entry in itemListDto.Data)
{
var item = entry.Value;
if (string.IsNullOrWhiteSpace(item.Name) || item.Gold.Total == 0)
{
continue;
}
items.Add(new Item()
{
Id = item.Id,
Name = item.Name,
SearchName = Regex.Replace(item.Name.ToUpper(), @"[^\w\.@-]", ""), //strip special characters
Gold = item.Gold.Total,
SquareImageUrl = string.Format(ServiceConstants.ItemImageUrl, item.Image.Full)
});
}
return(items.OrderBy(c => c.Name).ToList());
}
/// <summary>
/// 房间有玩家财富变更同步更新，uid：变更得uid，dto：变更得财富
/// </summary>
public virtual void playerWeathUpdate(long uid, ItemListDto dto)
{
}
/// <summary>
/// 购买vip ----> <<pay();回调>>
/// </summary>
public virtual void pay2CallBack(ItemListDto callBackParam)
{
}
private void OnEnable()
{
ItemListDto itemListDto = PlayerCache.hallPlayerInfoOperation.playerAutos(PlayerCache.loginInfo.uid);
UpdateUIData(itemListDto);
}
private ItemListDto myList([FromBody] itemFilterDto filter, [FromQuery] Pagination pagination)
{
try
{
_context.ChangeTracker.QueryTrackingBehavior = Microsoft.EntityFrameworkCore.QueryTrackingBehavior.NoTracking;
ItemListDto final = new ItemListDto();
var orderExpression = string.Format("{0} {1}", pagination.SortName, pagination.SortType);
var onlineshopId = _isettings.getOnlineShopId();
var count = (from c in _context.CodeRelations
where
c.IsWebsiteItem == true && c.Skip == false && c.OnLineRetail == true &&
(filter.Cat != null ? c.Cat == filter.Cat : true) &&
(filter.SCat != null ? c.SCat == filter.SCat : true) &&
(filter.SsCat != null ? c.SsCat == filter.SsCat : true) &&
(filter.Hot != null ? c.Hot == filter.Hot : true) &&
(filter.Skip != null ? c.Skip == filter.Skip : true) &&
(filter.Clearance != null ? c.Clearance == filter.Clearance : true) &&
(filter.ComingSoon != null ? Convert.ToBoolean(c.ComingSoon) == filter.ComingSoon : true) &&
(filter.NewItem != null ? c.NewItem == filter.NewItem : true) &&
(filter.FreeDelivery != null ? c.FreeDelivery == filter.FreeDelivery : true) &&
(filter.KeyWord != null ?
//c.Name.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//|| (String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0)
//|| c.Code.ToString().Contains(filter.KeyWord)
//|| c.SupplierCode.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//|| c.Brand.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//|| c.Cat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//|| c.SCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//|| c.SsCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
c.Name.ToLower().Contains(filter.KeyWord.ToLower()) ||
(String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Code.ToString().Contains(filter.KeyWord)) ||
c.SupplierCode.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Brand.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Cat.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.SCat.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.SsCat.ToLower().Contains(filter.KeyWord.ToLower())
: true)
join sq in _context.StockQty on c.Code equals sq.Code into g
from sq in g
// where sq.Qty > 0 && sq.BranchId == _isettings.getOnlineShopId()
where sq.BranchId == _isettings.getOnlineShopId()
//join cb in _context.CodeBranch on c.Code equals cb.Code into g
//from cb in g.DefaultIfEmpty()
//where cb.BranchId == _isettings.getOnlineShopId() && cb.Inactive == false
select new
{
}).Count();
var list = (from c in _context.CodeRelations
where
c.IsWebsiteItem == true && c.Skip == false && c.OnLineRetail == true &&
(filter.Cat != null ? c.Cat == filter.Cat : true) &&
(filter.SCat != null ? c.SCat == filter.SCat : true) &&
(filter.SsCat != null ? c.SsCat == filter.SsCat : true) &&
(filter.Hot != null ? c.Hot == filter.Hot : true) &&
(filter.Skip != null ? c.Skip == filter.Skip : true) &&
(filter.Clearance != null ? c.Clearance == filter.Clearance : true) &&
(filter.ComingSoon != null ? Convert.ToBoolean(c.ComingSoon) == filter.ComingSoon : true) &&
(filter.NewItem != null ? c.NewItem == filter.NewItem : true) &&
(filter.FreeDelivery != null ? c.FreeDelivery == filter.FreeDelivery : true) &&
(filter.KeyWord != null ?
//c.Name.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
//cotainKeyword(c.Name,filter.KeyWord)
//|| (String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0)
// || c.Code.ToString().Contains(filter.KeyWord)
// || c.SupplierCode.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
// || c.Brand.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
// || c.Cat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
// || c.SCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
// || c.SsCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
c.Name.ToLower().Contains(filter.KeyWord.ToLower()) ||
(String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Code.ToString().Contains(filter.KeyWord)) ||
c.SupplierCode.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Brand.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.Cat.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.SCat.ToLower().Contains(filter.KeyWord.ToLower()) ||
c.SsCat.ToLower().Contains(filter.KeyWord.ToLower())
: true)
join sq in _context.StockQty on c.Code equals sq.Code into g
from sq in g
// where sq.Qty > 0 && sq.BranchId == _isettings.getOnlineShopId()
where sq.BranchId == _isettings.getOnlineShopId()
//join cb in _context.CodeBranch on c.Code equals cb.Code
//into g
//from cb in g.DefaultIfEmpty()
//where cb.BranchId == _isettings.getOnlineShopId() && cb.Inactive == false
//orderby cb.Price1 descending
select new ItemDto
{
Code = c.Code,
SupplierCode = c.SupplierCode,
// Site = siteName, // Common.ConvertoToMD5(siteName),
Name = c.Name, //Common.RemoveString(c.Name, "--"),//Common.ReplacePriceInDescription(c.Name, @"WAS\s|(\$)[-]?[0-9]+\.?[0-9]+"),
NameCn = c.NameCn,
Cat = c.Cat,
SCat = c.SCat,
SsCat = c.SsCat,
Brand = c.Brand,
Hot = c.Hot,
FreeDelivery = c.FreeDelivery,
IsIdCheck = c.IsIdCheck,
Weight = c.Weight,
NewItem = c.NewItem,
OuterPack = c.outer_pack,
InnerPack = c.InnerPack,
Moq = (c.Moq == null || c.Moq == 0) ? 1 : c.Moq ?? 1,
Barcode = c.Barcode,
PicUrl = _config["Url"] + "/pi/" + c.Code + ".jpg",
Stock = _iitem.getItemStork(onlineshopId, c.Code),
Price1 = c.Price1,
Barcodes = _iitem.getBarcodes(c.Code),
StoreSpecial = _iitem.SpecialSetting(c.Code, _isettings.getOnlineShopId())
});
var itemCount = count;
var pageCount = (int)Math.Ceiling(itemCount / (double)pagination.PageSize);
IQueryable <ItemDto> items =
list
.OrderBy(orderExpression)
.Skip((pagination.PageNumber - 1) * pagination.PageSize)
.Take(pagination.PageSize);
//.Take(10);
final.Items = items;
final.CurrentPage = pagination.PageNumber;
final.PageSize = pagination.PageSize;
final.PageCount = pageCount;
final.ItemCount = itemCount;
// var result = list; // Mapper.Map<IEnumerable<ItemDto>>(myItemList).OrderBy(c => c.Code).ToList() ;
return(final);
}
catch (Exception ex)
{
throw ex;
}
}
//在场玩家中途更改财富信息
public void MiddleWeath(long uid, ItemListDto dto)
{
//是否是自己
if (uid == PlayerCache.loginInfo.uid)
{ //座位中
if (PlayerCache.SeatPlayerinfoDic.ContainsKey(PlayerCache.loginInfo.uid))
{
PlayerCache.SeatPlayerinfoDic.TryGetValue(uid, out GameDicePositionPlayerInfoDto value);
for (int i = 0; i < dto.items.Count; i++)
{
if (dto.items[i].itemId == 1)
{
SeatList[value.position].transform.GetChild(0).GetChild(2).GetComponent <Text>().text
= NumberConvert.ConvertW(dto.items[i].itemCount);
}
}
if (PlayerCache.loginInfo.vipLv > 0)
{
SeatList[value.position].transform.GetChild(0).GetChild(1).GetComponent <Image>().sprite = VIPImages[PlayerCache.loginInfo.vipLv - 1];
}
else
{
SeatList[value.position].transform.GetChild(0).GetChild(1).gameObject.SetActive(false);
}
}
else
{
for (int i = 0; i < dto.items.Count; i++)
{
if (dto.items[i].itemId == 1)
{
PlayerGoldCount.text = dto.items[i].itemCount.ToString();
}
}
if (PlayerCache.loginInfo.vipLv > 0)
{
VIPbiao.sprite = VIPImages[PlayerCache.loginInfo.vipLv - 1];
}
else
{
VIPbiao.gameObject.SetActive(false);
}
}
}
else
{
//座位中
if (PlayerCache.SeatPlayerinfoDic.ContainsKey(uid))
{
PlayerCache.SeatPlayerinfoDic.TryGetValue(uid, out GameDicePositionPlayerInfoDto value);
for (int i = 0; i < dto.items.Count; i++)
{
if (dto.items[i].itemId == 1)
{
SeatList[value.position].transform.GetChild(0).GetChild(2).GetComponent <Text>().text
= NumberConvert.ConvertW(dto.items[i].itemCount);
}
}
if (PlayerCache.loginInfo.vipLv > 0)
{
SeatList[value.position].transform.GetChild(0).GetChild(1).GetComponent <Image>().sprite = VIPImages[PlayerCache.loginInfo.vipLv - 1];
}
else
{
SeatList[value.position].transform.GetChild(0).GetChild(1).gameObject.SetActive(false);
}
}
}
}
/// <summary>
/// 购买成功回调
/// </summary>
/// <param name="callBackParam"></param>
public override void pay2CallBack(ItemListDto callBackParam)
{
XUIMidMsg.QuickMsg("购买成功！");
PlayerCache.SetWealthUpdate(callBackParam.items, true);
}
public override bool UpdateInfo()
{
ItemList = BaronReplays.RiotAPI.Services.Request.GetStaticData("na/v1.2/item?itemListData=image&locale=" + Request.ApiLanguage, typeof(ItemListDto), DirectoryPath + InfoFile);
return(ItemList != null);
}
private async void buttonFilterItem_Click(object sender, RoutedEventArgs e)
{
buttonFilterItem.IsEnabled = false;
List <string> filters = new List <string>();
if (filterItemAbillity.IsChecked == true)
{
filters.Add("SpellDamage");
}
if (filterItemArmor.IsChecked == true)
{
filters.Add("Armor");
}
if (filterItemAttackSpeed.IsChecked == true)
{
filters.Add("AttackSpeed");
}
if (filterItemConsumable.IsChecked == true)
{
filters.Add("Comsumable");
}
if (filterItemCooldownReduction.IsChecked == true)
{
filters.Add("CooldownReduction");
}
if (filterItemCritic.IsChecked == true)
{
filters.Add("CriticalStrike");
}
if (filterItemDamage.IsChecked == true)
{
filters.Add("Damage");
}
if (filterItemLife.IsChecked == true)
{
filters.Add("Health");
}
if (filterItemLifeRegen.IsChecked == true)
{
filters.Add("HealthRegen");
}
if (filterItemLifeSteal.IsChecked == true)
{
filters.Add("LifeSteal");
}
if (filterItemMagicResistence.IsChecked == true)
{
filters.Add("SpellBlock");
}
if (filterItemMana.IsChecked == true)
{
filters.Add("Mana");
}
if (filterItemManaRegen.IsChecked == true)
{
filters.Add("ManaRegen");
}
if (filterItemTrinket.IsChecked == true)
{
filters.Add("Trinket");
}
if (filterItemVision.IsChecked == true)
{
filters.Add("Vision");
}
if (filterItemMagicPen.IsChecked == true)
{
filters.Add("MagicPenetration");
}
if (filterItemSpellVamp.IsChecked == true)
{
filters.Add("SpellVamp");
}
if (filterItemGoldPer.IsChecked == true)
{
filters.Add("GoldPer");
}
if (filterItemJungle.IsChecked == true)
{
filters.Add("Jungle");
}
if (filterItemSpeed.IsChecked == true)
{
filters.Add("Boots");
filters.Add("NonbootsMovement");
}
if (filterItemArmorPenetration.IsChecked == true)
{
filters.Add("ArmorPenetration");
}
if (filters.Count == 0)
{
filters.Add("All");
}
ItensList.Items.Clear();
if (ItemListDto.AllItems == null)
{
await ItemListDto.LoadAllItens();
}
foreach (ItemDto item in ItemListDto.AllItems)
{
if (!filters.Contains("All"))
{
if (item.Tags != null)
{
foreach (string tag in item.Tags)
{
if (filters.Contains(tag))
{
ItemSelect itemSelect = new ItemSelect();
itemSelect.Item = item;
itemSelect.Tap += ItemSelect_Tap;
ItensList.Items.Add(itemSelect);
break;
}
}
}
}
else
{
ItemSelect itemSelect = new ItemSelect();
itemSelect.Item = item;
itemSelect.Tap += ItemSelect_Tap;
ItensList.Items.Add(itemSelect);
}
}
expanderDamage.IsExpanded = false;
expanderDesfense.IsExpanded = false;
expanderSpell.IsExpanded = false;
expanderUtil.IsExpanded = false;
buttonFilterItem.IsEnabled = true;
}
//有玩家中途财富变更
public override void playerWeathUpdate(long uid, ItemListDto dto)
{
UIDicePlane uIDicePlane = MessageManager.GetInstance.GetUIDict <UIDicePlane>();
uIDicePlane.MiddleWeath(uid, dto);
}
protected override void ReadInfo()
{
ItemList = BaronReplays.RiotAPI.Services.Request.ReadFromFile(DirectoryPath + InfoFile, typeof(ItemListDto));
DecodeData();
}
private ItemListDto myList([FromBody] itemFilterDto filter, [FromQuery] Pagination pagination)
{
_context.ChangeTracker.QueryTrackingBehavior = Microsoft.EntityFrameworkCore.QueryTrackingBehavior.NoTracking;
ItemListDto final = new ItemListDto();
var orderExpression = string.Format("{0} {1}", pagination.SortName, pagination.SortType);
var onlineshopId = _isettings.getOnlineShopId();
var count = (from c in _context.CodeRelations
where
c.IsWebsiteItem == true && c.Skip == false
//&& (filter.Supplier != null ? c.Supplier == filter.Supplier : true)
//&& (filter.Brand != null ? c.Brand == filter.Brand : true)
&& (filter.Cat != null ? c.Cat == filter.Cat : true) &&
(filter.SCat != null ? c.SCat == filter.SCat : true) &&
(filter.SsCat != null ? c.SsCat == filter.SsCat : true) &&
(filter.Hot != null ? c.Hot == filter.Hot : true) &&
(filter.Skip != null ? c.Skip == filter.Skip : true) &&
(filter.Clearance != null ? c.Clearance == filter.Clearance : true) &&
(filter.ComingSoon != null ? Convert.ToBoolean(c.ComingSoon) == filter.ComingSoon : true) &&
(filter.NewItem != null ? c.NewItem == filter.NewItem : true) &&
(filter.FreeDelivery != null ? c.FreeDelivery == filter.FreeDelivery : true) &&
(filter.KeyWord != null ?
c.Name.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
(String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0) ||
c.Code.ToString().Contains(filter.KeyWord) ||
c.SupplierCode.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.Brand.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.Cat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.SCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.SsCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
: true)
join sq in _context.StockQty on c.Code equals sq.Code into g
from sq in g
where sq.Qty > 0 && sq.BranchId == _isettings.getOnlineShopId()
select new
{
}).Count();
var list = (from c in _context.CodeRelations
where
c.IsWebsiteItem == true && c.Skip == false
//&& (filter.Supplier != null ? c.Supplier == filter.Supplier : true)
//&& (filter.Brand != null ? c.Brand == filter.Brand : true)
&& (filter.Cat != null ? c.Cat == filter.Cat : true) &&
(filter.SCat != null ? c.SCat == filter.SCat : true) &&
(filter.SsCat != null ? c.SsCat == filter.SsCat : true) &&
(filter.Hot != null ? c.Hot == filter.Hot : true) &&
(filter.Skip != null ? c.Skip == filter.Skip : true) &&
(filter.Clearance != null ? c.Clearance == filter.Clearance : true) &&
(filter.ComingSoon != null ? Convert.ToBoolean(c.ComingSoon) == filter.ComingSoon : true) &&
(filter.NewItem != null ? c.NewItem == filter.NewItem : true) &&
(filter.FreeDelivery != null ? c.FreeDelivery == filter.FreeDelivery : true) &&
(filter.KeyWord != null ? c.Name.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
(String.IsNullOrEmpty(c.NameCn) ? false : c.NameCn.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0) ||
c.Code.ToString().Contains(filter.KeyWord) ||
c.SupplierCode.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.Brand.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.Cat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.SCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0 ||
c.SsCat.IndexOf(filter.KeyWord, StringComparison.OrdinalIgnoreCase) >= 0
: true)
join sq in _context.StockQty on c.Code equals sq.Code into g
from sq in g
where sq.Qty > 0 && sq.BranchId == _isettings.getOnlineShopId()
select new ItemDto
{
Code = c.Code,
SupplierCode = c.SupplierCode,
Name = c.Name,
NameCn = c.NameCn,
Cat = c.Cat,
SCat = c.SCat,
SsCat = c.SsCat,
Hot = c.Hot,
FreeDelivery = c.FreeDelivery,
IsIdCheck = c.IsIdCheck,
Weight = c.Weight,
NewItem = c.NewItem,
OuterPack = c.outer_pack,
InnerPack = c.InnerPack,
Moq = (c.Moq == null || c.Moq == 0) ? 1 : c.Moq ?? 1,
LevelPrice0 = c.LevelPrice0,
LevelPrice1 = c.LevelPrice1,
LevelPrice2 = c.LevelPrice2,
LevelPrice3 = c.LevelPrice3,
LevelPrice4 = c.LevelPrice4,
LevelPrice5 = c.LevelPrice5,
LevelPrice6 = c.LevelPrice6,
LevelPrice7 = c.LevelPrice7,
LevelPrice8 = c.LevelPrice8,
LevelPrice9 = c.LevelPrice9,
Barcode = c.Barcode,
Stock = _iitem.getItemStork(onlineshopId, c.Code),
Price1 = c.Price1,
PicUrl = _config["Url"] + "/pi/" + c.Code + ".jpg",
// _iitem.getOnlineShopPrice(onlineshopId, c.Code),
Barcodes = _iitem.getBarcodes(c.Code),
StoreSpecial = _iitem.SpecialSetting(c.Code, _isettings.getOnlineShopId())
});
var itemCount = count;
var pageCount = (int)Math.Ceiling(itemCount / (double)pagination.PageSize);
IQueryable <ItemDto>
items =
list.OrderBy(c => c.Cat)
.ThenBy(orderExpression)
.Skip((pagination.PageNumber - 1) * pagination.PageSize)
.Take(pagination.PageSize);
final.Items = items;
final.CurrentPage = pagination.PageNumber;
final.PageSize = pagination.PageSize;
final.PageCount = pageCount;
final.ItemCount = itemCount;
// var result = list; // Mapper.Map<IEnumerable<ItemDto>>(myItemList).OrderBy(c => c.Code).ToList() ;
return(final);
}
