public static FixtureNoticias SelectById(int id)
{
FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter adapter =
new FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter();
FixtureNoticiaDS.tbl_fixtureNoticiaDataTable table = adapter.SelectById(id);
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static FixtureNoticias SelectByTipo(string tipo, string idFixture)
{
FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter adapter =
new FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter();
FixtureNoticiaDS.tbl_fixtureNoticiaDataTable table = adapter.SelectByTipos(tipo, Convert.ToInt32(idFixture));
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static List <FixtureNoticias> SelectByEvento(string idEvento)
{
FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter adapter =
new FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter();
FixtureNoticiaDS.tbl_fixtureNoticiaDataTable table = adapter.SelectByEvento(Convert.ToInt32(idEvento));
List <FixtureNoticias> listNoticia = new List <FixtureNoticias>();
foreach (FixtureNoticiaDS.tbl_fixtureNoticiaRow row in table)
{
listNoticia.Add(RowToDto(row));
}
return(listNoticia);
}
public static List <FixtureNoticias> SelectNoComentarios()
{
FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter adapter =
new FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter();
FixtureNoticiaDS.tbl_fixtureNoticiaDataTable table = adapter.SelectNoEliminados();
List <FixtureNoticias> listNoticia = new List <FixtureNoticias>();
foreach (FixtureNoticiaDS.tbl_fixtureNoticiaRow row in table)
{
listNoticia.Add(RowToDto(row));
}
return(listNoticia);
}
public static FixtureNoticias InsertWithReturn(string idFixture, string idEquipo,
string idJugador, string tipo, string descripcion, string fecha, string hora)
{
FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter adapter =
new FixtureNoticiaDSTableAdapters.tbl_fixtureNoticiaTableAdapter();
FixtureNoticiaDS.tbl_fixtureNoticiaDataTable table =
adapter.InsertWithReturn(Convert.ToInt32(idFixture), Convert.ToInt32(idEquipo), Convert.ToInt32(idJugador),
tipo, descripcion, Convert.ToDateTime(fecha), TimeSpan.Parse(hora), 0);
if (table.Rows.Count == 0)
{
return(null);
}
if (tipo == "Gol")
{
Goles objGol = GolesBLL.SelectByJugador(Convert.ToInt32(idJugador));
int goles = objGol.Gol + 1;
GolesBLL.UpdateGoles(goles, Convert.ToInt32(idJugador));
}
return(RowToDto(table[0]));
}
