private void deleteButton_Click(object sender, EventArgs e)
{
try
{
string query = "";
if (EmpIdtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Employee ID");
EmpIdtextBox.Focus();
return;
}
query = "DELETE FROM Employee_Info WHERE EmpID = " + EmployeeID;
if (DbAccess.ExecuteToDB(query))
{
if (EmployeeID != 0)
{
MessageBox.Show("Delete Successfully!!!");
}
else
{
MessageBox.Show("Failed To Delete!!!");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
private void saveButton_Click(object sender, EventArgs e)
{
string query = "";
if (EmpIdtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Employee ID");
EmpIdtextBox.Focus();
return;
}
if (userNametextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter UserName");
userNametextBox.Focus();
return;
}
if (passwordtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Password");
passwordtextBox.Focus();
return;
}
if (confirmpasswordtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Confirm Passowrd");
confirmpasswordtextBox.Focus();
return;
}
if (passwordtextBox.Text != confirmpasswordtextBox.Text)
{
MessageBox.Show("Password does not match with Confirm Passowrd");
passwordtextBox.Focus();
confirmpasswordtextBox.Focus();
return;
}
query = "SELECT COUNT(*) FROM Employee_Info WHERE UserName = '******'";
if (EmployeeID == 0)
{
if (DbAccess.NumberOfRecords(query) > 0)
{
MessageBox.Show("This username already exists! Please try another username!");
userNametextBox.Focus();
return;
}
}
else
{
if (DbAccess.NumberOfRecords(query) > 1)
{
MessageBox.Show("This username already exists! Please try another username!");
userNametextBox.Focus();
return;
}
}
try
{
if (EmployeeID == 0)
{
query = "INSERT INTO Employee_Info(EmpID,UserName,Password) VALUES(" + EmpIdtextBox.Text + ", '" + userNametextBox.Text + "', '" + passwordtextBox.Text + "')";
}
else
{
query = "UPDATE Employee_Info SET Password = '******' WHERE EmpID = " + EmployeeID;
}
if (DbAccess.ExecuteToDB(query))
{
if (EmployeeID == 0)
{
MessageBox.Show("Saved Successfully!!!");
}
else
{
MessageBox.Show("Updated Successfully!!!");
}
}
else
{
MessageBox.Show("Failed To Save!!!");
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
