public static void importForSale(Dictionary<int, ListingForSale> dict) { //_input,_num,_widgetName,_source,_resultNumber,_pageUrl,adresse,postnr,by,pris,kvm_pris,type,liggetid_nu, //liggetid_total,kvm_bbr,kvm_bbr_vaegtet,vaerelser,links,links / _source,links / _title,links / _text var reader = new StreamReader(File.OpenRead(savefile + "nyboligsiden.csv"), Encoding.UTF8); while (!reader.EndOfStream) { var line = reader.ReadLine(); string[] values = line.Split(','); string adresse = values[6]; string streetName = String.Empty; string houseNumber = String.Empty; Match regexMatch = Regex.Match(adresse, "\\d"); if (regexMatch.Success) { int digitStartIndex = regexMatch.Index; streetName = adresse.Substring(0, digitStartIndex - 1); string uncleanHouseNumber = adresse.Substring(digitStartIndex); string[] uncleanHousenumber = uncleanHouseNumber.Split(' '); houseNumber = uncleanHousenumber[0]; } int areaCode = Convert.ToInt32(values[7]); int priceOfHouse = Convert.ToInt32(values[9].Replace(".","")); int sqrPrice; if (values[14] == "-") { sqrPrice = 0; } else { sqrPrice = Convert.ToInt32(values[10].Replace(".", "")); } string propertyType = values[11]; int demurrage = Convert.ToInt32(values[12].Replace(".", "")); int sizeOfHouse; if (values[14] == "-") { sizeOfHouse = 0; } else { sizeOfHouse = Convert.ToInt32(values[14]); } int numberOfRooms; if (values[16] == "-") { numberOfRooms = 0; } else { numberOfRooms = Convert.ToInt32(values[16]); } ListingForSale listing = new ListingForSale(streetName, houseNumber, numberOfRooms, areaCode, priceOfHouse, sizeOfHouse, sqrPrice, propertyType, demurrage); dict.Add(listing.ID, listing); } }
public static void SaveUpdateForSale(ListingForSale property) { using (StreamWriter tw = new StreamWriter(savefile + "DBListings.csv", true)) { tw.WriteLine("{0};{1};{2};{3};{4}", property.ID, property.PropertyType, property.Size, property.Rooms, property.YearBuilt); } using (StreamWriter tw = new StreamWriter(savefile + "DBAddress.csv", true)) { tw.WriteLine("{0};{1};{2};{3};{4};{5}", property.ID, property.StreetName, property.HouseNumber, property.AreaCode, property.Lat, property.Lng); } using (StreamWriter tw = new StreamWriter(savefile + "DBSalesInfoForSale.csv", true)) { tw.WriteLine("{0};{1};{2};{3}", property.ID, property.Price, property.Sqrprice, property.Demurrage); } }