private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
panelClassData.Visible = true;
pictureBox2.Visible = false; // show error pic
buttonAdd.Enabled = true;
Class = Classes.Find(g => (g.getClassName() == comboBoxClasses.Text));
labelRegisterd.Text = Class.getClassListed().ToString();
labelCapacity.Text = Class.getClassCapacity().ToString();
labelInstructorNmae.Text = Class.getClassInstructor().getNameFirst() + " " + Class.getClassInstructor().getNameLast();
labelDay.Text = Class.getTimeDay();
labelHour.Text = Class.getTimeHours();
if (Class.getClassListed() == Class.getClassCapacity())// if no more space in class
{
pictureBox2.Visible = true; // show error pic
buttonAdd.Enabled = false;
MessageBox.Show("Class have reached maximum capacity");
}
else
{
pictureBox1.Visible = true; // show good pic
}
panelClassData.Visible = true;
}
/// <summary>
/// checks if the customer has already registered the class with the date and hour
/// </summary>
/// <param name="Class2">GymClass object </param>
/// <returns>Boolead true if it's</returns>
public Boolean hoursCollied(GymClass Class2)
{
int result1;
int result2;
result1 = string.Compare(this.timeDay, Class2.timeDay);
result2 = string.Compare(this.timeHours, Class2.timeHours);
if (result1 == 0 && result2 == 0)
{
return true;
}
return false;
}
private void comboBoxGymClasses_SelectedIndexChanged(object sender, EventArgs e)
{
choosengym = curr.getGymClasses().Find( g => (g.getClassName().Equals(comboBoxGymClasses.Text)));
Console.WriteLine(choosengym.getlistCustomerListed().Count);
foreach(Customer customer in choosengym.getlistCustomerListed())
{
checkedListBoxCustomers.Items.Add(customer.getNameFirst() + " " +customer.getNameLast());
}
}
/// <summary>
/// add the customer to specific gymclass
/// </summary>
/// <param name="Class">GymClass object that the customer choose</param>
public void AddToClass(GymClass Class)
{
//check if the class have reached full capcaety(isFull)
if (Class.isFull())
{
MessageBox.Show("Class have reached maximum capacity");
return;
}
//if the customer not registered to any class yet
else if (this.listGymClass.Count() == 0)
{
//add the gymclass to the customer object
this.listGymClass.Add(Class);
//add the preson to the gymclass listed customer
Class.AddNewPersonToClass(this);
MessageBox.Show("you just registered to " + Class.getClassName() + " you can see details,just click the View Registered button ");
return;
}
else
{
//if the customer already registered to the class he choose
if (this.listGymClass.Contains(Class))
{
MessageBox.Show("You already registerd to this class.(You can see which course you already registered,just click the View Registered button)");
return;
}
else
{//for each class the customer registered , we checked if the hours between his classes to the new classes conflicted
foreach (GymClass Element in this.listGymClass)
{
if (Class.hoursCollied(Element) == true)
{
MessageBox.Show("Hours conflicted with another class you are registered to");
return;
}
}
}
}
this.listGymClass.Add(Class);
Class.AddNewPersonToClass(this);
MessageBox.Show("you just registered to " + Class.getClassName() + " you can see detail ,just clicked the View Registered button");
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
if (CurrentCustomer.getListGymClass().Count() != 0)
{
Classes = CurrentCustomer.getListGymClass().
Find(g => (g.getClassName().Equals(comboBox1.Text)));
CurrentCustomer.RemoveFromClass(Classes);
MessageBox.Show(comboBox1.Text + " Removed successfully");
Refresher();
}
}
else { MessageBox.Show("please choose one class"); }
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//check what the user choose and get the specific gymclass
Class = allgymClasses.Find(g => (g.getClassName().Equals(comboBox1.Text)));
if (Class != null)
{
labelClassName.Text = Class.getClassName();
labelClassRagisterd.Text = Class.getClassListed().ToString();
labelClassCapacity.Text = Class.getClassCapacity().ToString();
labelInstructorName.Text = Class.getClassInstructor().getNameFirst() + " " + Class.getClassInstructor().getNameLast();
label10.Text = Class.getTimeDay();
label12.Text = Class.getTimeHours();
//check if the customer already registered to the choosen class if he is switch the button text from add to delete
if (Curr.getListGymClass().Any(g => g.getClassName().Equals(comboBox1.Text)))
{
buttonAddSelected.Text = "Delete Selected";
}
else
{
buttonAddSelected.Text = "Add Selected";
}
}
else
{
labelClassName.Text ="";
labelClassRagisterd.Text = "";
labelClassCapacity.Text = "";
labelInstructorName.Text = "";
label10.Text = "";
label12.Text = "";
}
}
/// <summary>
/// remove customer from choosen gymclass
/// </summary>
/// <param name="Class">GymClass object that the customer choose</param>
public void RemoveFromClass(GymClass Class)
{
//checking if the customer is registered to the class
if (!(this.listGymClass.Any(x => x.getClassName().Equals(Class.getClassName()))))
{
MessageBox.Show("You are not registered to " + Class.getClassName());
return;
}
this.listGymClass.Remove(Class);
Class.DeleteCustomerFromClass(this);
}
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;
}
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;
}
/// <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;
}
public void deleteCostumerGymClass(GymClass gymclass, Customer customer)
{
string query = "DELETE FROM client_activity WHERE client_id = '" + customer.getDBid() + "' AND activity_id = '" + gymclass.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "UPDATE activity SET listed=listed - 1 WHERE id='" + gymclass.getDBid() + "';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
public void updateCostumerGymClass(GymClass gymclass, Customer customer) {
string query = "INSERT INTO client_activity (client_id, activity_id) VALUES('"+customer.getDBid()+"', '"+gymclass.getDBid()+"');";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "UPDATE activity SET listed=listed + 1 WHERE id='" + gymclass.getDBid() + "';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
