public int addNewMedicalStaff(MySqlConnection conn, MedicalStaff staff)
{
string sql = "INSERT INTO medicalstaff (staffId, staffName, password, careerType, email, contactNumber" +
", pagerNumber) VALUES ('" + staff.Staffid + "', '" + staff.Name + "' , '" + staff.Password + "', '" +
staff.Career + "' , '" + staff.Email + "', '" + staff.Contact + "' , '" + staff.Pager + "')";
MySqlCommand sqlComm = new MySqlCommand(sql, conn);
return(sqlComm.ExecuteNonQuery());
}
public List <MedicalStaff> listStaff(MySqlConnection conn, MedicalStaff staff, int num)
{
List <MedicalStaff> listOfStaff = new List <MedicalStaff>();
string sql = "";
if (num == 1)
{
sql = "SELECT * from `medicalstaff` WHERE staffId LIKE '" + staff.Name + "%' OR staffName LIKE '" + staff.Name + "%' OR " +
"password LIKE '" + staff.Name + "%' OR careerType LIKE '" + staff.Name + "%' OR email LIKE '" + staff.Name + "%' OR contactNumber LIKE '" +
staff.Name + "%' OR pagerNumber LIKE '" + staff.Name + "%'";
}
else if (num == 2)
{
sql = "SELECT * from `medicalstaff` WHERE careerType LIKE '" + staff.Career + "'";
}
MySqlCommand sqlComm = new MySqlCommand(sql, conn);
using (MySqlDataReader sqlReader = sqlComm.ExecuteReader())
{
while (sqlReader.Read())
{
MedicalStaff aStaff = new MedicalStaff();
aStaff.Id = (int)sqlReader.GetValue(0);
aStaff.Staffid = (string)sqlReader.GetValue(1);
aStaff.Name = (string)sqlReader.GetValue(2);
aStaff.Password = (string)sqlReader.GetValue(7);
aStaff.Career = (string)sqlReader.GetValue(3);
aStaff.Email = (string)sqlReader.GetValue(4);
aStaff.Contact = (string)sqlReader.GetValue(5);
aStaff.Pager = (string)sqlReader.GetValue(6);
listOfStaff.Add(aStaff);
}
}
return(listOfStaff);
}
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;
}
public bool checkMedicalStaffLoginDetail(MySqlConnection conn, MedicalStaff staff)
{
bool check = false;
string sql = "SELECT id FROM medicalstaff WHERE staffId LIKE '" + staff.Staffid + "' AND password LIKE '" + staff.Password + "';";
MySqlCommand sqlComm = new MySqlCommand(sql, conn);
using (MySqlDataReader sqlReader = sqlComm.ExecuteReader())
{
while (sqlReader.Read())
{
MedicalStaff aStaff = new MedicalStaff();
if ((sqlReader.GetValue(0)).ToString() != " ")
{
check = true;
}
}
}
return(check);
}
//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.");
}
}