private void ClearData()
{
using (CatchmeContext context = new CatchmeContext())
{
context.Age.Clear();
context.BodyType.Clear();
context.Children.Clear();
context.Diet.Clear();
context.Drinks.Clear();
context.Drugs.Clear();
context.Education.Clear();
context.Ethnicity.Clear();
context.EyeColor.Clear();
context.Gender.Clear();
context.HairColor.Clear();
context.Height.Clear();
context.Languages.Clear();
context.LookingFor.Clear();
context.MaritalStatus.Clear();
context.Pets.Clear();
context.Religion.Clear();
context.Smokes.Clear();
context.Weight.Clear();
context.SaveChanges();
}
}
public ChatHub(CatchmeContext context, catchmebgContext bgContext)
{
_context = context;
_bgContext = bgContext;
AllUsers = _bgContext.Users.Select(u => new UserDetail()
{
ConnectionId = "", UserName = u.UserName
}).ToList();
}
private void SeedEducation(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var education = new Education();
education.Name = item;
education.ItemId = i;
context.Education.Add(education);
i++;
}
context.SaveChanges();
}
}
private void SeedDrugs(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var drugs = new Drugs();
drugs.Name = item;
drugs.ItemId = i;
context.Drugs.Add(drugs);
i++;
}
context.SaveChanges();
}
}
private void SeedDiet(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var diet = new Diet();
diet.Name = item;
diet.ItemId = i;
context.Diet.Add(diet);
i++;
}
context.SaveChanges();
}
}
private void SeedChildren(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var children = new Children();
children.Name = item;
children.ItemId = i;
context.Children.Add(children);
i++;
}
context.SaveChanges();
}
}
private void SeedBodyType(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var bodyType = new BodyType();
bodyType.Name = item;
bodyType.ItemId = i;
context.BodyType.Add(bodyType);
i++;
}
context.SaveChanges();
}
}
private void SeedAge(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var age = new Age();
age.Name = item;
age.ItemId = i;
context.Age.Add(age);
i++;
}
context.SaveChanges();
}
}
private void SeedEthnicity(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var ethnicity = new Ethnicity();
ethnicity.Name = item;
ethnicity.ItemId = i;
context.Ethnicity.Add(ethnicity);
i++;
}
context.SaveChanges();
}
}
private void SeedGender(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var gender = new Gender();
gender.Name = item;
gender.ItemId = i;
context.Gender.Add(gender);
i++;
}
context.SaveChanges();
}
}
private void SeedSmokes(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var smokes = new Smokes();
smokes.Name = item;
smokes.ItemId = i;
context.Smokes.Add(smokes);
i++;
}
context.SaveChanges();
}
}
private void SeedWeight(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var weight = new Weight();
weight.Name = item;
weight.ItemId = i;
context.Weight.Add(weight);
i++;
}
context.SaveChanges();
}
}
private void SeedPets(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var pets = new Pets();
pets.Name = item;
pets.ItemId = i;
context.Pets.Add(pets);
i++;
}
context.SaveChanges();
}
}
private void SeedReligion(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var religion = new Religion();
religion.Name = item;
religion.ItemId = i;
context.Religion.Add(religion);
i++;
}
context.SaveChanges();
}
}
private void SeedMaritalStatus(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var maritalStatus = new MaritalStatus();
maritalStatus.Name = item;
maritalStatus.ItemId = i;
context.MaritalStatus.Add(maritalStatus);
i++;
}
context.SaveChanges();
}
}
private void SeedLookingFor(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var lookingFor = new LookingFor();
lookingFor.Name = item;
lookingFor.ItemId = i;
context.LookingFor.Add(lookingFor);
i++;
}
context.SaveChanges();
}
}
private void SeedLanguages(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var languages = new Languages();
languages.Name = item;
languages.ItemId = i;
context.Languages.Add(languages);
i++;
}
context.SaveChanges();
}
}
private void SeedHairColor(List <string> list)
{
using (CatchmeContext context = new CatchmeContext())
{
var i = 0;
foreach (var item in list)
{
var hairColor = new HairColor();
hairColor.Name = item;
hairColor.ItemId = i;
context.HairColor.Add(hairColor);
i++;
}
context.SaveChanges();
}
}
private string SeedMbtiTable()
{
var engine = new FileHelperEngine <Question>();
var contentRoot = _env.ContentRootPath;
var filePath = System.IO.Path.Combine(contentRoot, "SeedData/MbtiTest.csv");
// To Read Use:
var result = engine.ReadFile(filePath);
// result is now an array of MbtiTest
using (CatchmeContext context = new CatchmeContext())
{
var firstQuestion = context.Questions.FirstOrDefault(u => u.Id == 1 && u.Language == "en");
var lastQuestion = context.Questions.FirstOrDefault(u => u.Id == 140 && u.Language == "bg");
if (firstQuestion != null && lastQuestion != null)
{
return("Db seeded already!");
}
else
{
foreach (Question question in result)
{
var dbQuestion = new Question()
{
QuestionID = question.QuestionID,
QuestionText = question.QuestionText,
AnswerText1 = question.AnswerText1,
AnswerText2 = question.AnswerText2,
Language = question.Language
};
context.Questions.Add(dbQuestion);
//context.DetachLocal(dbQuestion, dbQuestion.ID.ToString());
}
context.SaveChanges();
return("Db has been seeded!");
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, catchmebgContext db1, CatchmeContext db2)
{
// run the migrations before other code
db1.Database.Migrate();
db2.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseAuthentication();
app.UseFileServer();
app.UseWebSockets();
app.UseSignalR(routes =>
{
routes.MapHub <ChatHub>("/hubs/chat");
});
//app.UseMvc(routes =>
//{
// routes.MapRoute(
// name: "default",
// template: "{controller=Home}/{action=Index}/{id?}");
//});
app.UseMvc(routes =>
{
routes.MapRoute(
name: "areas",
template: "{area:exists}/{controller=Home}/{action=Index}/{id?}");
routes.MapAreaRoute(
name: "default",
areaName: "Main",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
