private void FindAgent(string name) { agents Agent = agentsDA.GetAgents(name); if (Agent != null) { type.Text = "Type"; skill1_name.Text = "Skill Name"; first.Text = "First Ability"; second.Text = "Second Ability"; third.Text = "Third Ability"; ult.Text = "Ultimate Ability"; cost.Text = "Cost"; totalCost.Text = "Total Cost"; agent_type.Text = Agent.AgentType; skill1_name.Text = Agent.FirstAbility; skill2_name.Text = Agent.SecondAbility; skill3_name.Text = Agent.ThirdAbility; ultimate_name.Text = Agent.UltimateAbility; skill1_cost.Text = Agent.FirstAbility_Cost; skill2_cost.Text = Agent.SecondAbilityCost; skill3_cost.Text = Agent.ThirdAbilityCharge_Method; ultimate_cost.Text = Agent.UltimateAbilityPoints + " Points"; total_cost.Text = Agent.TotalAbilityCost; } else { MessageBox.Show($"Invalid Agent! Try Again!"); } }
// GET api/customers/5 public bool Get(string password) { agents agent; var context = HttpContext.Current; if (String.IsNullOrEmpty(password)) { agent = (agents)context.Cache["agent"]; if (agent == null) { return(false); } return(true); } if (!db.agents1.Any(s => s.password == password)) { return(false); } var item = db.agents1.Where(s => s.password == password).FirstOrDefault(); agent = new agents(); agent.agent = item.agent; agent.password = item.password; agent.id = item.id; if (context != null) { context.Cache["agent"] = agent; } return(true); }
public Task <agents> Put(agents agent) { using (var db = new InccomingDbContext()) { var isUpdated = db.Agents.Update(O => new { O.Address, O.ContactPerson, O.Name, O.Telepon }, agent, O => O.Id == agent.Id); if (isUpdated) { return(Task.FromResult(agent)); } else { throw new SystemException("Data Tidak Berhasil Diubah"); } } }
public Task <agents> Post(agents agent) { using (var db = new InccomingDbContext()) { agent.Id = db.Agents.InsertAndGetLastID(agent); if (agent.Id > 0) { return(Task.FromResult(agent)); } else { throw new SystemException("Data Tidak Terhapus"); } } }
public string UpdateImage(string token) { token = TokenManager.readToken(HttpContext.Current.Request); string message = ""; var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { string agentObject = ""; agents agentObj = null; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "itemObject") { agentObject = c.Value.Replace("\\", string.Empty); agentObject = agentObject.Trim('"'); agentObj = JsonConvert.DeserializeObject <agents>(agentObject, new IsoDateTimeConverter { DateTimeFormat = "dd/MM/yyyy" }); break; } } try { agents agent; using (incposdbEntities entity = new incposdbEntities()) { var agentEntity = entity.Set <agents>(); agent = entity.agents.Where(p => p.agentId == agentObj.agentId).First(); agent.image = agentObj.image; entity.SaveChanges(); } message = agent.agentId.ToString(); return(TokenManager.GenerateToken(message)); } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } }
public static agents GetAgents(string agentName) { string query = "SELECT *, (first_ability_cost + second_ability_cost) AS total_ability_cost FROM agents WHERE name = (@AgentName) limit 1"; cmd = DBHelper.GetAgentQuery(query, agentName); agents aUser = null; if (cmd != null) { dt = new DataTable(); sda = new MySqlDataAdapter(cmd); sda.Fill(dt); foreach (DataRow dr in dt.Rows) { string uAgentName = dr["name"].ToString(); string uAgentType = dr["type"].ToString(); string uFirstAbility = dr["first_ability"].ToString(); string uSecondAbility = dr["second_ability"].ToString(); string uThirdAbility = dr["third_ability"].ToString(); string uUltimateAbility = dr["ultimate_ability"].ToString(); string uFirstAbilityCost = dr["first_ability_cost"].ToString(); string uSecondAbilityCost = dr["second_ability_cost"].ToString(); string uTotalAbilityCost = dr["total_ability_cost"].ToString(); string uThirdAbilityChargeMethod = dr["third_ability_charge_method"].ToString(); string uUltimateAbilityPoints = dr["ultimate_ability_points"].ToString(); aUser = new agents(uAgentName, uAgentType, uFirstAbility, uSecondAbility, uThirdAbility, uUltimateAbility, uFirstAbilityCost, uSecondAbilityCost, uTotalAbilityCost, uThirdAbilityChargeMethod, uUltimateAbilityPoints); } } return(aUser); }
public string Save(string token) { token = TokenManager.readToken(HttpContext.Current.Request); string message = ""; var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { string agentObject = ""; agents agentObj = null; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "itemObject") { agentObject = c.Value.Replace("\\", string.Empty); agentObject = agentObject.Trim('"'); agentObj = JsonConvert.DeserializeObject <agents>(agentObject, new IsoDateTimeConverter { DateTimeFormat = "dd/MM/yyyy" }); break; } } try { agents agent; using (incposdbEntities entity = new incposdbEntities()) { var agentEntity = entity.Set <agents>(); if (agentObj.agentId == 0) { ProgramInfo programInfo = new ProgramInfo(); int agentMaxCount = 0; if (agentObj.type == "c") { agentMaxCount = programInfo.getCustomerCount(); } else if (agentObj.type == "v") { agentMaxCount = programInfo.getVendorCount(); } int agentCount = entity.agents.Where(x => x.type == agentObj.type).Count(); if (agentCount >= agentMaxCount && agentMaxCount != -1) { message = "-1"; return(TokenManager.GenerateToken(message)); } else { agentObj.createDate = DateTime.Now; agentObj.updateDate = DateTime.Now; agentObj.updateUserId = agentObj.createUserId; agentObj.balanceType = 0; agent = agentEntity.Add(agentObj); } } else { agent = entity.agents.Where(p => p.agentId == agentObj.agentId).First(); agent.accType = agentObj.accType; agent.address = agentObj.address; agent.code = agentObj.code; agent.company = agentObj.company; agent.email = agentObj.email; agent.image = agentObj.image; agent.mobile = agentObj.mobile; agent.name = agentObj.name; agent.notes = agentObj.notes; agent.phone = agentObj.phone; agent.type = agentObj.type; agent.maxDeserve = agentObj.maxDeserve; agent.fax = agentObj.fax; agent.updateDate = DateTime.Now;// server current date agent.updateUserId = agentObj.updateUserId; agent.isActive = agentObj.isActive; agent.balance = agentObj.balance; agent.balanceType = agentObj.balanceType; agent.isLimited = agentObj.isLimited; agent.payType = agentObj.payType; } entity.SaveChanges(); message = agent.agentId.ToString(); } return(TokenManager.GenerateToken(message)); } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } }