public static List <CompetitorModel> ObtenerTodos()
{
try
{
//List<(string, object)> parametros = new List<(string, object)> { ("@codigo", codigo) };
DataTable dt = (DataTable)DB.StoredProcedureQueryReturn("GetAll", null);
if (dt != null)
{
List <CompetitorModel> listado = new List <CompetitorModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CompetitorModel competitor = new CompetitorModel();
competitor.id = Convert.ToInt32(dt.Rows[i]["idCompetitor"]);
competitor.nombre = dt.Rows[i]["nombreCompetitor"].ToString();
competitor.foto = dt.Rows[i]["urlImageCompetitor"].ToString();
listado.Add(competitor);
}
return(listado);
}
return(null);
}
catch (Exception e)
{
return(null);
}
}
public static CompetitorModel ObtenerGanadorAnterior()
{
try
{
DataTable dt = (DataTable)DB.StoredProcedureQueryReturn("GetPreviousChosen", null);
if (dt != null && dt.Rows.Count == 1)
{
CompetitorModel competitor = new CompetitorModel();
competitor.id = Convert.ToInt32(dt.Rows[0]["idCompetitor"]);
competitor.nombre = dt.Rows[0]["nombreCompetitor"].ToString();
competitor.foto = dt.Rows[0]["urlImageCompetitor"].ToString();
return(competitor);
}
return(null);
}
catch (Exception e)
{
return(null);
}
}
