private void button1_Click(object sender, EventArgs e)
{
if (isEmpty())
{
if (eIsupdateP)
{
UpdateMethod();
this.Hide();
EmployeeShowForm obj = new EmployeeShowForm();
obj.Show();
}
else
{
SaveMethod();
this.Hide();
EmployeeShowForm obj = new EmployeeShowForm();
obj.Show();
}
}
}
private void button3_Click(object sender, EventArgs e)
{
string c1 = ConfigurationManager.ConnectionStrings["edb"].ConnectionString;
SqlConnection conn1 = new SqlConnection(c1);
SqlCommand cm = new SqlCommand("select * from [EmployeeTbl] where [EmpName]='" + nametext.Text.Trim() + "'", conn1);
SqlDataAdapter adapter = new SqlDataAdapter(cm);
adapter.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{
string c = ConfigurationManager.ConnectionStrings["edb"].ConnectionString;
SqlConnection conn = new SqlConnection(c);
SqlCommand cmd = new SqlCommand("spEdel", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@n", nametext.Text.Trim());
cmd.Parameters.AddWithValue("@designation", designationComboBox1.Text);
cmd.Parameters.AddWithValue("@epwd", passwordtextbox.Text.Trim());
cmd.Parameters.AddWithValue("@edate", joiningdate.Value.Date);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Delete Record Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
EmployeeShowForm obj = new EmployeeShowForm();
obj.Show();
}
else
{
MessageBox.Show("Employee Name " + nametext.Text + " is Not Exist", "ERROR!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void employeesToolStripMenuItem_Click(object sender, EventArgs e)
{
EmployeeShowForm obj = new EmployeeShowForm();
obj.ShowDialog();
}