public static Fixture SelectById(int id)
{
FixtureDSTableAdapters.tbl_fixtureTableAdapter adapter =
new FixtureDSTableAdapters.tbl_fixtureTableAdapter();
FixtureDS.tbl_fixtureDataTable table = adapter.SelectById(id);
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static List <Fixture> SelectByEvento(string idGrupo)
{
FixtureDSTableAdapters.tbl_fixtureTableAdapter adapter =
new FixtureDSTableAdapters.tbl_fixtureTableAdapter();
FixtureDS.tbl_fixtureDataTable table = adapter.SelectByEvento(Convert.ToInt32(idGrupo));
List <Fixture> listFixture = new List <Fixture>();
foreach (FixtureDS.tbl_fixtureRow row in table)
{
listFixture.Add(RowToDto(row));
}
return(listFixture);
}
public static List <Fixture> SelectActuales()
{
FixtureDSTableAdapters.tbl_fixtureTableAdapter adapter =
new FixtureDSTableAdapters.tbl_fixtureTableAdapter();
FixtureDS.tbl_fixtureDataTable table = adapter.SelectActuales();
List <Fixture> listFixture = new List <Fixture>();
foreach (FixtureDS.tbl_fixtureRow row in table)
{
listFixture.Add(RowToDto(row));
}
return(listFixture);
}
public static Fixture InsertWithReturn(string idEquipo, string idRival,
string idCancha, string fecha, string hora, string idGrupo,
string estado, string scoreEquipo, string scoreRival, string puntos)
{
FixtureDSTableAdapters.tbl_fixtureTableAdapter adapter =
new FixtureDSTableAdapters.tbl_fixtureTableAdapter();
FixtureDS.tbl_fixtureDataTable table = adapter.InsertWithReturn(Convert.ToInt32(idEquipo),
Convert.ToInt32(idRival), Convert.ToInt32(idCancha),
TimeSpan.Parse(hora), Convert.ToDateTime(fecha), 0, Convert.ToInt32(idGrupo),
estado, Convert.ToInt32(scoreEquipo), Convert.ToInt32(scoreRival), Convert.ToInt32(puntos));
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
