private void NewEmployeeSaveButton_Click(object sender, EventArgs e)
{
ArrayList Employee = new ArrayList();
string EmployeeName = NewEmployeeNameTextBox.Text;
string EmployeeAddress = NewEmployeeAddressTextBok.Text;
string EmployeeEmail = NewEmployeeEmailTextBox.Text;
string EmployeeID = NewEmployeeIDTextBox.Text;
string EmployeePassword = NewEmployeePasswordTextBox.Text;
string EmployeeRePassword = NewEmployeeRePasswordTextBox.Text;
string EmployeeUsername = NewEmployeeUsernameTextBox.Text;
string EmployeeGender = "";
Boolean flag = false;
Boolean flag1 = false;
if (MaleEmployee.Checked)
{
EmployeeGender = "Male";
}
if (FemaleEmployee.Checked)
{
EmployeeGender = "Female";
}
Boolean empty = string.IsNullOrEmpty(EmployeeName) || string.IsNullOrEmpty(EmployeeAddress) || string.IsNullOrEmpty(EmployeeEmail) || string.IsNullOrEmpty(EmployeeID) || string.IsNullOrEmpty(EmployeePassword) || string.IsNullOrEmpty(EmployeeRePassword) || string.IsNullOrEmpty(EmployeeUsername) || string.IsNullOrEmpty(EmployeeGender);
string query = "select UserID from Employee where UserID= '" + EmployeeID + "';";
Connection.Open();
Command = new SqlCommand(query, Connection);
SqlDataReader result = Command.ExecuteReader();
while (result.Read())
{
string id = result["UserID"].ToString();
flag = true;
}
Connection.Close();
string query1 = "select UserUsername from Employee where UserUsername= '******';";
Connection.Open();
Command1 = new SqlCommand(query1, Connection);
SqlDataReader result1 = Command1.ExecuteReader();
while (result1.Read())
{
string name = result1["UserUsername"].ToString();
flag1 = true;
}
Connection.Close();
if (empty)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "Please fill all the fields");
}
else if (!EmployeePassword.Equals(EmployeeRePassword))
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "Password not matched");
}
else if (flag)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "ID already exist");
}
else if (flag1)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "Username not available");
}
else
{
Employee.Add(EmployeeID);
Employee.Add(EmployeeName);
Employee.Add(EmployeeEmail);
Employee.Add(EmployeeUsername);
Employee.Add(EmployeeRePassword);
Employee.Add(EmployeeGender);
Employee.Add(EmployeeAddress);
database.InsertNewEmployee(Employee);
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(2))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "Employee Added successfully");
}
EmployeeInformation eq = new EmployeeInformation();
eq.LoadData();
}
