public static Customer CreatCustomer(String nameFirst, String nameLast, String homeAddress, String phoneNumber, String emailAddress, long idNumber, int permissionLevel, String DateJoined, String MDClernsExpiration,TrainingProgram traningProgram , int Class_Miss) { Customer newCustomer = new Customer(nameFirst, nameLast, homeAddress, phoneNumber, emailAddress, idNumber, permissionLevel, DateJoined, MDClernsExpiration , Class_Miss); newCustomer.addTraningProgram(traningProgram); return newCustomer; }
private void comboBoxTraningPrograms_SelectedIndexChanged(object sender, EventArgs e) { dataGridViewTraningPrograms.Rows.Clear(); selectedTrp = listTrainingPrograms.Find(g => (g.getWorkoutID().ToString().Equals(comboBoxTraningPrograms.Text))); foreach (Exercise ex in selectedTrp.getExerciseList()) { dataGridViewTraningPrograms.Rows.Add( ex.getExerciseName(), ex.getExerciseRepeats(), ex.getExerciseSets()); } }
private void buttonSearch_Click(object sender, EventArgs e) { if (!validateID()) { return; } customerObject = dbcObject.getCusomerById(Convert.ToInt32(textBoxID.Text)); if (customerObject == null) { MessageBox.Show("No user with this id number"); textBoxID.Text = ""; return; } if (this.requetsType == "Add") { // Creat New Training Program with First Free workoutID long workoutID = customerObject.getListTrainingPrograms().Count; selectedTrp = new TrainingProgram(workoutID, new List<Exercise>()); // Add The New (Empty) Traning Program To Customer customerObject.addTraningProgram(selectedTrp); } else { // Request type is Edit buttonSearch.Enabled = false; // Get Customers Existing Traning Programs listTrainingPrograms = customerObject.getListTrainingPrograms(); foreach (TrainingProgram trp in listTrainingPrograms) { comboBoxTraningPrograms.Items.Add(trp.getWorkoutID()); } } // Show Panels panelEditExercise.Visible = true; panelMainDisplay.Visible = true; }
/// <summary> /// remove training program from customer object /// </summary> /// <param name="trainProg"></param> public void removeTraningProgram(TrainingProgram trainProg) { this.listTrainingPrograms.Remove(trainProg); }
public void setmedicalClearanceExpiration(String medicalClearanceExpiration) { this.medicalClearanceExpiration = medicalClearanceExpiration; }//end Class settrs /// <summary> /// add training program to the ucustomer object /// </summary> /// <param name="trainProg"> otrainingprogram object</param> public void addTraningProgram(TrainingProgram trainProg) { this.listTrainingPrograms.Add(trainProg); }
public void updateTrainingProgrem(TrainingProgram tp) { if (tp.getWorkoutID() == 1) { System.Windows.Forms.MessageBox.Show("Cannot Change Default Training Program"); return; } Dictionary<String, int> excersisses = this.getExcerssiesBackwords(); String tpList = ""; foreach (Exercise ex in tp.getExerciseList()) { tpList = tpList + excersisses[ex.getExerciseName()] + "_" + ex.getExerciseRepeats() + "_" + ex.getExerciseSets() + ","; } tpList = tpList.Substring(0, tpList.Length - 1); string query = "UPDATE training_program SET exersie_list='" + tpList + "' WHERE workoutId='" + tp.getWorkoutID() + "';"; MySqlCommand cmd = new MySqlCommand(query, this.connection); cmd.ExecuteNonQuery(); }
/// <summary> /// add training progrem to a customer /// </summary> /// <param name="edit"></param> /// <param name="tp"></param> public void AddCustomerTrainingProgrem(Customer edit, TrainingProgram tp) { Dictionary<String, int> excersisses = this.getExcerssiesBackwords(); String tpList = ""; foreach(Exercise ex in tp.getExerciseList()) { tpList = tpList + excersisses[ex.getExerciseName()] + "_" + ex.getExerciseRepeats() + "_" + ex.getExerciseSets() + ","; } tpList = tpList.Substring(0, tpList.Length - 1); string query = "INSERT INTO training_program (exersie_list) VALUES('" + tpList + "');"; MySqlCommand cmd = new MySqlCommand(query, this.connection); cmd.ExecuteNonQuery(); long tpLastId = cmd.LastInsertedId; string query2 = "INSERT INTO client_program (program_id, client_id) VALUES ('"+ tpLastId +"', '" + edit.getDBid() + "');"; MySqlCommand cmd2 = new MySqlCommand(query2, this.connection); cmd2.ExecuteNonQuery(); }
/// <summary> /// find the customer training progrem by customer id number /// </summary> /// <param name="customerDbId"></param> /// <returns>list of training progrems</returns> private List<TrainingProgram> getCustomerTPByDbId(int customerDbId) { List<Exercise> list = new List<Exercise>(); List<TrainingProgram> TP = new List<TrainingProgram>(); Dictionary<String, String> gymTools = this.getExcerssies(); string query = "Select * FROM training_program INNER JOIN client_program ON training_program.workoutId = client_program.program_id WHERE client_program.client_id='" + customerDbId + "' ;"; MySqlCommand cmd = new MySqlCommand(query, this.connection); MySqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { String training = (String)Reader["exersie_list"]; int id = (int)Reader["workoutId"]; String[] s = training.Split(','); foreach (String ex in s) { String[] e = ex.Split('_'); list.Add(new Exercise(gymTools[e[0]], e[1], e[2])); } TrainingProgram tempTP = new TrainingProgram(id, list); TP.Add(tempTP); list.Clear(); } Reader.Close(); return TP; }