/// <summary> /// Search customer by id /// and checking the correctness of the input /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonSearch_Click(object sender, EventArgs e) { int parsedValue; if (!int.TryParse(textBoxId.Text, out parsedValue)) // check if id number not contain a characters { MessageBox.Show("Id number have to be digits only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxId.Text = ""; } if (textBoxId.Text == "") { MessageBox.Show("Enter Customer id"); } else { CurrentCustomer = obj.getCusomerById(Convert.ToInt32(textBoxId.Text)); if (CurrentCustomer != null) { buttonSearch.Enabled = false; panelClasses.Visible = true; customerClasses = CurrentCustomer.getListGymClass(); } else { MessageBox.Show("No user with this id number"); textBoxId.Text = ""; } } }
public FormViewRegisterdClasses(Customer Curr) { InitializeComponent(); this.Current = Curr; }
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; }
//string reason; public FormRequestTrPrgmChg() { InitializeComponent(); curr = (Customer)User.Instance.getCurrent(); listTrainingPrograms = curr.getListTrainingPrograms(); list = dbConnector.Instance.getTrainers(); }
public FormCustomerRegisterToClass() { Curr = (Customer)User.Instance.getCurrent(); //Curr = (Customer)dbConnector.Instance.getRandomPersonByPermission(PermissiomLevels.CUSTOMER); this.allgymClasses = dbConnector.Instance.getClasses(); InitializeComponent(); }
public String editCustomer(String nameFirst, String nameLast, String homeAddress, String phoneNumber, String emailAddress, String medicalClearanceExpiration, Customer UpdateCustomer) { UpdateCustomer.setNameFirst(nameFirst); UpdateCustomer.setNameLast(nameLast); UpdateCustomer.setEmailAddress(emailAddress); UpdateCustomer.setHomeAddress(homeAddress); UpdateCustomer.setphoneNumber(phoneNumber); UpdateCustomer.setmedicalClearanceExpiration(medicalClearanceExpiration); String result = dbConnector.Instance.EditCustomer(UpdateCustomer); return result; }
private void button1_Click(object sender, EventArgs e) { int parsedValue; if (!int.TryParse(textBoxID.Text, out parsedValue)) // check if id number not contain a characters { MessageBox.Show("Id number have to be digits only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxID.Text = ""; } if (textBoxID.Text == "") { MessageBox.Show("Enter Customer id"); } else { CurrentCustomer = obj.getCusomerById(Convert.ToInt32(textBoxID.Text)); if (CurrentCustomer != null) { if (CurrentCustomer.getListGymClass().Count() != 0) { button1.Enabled = false; foreach (GymClass ClassName in CurrentCustomer.getListGymClass()) { // empEdit classes name to combobox comboBox1.Items.Add(ClassName.getClassName()); } panel1.Visible = true; } else { MessageBox.Show("This user have no classes"); } } else { MessageBox.Show("No user with this id number"); textBoxID.Text = ""; } } }
/// <summary> /// add new customer to gymclass /// </summary> /// <param name="customer">customer object that we need to add to the gymclas</param> public void AddNewPersonToClass(Customer customer) { this.classListed++; this.listCustomerListed.Add(customer); dbConnector.Instance.updateCostumerGymClass(this, customer); }
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; }
public List<Customer> getListedCustomerByClassID(int classId) { List<Customer> customerList = new List<Customer>(); string query = "Select * FROM cilent INNER JOIN client_activity ON cilent.idCilent = client_activity.client_id WHERE client_activity.activity_id ='" + classId + "';"; MySqlCommand cmd = new MySqlCommand(query, this.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { String first_name = (String)dataReader["F_Name"]; String last_name = (String)dataReader["L_Name"]; String address = (String)dataReader["Address"]; String phone_number = (String)dataReader["phone_number"]; String email = (String)dataReader["eMail"]; int personId = (int)dataReader["person_id"]; int permmsion = (int)dataReader["Premission"]; String DataJoind = (String)dataReader["DateJoind"]; String Md_LastDate = (String)dataReader["Md_LastDate"]; int class_miss = (int)dataReader["class_miss"]; //Console.Write(first_name); Customer temp = new Customer(first_name, last_name, address, phone_number, email, personId, permmsion, DataJoind, Md_LastDate, class_miss); temp.setDBid((int)dataReader["idCilent"]); customerList.Add(temp); } dataReader.Close(); return customerList; }
/* Add Methods */ public String addCustomer(Customer add, String password) { // TODO: change to bool string checkIfExsites = "Select * FROM users WHERE person_id = '" + add.getIdNumber() + "' ;"; MySqlCommand cmdCheck = new MySqlCommand(checkIfExsites, this.connection); MySqlDataReader dataReader = cmdCheck.ExecuteReader(); int count = 0; while (dataReader.Read()) { count++; } dataReader.Close(); if (count > 0) { return "ID allready in use"; } string query = "INSERT INTO cilent (F_Name, L_Name, ClientIDNum, phone_number, Address, DateJoind, Md_LastDate, eMail, program, person_id, password, Premission) VALUES('" + add.getNameFirst() + "', '" + add.getNameLast() + "' , '" + add.getIdNumber() + "', '" + add.getPhoneNumber() + "','" + add.getHomeAddress() + "','" + add.getDateJoined() + "','" + add.getMedicalClearanceExpiration() + "','" + add.getEmailAddress() + "', '1','" + add.getIdNumber() + "', md5('" + password + "'), 0);"; MySqlCommand cmd = new MySqlCommand(query, this.connection); try { cmd.ExecuteNonQuery(); } catch (MySqlException ex) { if (ex.Message.Contains("Duplicate")) { if (ex.Message.Contains("PhoneNumber")) { return "Phone Number"; } else if (ex.Message.Contains("eMail")) { return "Email"; } } else System.Windows.Forms.MessageBox.Show("Unknow error"); } long customerDbId = cmd.LastInsertedId; string query2 = "INSERT INTO users (person_id, password, type) VALUES('" + add.getIdNumber() + "', md5('" + password + "'), 'customer');"; MySqlCommand cmd2 = new MySqlCommand(query2, this.connection); cmd2.ExecuteNonQuery(); string query3 = "INSERT INTO client_program (program_id, client_id) VALUES('1', '" + customerDbId + "');"; MySqlCommand cmd3 = new MySqlCommand(query3, this.connection); cmd3.ExecuteNonQuery(); return "OK"; }
/// <summary> /// get all the customer from the data base /// </summary> /// <returns>return a list of customers</returns> public List<Customer> getAllCustomer() { List<Customer> customerList = new List<Customer>(); string query = "Select * FROM cilent;"; MySqlCommand cmd = new MySqlCommand(query, this.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { String first_name = (String)dataReader["F_Name"]; String last_name = (String)dataReader["L_Name"]; String address = (String)dataReader["Address"]; String phone_number = (String)dataReader["phone_number"]; String email = (String)dataReader["eMail"]; int personId = (int)dataReader["person_id"]; int permmsion = (int)dataReader["Premission"]; String DataJoind = (String)dataReader["DateJoind"]; String Md_LastDate = (String)dataReader["Md_LastDate"]; int class_miss = (int)dataReader["class_miss"]; Customer temp = new Customer(first_name, last_name, address, phone_number, email, personId, permmsion, DataJoind, Md_LastDate, class_miss); temp.setDBid((int)dataReader["idCilent"]); customerList.Add(temp); } dataReader.Close(); return customerList; }
/// <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> /// delete customer from the system(only manager) /// </summary> /// <param name="DeleteCustomer">customer object that he want to delete</param> public void deleteCustomer(Customer DeleteCustomer) { dbConnector.Instance.deleteCustomer(DeleteCustomer); }
/// <summary> /// look for a customer in the data base by its id number /// </summary> /// <param name="id"></param> /// <returns>returns a customer instance by a given id</returns> public Customer getCusomerById(int id) { Customer temp = null; string queryPerson = "Select * FROM cilent WHERE person_id='" + id + "';"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["Address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["eMail"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; String DataJoind = (String)personReader["DateJoind"]; String Md_LastDate = (String)personReader["Md_LastDate"]; int class_miss = (int)personReader["class_miss"]; temp = new Customer(first_name, last_name, address, phone_number, email, personId, permmsion, DataJoind, Md_LastDate, class_miss); temp.setDBid((int)personReader["idCilent"]); } personReader.Close(); if (temp != null) { ((Customer)temp).setListGymClass(getCustomerGymClassByDbId(temp.getDBid())); //sets the customr gymclasses ((Customer)temp).setListTrainingProgram(getCustomerTPByDbId(temp.getDBid())); // sets the customer training progrem } return temp; }
private void buttonAddFind_Click(object sender, EventArgs e) { // Validate ID Input if (!validateID()) { return; } if (this.requetsType == "Add") {// Current Form Request is Add if (validateData()) {// Detiles are OK String result = current.getCutomerManagement().addCustomer(textBoxNameFirst.Text, textBoxNameLast.Text, textBoxAddress.Text, textBoxPhoneNumber.Text, textBoxEmail.Text, Convert.ToInt64(textBoxID.Text), PermissiomLevels.CUSTOMER, DateTime.Now.ToString("dd/mm/yyyy"), dateTimePickerMDClerExp.Value.ToString("dd/MM/yyyy"), textBoxPassword.Text); switch (result) {// Varify Addition case "ID": labelID.ForeColor = Color.Red; MessageBox.Show("This ID Number is listed for another customer!"); return; case "Phone Number": labelPhone.ForeColor = Color.Red; MessageBox.Show("This Phone Number is listed for another customer!"); return; case "Email": labelEmail.ForeColor = Color.Red; MessageBox.Show("This Email is listed for another customer!"); return; case "Customer Allready existes": MessageBox.Show("Customer Allready existes!"); resetLabelColors(); refresher(); return; case "OK": MessageBox.Show("Customer Added Successfully!"); refresher(); return; } // Switch } // if (validateData()) return; } // if (this.requetsType == "Add") // Current Form Request is Edit (Button Text is Find) customerObject = dbConnector.Instance.getCusomerById(Convert.ToInt32(textBoxID.Text)); // in this place we need to read data from MYSQL database and fill in our text boxes if (customerObject == null) { // Customer Not Found MessageBox.Show("There is no Customer with this id"); return; } // Fill Data textBoxNameFirst.Text = customerObject.getNameFirst(); textBoxNameLast.Text = customerObject.getNameLast(); textBoxPhoneNumber.Text = customerObject.getPhoneNumber(); dateTimePickerMDClerExp.Value = Convert.ToDateTime(customerObject.getMedicalClearanceExpiration()); textBoxEmail.Text = customerObject.getEmailAddress(); textBoxAddress.Text = customerObject.getHomeAddress(); buttonSave.Enabled = true; panelData.Visible = true; }
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(); }
public void deleteCustomer(Customer customer) { string query = "DELETE FROM cilent WHERE idCilent='" + customer.getDBid() + "';"; MySqlCommand cmd = new MySqlCommand(query, this.connection); cmd.ExecuteNonQuery(); string query2 = "DELETE FROM users WHERE person_id = '" + customer.getIdNumber() + "' AND type = 'customer';"; MySqlCommand cmd2 = new MySqlCommand(query2, this.connection); cmd2.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show(customer.getNameFirst()+" "+customer.getNameLast()+" Was Deleted"); }
public String EditCustomer(Customer add) { string query = "UPDATE cilent SET F_Name='" + add.getNameFirst() + "', L_Name='" + add.getNameLast() + "', Md_LastDate = '"+add.getMedicalClearanceExpiration() +"' ,phone_number='" + add.getPhoneNumber() + "', person_id='" + add.getIdNumber() + "', address='" + add.getHomeAddress() + "', email='" + add.getEmailAddress() + "' WHERE idCilent='" + add.getDBid() + "';"; MySqlCommand cmd = new MySqlCommand(query, this.connection); try { cmd.ExecuteNonQuery(); } catch (MySqlException ex) { if (ex.Message.Contains("Duplicate")) { if (ex.Message.Contains("ClientIDNum")) { return "ID"; } else if (ex.Message.Contains("PhoneNumber")) { return "Phone Number"; } else if (ex.Message.Contains("eMail")) { return "Email"; } } else System.Windows.Forms.MessageBox.Show("Unknow error"); } return "O.K"; }
/// <summary> /// delete customer from the clas /// </summary> /// <param name="customer">customer object that want to be deleted</param> public void DeleteCustomerFromClass(Customer customer) { this.classListed--; this.listCustomerListed.Remove(customer); MessageBox.Show("You just delete your self from " + this.getClassName()); dbConnector.Instance.deleteCostumerGymClass(this, customer); }
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(); }
/// <summary> /// get an id and a password from the login form, search for it in the user table and if it exisets returns the right person object /// </summary> /// <param name="id"></param> /// <param name="password"></param> /// <returns>null if the user was not found , else return the person object from the database</returns> public Person getPersonByCredentials(long id, String password) { Person person = null; String type = null; string query = "Select * FROM users WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmd = new MySqlCommand(query, this.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { type = (String)dataReader["type"]; //get the user type from the users table } dataReader.Close(); if (type != null) { //Create query for the right person type (customer, manager, reception, instructor, trainer) switch (type) { case "manager": { string queryPerson = "Select * FROM administration WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["email"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; float sallery = (float)personReader["Sal_Hour"]; person = new Manager(first_name, last_name, address, phone_number, email, personId, permmsion, sallery); //create a new manager person.setDBid((int)personReader["idAdministration"]); //set the uniqe id from the mysql table } personReader.Close(); break; } case "customer": { string queryPerson = "Select * FROM cilent WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["Address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["eMail"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; String DataJoind = (String)personReader["DateJoind"]; String Md_LastDate = (String)personReader["Md_LastDate"]; int class_miss = (int)personReader["class_miss"]; //Console.Write(first_name); person = new Customer(first_name, last_name, address, phone_number, email, personId, permmsion, DataJoind, Md_LastDate, class_miss); //create a new customer instance person.setDBid((int)personReader["idCilent"]); //set the uniqe id from the mysql table } personReader.Close(); ((Customer)person).setListGymClass(getCustomerGymClassByDbId(person.getDBid())); ((Customer)person).setListTrainingProgram(getCustomerTPByDbId(person.getDBid())); break; } case "instructor": { string queryPerson = "Select * FROM instructor WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["email"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; float sallery = (float)personReader["Sal_Hour"]; person = new Instructor(first_name, last_name, address, phone_number, email, personId, permmsion, sallery); //crate a new instructor instance person.setDBid((int)personReader["idInstructor"]); //set the uniqe id from the mysql table } personReader.Close(); break; } case "reception": { string queryPerson = "Select * FROM reception WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["email"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; float sallery = (float)personReader["Sal_Hour"]; person = new Receptionist(first_name, last_name, address, phone_number, email, personId, permmsion, sallery); //create a new reception instance person.setDBid((int)personReader["idReception"]); //set the uniqe id from the mysql table } personReader.Close(); break; } case "trainer": { string queryPerson = "Select * FROM trainers WHERE person_id='" + id + "' AND password=md5('" + password + "');"; MySqlCommand cmdPerson = new MySqlCommand(queryPerson, this.connection); MySqlDataReader personReader = cmdPerson.ExecuteReader(); while (personReader.Read()) { String first_name = (String)personReader["F_Name"]; String last_name = (String)personReader["L_Name"]; String address = (String)personReader["address"]; String phone_number = (String)personReader["phone_number"]; String email = (String)personReader["email"]; int personId = (int)personReader["person_id"]; int permmsion = (int)personReader["Premission"]; float sallery = (float)personReader["Sal_Hour"]; String certificate = (String)personReader["certificate"]; person = new Trainer(first_name, last_name, address, phone_number, email, personId, permmsion, sallery, certificate); //create a new trainer instance person.setDBid((int)personReader["idtrainer"]); //set the uniqe id from the mysql table } personReader.Close(); break; } } } return person; }