protected internal StudentsPage(IStudentsRepository StudentsRepository, ISchoolsRepository schoolsRepository) : base(StudentsRepository)
{
PageTitle = "Õpilased";
Schools = CreateSelectList <School, SchoolData>(schoolsRepository);
schools = schoolsRepository;
}
public Program()
{
var client = new MongoClient();
var db = "kulepool";
_districtsRepo = new DistrictsRepository(client, db);
_schoolsRepo = new SchoolsRepository(client, db);
_studentsRepo = new StudentsRepository(client, db);
}
//[Fact]
public void Test_RealDB_Test()
{
//real DB Test
string baseUrl = "http://presence.kingzad.local/";
string dbString = "Data Source=.;Initial Catalog=Presence_QA;User Id=sa;Password=P@ssw0rd";
mockDBConnectionService.Setup(p => p.GetConnection(baseUrl)).Returns(dbString);
var _databaseProvider = new DatabaseProvider();
_schoolRepository = new DBSchoolsRepository(_databaseProvider, mockDBConnectionService.Object);
var schools = _schoolRepository.GetSchools(baseUrl);
Assert.NotEmpty(schools);
}
dynamic GetDistrict(IDistrictsRepository districtsRepository, ISchoolsRepository schoolsRepository, dynamic parameters)
{
string idAsString = parameters.districtId;
Guid districtId;
if (!Guid.TryParse(idAsString, out districtId))
{
return(Response.AsJson(new { Error = $"Invalid district id '{idAsString}'" }, HttpStatusCode.BadRequest));
}
var command = new GetDistrictCommand(districtsRepository, schoolsRepository);
var vm = command.Execute(districtId);
return(View["schools", vm]);
}
public void Test_School_Reposity_Get_Schools()
{
string baseUrl = "http://presence.kingzad.local/";
string connectionString = "fake_connection_string";
//arrange
mockDBConnectionService.Setup(p => p.GetConnection(baseUrl)).Returns(connectionString);
IDatabaseProvider _databaseProvider = new DatabaseProvider();
//
List <School> schools = GetSampleSchools(5);
mockDatabaseProvider = new Mock <IDatabaseProvider>();
mockDatabaseProvider.Setup(p => p.GetCellValue <int>(connectionString, "SELECT TOP 1 server_id FROM click_server_urls WHERE url = @url", It.IsAny <object>(), CommandType.Text)).Returns(10);
mockDatabaseProvider.Setup(p => p.GetData <School>(connectionString, "[dbo].[cma_server_v2]", It.IsAny <object>(), CommandType.StoredProcedure)).Returns(schools);
mockDatabaseProvider.Setup(p => p.GetData <MAttribute>(connectionString, "[dbo].[cma_server_attributes.get]", It.IsAny <object>(), CommandType.StoredProcedure)).Returns(GetSampleAttributes());
_schoolRepository = new DBSchoolsRepository(mockDatabaseProvider.Object, mockDBConnectionService.Object);
var resultSchools = _schoolRepository.GetSchools(baseUrl);
//Assert
Assert.Equal(4, resultSchools.Count());
}
public void Test_School_Reposity_Url_Not_Exist_No_Schools_Return()
{
//arrange
string baseUrl = "http://presence.kingzad.local/";
//string connectionString = "fake_connection_string";
mockDBConnectionService.Setup(p => p.GetConnection(baseUrl)).Returns("");
IDatabaseProvider _databaseProvider = new DatabaseProvider();
//
List <School> schools = GetSampleSchools(0);
mockDatabaseProvider = new Mock <IDatabaseProvider>();
mockDatabaseProvider.Setup(p => p.GetCellValue <int>("", "SELECT TOP 1 server_id FROM click_server_urls WHERE url = @url", new { url = baseUrl }, CommandType.Text)).Returns(10);
mockDatabaseProvider.Setup(p => p.GetData <School>("", "[dbo].[cma_server_v2]", new { district_server_id = 10 }, CommandType.StoredProcedure)).Returns(schools);
_schoolRepository = new DBSchoolsRepository(mockDatabaseProvider.Object, mockDBConnectionService.Object);
var resultSchools = _schoolRepository.GetSchools(baseUrl);
//Assert
Assert.Null(resultSchools);
}
public EditModel(ISchoolsRepository SchoolsRepository, IStudentsRepository studentsRepository) : base(SchoolsRepository, studentsRepository)
{
}
public SchoolsDomainService(ISchoolsRepository schoolsRepository)
{
this.schoolsRepository = schoolsRepository;
}
public SchoolsService(ICacheProvider cacheProvider, IOptions <CMAOptions> options, ISchoolsRepository schoolsRepository)
{
_cacheProvider = cacheProvider;
_options = options;
_schoolsRepository = schoolsRepository;
}
public SchoolsService(ISchoolsRepository schoolsRepository)
{
_schoolsRepository = schoolsRepository;
}
public CreateModel(ISchoolsRepository SchoolsRepository, IStudentsRepository studentsRepository) : base(SchoolsRepository, studentsRepository)
{
}
public IndexModel(IStudentsRepository StudentsRepository, ISchoolsRepository schoolsRepository) : base(StudentsRepository, schoolsRepository)
{
}
public QuestionaryController(ISchoolsRepository repository, ILogger <QuestionaryController> logger)
{
_repository = repository;
_logger = logger;
}
public ExamController(ISchoolsRepository repository, ILogger <CityController> logger)
{
_repository = repository;
_logger = logger;
}
public GetDistrictCommand(IDistrictsRepository districtsRepository, ISchoolsRepository schoolsRepository)
{
this.districtsRepository = districtsRepository;
this.schoolsRepository = schoolsRepository;
}
public SchoolsController(ISchoolsRepository repository, ILogger <SchoolsController> logger)
{
_repository = repository;
_logger = logger;
}
public DetailsModel(IStudentsRepository StudentsRepository, ISchoolsRepository schoolsRepository) : base(StudentsRepository, schoolsRepository)
{
}
public SchoolsController(ISchoolsRepository schoolsRepository)
{
_schoolsRepository = schoolsRepository;
}
