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(); }