public ProductsLiteDb Update(ProductsLiteDb product)
{
using (var db = new LiteDatabase(@"C:\litedb\MyData.db"))
{
// Get products collection
var products = db.GetCollection <ProductsLiteDb>("Products")
.Update(product);
return(product);
}
}
public Products GetById(int Id)
{
if (!Directory.Exists(@"C:\litedb"))
{
Directory.CreateDirectory(@"C:\litedb");
}
using (var db = new LiteDatabase(@"C:\litedb\MyData.db"))
{
var Existingproducts = db.GetCollection <Products>("Products")
.Find(x => x.Id == Id).FirstOrDefault();
if (Existingproducts == null)
{
// Get a collection (or create, if doesn't exist)
var col = db.GetCollection <ProductsLiteDb>("Products");
Dictionary <string, string> hash = new Dictionary <string, string>
{
{ "value", "" },
{ "currency_code", "USD" }
};
var product = new Products()
{
Id = Id,
CurrentPrice = hash
};
var productlitedb = new ProductsLiteDb()
{
Id = Id,
CurrentPrice = hash
};
var updatedproductfromredsky = GetProductNameandPrice(product);
// if redsky has no item dont add it litedb
if (!(updatedproductfromredsky.ProductName == null && updatedproductfromredsky.CurrentPrice["value"] == ""))
{
productlitedb.CurrentPrice["value"] = updatedproductfromredsky.CurrentPrice["value"];
col.Insert(productlitedb);
}
}
// Get Product collection
var products = db.GetCollection <Products>("Products")
.Find(x => x.Id == Id).FirstOrDefault();
return(products);
}
}
