private void NViewStaffBtn_Click(object sender, EventArgs e)
{
ViewStaffMembers newViewStaff = new ViewStaffMembers();
this.Hide();
newViewStaff.ShowDialog();
}
private void updateBtnOperation()
{
string memberTypeValue = "";
bool memberTypeisChecked = adedemicRadio.Checked;
if (memberTypeisChecked)
{
memberTypeValue = adedemicRadio.Text;
}
else
{
memberTypeValue = nonAcedemicRadio.Text;
}
string accessLevelValue = "";
bool accessLevelisChecked = adminRadio.Checked;
if (accessLevelisChecked)
{
accessLevelValue = adminRadio.Text;
}
else
{
accessLevelValue = userRadio.Text;
}
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 memberType = '" + memberTypeValue + "',accessLevel = '" + accessLevelValue + "',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) + "',password = '******',subject2 = '" + subTextBox2.Text + "' WHERE staffID = '" + staffID + "'";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Updated Succesfully");
ViewStaffMembers viewStaff = new ViewStaffMembers();
this.Hide();
viewStaff.ShowDialog();
}
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
DialogResult dlgResult = MessageBox.Show("Are You Sure You Want To Delete?", "Delete!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
string memberTypeValue = "";
bool memberTypeisChecked = adedemicRadio.Checked;
if (memberTypeisChecked)
{
memberTypeValue = adedemicRadio.Text;
}
else
{
memberTypeValue = nonAcedemicRadio.Text;
}
string accessLevelValue = "";
bool accessLevelisChecked = adminRadio.Checked;
if (accessLevelisChecked)
{
accessLevelValue = adminRadio.Text;
}
else
{
accessLevelValue = userRadio.Text;
}
string genderValue = "";
bool genderisChecked = maleRadioButton2.Checked;
if (genderisChecked)
{
genderValue = maleRadioButton2.Text;
}
else
{
genderValue = femaleRadioButton1.Text;
}
cmd.CommandText = "INSERT INTO pastStaff(staffID,memberType,accessLevel,fullName,name,gender,NIC,DOB,address,phoneNo,email,subject,pastSchool,serviceYears,salary,password,subject2) VALUES('" + staffID + "','" + memberTypeValue + "','" + accessLevelValue + "','" + NametextBox1.Text + "','" + nameTextBox2.Text + "','" + genderValue + "','" + NICTextBox.Text + "','" + dateTimePicker1.Value + "','" + addressTextBox.Text + "','" + phNoTextBox.Text + "','" + emailTextBox1.Text + "','" + subTextBox1.Text + "','" + pastSchTextBox.Text + "','" + Int32.Parse(serviceYrsTextBox.Text) + "','" + Convert.ToDouble(salaryTextBox.Text) + "','" + NICTextBox.Text + "','" + subTextBox2.Text + "')";
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from staff where staffID = '" + staffID + "'";
cmd.ExecuteNonQuery();
con.Close();
}
ViewStaffMembers viewStaff = new ViewStaffMembers();
this.Hide();
viewStaff.ShowDialog();
}
private void AddOperation()
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
string memberTypeValue = "";
bool memberTypeisChecked = adedemicRadio.Checked;
if (memberTypeisChecked)
{
memberTypeValue = adedemicRadio.Text;
}
else
{
memberTypeValue = nonAcedemicRadio.Text;
}
string accessLevelValue = "";
bool accessLevelisChecked = adminRadio.Checked;
if (accessLevelisChecked)
{
accessLevelValue = adminRadio.Text;
}
else
{
accessLevelValue = userRadio.Text;
}
string genderValue = "";
bool genderisChecked = maleRadioButton2.Checked;
if (genderisChecked)
{
genderValue = maleRadioButton2.Text;
}
else
{
genderValue = femaleRadioButton1.Text;
}
cmd.CommandText = "INSERT INTO staff(memberType,accessLevel,fullName,name,gender,NIC,DOB,address,phoneNo,email,subject,pastSchool,serviceYears,salary,password,subject2) VALUES('" + memberTypeValue + "','" + accessLevelValue + "','" + NametextBox1.Text + "','" + nameTextBox2.Text + "','" + genderValue + "','" + NICTextBox.Text + "','" + dateTimePicker1.Value + "','" + addressTextBox.Text + "','" + phNoTextBox.Text + "','" + emailTextBox1.Text + "','" + subTextBox1.Text + "','" + pastSchTextBox.Text + "','" + Int32.Parse(serviceYrsTextBox.Text) + "','" + Convert.ToDouble(salaryTextBox.Text) + "','" + NICTextBox.Text + "','" + subTextBox2.Text + "')";
cmd.ExecuteNonQuery();
con.Close();
con.Open();
SqlCommand command;
SqlDataReader dataReader;
string query = "SELECT staffID FROM staff where NIC = '" + NICTextBox.Text + "' and email = '" + emailTextBox1.Text + "' and fullName = '" + NametextBox1.Text + "'";
command = new SqlCommand(query, con);
dataReader = command.ExecuteReader();
if (dataReader.Read())
{
staffID = dataReader.GetValue(0).ToString();
}
dataReader.Close();
command.Dispose();
con.Close();
con.Open();
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "insert into SalaryRecord(staffID,salary,date) values(" + staffID + "," + salaryTextBox.Text + ",'" + DateTime.Now.ToString("M/d/yyyy") + "')";
cmd2.ExecuteNonQuery();
con.Close();
DialogResult dlgResult = MessageBox.Show("Do You Want To Add More Staff", "Staff Member Added Succesfully!", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dlgResult == DialogResult.Yes)
{
AddStaffMember addstaffMember = new AddStaffMember();
this.Hide();
addstaffMember.ShowDialog();
}
else
{
ViewStaffMembers viewStaff = new ViewStaffMembers();
this.Hide();
viewStaff.ShowDialog();
}
}
