private void NViewSalaryBtn_Click(object sender, EventArgs e)
{
ViewSalaryInfo newViewSalary = new ViewSalaryInfo();
this.Hide();
newViewSalary.ShowDialog();
}
private void UpdateBtn_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE staff SET salary = " + Convert.ToDouble(salaryTextBox.Text) + " where staffID = '" + staffID + "'";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show(DateTime.Now.ToString("M/d/yyyy"));
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();
MessageBox.Show("Salary Updated");
ViewSalaryInfo viewSalaryInfo = new ViewSalaryInfo();
this.Hide();
viewSalaryInfo.ShowDialog();
}
