public string Execute(string instanceName, ApiMode apiMode, int localEducationAgencyId)
{
using (var sqlConnection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
return(sqlConnection.Query <string>(Query, new { LEAid = localEducationAgencyId }).Single());
}
}
public IReadOnlyList <SchoolYearType> Execute(string instanceName, ApiMode apiMode)
{
using (var connection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
return(connection.Query <SchoolYearType>(
@"SELECT SchoolYear, SchoolYearDescription, CurrentSchoolYear
FROM edfi.SchoolYearType
ORDER BY SchoolYear").ToList());
}
}
public StudentRaceReport Execute(string instanceName, ApiMode apiMode, int localEducationAgencyId)
{
using (var sqlConnection = _connectionProvider.CreateNewConnection(instanceName, apiMode))
{
var studentDemographicData = sqlConnection.Query <StudentDemographicData>(Query, new { LEAid = localEducationAgencyId }).ToList();
var localEducationAgencyName = new GetLocalEducationAgencyByIdQuery(_connectionProvider).Execute(instanceName, apiMode, localEducationAgencyId);
return(new StudentRaceReport(studentDemographicData, localEducationAgencyName, localEducationAgencyId));
}
}
public bool IsValidDatabase(int odsInstanceNumericSuffix, ApiMode mode)
{
try
{
using (var odsInstanceConnection = _connectionProvider.CreateNewConnection(odsInstanceNumericSuffix, mode))
{
odsInstanceConnection.Open();
return(true);
}
}
catch
{
return(false);
}
}
public TotalEnrollmentReport Execute(string instanceName, ApiMode apiMode, int localEducationAgencyId)
{
using (var sqlConnection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
var enrollmentCount = sqlConnection.QueryFirstOrDefault <int>(EnrollmentsCountQuery, new { LEAId = localEducationAgencyId });
var localEducationAgencyName = new GetLocalEducationAgencyByIdQuery(_databaseConnectionProvider).Execute(instanceName, apiMode, localEducationAgencyId);
return(new TotalEnrollmentReport
{
EnrollmentCount = enrollmentCount,
LocalEducationAgencyName = localEducationAgencyName,
LocalEducationAgencyId = localEducationAgencyId
});
}
}
public SchoolTypeReport Execute(string instanceName, ApiMode apiMode, int localEducationAgencyId)
{
using (var sqlConnection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
var schoolCounts = sqlConnection.Query <SchoolCount>(SchoolsCountQuery, new { LEAId = localEducationAgencyId }).ToList();
var localEducationAgencyName = new GetLocalEducationAgencyByIdQuery(_databaseConnectionProvider).Execute(instanceName, apiMode, localEducationAgencyId);
return(new SchoolTypeReport
{
SchoolCounts = schoolCounts,
LocalEducationAgencyName = localEducationAgencyName,
LocalEducationAgencyId = localEducationAgencyId
});
}
}
public SchoolYearType Execute(string instanceName, ApiMode apiMode)
{
using (var connection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
var current = connection.Query <SchoolYearType>(
@"SELECT SchoolYear, SchoolYearDescription, CurrentSchoolYear
FROM edfi.SchoolYearType
WHERE CurrentSchoolYear = @CurrentSchoolYear", new { CurrentSchoolYear = true }).ToList();
if (current.Count != 1)
{
return(null);
}
return(current.Single());
}
}
public void Execute(string instanceName, ApiMode apiMode, short schoolYear)
{
using (var connection = _databaseConnectionProvider.CreateNewConnection(instanceName, apiMode))
{
// Take special care that any modifications to the SQL here fall
// within the common subset of SQL Server and Postgres syntax.
var rowsAffected = connection.Execute(
@"UPDATE edfi.SchoolYearType
SET CurrentSchoolYear = 'true'
WHERE SchoolYear = @schoolYear", new { schoolYear });
if (rowsAffected == 0)
{
throw new Exception($"School year {schoolYear} does not exist.");
}
connection.Execute(
@"UPDATE edfi.SchoolYearType
SET CurrentSchoolYear = 'false'
WHERE SchoolYear <> @schoolYear", new { schoolYear });
}
}
private string InferInstanceDatabaseName(int?newInstanceNumericSuffix, ApiMode mode)
{
using (var connection = _databaseConnectionProvider.CreateNewConnection(newInstanceNumericSuffix.Value, mode))
return(connection.Database);
}
public string DatabaseName(int odsInstanceNumericSuffix, ApiMode mode)
{
using var connection = _connectionProvider.CreateNewConnection(odsInstanceNumericSuffix, mode);
return(connection.Database);
}