Ejemplo n.º 1
0
        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);
              }
        }
Ejemplo n.º 2
0
        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);
              }
        }