示例#1
0
 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;
 }
示例#2
0
 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());
     }
 }
示例#3
0
        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;
        }
示例#4
0
 /// <summary>
 /// remove training program from customer object
 /// </summary>
 /// <param name="trainProg"></param>
 public void removeTraningProgram(TrainingProgram trainProg) { this.listTrainingPrograms.Remove(trainProg); }
示例#5
0
 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); }
示例#6
0
        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();            
        
        }
示例#7
0
        /// <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();            
        }
示例#8
0
        /// <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;
    
        }