public List<GymClass> getClasses()
{
List<GymClass> gymClass = new List<GymClass>();
string query = "Select * FROM activity ;";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
String gymClass_name = (String)dataReader["activity_name"];
int gymClass_capaity = (int)dataReader["capacity"];
int gymClass_listed = (int)dataReader["listed"];
String timeHour = (String)dataReader["timeHour"];
String timeDay = (String)dataReader["timeDay"];
String classRoom = (String)dataReader["room_number"];
Instructor classInstructor = null;
GymClass gc = new GymClass(timeHour, timeDay, gymClass_name, classRoom, gymClass_capaity, gymClass_listed, classInstructor);
gc.setDBid((int)dataReader["ID"]);
gymClass.Add(gc);
}
dataReader.Close();
foreach (GymClass cls in gymClass)
{
cls.setClassInstructor((Instructor)this.getGymClassInstructorByClassId(cls.getDBid()));
}
return gymClass;
}
public List<GymClass> getClassesByInstructor(Instructor ins) {
List<GymClass> gymClass = new List<GymClass>();
string query = "Select * FROM activity INNER JOIN instactor_activity ON activity.id = instactor_activity.activity_id WHERE instactor_activity.activityTrainer_id ='" + ins.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
String gymClass_name = (String)dataReader["activity_name"];
int gymClass_capaity = (int)dataReader["capacity"];
int gymClass_listed = (int)dataReader["listed"];
String timeHour = (String)dataReader["timeHour"];
String timeDay = (String)dataReader["timeDay"];
String classRoom = (String)dataReader["room_number"];
Instructor classInstructor = ins;
GymClass gc = new GymClass(timeHour, timeDay, gymClass_name, classRoom, gymClass_capaity, gymClass_listed, classInstructor);
gc.setDBid((int)dataReader["ID"]);
gymClass.Add(gc);
}
dataReader.Close();
foreach (GymClass cls in gymClass)
{
cls.setListCustomerListed(getListedCustomerByClassID(cls.getDBid()));
}
return gymClass;
}
/// <summary>
/// find the gym class that match the customer
/// </summary>
/// <param name="customerDbId"></param>
/// <returns>list of customer gym classes</returns>
public List<GymClass> getCustomerGymClassByDbId(int customerDbId) {
List<GymClass> gymclass = new List<GymClass>();
string queryGYmClass = "Select * FROM activity INNER JOIN client_activity ON activity.id = client_activity.activity_id WHERE client_activity.client_id ='" + customerDbId + "';";
MySqlCommand cmdGymClass = new MySqlCommand(queryGYmClass, this.connection);
MySqlDataReader dataReader = cmdGymClass.ExecuteReader();
while (dataReader.Read())
{
String gymClass_name = (String)dataReader["activity_name"];
int gymClass_capaity = (int)dataReader["capacity"];
int gymClass_listed = (int)dataReader["listed"];
String timeHour = (String)dataReader["timeHour"];
String timeDay = (String)dataReader["timeDay"];
String classRoom = (String)dataReader["room_number"];
Instructor classInstructor = null;
GymClass gc = new GymClass(timeHour, timeDay, gymClass_name, classRoom, gymClass_capaity, gymClass_listed, classInstructor);
gc.setDBid((int)dataReader["ID"]);
gymclass.Add(gc);
}
dataReader.Close();
foreach (GymClass s in gymclass)
{
s.setClassInstructor(getGymClassInstructorByClassId(s.getDBid()));
}
return gymclass;
}
