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();
                }
            }
        }
Пример #2
0
 public EventBracketList AddBracketToEvent(EventBracketList eventBracket)
 {
     return(_eventDataAccess.AddBracketToEvent(eventBracket));
 }
Пример #3
0
 public EventBracketList AddBracketToEvent(EventBracketList eventBracket)
 {
     databaseQuery.InsertEventBracket(eventBracket);
     return(eventBracket);
 }
 public IActionResult AddEventBracket(EventBracketList eventBracket)
 {
     return(Ok(_eventManager.AddBracketToEvent(eventBracket)));
 }