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(); }