private void button2_Click_1(object sender, EventArgs e)
{
//fields checker
if (firstName.Text.Equals("") || lastName.Text.Equals("") || dateOfBirth.Text.Equals("") || joiningDate.Text.Equals("") || comboJobTitle.Text.Equals("") || comboJobType.Text.Equals("") || mailAddress.Text.Equals("") || comboGender.Text.Equals("") || comboBloodGroup.Text.Equals("") || Nationality.Text.Equals(""))
{
MessageBox.Show("You Must Enter all Mandatory Fields..!");
}
else
{
string fName = firstName.Text;
string mName = middleName.Text;
string lName = lastName.Text;
string dob = dateOfBirth.Text;
string joinDate = joiningDate.Text;
string jobtitle = comboJobTitle.Text;
string mail = mailAddress.Text;
string gender = comboGender.Text;
string bloodGrp = comboBloodGroup.Text;
string natinality = Nationality.Text;
string jType = comboJobType.Text;
string phone = phoneTextBox.Text;
string query = String.Format("insert into Employee values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}')", this.id.Text, fName, mName, lName, dob, gender, joinDate, null, natinality, null, null, null, bloodGrp, mail, null, jobtitle, null, null, null, jType, phone, null);
int result = DataAccess.ExecuteSQL(query);
if (result == 2627)
{
MessageBox.Show("Employee ID Already Exists...!");
}
else if (result > 0)
{
MessageBox.Show("Employee Added");
AddEmployeeHelper.increaseIdCounter();
this.updateGrideViews();
{
//add ligin info
this.button7_Click(sender, e);
}
{
//backup Data store
string query2 = String.Format("insert into Employee values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}')", this.id.Text, fName, mName, lName, dob, gender, joinDate, null, natinality, null, null, null, bloodGrp, mail, null, jobtitle, null, null, null, jType, phone, null);
DataAccess.ExecuteSQL(query2);
}
}
else
{
MessageBox.Show("Failed To Add Employee...!");
}
}
}
public AddEmployee()
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
this.panel3.Hide();
this.id.Enabled = false;
this.loginUserName.Enabled = false;
this.button7.Visible = false;//login details add button
this.dataGridViewEducationalInfo.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dataGridViewExperience.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dataGridViewSkill.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dataGridViewUpdate.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.id.Text = AddEmployeeHelper.idGenerator();
this.loginUserName.Text = AddEmployeeHelper.idGenerator();
}
