public void InsertCars(IList <Car> cars)
{
using (var db = new CarsContext())
{
db.Cars.AddRange(cars);
db.SaveChanges();
}
}
public void InsertNotificationsLog(IList <NotificationLog> notifications)
{
using (var db = new CarsContext())
{
db.NotificationsLog.AddRange(notifications);
db.SaveChanges();
}
}
public void UpdateCarImagePath(Car car, string path)
{
using (var db = new CarsContext())
{
car.LocalPicturePath = path;
db.Attach(car);
db.Entry(car).Property(x => x.LocalPicturePath).IsModified = true;
db.SaveChanges();
}
}
/// <summary>
/// Inserts cars to database and returns their ids.
/// </summary>
/// <returns>A list of car id's</returns>
public IList <int> InsertCars(IList <Car> cars)
{
using (var db = new CarsContext())
{
db.Cars.AddRange(cars);
db.SaveChanges();
}
return(cars.Select(c => c.Id).ToList());
}
/// <summary>
/// Inserts only missing urls into database.
/// </summary>
/// <param name="urls"></param>
public void MergeUrls(IList <string> urls)
{
using (var db = new CarsContext())
{
var dbUrls = db.Urls.Select(x => x.Address);
var missingUrls = urls.Except(dbUrls).Select(x => new Url {
Address = x
});
db.Urls.AddRange(missingUrls);
db.SaveChanges();
}
}