private void NStaffHomeBtn_Click(object sender, EventArgs e)
{
TeacherMyProfile tchrProfile = new TeacherMyProfile();
this.Hide();
tchrProfile.ShowDialog();
}
private void MngStaffImgBtn_Click(object sender, System.EventArgs e)
{
TeacherMyProfile myPro = new TeacherMyProfile();
this.Hide();
myPro.ShowDialog();
}
private void updateBtnOperation()
{
string genderValue = "";
bool genderisChecked = maleRadioButton2.Checked;
if (genderisChecked)
{
genderValue = maleRadioButton2.Text;
}
else
{
genderValue = femaleRadioButton1.Text;
}
DialogResult dlgResult = MessageBox.Show("Are You Sure You Want To Update?", "Update!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE staff SET fullName = '" + NametextBox1.Text + "',name = '" + nameTextBox2.Text + "',gender = '" + genderValue + "',NIC = '" + NICTextBox.Text + "',DOB = '" + dateTimePicker1.Value + "',address = '" + addressTextBox.Text + "',phoneNo = '" + phNoTextBox.Text + "',email = '" + emailTextBox1.Text + "',subject = '" + subTextBox1.Text + "',pastSchool = '" + pastSchTextBox.Text + "',serviceYears = '" + Int32.Parse(serviceYrsTextBox.Text) + "',salary = '" + Convert.ToDouble(salaryTextBox.Text) + "',subject2 = '" + subTextBox2.Text + "' WHERE staffID = '" + GetSetInfo.getsetusrId + "'";
cmd.ExecuteNonQuery();
con.Close();
GetSetInfo.userName = nameTextBox2.Text;
MessageBox.Show("Updated Succesfully");
TeacherMyProfile teacherMyProfile = new TeacherMyProfile();
this.Hide();
teacherMyProfile.ShowDialog();
}
}