public void InsertEventBracket(EventBracketList eventBracket) { var DB = new Database(); using (MySqlConnection conn = new MySqlConnection(DB.GetConnString())) { using (MySqlCommand comm = conn.CreateCommand()) { comm.CommandText = "INSERT INTO event_bracket_list(eventID, bracketID) VALUES(@eventID, @bracketID)"; comm.Parameters.AddWithValue("@eventID", eventBracket.EventID); comm.Parameters.AddWithValue("@bracketID", eventBracket.BracketID); conn.Open(); comm.ExecuteNonQuery(); conn.Close(); } } }
public EventBracketList AddBracketToEvent(EventBracketList eventBracket) { return(_eventDataAccess.AddBracketToEvent(eventBracket)); }
public EventBracketList AddBracketToEvent(EventBracketList eventBracket) { databaseQuery.InsertEventBracket(eventBracket); return(eventBracket); }
public IActionResult AddEventBracket(EventBracketList eventBracket) { return(Ok(_eventManager.AddBracketToEvent(eventBracket))); }