private void InitializeOtherStuff()
{
db = new SQLiteDataBase();
dgvPatientVisit = this.patientFilesGridView;
dgvRoom = this.roomsGridView;
dgvSchedule = this.schedulesGridView;
notesBox = this.notesTextBox;
illnessBox = this.illnessTextBox;
this.enterSWB.Enabled = true;
this.updateSWB.Enabled = true;
this.deleteSWB.Enabled = true;
dgvSchedule.Columns["visitID"].ReadOnly = true;//will become editable when double clicked
dgvSchedule.Columns["patientID"].ReadOnly = true;//do not allow changes to patientID
dgvSchedule.Columns["doctorID"].ReadOnly = true;//do not allow changes to doctorID
dgvSchedule.Columns["buildingID"].ReadOnly = true;//do not allow changes
dgvSchedule.Columns["roomNumber"].ReadOnly = true;//do not allow changes
dgvSchedule.AutoGenerateColumns = true;
dayComboBox.MouseClick += new MouseEventHandler(dayBoxText_Click);
dayComboBox.LostFocus += new EventHandler(dayComboBox_LostFocus);
timeBox.MouseClick += new MouseEventHandler(timeBox_MouseClick);
timeBox.LostFocus += new EventHandler(timeBox_LostFocus);
dgvPatientVisit.SelectionChanged += new EventHandler(patientFilesGridViewSelectionChanged);
dgvRoom.SelectionChanged += new EventHandler(roomGridViewSelectionChanged);
dgvSchedule.SelectionChanged += new EventHandler(scheduleGridViewSelectionChanged);
//counter = db.getMaxID("Schedule", "visitID") + 1; //NO Counter. Because the unique ID of schedule is date
//date will not be auto generated and is user decided
}
private void InitializeOtherStuff()
{
db = new SQLiteDataBase();
dgvPatientVisit = this.patientFilesGridView;
dgvPatients = this.patientsGridView;
dgvDoctors = this.doctorsGridView;
notesBox = this.notesTextBox;
illnessBox = this.illnessTextBox;
outcomeBox = this.outcomeTextBox;
this.enterPFWB.Enabled = true;
this.updatePFWB.Enabled = true;
this.deletePFWB.Enabled = true;
dgvPatientVisit.Columns["visitID"].ReadOnly = true;//will become editable when double clicked
dgvPatientVisit.Columns["patientIDPV"].ReadOnly = true;//do not allow changes to patientID
dgvPatientVisit.Columns["doctorIDPV"].ReadOnly = true;//do not allow changes to doctorID
dgvPatientVisit.AutoGenerateColumns = true;
dgvPatientVisit.CellDoubleClick += new DataGridViewCellEventHandler(patientFilesGridView_CellDoubleClick);
dgvPatientVisit.SelectionChanged += new EventHandler(patientFilesGridViewSelectionChanged);
dgvPatients.SelectionChanged += new EventHandler(patientGridViewSelectionChanged);
dgvDoctors.SelectionChanged += new EventHandler(doctorGridViewSelectionChanged);
counter = db.getMaxID("PatientVisit", "visitID") + 1; // set counter to the next id.
}
private void InitializeOtherStuff()
{
db = new SQLiteDataBase();
dgvRoom = this.roomsGridView;
dgvBuilding = this.buildingGridView;
dgvRoom.Columns["roomNumber"].ReadOnly = false;
dgvRoom.Columns["buildingIDR"].ReadOnly = true;//do not allow changes to BuildingID
dgvRoom.Columns["available"].ReadOnly = true;
dgvRoom.Columns["roomType"].ReadOnly = true;
dgvRoom.AutoGenerateColumns = true;
dgvRoom.SelectionChanged += new EventHandler(this.roomsGridViewSelectionChanged);
dgvBuilding.SelectionChanged += new EventHandler(this.buildingsGridViewSelectionChanged);
counter = db.getMaxID("Room", "roomNumber"); // set counter to the next id.
}
private void FillPatientVisitsTable()
{
db = new SQLiteDataBase();
DataTable dt = new DataTable();
try
{
// System.Windows.Forms.MessageBox.Show("IN get table");
dt = db.GetDataTable("SELECT * FROM PatientVisit");
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
this.patientFilesGridView.DataSource = dt;
}
private void FillMedicalProfessionalTable()
{
db = new SQLiteDataBase();
DataTable dt = new DataTable();
try
{
dt = db.GetDataTable("SELECT * FROM MedicalProfessional");
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
this.doctorsGridView.DataSource = dt;
}
private void InitializeOtherStuff()
{
db = new SQLiteDataBase();
dgv = this.patientsGridView;
this.enterPWB.Enabled = false;
this.updatePWB.Enabled = false;
this.deletePWB.Enabled = false;
dgv.Columns["patientID"].ReadOnly = true;
dgv.AutoGenerateColumns = true;
dgv.CellDoubleClick += new DataGridViewCellEventHandler(patientsGridView_CellDoubleClick);
dgv.SelectionChanged += new EventHandler(this.patientGridViewSelectionChanged);
//this.patientsGridView.CellValueChanged += new DataGridViewCellEventHandler(this.patientsGridViewCellValueChanged);
//use DataGridView1.CellValueChanged += new DataGridViewCellEventHandler(DataGridView1_CellValueChanged);
//for updates, and maybe get rid of update button
counter = db.getMaxID("Patient", "PatientID") + 1; // set counter to the next id.
}
//Refreshes the medical professionals table after applying the sort
private void sortButton_Click(object sender, EventArgs e)
{
string select = " SELECT mp.DoctorID, mp.DoctorDepartment, mp.DoctorName, mp.DoctorPhone, mp.DoctorAge, mp.DoctorDateOfBirth, mp.DoctorType, mp.DoctorSalary ";
string from = " FROM MedicalProfessional AS mp ";
string where = " WHERE mp.DoctorID = mp.DoctorID ";
//where += " mp.DoctorID = s.DoctorID AND mp.DoctorID = t.DoctorID ";
if (dateBox.Text != "MM/DD/YY")
{
from = from + " , Schedule AS s ";
where = where + " AND mp.DoctorID = s.DoctorID AND " + " s.ScheduleDay = " + "'" + dateBox.Text + "'";
}
if (buildingBox.Text != "Building Name")
{
if (dateBox.Text == "MM/DD/YY")
from = from + " , Schedule AS s ";
from = from + " , Building AS b ";
where = where + " AND mp.DoctorID = s.DoctorID AND " + " s.BuildingID = b.BuildingID AND " + " b.BuildingName = " + "'" + buildingBox.Text + "'";
}
if (courseBox.Text != "Course Name")
{
from = from + " , Training AS t ";
where = where + " AND mp.DoctorID = t.DoctorID AND " + " t.TrainingCourse = " + "'" + courseBox.Text + "'";
}
db = new SQLiteDataBase();
DataTable dt = new DataTable();
try
{
dt = db.GetDataTable( select + from + where );
}
catch (Exception fail)
{
System.Windows.Forms.MessageBox.Show(fail.Message);
}
this.medicalProfessionalsGridView.DataSource = dt;
}
private void InitializeOtherStuff()
{
db = new SQLiteDataBase();
dgv = this.medicalProfessionalsGridView;
this.enterMPWB.Enabled = false;
this.updateMPWB.Enabled = false;
this.deleteMPWB.Enabled = false;
dgv.Columns["doctorID"].ReadOnly = true;
dgv.AutoGenerateColumns = true;
dgv.CellDoubleClick += new DataGridViewCellEventHandler(medicalProfessionalsGridView_CellDoubleClick);
dgv.SelectionChanged += new EventHandler(this.medicalProfessionalsGridViewSelectionChanged);
dateBox.MouseClick += new MouseEventHandler(dateBoxText_Click);
dateBox.LostFocus += new EventHandler(dateBoxText_LostFocus);
buildingBox.MouseClick += new MouseEventHandler(buildingNameBox_MouseClick);
buildingBox.LostFocus += new EventHandler(buildingNameBox_LostFocus);
courseBox.MouseClick += new MouseEventHandler(courseBox_MouseClick);
courseBox.LostFocus += new EventHandler(courseBox_LostFocus);
patientsGridView.Enabled = false;
counter = db.getMaxID("MedicalProfessional", "DoctorID") + 1; // set counter to the next id.
}
