//********************Class Variables********************
public Delete_Practice()
{
InitializeComponent();
Global.testConnection(this); //Tests connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
}
public Change_User_Privileges()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
}
//********************Constructor********************
public Delete_Reffering_GP()
{
InitializeComponent();
Global.testConnection(this); //Tests connection
UserLabel.Text = "Current User: "******" " +
Global.userLastName; //Sets user label
setSortedButtonText(); //Sets sort by button text
}
public Current_Patients()
{
InitializeComponent();
Global.testConnection(this); //Tests connection
setSortedButtonText(); //Sets sorted button text
UserLabel.Text = "Current User: "******" " +
Global.userLastName; //Sets user label
}
//DDL for [GENERAL PRACTICE]
//"CREATE TABLE [GENERAL PRACTICE]" +
//"(PRAC_Name TEXT PRIMARY KEY," +
//"PRAC_Address TEXT," +
//"PRAC_Suburb TEXT," +
//"PRAC_Post_Code TEXT," +
//"PRAC_State TEXT," +
//"PRAC_Phone TEXT," +
//"PRAC_Fax TEXT," +
//"PRAC_Notes TEXT);";
//********************Class Constructor********************
public Add_Edit_Practice()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
Global.editingExistingPractice = false; //If an editing session is open it reverts to false
}
public Add_Edit_Class_Times()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " +
Global.userLastName; //Sets user label
PopulateClassTimes(); //Populates class times in the day datagridviews
}
public Generate_Letters()
{
InitializeComponent();
Global.testConnection(this); //Test database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
setSortedButtonText(); //Sets sorted by button text
}
//********************Class Constructor********************
public Add_Edit_Consultation_1()
{
InitializeComponent();
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
Global.testConnection(this); //Tests database connection
SetSortedButtonText(); //Sets the sort by button text
Global.editingExistingConsulation = false; //If an editing session is open it reverts to false
}
//********************Class Constructor********************
public Add_Edit_Reffering_GP()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Set user label
SetSortedButtonText(); //Sets the sort by button text
Global.editingExistingRefferingGP = false; //If an editing session is open it reverts to false
}
public Add_Edit_Class()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
Date_1.Value = DateTime.Now.Date; //Sets date to current date
Date_1.MaxDate = DateTime.Now.Date; //Doesn't allow user to choose a date later than today
setSortedButtonText(); //Sets sorted button text
}
//DDL for Patient
//"CREATE TABLE [PATIENT]" +
//"(PAT_ID_Number INTEGER NOT NULL DEFAULT 1 PRIMARY KEY UNIQUE," +
//"PAT_First_Name TEXT NOT NULL," +
//"PAT_Last_Name TEXT NOT NULL," +
//"PAT_Address TEXT," +
//"PAT_Suburb TEXT," +
//"PAT_Post_Code TEXT," +
//"PAT_State TEXT," +
//"PAT_Home_Phone TEXT," +
//"PAT_Mobile_Phone TEXT," +
//"PAT_Email_Address TEXT," +
//"REFGP_ID_Number INTEGER," +
//"PAT_Date_Reffered DATE," +
//"PAT_Date_of_Birth DATE," +
//PAT_Gender TEXT," +
//"PAT_Notes TEXT," +
//"PAT_Current BOOLEAN);"
//********************Class Constructor********************
public Add_Edit_Patient()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
UserLabel.Text = "Current User: "******" " + Global.userLastName; //Sets user label
SetSortedButtonText(); //Sets the sort by button text
Global.editingExistingPatient = false; //If an editing session is open it reverts to false
Date_1.Value = DateTime.Now;
Date_2.Value = DateTime.Now;
}
//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
}
public View_Records()
{
InitializeComponent();
Global.testConnection(this);
Dropdown_1.SelectedIndex = 0;
Date_1.Value = DateTime.Now;
Date_2.Value = DateTime.Now;
//Sets the look of the form depending on what button was clicked in the Initial Screen
switch (Global.view)
{
case "View Patients":
this.Text = "View Patients";
dropDown1Label.Visible = true;
Dropdown_1.Visible = true;
View_All.Location = new Point(190, 58);
View_All.Size = new Size(101, 25);
View_All.Text = "View All Patients";
dropDown2Label.Text = "Search Patient by:";
string[] patientSearchItems = new string[17] {
"ID Number", "First Name", "Last Name", "General Practice", "Reffering GP ID", "Address",
"Suburb", "Post Code", "State", "Home Phone", "Mobile Phone", "Email", "Date Reffered",
"Date of Birth", "Gender", "GP Letter Sent", "Class Attendance"
};
Dropdown_2.Items.AddRange(patientSearchItems);
break;
case "View Consultations":
this.Text = "View Consultations";
dropDown1Label.Visible = true;
Dropdown_1.Visible = true;
View_All.Location = new Point(190, 58);
View_All.Size = new Size(101, 38);
View_All.Text = "View All Consultations";
dropDown2Label.Text = "Search Consultations by:";
dropDown2Label.Location = new Point(477, 9);
string[] consSearchItems = new string[7] {
"Consultation ID", "Patient ID", "Patient First Name",
"Patient Last Name", "Consultant Full Name", "Time Period", "Consultation Date"
};
Dropdown_2.Items.AddRange(consSearchItems);
break;
case "View Reffering GPs":
this.Text = "View Reffering GPs";
View_All.Text = "View All Reffering GPs";
dropDown2Label.Text = "Search Reffering GP by:";
View_All.Location = new Point(190, 18);
View_All.Size = new Size(96, 38);
dropDown2Label.Location = new Point(477, 9);
string[] refgpSearchItems = new string[6] {
"ID Number", "First Name", "Last Name", "Practice Name", "Direct Number",
"Email"
};
Dropdown_2.Items.AddRange(refgpSearchItems);
Records_Gridview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
break;
case "View Practices":
this.Text = "View Practices";
View_All.Text = "View All Practices";
dropDown2Label.Text = "Search Practices by:";
View_All.Location = new Point(190, 18);
View_All.Size = new Size(96, 38);
string[] pracSearchItems = new string[7] {
"Practice Name", "Address", "Suburb", "Post Code", "State",
"Phone", "Fax"
};
Dropdown_2.Items.AddRange(pracSearchItems);
Records_Gridview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
break;
}
}
public Reset_User_Password()
{
InitializeComponent();
Global.testConnection(this);
}
public Change_User_Details()
{
InitializeComponent();
Global.testConnection(this); //Tests database connection
FillDetails(); //Fills patient details
}
