private static void SeedUsers(PitalicaDbContext _pitalicaDbContext)
{
var users = new List <Users>();
for (int i = 1; i < 6; i++)
{
var user1 = new Users
{
SchoolId = i,
UserName = "******" + i,
Password = "******",
StringUserId = "User" + i,
};
var user2 = new Users
{
SchoolId = i,
UserName = "******" + i,
Password = "******",
StringUserId = "Osoba" + i,
};
users.Add(user1);
users.Add(user2);
}
_pitalicaDbContext.Users.AddRange(users);
_pitalicaDbContext.SaveChanges();
}
public async void PostSchools()
{
using (var context = new PitalicaDbContext(_dbContextOptions))
{
var schoolsAPI = new SchoolsController(context);
for (int i = 0; i < 10; ++i)
{
Schools tmpSchool = new Schools
{
Name = $"Skola { i + 1 }",
Address = new Addresses
{
CityName = "Zagreb",
Country = "Hrvatska",
StreetName = $"Ulica{ i }"
}
};
var result = await schoolsAPI.PostSchools(tmpSchool);
var badRequest = result as BadRequestObjectResult;
Assert.Null(badRequest); // Ako API ne vraca BadRequest, to znaci da je poziv uspjesan
}
}
}
public static void SeedInitial(this PitalicaDbContext _pitalicaDbContext)
{
if (!_pitalicaDbContext.ExamResults.Any())
{
//SeedSchools(_pitalicaDbContext);
//SeedUsers(_pitalicaDbContext);
//SeedExams(_pitalicaDbContext);
//SeedQuestions(_pitalicaDbContext);
SeedExamResults(_pitalicaDbContext);
}
}
public async void DeleteSchools()
{
// Dodavanje skola prije dohvacanja
using (var context = new PitalicaDbContext(_dbContextOptions))
{
var schoolsAPI = new SchoolsController(context);
for (int i = 0; i < 10; ++i)
{
Schools tmpSchool = new Schools
{
Name = $"Skola { i + 1 }",
Address = new Addresses
{
CityName = "Zagreb",
Country = "Hrvatska",
StreetName = $"Ulica{ i }"
}
};
schoolsAPI.PostSchools(tmpSchool).Wait();
}
}
using (var context = new PitalicaDbContext(_dbContextOptions))
{
var schoolsAPI = new SchoolsController(context);
var result = await schoolsAPI.DeleteSchools(2);
var okResult = result as OkObjectResult;
// Status kod je 200, tada je poziv uspjesan
Assert.Equal(200, okResult.StatusCode);
// Ako mu ne vrati ok result (jer ne postoji objekt), onda je test uspjesan
var result2 = await schoolsAPI.GetSchools(2);
var okResult2 = result2 as OkObjectResult;
Assert.Null(okResult2);
}
}
private static void SeedQuestions(PitalicaDbContext _pitalicaDbContext)
{
var questions = new List <Questions>();
for (int i = 1; i < 16; i++)
{
var question1 = new Questions
{
Definition = "PrvoPitanje",
Answer = "Ogovor" + i,
ExamId = i,
Score = i,
Visibility = true
};
var question2 = new Questions
{
Definition = "DrugoPitanje",
Answer = "Ogovor" + i,
ExamId = i,
Score = i,
Visibility = true
};
var question3 = new Questions
{
Definition = "TrećePitanje",
Answer = "Ogovor" + i,
ExamId = i,
Score = i,
Visibility = true
};
questions.Add(question1);
questions.Add(question2);
questions.Add(question3);
}
_pitalicaDbContext.Questions.AddRange(questions);
_pitalicaDbContext.SaveChanges();
}
public async void GetSchools()
{
// Dodavanje skola prije dohvacanja
using (var context = new PitalicaDbContext(_dbContextOptions))
{
var schoolsAPI = new SchoolsController(context);
for (int i = 0; i < 10; ++i)
{
Schools tmpSchool = new Schools
{
Name = $"Skola { i + 1 }",
Address = new Addresses
{
CityName = "Zagreb",
Country = "Hrvatska",
StreetName = $"Ulica{ i }"
}
};
schoolsAPI.PostSchools(tmpSchool).Wait();
}
}
using (var context = new PitalicaDbContext(_dbContextOptions))
{
var schoolsAPI = new SchoolsController(context);
var result = await schoolsAPI.GetSchools(2);
var okResult = result as OkObjectResult;
// Ako je rezultat Ok i status kod je 200, tada je poziv uspjesan
Assert.NotNull(okResult);
Assert.Equal(200, okResult.StatusCode);
// Ako je dohvacena skola sa ispravnim imenom, poziv je uspjesan
Schools school = okResult.Value as Schools;
Assert.NotNull(school);
Assert.Equal("Skola 2", school.Name);
}
}
private static void SeedExams(PitalicaDbContext _pitalicaDbContext)
{
var exams = new List <Exams>();
for (int i = 1; i < 6; i++)
{
var exam1 = new Exams
{
ExamName = "Exam" + i,
MaxScore = i * 2,
Password = "******",
UserId = i,
};
var exam2 = new Exams
{
ExamName = "Test" + i,
MaxScore = i * 2,
Password = "******",
UserId = i,
};
var exam3 = new Exams
{
ExamName = "Ispit" + i,
MaxScore = i * 2,
Password = "******",
UserId = i,
};
exams.Add(exam1);
exams.Add(exam2);
exams.Add(exam3);
}
_pitalicaDbContext.Exams.AddRange(exams);
_pitalicaDbContext.SaveChanges();
}
private static void SeedExamResults(PitalicaDbContext _pitalicaDbContext)
{
var examResults = new List <ExamResults>();
/*for (int i = 0; i < 4; i++)
* {*/
var examResults1 = new ExamResults
{
ExamId = 1,
UserId = 2 + 1,
Score = "10"
};
/*
* var examResults2 = new ExamResults
* {
* ExamId = i,
* UserId = i + 2,
* Score = "20"
*
* };
*
* var examResults3 = new ExamResults
* {
* ExamId = i,
* UserId = i + 3,
* Score = "30"
*
* };*/
examResults.Add(examResults1);
//examResults.Add(examResults2);
//examResults.Add(examResults3);
//}
_pitalicaDbContext.ExamResults.AddRange(examResults);
_pitalicaDbContext.SaveChanges();
}
private static void SeedSchools(PitalicaDbContext _pitalicaDbContext)
{
var schools = new List <Schools>();
for (int i = 1; i < 6; i++)
{
var school = new Schools
{
Name = "Škola" + i,
Address = new Addresses
{
CityName = "Zagreb",
Country = "Hrvatska",
StreetName = "Našička" + i + i
},
};
schools.Add(school);
}
_pitalicaDbContext.Schools.AddRange(schools);
_pitalicaDbContext.SaveChanges();
}
public AddressesController(PitalicaDbContext context)
{
_context = context;
}
public ExamsController(PitalicaDbContext context, UserManager <ApplicationUser> userManager)
{
_userManager = userManager;
_context = context;
}
public UsersController(PitalicaDbContext context)
{
_context = context;
}
public SchoolsController(PitalicaDbContext context)
{
_context = context;
}
public QuestionsController(PitalicaDbContext context)
{
_context = context;
}
public ExamResultsController(PitalicaDbContext context)
{
_context = context;
}
public TokenControllerV1_1(PitalicaDbContext context, IConfiguration configuration)
{
_context = context;
Configuration = configuration;
}
