private void textBox20_TextChanged(object sender, EventArgs e)
{
if (textBox20.Text == "")
{
label36.Text = "Validate Medical Staff ID";
label36.ForeColor = Color.Black;
label36.Visible = false;
}
else
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
MedicalStaffHandler mStaffHnd = new MedicalStaffHandler();
bool goCheckStaffId = mStaffHnd.checkStaffId(dbConn.getConn(), textBox20.Text);
if (goCheckStaffId == true)
{
label36.Text = "Valid Staff ID";
label36.ForeColor = Color.Green;
label36.Visible = true;
dateTimePicker1_ValueChanged(null, e);
}
else if (goCheckStaffId == false)
{
label36.Text = "Invalid Staff ID";
label36.ForeColor = Color.Red;
label36.Visible = true;
}
}
}
private void textBox21_TextChanged(object sender, EventArgs e)
{
if (textBox21.Text == "")
{
label41.Text = "Validate Medical Staff ID";
label41.ForeColor = Color.Black;
label41.Visible = false;
comboBox7.Enabled = false;
comboBox8.Enabled = false;
}
else
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
MedicalStaffHandler mStaffHnd = new MedicalStaffHandler();
bool goCheckStaffId = mStaffHnd.checkStaffId(dbConn.getConn(), textBox21.Text);
if (goCheckStaffId == true)
{
label41.Text = "Valid Staff ID";
label41.ForeColor = Color.Green;
label41.Visible = true;
comboBox7.Enabled = true;
OnShift oShift = new OnShift();
OnShiftHandler oShiftHnd = new OnShiftHandler();
oShift.StaffId = textBox21.Text;
comboBox7.DataSource = oShiftHnd.showDate(dbConn.getConn(), oShift);
}
else if (goCheckStaffId == false)
{
label41.Text = "Invalid Staff ID";
label41.ForeColor = Color.Red;
label41.Visible = true;
comboBox7.Enabled = false;
comboBox8.Enabled = false;
comboBox7.SelectedIndex = 0;
comboBox8.SelectedIndex = 0;
}
}
}
public void medicalStaffDBtable(int num)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
MedicalStaff mStaff = new MedicalStaff();
MedicalStaffHandler mStaffHnd = new MedicalStaffHandler();
if (num == 1)
{
mStaff.Name = textBox13.Text;
}
else if (num == 2)
{
mStaff.Career = "%";
}
dataGridView2.DataSource = mStaffHnd.listStaff(dbConn.getConn(), mStaff, num);
dataGridView2.Columns[0].HeaderText = "ID";
dataGridView2.Columns[1].HeaderText = "STAFF ID";
dataGridView2.Columns[2].HeaderText = "NAME";
dataGridView2.Columns[3].HeaderText = "PASSWORD";
dataGridView2.Columns[4].HeaderText = "CAREER TYPE";
dataGridView2.Columns[5].HeaderText = "EMAIL";
dataGridView2.Columns[6].HeaderText = "CONTACT NUMBER";
dataGridView2.Columns[7].HeaderText = "PAGER NUMBER";
dataGridView2.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
//Onclick "Login" button verify username & password and navigate to Bedside System Page
private void button1_Click(object sender, EventArgs e)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
MedicalStaff mStaff = new MedicalStaff();
MedicalStaffHandler mStaffHnd = new MedicalStaffHandler();
mStaff.Staffid = textBox1.Text;
mStaff.Password = textBox2.Text;
if ((mStaffHnd.checkMedicalStaffLoginDetail(dbConn.getConn(), mStaff)) == true)
{
Central_Station central_station = new Central_Station();
central_station.Show();
//this.Close();
}
else
{
MessageBox.Show("Invalid Username or Password.");
}
}
//Add new medical staff button
private void button7_Click(object sender, EventArgs e)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
MedicalStaff mStaff = new MedicalStaff();
MedicalStaffHandler mStaffHnd = new MedicalStaffHandler();
bool verifyCareer = false;
if (textBox14.Text != "" && textBox15.Text != "" && textBox16.Text != "" &&
(comboBox6.SelectedItem).ToString() != "- SELECT CAREER -")
{
if ((comboBox6.SelectedItem).ToString() == "Consultant")
{
if (textBox17.Text != "")
{
verifyCareer = true;
}
else
{
MessageBox.Show("Invalid format for Email !");
}
}
else if ((comboBox6.SelectedItem).ToString() == "Doctor" || (comboBox6.SelectedItem).ToString() == "Nurse")
{
if (int.TryParse(textBox18.Text, out int theContact))
{
if (int.TryParse(textBox19.Text, out int thePager))
{
verifyCareer = true;
}
else
{
MessageBox.Show("Invalid format for Pager Number !");
}
}
else
{
MessageBox.Show("Invalid format for Contact Number!");
}
}
else
{
MessageBox.Show("Please select a type of career.");
}
if (verifyCareer == true)
{
mStaff.Staffid = textBox14.Text;
mStaff.Name = textBox15.Text;
mStaff.Password = textBox16.Text;
mStaff.Email = textBox17.Text;
mStaff.Contact = textBox18.Text;
mStaff.Pager = textBox19.Text;
mStaff.Career = (comboBox6.SelectedItem).ToString();
int recordCnt = mStaffHnd.addNewMedicalStaff(dbConn.getConn(), mStaff);
MessageBox.Show(recordCnt + " Medical Staff Registered Successfully !");
textBox14.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = "";
textBox19.Text = "";
comboBox6.SelectedIndex = 0;
medicalStaffDBtable(1);
}
}
else
{
MessageBox.Show("Please fill up all fields to register.");
}
}
