// Получение всех событий public List <EventBet> GetEvent() { List <EventBet> eventL = new List <EventBet>(); try { comm.CommandText = "SELECT * FROM Events"; comm.CommandType = CommandType.Text; conn.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { EventBet evet = new EventBet() { EventId = Convert.ToInt32(reader[0]), DateEvent = Convert.ToDateTime(reader[1]), Team1 = reader[2].ToString(), Team1Coef = Convert.ToDecimal(reader[3]), Team2 = reader[4].ToString(), Team2Coef = Convert.ToDecimal(reader[5]) }; eventL.Add(evet); } return(eventL); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
// Поиск события по коду public EventBet GetEventCode(EventBet eb) { EventBet eeventBet = new EventBet(); try { comm.CommandText = "SELECT * FROM Events WHERE EventId=@EventId"; comm.Parameters.AddWithValue("EventId", eb.EventId); comm.CommandType = CommandType.Text; conn.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { eeventBet.EventId = Convert.ToInt32(reader[0]); eeventBet.DateEvent = Convert.ToDateTime(reader[1]); eeventBet.Team1 = reader[2].ToString(); eeventBet.Team1Coef = Convert.ToDecimal(reader[3]); eeventBet.Team2 = reader[4].ToString(); eeventBet.Team2Coef = Convert.ToDecimal(reader[5]); } return(eeventBet); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
// Удаление события из таблицы public int RemoveEvent(EventBet e) { try { comm.CommandText = "DELETE Events WHERE @EventId=EventId"; comm.Parameters.AddWithValue("EventId", e.EventId); comm.CommandType = CommandType.Text; conn.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }