public static void InsertHouseModel(HouseModel model)
{
using (var db = new SystemDBContext())
{
db.Houses.Add(model);
db.SaveChanges();
}
}
private static List<HouseModel> GetHouseModel(DataTable data)
{
var addressIndex = data.Columns.IndexOf("address");
var latIndex = data.Columns.IndexOf("lat");
var lonIndex = data.Columns.IndexOf("long");
var monthSoldIndex = data.Columns.IndexOf("month_sold");
var yearSoldIndex = data.Columns.IndexOf("year_sold");
var finalAmountIndex = data.Columns.IndexOf("final_amount");
var askingAmountIndex = data.Columns.IndexOf("asking_price");
// list to insert
var insertList = new List<HouseModel>();
foreach (DataRow row in data.Rows)
{
string address = "", lon = "", lat = "", monthSold = "", yearSold = "", finalAmount = "", askingAmount = "";
if (addressIndex >= 0)
address = row.ItemArray[addressIndex].ToString();
if (latIndex >= 0)
lat = row.ItemArray[latIndex].ToString();
if (lonIndex >= 0)
lon = row.ItemArray[lonIndex].ToString();
if (monthSoldIndex >= 0)
monthSold = row.ItemArray[monthSoldIndex].ToString();
if (yearSoldIndex >= 0)
yearSold = row.ItemArray[yearSoldIndex].ToString();
if (finalAmountIndex >= 0)
finalAmount = row.ItemArray[finalAmountIndex].ToString();
if (askingAmountIndex >= 0)
askingAmount = row.ItemArray[askingAmountIndex].ToString();
// Ask google map API
if ((lat == "" || lon == "")&& address !="")
{
var lonlat = API.Google.GeoCoding.GetAddressLonLat(address);
}
var newHouse = new HouseModel()
{
Address = address,
Lat = lat,
Lon = lon,
MonthSold = monthSold,
YearSold = yearSold,
FinalAmount = finalAmount,
AskingAmount = askingAmount,
Hash = SHA1Hash.GetSHA1HashData(address + monthSold + yearSold)
};
insertList.Add(newHouse);
}
return insertList;
}