private void ReadCSVFiles() { try { Restaurants = new Dictionary<string, RestaurantsCustomersGeoplaceEntity>(); UserProfiles = new Dictionary<string, RestaurantCustomersUserProfileEntity>(); Rating_finals = new Dictionary<string, RestaurantsAndCustomersRating_finalEntity>(); #region Reading geoplaces2.csv TextFieldParser restaurantsParser = new TextFieldParser(Properties.Settings.Default["geoplaces2Path"].ToString()); restaurantsParser.TextFieldType = FieldType.Delimited; restaurantsParser.SetDelimiters(","); restaurantsParser.ReadFields(); while (!restaurantsParser.EndOfData) { //Processing row RestaurantsCustomersGeoplaceEntity entity = new RestaurantsCustomersGeoplaceEntity(); string[] fields = restaurantsParser.ReadFields(); double latitude; double longtitude; fields[1] = fields[1].Replace('.', ','); fields[2] = fields[2].Replace('.', ','); double.TryParse(fields[1], out latitude); double.TryParse(fields[2], out longtitude); entity.ID = fields[0]; entity.Latitutde = latitude; entity.Longtitude = longtitude; entity.The_geom_meter = fields[3]; entity.Name = fields[4]; entity.Address = fields[5]; entity.City = fields[6]; entity.State = fields[7]; entity.Country = fields[8]; //ToDo Change fax type to numeric one entity.Fax = fields[9]; entity.Zip = fields[10]; entity.ParseAlcoholString(fields[11]); Restaurants.Add(fields[0], entity); } restaurantsParser.Close(); #endregion #region Reading user profiles TextFieldParser userProfilesParser = new TextFieldParser(Properties.Settings.Default["userProfilePath"].ToString()); userProfilesParser.TextFieldType = FieldType.Delimited; userProfilesParser.SetDelimiters(","); userProfilesParser.ReadFields(); while (!userProfilesParser.EndOfData) { //Processing row try { RestaurantCustomersUserProfileEntity entity = new RestaurantCustomersUserProfileEntity(); string[] fields = userProfilesParser.ReadFields(); int weightInput; int birthYearInput; double heightInput; Int32.TryParse(fields[16], out weightInput); Int32.TryParse(fields[10], out birthYearInput); double.TryParse(fields[18].Replace('.',','), out heightInput); fields[5] = fields[5].Replace(' ', '_'); fields[5] = fields[5].Replace('-', '_'); fields[4] = fields[4].Replace(' ', '_'); fields[4] = fields[4].Replace('-', '_'); fields[6] = fields[6].Replace(' ', '_'); fields[6] = fields[6].Replace('-', '_'); fields[8] = fields[8].Replace(' ', '_'); fields[8] = fields[8].Replace('-', '_'); fields[7] = fields[7].Replace(' ', '_'); fields[7] = fields[7].Replace('-', '_'); fields[12] = fields[12].Replace(' ', '_'); fields[12] = fields[12].Replace('-', '_'); fields[11] = fields[11].Replace(' ', '_'); fields[11] = fields[11].Replace('-', '_'); fields[13] = fields[13].Replace(' ', '_'); fields[13] = fields[13].Replace('-', '_'); fields[14] = fields[14].Replace(' ', '_'); fields[14] = fields[14].Replace('-', '_'); entity.ID = fields[0]; entity.Name = string.Format("User {0}", fields[0]); entity.Weight = weightInput; entity.BirthYear = birthYearInput; entity.Height = heightInput; entity.Activity = fields[14] != "?" ? (activity)Enum.Parse(typeof(activity), fields[14]) : activity.missing; entity.Ambience = fields[6] != "?" ?(ambience)Enum.Parse(typeof(ambience), fields[6]): ambience.missing; entity.Budget = fields[17] != "?" ? (budget)Enum.Parse(typeof(budget), fields[17]): budget.missing; entity.Color = fields[15] != "?" ?(color)Enum.Parse(typeof(color), fields[15]): color.missing; entity.Dress_preference = fields[5] != "?" ? (dress_preference)Enum.Parse(typeof(dress_preference), fields[5]) : dress_preference.missing; entity.Drink_level = fields[4] != "?" ? (drink_level)Enum.Parse(typeof(drink_level), fields[4]) : drink_level.missing; entity.Hijos = fields[9] != "?" ? (hijos)Enum.Parse(typeof(hijos), fields[9]) : hijos.missing; entity.Interest = fields[11] != "?" ? (interest)Enum.Parse(typeof(interest), fields[11]) : interest.missing; entity.Marital_status = fields[8] != "?" ? (marital_status)Enum.Parse(typeof(marital_status), fields[8]) : marital_status.missing; entity.Personality = fields[12] != "?" ? (personality)Enum.Parse(typeof(personality), fields[12]): personality.missing; entity.Religion = fields[13] != "?" ? (religion)Enum.Parse(typeof(religion), fields[13]) : religion.missing; entity.Smoker = fields[4] == "false" ? false : true; // entity.Transport = (transport)Enum.Parse(typeof(transport), fields[7]); UserProfiles.Add(fields[0], entity); } catch (Exception ex) { throw ex; } } #endregion #region Reading ratings TextFieldParser ratingsParser = new TextFieldParser(Properties.Settings.Default["rating_finalPath"].ToString()); ratingsParser.TextFieldType = FieldType.Delimited; ratingsParser.SetDelimiters(","); ratingsParser.ReadFields(); while (!ratingsParser.EndOfData) { int rating; int food_rating; int service_rating; //Processing row RestaurantsAndCustomersRating_finalEntity entity = new RestaurantsAndCustomersRating_finalEntity(); string[] fields = ratingsParser.ReadFields(); entity.UserID = fields[0]; entity.PlaceID = fields[1]; entity.ID = fields[0] + fields[1]; Int32.TryParse(fields[2], out rating); entity.Rating = rating; Int32.TryParse(fields[3], out food_rating); entity.Food_Rating = food_rating; Int32.TryParse(fields[4], out service_rating); entity.Service_Rating = service_rating; Rating_finals.Add(entity.ID,entity); } #endregion } catch (Exception ex) { throw ex; } }
private void GenerateRatings() { Rating_finals = new Dictionary<string, RestaurantsAndCustomersRating_finalEntity>(); RestaurantsAndCustomersRating_finalEntity entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "10"; entity.PlaceID = "l1"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "10"; entity.PlaceID = "l3"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "10"; entity.PlaceID = "l4"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "20"; entity.PlaceID = "l2"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "20"; entity.PlaceID = "l3"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "20"; entity.PlaceID = "l5"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "30"; entity.PlaceID = "l1"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "30"; entity.PlaceID = "l2"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "30"; entity.PlaceID = "l3"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "30"; entity.PlaceID = "l5"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "40"; entity.PlaceID = "l2"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); entity = new RestaurantsAndCustomersRating_finalEntity(); entity.UserID = "40"; entity.PlaceID = "l5"; Rating_finals.Add(entity.UserID + entity.PlaceID, entity); }