public static void StoreWatche(CasioWatch watch)
{
using (var db = new WebScrappingContext())
{
if (watch != null)
{
db.CasioWatch.Add(watch);
db.SaveChanges();
}
}
}
public static void StoreWatches(List <CasioWatch> watches)
{
using (var db = new WebScrappingContext())
{
if (watches != null)
{
db.CasioWatch.AddRange(watches);
db.SaveChanges();
}
}
}
public static void UpdateWatch(CasioWatch watch)
{
// add logic to update only properties that are not null
using (var db = new WebScrappingContext())
{
if (watch != null)
{
var query = from watchdb in db.CasioWatch
where watchdb.Name == watch.Name
select watchdb;
CasioWatch updateWatch = query.SingleOrDefault <CasioWatch>();
updateWatch.AmazonPosted = watch.AmazonPosted;
updateWatch.AmazonPricePost = watch.AmazonPricePost;
updateWatch.BetterPriceThanAmazon = watch.BetterPriceThanAmazon;
updateWatch.Description = watch.Description;
updateWatch.Image = watch.Image;
updateWatch.ImageUrl = watch.ImageUrl;
updateWatch.Name = watch.Name;
updateWatch.Price = watch.Price;
updateWatch.WatchUrl = watch.WatchUrl;
db.SaveChanges();
}
}
}
