public static void InsertHouseModel(HouseModel model)
{
using (var db = new SystemDBContext())
{
db.Houses.Add(model);
db.SaveChanges();
}
}
public static void UpdateDatabase(string csv_file_path)
{
var data = getCSVContent(csv_file_path);
var houseModel = GetHouseModel(data);
using (var db = new SystemDBContext())
{
if (!CheckTableExists())
return;
var dbHouses = db.Houses.Select(x => x.Hash).ToList();
foreach (var house in houseModel.Where(house => !dbHouses.Contains(house.Hash)))
{
db.Houses.Add(house);
}
db.SaveChanges();
}
}