public void AtualizarEstoque(BotItemEstoque estoque) { BotWoWEntities n = new BotWoWEntities(); Estoque est = new Estoque(); try { est = (from p in n.Estoques where p.idItem == estoque.itemID && p.NomePersonagem == estoque.Personagem select p).First(); est.Qtd = estoque.Qtd; est.dtAtualizado = DateTime.Now; n.SaveChanges(); } catch (InvalidOperationException) { est.idItem = estoque.itemID; est.NomePersonagem = estoque.Personagem; est.Qtd = estoque.Qtd; est.dtAtualizado = DateTime.Now; est.dtFabricado = DateTime.Now; n.Estoques.AddObject(est); n.SaveChanges(); } catch (Exception ex) { throw new Exception(String.Format("Erro na rotina BotControlaEstoque.AtualizarEstoque. {0} itemID: {1} {0}",Environment.NewLine, estoque.itemID), ex); } }
public List<BotItemEstoque> RetornaGrupoGemas(string nome) { List<BotItemEstoque> l = new List<BotItemEstoque>(); const int VALOR_EM_ESTOQUE = 18; const decimal VALOR_MINIMO_AH = 249999; BotWoWEntities n = new BotWoWEntities(); BotWoWEntities n1 = new BotWoWEntities(); var a = (from i in n.Items join isp in n.SpellItems on i.id equals isp.idItem join est in n.Estoques on isp.idItem equals est.idItem where i.itemClass == 3 && est.Qtd < VALOR_EM_ESTOQUE && est.NomePersonagem == nome && est.dtFabricado < est.dtAtualizado && i.ValorMinnaAH > VALOR_MINIMO_AH select new { idItem = i.id, idSpell = isp.idSpell, qtd = (VALOR_EM_ESTOQUE - est.Qtd) }); foreach (var item in a) { BotItemEstoque b = new BotItemEstoque(); b.itemID = (int)item.idItem; b.Personagem = nome; b.Qtd = (int)item.qtd; b.SpellQueCriaOItem = (int)item.idSpell; l.Add(b); var x = (from p in n1.Estoques where p.idItem == item.idItem && p.NomePersonagem == nome select p).First(); x.dtFabricado = DateTime.Now; n1.SaveChanges(); } return l; }
public void AtualizaValorItem(decimal idItem, decimal valor) { BotWoWEntities n = new BotWoWEntities(); Item i; i = (from p in n.Items where p.id == idItem select p).FirstOrDefault(); if (i != null) { i.ValorMinnaAH = valor; n.SaveChanges(); } }
protected void Button1_Click(object sender, EventArgs e) { try { BotWoWEntities n1 = new BotWoWEntities(); c = (from p in n1.ConfiguracaoEstoques where p.id == codigo select p).First(); c.Qtd = Decimal.Parse(TextBox1.Text); n1.SaveChanges(); Response.Redirect("ConfigEstoque.aspx"); } catch (Exception ex) { throw ex; } }
public Object RecuperaEntity(Entities en) { Object EF; if (en == Entities.MercadoLivre) { EF = new NSAADMEntities(stringdeconexao()); return (NSAADMEntities)EF; } else if (en == Entities.Bot) { EF = new BotWoWEntities(stringdeconexao()); return (BotWoWEntities)EF; } else { throw new Exception("Enumerador inválido"); } }
public void PegarSpelleItem(decimal spell, decimal item) { BotWoWEntities n = new BotWoWEntities(); try { var x = (from p in n.SpellItems where p.idItem == item && p.idSpell == spell select p).First(); } catch (Exception) { SpellItem s = new SpellItem(); s.idSpell = spell; s.idItem = item; n.SpellItems.AddObject(s); n.SaveChanges(); } }
private void GravaAtualizaItem(Item it) { BotWoWEntities n = new BotWoWEntities(); try { Item c = (from p in n.Items where p.id == it.id select p).First(); //NovoItem.armor = Convert.ToInt32(Obj["armor"].ToString()); //NovoItem.baseArmor = Convert.ToInt32(Obj["baseArmor"].ToString()); c.buyPrice = it.buyPrice; c.containerSlots = it.containerSlots; c.Desc = it.Desc; //NovoItem.disenchantingSkillRank = Convert.ToInt32(Obj["disenchantingSkillRank"].ToString()); //NovoItem.displayInfoId = Convert.ToInt32(Obj["displayInfoId"].ToString()); c.equippable = it.equippable; //NovoItem.hasSockets = Convert.ToBoolean(Obj["hasSockets"].ToString()); //NovoItem.heroicTooltip = Convert.ToBoolean(Obj["heroicTooltip"].ToString()); c.icon = it.icon; c.id = it.id; c.inventoryType = it.inventoryType; //NovoItem.isAuctionable = Convert.ToBoolean(Obj["isAuctionable"].ToString()); c.itemBind = it.itemBind; c.itemClass = it.itemClass; c.itemLevel = it.itemLevel; c.itemSubClass = it.itemSubClass; c.maxCount = it.maxCount; c.maxDurability = it.maxDurability; c.minFactionId = it.minFactionId; c.minReputation = it.minReputation; //NovoItem.name = Obj["name"].ToString(); //NovoItem.nameDescription = Obj["nameDescription"].ToString(); //NovoItem.nameDescriptionColor = Obj["nameDescriptionColor"].ToString(); ; c.quality = it.quality; //NovoItem.requiredLevel = Convert.ToInt32(Obj["requiredLevel"].ToString()); //NovoItem.requiredSkill = Convert.ToInt32(Obj["requiredSkill"].ToString()); //NovoItem.requiredSkillRank = Convert.ToInt32(Obj["requiredSkillRank"].ToString()); //NovoItem.sellPrice = Convert.ToInt32(Obj["sellPrice"].ToString()); c.stackable = it.stackable; //NovoItem.upgradable = Convert.ToBoolean(Obj["upgradable"].ToString()); n.SaveChanges(); } catch (InvalidOperationException) { n.Items.AddObject(it); n.SaveChanges(); } catch (Exception ex) { throw new Exception("Erro na rotina GravaAtualizaItem", ex); } }
public void ZeraEstoque(string nome) { BotWoWEntities n = new BotWoWEntities(); var x = (from p in n.Estoques where p.NomePersonagem == nome select p); foreach (Estoque item in x) { item.Qtd = 0; } n.SaveChanges(); }
public int RetornaQTDaProduzir(int idItem, string NomePersonagem) { BotWoWEntities n = new BotWoWEntities(); try { var x = (from p in n.Estoques where p.idItem == idItem && p.NomePersonagem == NomePersonagem && p.dtAtualizado > p.dtFabricado select p).First(); var y = (from p in n.ConfiguracaoEstoques where p.idItem == idItem && p.NomePersonagem == NomePersonagem select p).First(); x.dtFabricado = DateTime.Now; n.SaveChanges(); return (int)y.Qtd - (int)x.Qtd; } catch (Exception) { return 0; } }
public List<BotItemEstoque> RetornaItensEnchantInscr(string Real, string Faccao) { List<BotItemEstoque> l = new List<BotItemEstoque>(); List<decimal> IDs = new List<decimal>(); const int VALOR_EM_ESTOQUE = 18; IDs.Add(87559); IDs.Add(87560); IDs.Add(83007); IDs.Add(83006); BotWoWEntities n = new BotWoWEntities(); BotWoWEntities n1 = new BotWoWEntities(); var a = (from i in n.Items join isp in n.SpellItems on i.id equals isp.idItem join est in n.Estoques on isp.idItem equals est.idItem where IDs.Any(x => x == i.id) && est.Qtd < VALOR_EM_ESTOQUE && est.dtFabricado < est.dtAtualizado select new { idItem = i.id, idSpell = isp.idSpell, qtd = (VALOR_EM_ESTOQUE - est.Qtd), nome = est.NomePersonagem }); foreach (var item in a) { BotItemEstoque b = new BotItemEstoque(); b.itemID = (int)item.idItem; b.Personagem = item.nome; b.Qtd = (int)item.qtd; b.SpellQueCriaOItem = (int)item.idSpell; l.Add(b); var x = (from p in n1.Estoques where p.idItem == item.idItem && p.NomePersonagem == item.nome select p).First(); x.dtFabricado = DateTime.Now; n1.SaveChanges(); } return l; }