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));
}
}
}
