//SaveItem para la tabla Favoritos
public int SaveItemFav(FavoritosItem item)
{
int r;
lock (locker) {
if (item.ID != 0)
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand()) {
command.CommandText = "UPDATE [Favoritos] SET [Title] = ?, [Description] = ?, [Id_Unid] = ? WHERE [_id] = ?;";
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.Titulo
});
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.Descripcion
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = item.Id_unidad
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = item.ID
});
r = command.ExecuteNonQuery();
}
connection.Close();
return(r);
}
else
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand()) {
command.CommandText = "INSERT INTO [Favoritos] ([Title], [Description], [Id_Unid]) VALUES (? ,?, ?)";
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.Titulo
});
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.Descripcion
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = item.Id_unidad
});
r = command.ExecuteNonQuery();
}
connection.Close();
return(r);
}
}
}
//FromReader Tabla Favoritos
FavoritosItem FromReaderFav(SqliteDataReader r)
{
var t = new FavoritosItem();
t.ID = Convert.ToInt32(r ["_id"]);
t.Titulo = r ["Title"].ToString();
t.Descripcion = r ["Description"].ToString();
t.Id_unidad = Convert.ToInt32(r ["Id_Unid"]);
return(t);
}
//GetItem para Favoritos 2
public FavoritosItem GetItemFav(int id)
{
var t = new FavoritosItem();
lock (locker) {
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand()) {
command.CommandText = "SELECT [_id], [Title], [Description], [Id_Unid] from [Favoritos] WHERE [_id] = ?";
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = id
});
var r = command.ExecuteReader();
while (r.Read())
{
t = FromReaderFav(r);
break;
}
}
connection.Close();
}
return(t);
}
public static int SaveTask (FavoritosItem item)
{
return me.db.SaveItemFav(item);
}
public static int SaveTask(FavoritosItem item)
{
return(FavoritosItemRepositoryADO.SaveTask(item));
}
public static int SaveTask (FavoritosItem item)
{
return FavoritosItemRepositoryADO.SaveTask(item);
}
public static int SaveTask(FavoritosItem item)
{
return(me.db.SaveItemFav(item));
}
