//When a user clicks a selection from the dropdown box all the values of the selected patient will //populate the fields. private void Dropdown_1_SelectionChangeCommitted(object sender, EventArgs e) { Patient_Database.PatientSelectedConsultation1(Dropdown_1, Input_1, Input_2, Input_3, Input_4, Input_5); Consultation_Database.PopulateConsultationDataGridView(Dropdown_1, Existing_Consultations); //Poplulates existing consultations if any Dropdown_2.Enabled = true; //Allows user to choose time period if (Dropdown_2.SelectedIndex != -1) { Add_Consultation.Enabled = true; } }
//Deletes selected consultation private void Delete_Click(object sender, EventArgs e) { bool deleteSuccessful = Consultation_Database.DeleteConsultation(Dropdown_1, Existing_Consultations); //Deletes Consultation //If user chooses to cancel delete or there is no consultations to delete it stops the method if (deleteSuccessful == false) { return; } Consultation_Database.PopulateConsultationDataGridView(Dropdown_1, Existing_Consultations); //Refreshes existing consultations }
//DDL for Consultation // "CREATE TABLE [CONSULTATION]" + // "(CONS_ID_Number TEXT NOT NULL PRIMARY KEY UNIQUE," + // "PAT_ID_Number INT NOT NULL," + // "CONS_Consultant TEXT NOT NULL," + // "CONS_Time_Period TEXT NOT NULL," + // "CONS_Date DATE NOT NULL," + // "CONS_Health_Rating TEXT," + // "CONS_Smoking_Status TEXT," + // "CONS_Alcohol_Days NUMERIC," + // "CONS_Alcohol_Drinks NUMERIC," + // "CONS_Height NUMERIC," + // "CONS_Weight NUMERIC," + // "CONS_BMI NUMERIC," + // "CONS_Waist NUMERIC," + // "CONS_SBP NUMERIC," + // "CONS_DBP NUMERIC," + // "CONS_Body_Fat_Percentage NUMERIC," + // "CONS_LBM NUMERIC," + // "CONS_Visceral_Fat_Rating NUMERIC," + // "CONS_CHO_TC NUMERIC," + // "CONS_CHO_LDL NUMERIC," + // "CONS_CHO_HDL NUMERIC," + // "CONS_CHO_TG NUMERIC," + // "CONS_Fasting_Glucose NUMERIC," + // "CONS_HbA1c NUMERIC," + // "CONS_Resistance INTEGER," + // "CONS_Cardio INTEGER," + // "CONS_Brisk_Walk INTEGER," + // "CONS_Light_Activity INTEGER," + // "CONS_Fruit_Serves NUMERIC," + // "CONS_Fruit_Greater_2_Serves NUMERIC," + // "CONS_Vegetable_Serves NUMERIC," + // "CONS_Vegetable_Greater_5_Serves NUMERIC," + // "CONS_Commercial_Meals INTEGER," + // "CONS_Sweets INTEGER," + // "CONS_Soft_Drinks INTEGER," + // "CONS_Skip_Main_Meals INTEGER," + // "CONS_Keep_Track_Of_Food INTEGER," + // "CONS_Limit_Portions INTEGER," + // "CONS_Eat_When_Upset INTEGER," + // "CONS_Eat_In_Front_Of_TV INTEGER," + // "CONS_Choose_Healthier_Foods INTEGER," + // "CONS_Notes TEXT);"; //********************Class Constructor******************** public Add_Edit_Consultation_2() { InitializeComponent(); Global.testConnection(this); //Tests database connection Date_1.Value = DateTime.Now; //Sets Date to today UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label //Shows existing consultations in the DGV Consultation_Database.PopulateConsultationDataGridView(Exisiting_Consultations); FillPatientDetails(); //Sets pre fill details }
//********************Database Event Methods******************** //Saves changes to new patient or existing patient private void Save_Click(object sender, EventArgs e) { //All input boxes are read only when they can't be saved. //This will stop users from clicking save when not in edit mode if (Input_3.ReadOnly == true) { MessageBox.Show("Please click 'Edit Current' button to save changes", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Consultant must be chosen if (Dropdown_2.SelectedIndex == -1) { MessageBox.Show("Please choose a consultant", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Testing if only numbers were input if (TestNumbers() == false) { MessageBox.Show("All fields need to be numbers except for:\nHeath Rating,\nSmoking Status and\nNotes", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Saves Consultation to Database bool saveSuccessful = Consultation_Database.SaveConsultation(Input_1, Input_2, Input_3, Input_4, Input_5, Input_6, Input_7, Input_8, Input_9, Input_10, Input_11, Input_12, Input_13, Input_14, Input_15, Input_16, Input_17, Input_18, Input_19, Input_20, Input_21, Input_22, Input_23, Input_24, Input_25, Input_26, Input_27, Input_28, Input_29, Input_30, Input_31, Input_32, Input_33, Input_34, Input_35, Input_36, Input_37, Input_38, Date_1, Dropdown_1, Dropdown_2); //Triggered if user is promted that a record exists with the same time period and the user clicks cancel if (saveSuccessful == false) { return; } //Once consultation is saved the DGV is updated Consultation_Database.PopulateConsultationDataGridView(Exisiting_Consultations); AddOrEditFields(false); //Changes all fields to read only Edit_Consultation.Visible = true; //Allows user to make edits if necessary }