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])); }