public static List <YogaClass> LoadAllClasses()
{//method used to load clases from data base in lists
List <YogaClass> classes = new List <YogaClass>();
List <YogaNames> teachers = ListTeachers();
OleDbConnection myConnection = GetConnection();
string myQuery = "SELECT * FROM YogaClass WHERE NOW() <= ClassStartingTime ORDER BY ClassStartingTime";
OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection);
try
{
myConnection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
YogaNames currentTeacher = FindTeacher(teachers, int.Parse(myReader["StaffID"].ToString()));
YogaClass c = new YogaClass((int.Parse(myReader["ClassID"].ToString())), DateTime.Parse(myReader["ClassStartingTime"].ToString()), myReader["ClassName"].ToString(), currentTeacher, (int.Parse(myReader["ClassLevel"].ToString())), (myReader["ClassDuration"].ToString()), myReader["ClassDescription"].ToString(), (int.Parse(myReader["ClassPlacesAvailable"].ToString())));
classes.Add(c);
}
return(classes);
}
catch (Exception ex)
{
Console.WriteLine("Exception in DBHandler", ex);
return(null);
}
finally
{
myConnection.Close();
}
}
public static List <YogaClass> LoadBookedClasses(string username, int wStatus)
{//method used to load booked clases from data base in lists
List <YogaClass> classes = new List <YogaClass>();
List <YogaNames> teachers = ListTeachers();
OleDbConnection myConnection = GetConnection();
string myQuery = "SELECT * FROM YogaClass LEFT JOIN YogaClassReservation ON YogaClass.ClassID=YogaClassReservation.YogaClassID WHERE CClientUsername = '******' AND ClassWaitinglistStatus =" + wStatus + ";";
OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection);
try
{
myConnection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
YogaNames currentTeacher = FindTeacher(teachers, int.Parse(myReader["StaffID"].ToString()));
YogaClass c = new YogaClass((int.Parse(myReader["ClassID"].ToString())), DateTime.Parse(myReader["ClassStartingTime"].ToString()), myReader["ClassName"].ToString(), currentTeacher, (int.Parse(myReader["ClassLevel"].ToString())), (myReader["ClassDuration"].ToString()), myReader["ClassDescription"].ToString(), (int.Parse(myReader["ClassPlacesAvailable"].ToString())));
classes.Add(c);
}
return(classes);
}
catch (Exception ex)
{
Console.WriteLine("Exception in DBHandler", ex);
return(null);
}
finally
{
myConnection.Close();
}
}
