public static Progresion getProgresion(int index)
{
DataBase db = new DataBase();
string query = "select id_progresion, nombre_estado, descripcion from progresion where id_progresion = " + index;
List <object[]> select = db.Select(query);
if (select == null || select.Count == 0)
{
return(null);
}
object[] row = select[0];
Progresion progresion = new Progresion();
progresion.Id_progresion = int.Parse(row[0].ToString());
progresion.Nombre_estado = (string)row[1];
progresion.Descripcion = (string)row[2];
return(progresion);
}
public static List <Progresion> listarProgresiones()
{
List <Progresion> lista = new List <Progresion>();
DataBase db = new DataBase();
string query = "select id_progresion, nombre_estado, descripcion from progresion";
List <object[]> select = db.Select(query);
if (select != null && select.Count > 0)
{
foreach (var row in select)
{
Progresion progresion = new Progresion();
progresion.Id_progresion = int.Parse(row[0].ToString());
progresion.Nombre_estado = (string)row[1];
progresion.Descripcion = (string)row[2];
lista.Add(progresion);
}
}
return(lista);
}
