public List <Battlerite> GetBattleritesByChampionName(string name)
{
MySqlConnection conn = new MySqlConnection(connString);
List <Battlerite> battleriteList = new List <Battlerite>();
try
{
conn.Open();
string query = "SELECT * FROM BattleRite where ChampionName = '" + name + "';";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn);
DataTable data = new DataTable();
adapter.Fill(data);
foreach (DataRow row in data.Rows)
{
Battlerite br = new Battlerite();
br.battleRiteName = (row["BattleRiteName"]).ToString();
br.championName = (row["ChampionName"]).ToString();
br.description = (row["Description"]).ToString();
br.battleRiteType = (row["BattleRiteType"]).ToString();
br.battleRiteImage = (row["Image"]).ToString();
battleriteList.Add(br);
}
return(battleriteList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public async Task <Battlerite> Patch(string id, [FromBody] Battlerite value)
{
return(await _battlerites.PartialUpdate(id, value));
}
public async Task <Battlerite> Put(string id, [FromBody] Battlerite value)
{
return(await _battlerites.Update(id, value));
}
public async Task <Battlerite> Post([FromBody] Battlerite value)
{
return(await _battlerites.Create(value));
}
