private static void CreateGenres(onea db, GraphClient client, List <UserProfile> businesses)
{
var businessIds = businesses.Select(y => y.UserId);
var categoryBusinessXrefs = db.BusinessUserRestaurantCategoryXRefs.Where(x => businessIds.Contains(x.BusinessUser.UserId)).ToList();
var categoriesDistinct = categoryBusinessXrefs.Select(x => x.RestaurantCategory).Distinct();
foreach (var cd in categoriesDistinct)
{
client.Cypher
.Create("(n:genre {genre})")
.WithParam("genre", new { name = cd.Name.ToLower() })
.ExecuteWithoutResults();
}
foreach (var categoryBusiness in categoryBusinessXrefs)
{
var businessName = db.UserProfiles.Find(categoryBusiness.BusinessUser.UserId).Name;
try
{
client.Cypher
.Match(string.Concat("(b:business {name:\"", businessName.Replace("'", "\'").Replace("\"", "\""), "\"})"))
.Match(string.Concat("(g:genre {name:\"", categoryBusiness.RestaurantCategory.Name.ToLower(), "\"})"))
.Merge("(b)-[r:HAS_GENRE]->(g)")
.ExecuteWithoutResults();
}
catch (Exception e) { }
}
}
private static List <UserProfile> GetBusinesses(onea db)
{
var confirmedBusinesses = new List <UserProfile>();
var possibleBusinesses = db.UserProfiles.ToList();
using (var conn = new SqlConnection("Server=RT-PC\\SQL2012;Database=PourtraitBeta;Trusted_Connection=True;"))
{
conn.Open();
foreach (var business in possibleBusinesses)
{
using (var cmd = new SqlCommand("IsUseraBusiness", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@userId", SqlDbType.Int).Value = business.UserId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var x = reader[0];
if (x != null)
{
confirmedBusinesses.Add(business);
}
}
reader.Close();
}
}
}
return(confirmedBusinesses);
}
static void Main(string[] args)
{
using (var db = new onea {
})
{
var client = new GraphClient(new Uri("http://localhost:7474/db/data"));
client.Connect();
var businesses = GetBusinesses(db);
CreateBusinessNodes(db, client, businesses);
CreateDaysOfWeekNodes(client);
RelateBusinessesWithDaysAndSepcials(db, client, businesses);
CreateGenres(db, client, businesses);
}
}
private static void CreateBusinessNodes(onea db, GraphClient client, List <UserProfile> businesses)
{
foreach (var business in businesses)
{
client.Cypher
.Create("(n:business {biz})")
.WithParam("biz", new {
name = business.Name.Replace("\"", ""),
longitude = business.Longitude != null ? business.Longitude : 0,
latitude = business.Latitude != null ? business.Latitude : 0,
postal = business.PostalCode != null ? business.PostalCode : "",
address = business.Address != null ? business.Address : "",
about = business.About != null ? business.About : "",
city = business.City != null ? business.City.Name : "",
state = business.State != null ? business.State.Name: "",
image = business.PreviewImagePath != null ? business.PreviewImagePath : ""
})
.ExecuteWithoutResults();
}
}
private static void RelateBusinessesWithDaysAndSepcials(onea db, GraphClient client, List <UserProfile> businesses)
{
var foodSpecials = db.BusinessFoodSpecials.ToList();
var drinkSpecials = db.BusinessDrinkSpecials.ToList();
var dayFoodSpecials = Helper.InitializeDayFoodSpecials();
var dayDrinkSpecials = Helper.InitializeDayDrinkSpecials();
foreach (var fs in foodSpecials)
{
dayFoodSpecials[fs.DayOfWeek].Add(fs);
}
foreach (var ds in drinkSpecials)
{
dayDrinkSpecials[ds.DayOfWeek].Add(ds);
}
foreach (var key in dayFoodSpecials.Keys)
{
foreach (var fs in dayFoodSpecials[key])
{
var businessId = db.BusinessFoodItemCategories.Find(fs.BusinessFoodItem.BusinessFoodItemCategoryId).FoodMenu.UserId;
var businessName = db.UserProfiles.Find(businessId).Name;
client.Cypher
.Match("(d:day {day:'" + key.ToLower() + "'})")
.Match(string.Concat("(p:business {name:\"", businessName.Replace("'", "\'"), "\"})"))
.Merge("(d)-[r:HAS_FOOD_SPECIAL]->(p)")
.ExecuteWithoutResults();
client.Cypher
.Create("(n:food {food})")
.WithParam("food", new {
name = fs.BusinessFoodItem.Name,
imageUrl = S3Put(fs.BusinessFoodItem.ImageUrl, fs.BusinessFoodItem.Name)
})
.ExecuteWithoutResults();
client.Cypher
.Match(string.Concat("(p:business{name:\"", businessName.Replace("'", "\'"), "\"})"))
.Match(string.Concat("(f:food {name:\"", fs.BusinessFoodItem.Name, "\"})"))
.Merge(string.Concat("(p)-[r:FOOD_SPECIAL {price:\"", fs.Price, "\", start:\"", fs.StartTime, "\", end:\"", fs.EndTime, "\", dayOfWeek:\"", fs.DayOfWeek.ToLower(), "\"}]->(f)"))
.ExecuteWithoutResults();
}
}
foreach (var key in dayDrinkSpecials.Keys)
{
foreach (var ds in dayDrinkSpecials[key])
{
var businessId = db.BarMenuBeverageInstances.Find(ds.BarMenuBeverageInstanceId).BusinessUserBeverageXRef.BusinessUserId;
var businessName = db.UserProfiles.Find(businessId).Name;
var beverage = db.Beverages.Find(ds.BarMenuBeverageInstance.BusinessUserBeverageXRef.BeverageId);
client.Cypher
.Match("(d:day {day:'" + key.ToLower() + "'})")
.Match(string.Concat("(p:business {name:\"", businessName.Replace("'", "\'"), "\"})"))
.Merge("(d)-[r:HAS_DRINK_SPECIAL]->(p)")
.ExecuteWithoutResults();
client.Cypher
.Create("(n:drink {drink})")
.WithParam("drink", new {
name = beverage.Name,
imageUrl = S3Put(beverage.ImageUrl, beverage.Name)
})
.ExecuteWithoutResults();
client.Cypher
.Match(string.Concat("(p:business{name:\"", businessName.Replace("'", "\'"), "\"})"))
.Match(string.Concat("(f:drink {name:\"", beverage.Name, "\"})"))
.Merge(string.Concat("(p)-[r:DRINK_SPECIAL {price:\"", ds.Price, "\", start:\"", ds.StartTime, "\", end:\"", ds.EndTime, "\", dayOfWeek:\"", ds.DayOfWeek.ToLower(), "\"}]->(f)"))
.ExecuteWithoutResults();
}
}
}