public static void EnsurePopulated(IServiceProvider appServices)
{
TrabalhoDbContext context = (TrabalhoDbContext)appServices.GetService(typeof(TrabalhoDbContext));
if (!context.Turist.Any())
{
EnsureTuristPopulated(context);
}
context.SaveChanges();
if (!context.Questions.Any())
{
EnsureQuestionsPopulated(context);
}
context.SaveChanges();
if (!context.Difficulty.Any())
{
EnsureDifficultyPopulated(context);
}
context.SaveChanges();
if (!context.Answer.Any())
{
EnsureAnswerPopulated(context);
}
context.SaveChanges();
if (!context.Trails.Any())
{
EnsureTrailsPopulated(context);
}
context.SaveChanges();
context.SaveChanges();
if (!context.TuristAnswer.Any())
{
EnsureTuristAnswerPopulated(context);
}
context.SaveChanges();
}
private static void EnsureDifficultyPopulated(TrabalhoDbContext dbContext)
{
dbContext.Difficulty.AddRange(
new Difficulty {
DifficultyName = "Fácil"
},
new Difficulty {
DifficultyName = "Médio"
},
new Difficulty {
DifficultyName = "Dificil"
}
);
}
private static void EnsureTuristAnswerPopulated(TrabalhoDbContext dbContext)
{
dbContext.TuristAnswer.AddRange(
new TuristAnswer
{
TuristID = 1,
SurveyNumber = 1,
AnswerID = 2,
AnswerDate = DateTime.Parse("15-03-2013"),
TuristAnswerState = true
},
new TuristAnswer
{
TuristID = 1,
SurveyNumber = 1,
AnswerID = 5,
AnswerDate = DateTime.Parse("15-03-2013"),
TuristAnswerState = true
},
new TuristAnswer
{
TuristID = 1,
SurveyNumber = 1,
AnswerID = 7,
AnswerDate = DateTime.Parse("15-03-2013"),
TuristAnswerState = false
},
new TuristAnswer
{
TuristID = 1,
SurveyNumber = 1,
AnswerID = 10,
AnswerDate = DateTime.Parse("15-03-2013"),
TuristAnswerState = true
}
);
}
private static void EnsureAnswerPopulated(TrabalhoDbContext dbContext)
{
dbContext.Answer.AddRange(
new Answer {
PossibleAnswer = "150 - 169", QuestionsID = 1, DifficultyID = 1
},
new Answer {
PossibleAnswer = "170 - 179", QuestionsID = 1, DifficultyID = 2
},
new Answer {
PossibleAnswer = ">180", QuestionsID = 1, DifficultyID = 3
},
new Answer {
PossibleAnswer = "7 - 17", QuestionsID = 2, DifficultyID = 1
},
new Answer {
PossibleAnswer = "18 - 54", QuestionsID = 2, DifficultyID = 2
},
new Answer {
PossibleAnswer = ">55", QuestionsID = 2, DifficultyID = 3
},
new Answer {
PossibleAnswer = "50 - 79", QuestionsID = 3, DifficultyID = 1
},
new Answer {
PossibleAnswer = "80 - 99", QuestionsID = 3, DifficultyID = 2
},
new Answer {
PossibleAnswer = ">100", QuestionsID = 3, DifficultyID = 3
},
new Answer {
PossibleAnswer = "Não", QuestionsID = 4, DifficultyID = 1
},
new Answer {
PossibleAnswer = "Problemas Cardiológicos", QuestionsID = 4, DifficultyID = 2
},
new Answer {
PossibleAnswer = "Osteoporose", QuestionsID = 4, DifficultyID = 3
}
);
}
private static void EnsureQuestionsPopulated(TrabalhoDbContext dbContext)
{
dbContext.Questions.AddRange(
new Questions {
QuestionsToClient = "Qual é a sua altura?", QuestionsState = true
},
new Questions {
QuestionsToClient = "Qual é a sua idade?", QuestionsState = true
},
new Questions {
QuestionsToClient = "Qual é o seu peso?", QuestionsState = false
},
new Questions {
QuestionsToClient = "Tem algumas destas doenças?", QuestionsState = true
}
);
}
private static void EnsureTuristPopulated(TrabalhoDbContext dbContext)
{
dbContext.Turist.AddRange(
new Turist
{
TuristName = " João",
Phone = "963123456",
Genre = "Masculino",
Birthday = DateTime.Parse("01-09-1996"),
NIF = 313212454,
Email = "*****@*****.**",
EmergencyContact = "963123456",
TuristState = true,
TypeTurist = "Admin"
},
new Turist
{
TuristName = "Luis",
Phone = "963124356",
Genre = "Masculino",
Birthday = DateTime.Parse("01-09-1991"),
NIF = 313212431,
Email = "*****@*****.**",
EmergencyContact = "963124356",
TuristState = true,
TypeTurist = "Professor"
},
new Turist
{
TuristName = "André",
Phone = "963112156",
Genre = "Masculino",
Birthday = DateTime.Parse("01-09-1995"),
NIF = 313666431,
Email = "*****@*****.**",
EmergencyContact = "963112156",
TuristState = false,
TypeTurist = "Turista"
}
);
}
private static void EnsureTrailsPopulated(TrabalhoDbContext dbContext)
{
dbContext.Trails.AddRange(
new Trails
{
Description = "Um Percurso ao ar livre, pouco inclinado",
DifficultyID = 1,
Distance = 9,
InitialDate = DateTime.Parse("26-08-2011"),
TrailsName = "Percurso ao Ar Livre",
TrailsState = true,
FinalDate = DateTime.Parse("01-05-2012"),
TrailsStateDate = DateTime.Parse("25-08-2011")
},
new Trails
{
Description = "Um Percurso longo, alguma inclinação",
DifficultyID = 2,
Distance = 18,
InitialDate = DateTime.Parse("26-04-2012"),
TrailsName = "Percurso Longo ao Ar Livre",
TrailsState = true,
FinalDate = DateTime.Parse("15-01-2013"),
TrailsStateDate = DateTime.Parse("27-04-2012")
},
new Trails
{
Description = "Um Percurso longo, com passagens subterrâneas e cavernas",
DifficultyID = 3,
Distance = 21,
InitialDate = DateTime.Parse("11-06-2013"),
TrailsName = "Percurso Subterrâneo",
TrailsState = true,
FinalDate = DateTime.Parse("10-06-2014"),
TrailsStateDate = DateTime.Parse("12-06-2013")
}
);
}
public EFAnswerRepository(TrabalhoDbContext dbContext)
{
this.dbContext = dbContext;
}
public EFTuristRepository(TrabalhoDbContext dbContext)
{
this.dbContext = dbContext;
}
public EFQuestionsRepository(TrabalhoDbContext dbContext)
{
this.dbContext = dbContext;
}
public EFDifficultyRepository(TrabalhoDbContext dbContext)
{
this.dbContext = dbContext;
}
public EFTrailsRepository(TrabalhoDbContext dbContext)
{
this.dbContext = dbContext;
}