public Clase(CarpetaLista cl)
{
InitializeComponent();
clase = cl;
SetData();
ConfigurarGridItems();
}
public CarpetaLista GetCarpetaLista(Int32 id)
{
SQLiteCommand cmd = new SQLiteCommand(Program.m_dbConnection);
cmd.CommandText = "SELECT A.ID AS ID, " +
"A.TITULO AS TITULO, " +
"A.ID_CARPETALISTA AS ID_CARPETALISTA, " +
"A.TIPO AS TIPO, " +
"A.COMENTARIO AS COMENTARIO, " +
"A.CERRADA AS CERRADA " +
"FROM " + this.tableName + " A WHERE ID ='" + id.ToString() + "'";
SQLiteDataReader row = cmd.ExecuteReader();
row.Read();
CarpetaLista item = new CarpetaLista();
item.id = row.GetInt32(0);
item.titulo = row.GetString(1);
item.id_carpetalista = row.GetInt32(2);
item.tipo = row.GetInt32(3);
item.comentario = row.GetString(4);
item.cerrada = row.GetBoolean(5);
return(item);
}
public int Nuevo(CarpetaLista p)
{
Int32 id = this.NewId();
if (p.id != 0)
{
id = p.id;
}
string sql = "INSERT INTO " + tableName + " (id, titulo, id_carpetalista, tipo, comentario, cerrada, borrada ) " +
string.Format(" VALUES ({0},{1},{2},{3},{4},{5},{6})", id, "'" + p.titulo + "'", p.id_carpetalista, p.tipo, "'" + p.comentario + "'", p.cerrada?0:1, 0);
this.Execute(sql);
return(id);
}
public List <CarpetaLista> Lista()
{
List <CarpetaLista> lp = new List <CarpetaLista>();
if (this.idCarpetaLista != 0)
{
this.Filter("id_carpetalista " + this.idCarpetaLista.ToString());
}
foreach (DataRowView row in dv)
{
CarpetaLista p = new CarpetaLista();
p.id = Convert.ToInt32(row["id"]);
p.titulo = Convert.ToString(row["titulo"]);
p.procesado = false;
p.id_carpetalista = Convert.ToInt32(row["id_carpetalista"]);
p.tipo = Convert.ToInt32(row["tipo"]);
p.comentario = Convert.ToString(row["comentario"]);
p.cerrada = Convert.ToBoolean(row["cerrada"]);
lp.Add(p);
}
return(lp);
}