public static void SaveUpdateSold(ListingSold 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 + "DBSalesInfoSold.csv", true)) { tw.WriteLine("{0};{1};{2};{3};{4}", property.ID, property.SalesType, property.Price, property.Sqrprice, property.SalesDate); } }
public static void importSold(Dictionary<int, ListingSold> dict) { var reader = new StreamReader(File.OpenRead(savefile + "HackSolgte.csv"), Encoding.UTF8); while (!reader.EndOfStream) { var line = reader.ReadLine(); string[] values = line.Split(','); int room; if (values[0] == "-") { room = 0; } else { room = Convert.ToInt32(values[0]); } string salesType = values[1]; int sizeHouse; if (values[2] == "-") { sizeHouse = 0; } else { sizeHouse = Convert.ToInt32(values[2]); } string uncleanSqrPrice; if (values[3] == "-") { uncleanSqrPrice = "0"; } else { uncleanSqrPrice = values[3]; } int cleansqrprice = Convert.ToInt32(uncleanSqrPrice.Replace(".", "")); int yearBuilt; if (values[4] == "-") { yearBuilt = 0; } else { yearBuilt = Convert.ToInt32(values[4]); } string uncleanPrice = values[5]; if (values[5] == "-") { uncleanPrice = "0"; } else { uncleanPrice = values[5]; } int cleanPrice = Convert.ToInt32(uncleanPrice.Replace(".", "")); string salesDate = values[6]; string adresse = values[7]; 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]; } string propertyType = values[8]; int areaCode = Convert.ToInt32(values[9]); ListingSold listing = new ListingSold(streetName, houseNumber, room, areaCode, cleanPrice, sizeHouse, yearBuilt, salesDate, cleansqrprice, salesType, propertyType); dict.Add(listing.ID, listing); } }