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; }