public static List <Term> loadTermsFromThisSchool(SqlConnection connection, School school)
{
List <Term> returnMe = new List <Term>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "SELECT * FROM Term WHERE iSchoolID=" + school.getSchoolLogicID() + "";
sqlCommand.Connection.Open();
SqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
returnMe.Add(new Term(
int.Parse(dataReader["iTermID"].ToString().Trim()),
int.Parse(dataReader["iTrackID"].ToString().Trim()),
DateTime.Parse(dataReader["dStartDate"].ToString()),
DateTime.Parse(dataReader["dEndDate"].ToString()),
dataReader["cName"].ToString().Trim(),
int.Parse(dataReader["iSchoolID"].ToString().Trim())
));
}
}
sqlCommand.Connection.Close();
return(returnMe);
}
public static List <ReportPeriod> loadReportPeriodsFromThisSchool(SqlConnection connection, School school)
{
List <ReportPeriod> returnMe = new List <ReportPeriod>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "SELECT * FROM ReportPeriod WHERE iSchoolID=" + school.getSchoolLogicID() + "";
sqlCommand.Connection.Open();
SqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
returnMe.Add(new ReportPeriod(
int.Parse(dataReader["iReportPeriodID"].ToString().Trim()),
dataReader["cName"].ToString().Trim(),
DateTime.Parse(dataReader["dStartDate"].ToString()),
DateTime.Parse(dataReader["dEndDate"].ToString()),
int.Parse(dataReader["iSchoolID"].ToString().Trim()),
int.Parse(dataReader["iTermID"].ToString().Trim())
));
}
}
sqlCommand.Connection.Close();
foreach (ReportPeriod rp in returnMe)
{
rp.loadReportPeriodSettings(connection);
}
return(returnMe);
}
public static List <Track> loadAllTracksFromThisSchool(SqlConnection connection, School thisSchool)
{
List <Track> returnMe = new List <Track>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "SELECT * FROM Track WHERE iSchoolID=@SCHOOL ORDER BY iSchoolID ASC, cName ASC;";
sqlCommand.Parameters.AddWithValue("@SCHOOL", thisSchool.getSchoolLogicID());
sqlCommand.Connection.Open();
SqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Track newTrack = new Track(
int.Parse(dataReader["iTrackID"].ToString().Trim()),
dataReader["cName"].ToString().Trim(),
DateTime.Parse(dataReader["dStartDate"].ToString()),
DateTime.Parse(dataReader["dEndDate"].ToString()),
int.Parse(dataReader["iSchoolID"].ToString().Trim()),
bool.Parse(dataReader["lDaily"].ToString().Trim()),
dataReader["cCode"].ToString().Trim(),
int.Parse(dataReader["iDaysInCycle"].ToString().Trim()),
int.Parse(dataReader["iBlocksPerDay"].ToString().Trim()),
int.Parse(dataReader["iDailyBlocksPerDay"].ToString().Trim())
);
newTrack.school = thisSchool;
returnMe.Add(newTrack);
}
}
sqlCommand.Connection.Close();
return(returnMe);
}