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