// Получение всех событий
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();
}
}
}
