private void panelAdmin_Load(object sender, EventArgs e)
{
this.Dock = DockStyle.Fill;
panelAdmin_Main main = new panelAdmin_Main(ID);
main.Dock = DockStyle.Fill;
this.Controls.Add(main);
}
private void button1_Click(object sender, EventArgs e)
{
panelAdmin_Main main = new panelAdmin_Main(ID);
main.Dock = DockStyle.Fill;
this.Parent.Controls.Add(main);
this.Dispose();
}
private void button2_Click(object sender, EventArgs e)
{
string incoming = "SELECT TOP 1 Emp_ID FROM Employee ORDER BY Emp_ID DESC";
SqlCommand command = new SqlCommand(incoming, Program.sqlConnection);
Program.sqlConnection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Read();
int empID = reader.GetInt32(0);
reader.Close();
empID++;
string Fame = txtFname.Text;
string Mame = txtMName.Text;
if (Mame == "")
{
Mame = "NULL";
}
else
{
Mame = "'" + Mame + "'";
}
string Lame = txtLName.Text;
string DOB = datetimePick.Value.Date.ToString("yyyy-MM-dd");
DOB.Replace("/", "-");
string sex = txtSex.Text;
string password = txtPassword.Text;
string empType = Convert.ToString(comboBox1.SelectedItem);
string query = "INSERT INTO Employee(Emp_ID, F_Name, M_Name, L_Name, DOB, Sex, Job_Type, Pword)VALUES(" + Convert.ToString(empID) + ", '" + Fame + "', " + Mame + ", '" + Lame + "', '" + DOB + "', '" + sex + "', '" + empType + "', '" + password + "');";
command = new SqlCommand(query, Program.sqlConnection);
command.ExecuteNonQuery();
if (lblAdittional.Text == "Specialization")
{
string spec = txtAditional.Text;
string query2 = "INSERT INTO Doctor(Doctor_ID, Specialization) VALUES (" + Convert.ToString(empID) + ", '" + spec + "');";
command = new SqlCommand(query2, Program.sqlConnection);
command.ExecuteNonQuery();
}
else if (lblAdittional.Text == "Entrance No")
{
string eno = txtAditional.Text;
string spec = txtAditional.Text;
string query2 = "INSERT INTO Receptionist(Receptionist_ID, Entrance_No) VALUES(" + Convert.ToString(empID) + ", " + eno + "); ";
command = new SqlCommand(query2, Program.sqlConnection);
command.ExecuteNonQuery();
}
else if (lblAdittional.Text == "Department no")
{
string dno = txtAditional.Text;
string spec = txtAditional.Text;
string query2 = "INSERT INTO Pharmachist(Pharmachist_ID, Dept_No) VALUES(" + Convert.ToString(empID) + ", " + dno + "); ";
command = new SqlCommand(query2, Program.sqlConnection);
command.ExecuteNonQuery();
}
Program.sqlConnection.Close();
MessageBox.Show("Employee Added Succesfully with ID: " + Convert.ToString(empID));
panelAdmin_Main main = new panelAdmin_Main(ID);
main.Dock = DockStyle.Fill;
this.Parent.Controls.Add(main);
this.Dispose();
}
