private void btnSave_Click(object sender, EventArgs e) { string insertQuery = "INSERT INTO tblEmployees(FirstName, MiddleName, LastName, PositionID, " + "BDate, Gender, HomeAddress, TelNo, MobileNo, EmailAddress)" + "VALUES('" + txtFirstName.Text + "','" + txtMiddleName.Text + "'," + "'" + txtLastName.Text + "','" + getPositionID(cmbPosition.Text) + "'," + "'" + Convert.ToDateTime(dtBDate.Text).ToString("yyyy/MM/dd") + "'," + "'" + cmbGender.Text + "','" + txtAddress.Text + "','" + txtTelephoneNo.Text + "'," + "'" + txtMobileNo.Text + "', '" + txtEmailAddress.Text + "'); "; DialogResult res = MessageBox.Show("Are you sure you want to save a new employee?", "Save Employee", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (res == DialogResult.Yes) { int result = utilities.RunSQLCommand(insertQuery); if (result > 0) { MessageBox.Show("New Employee added.", "Add Employee", MessageBoxButtons.OK, MessageBoxIcon.Information); frmShowEmployees.isNewEmployeeAdded = true; this.Close(); } else { MessageBox.Show("There is a problem saving a new employee.", "Add Employee", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void btnSave_Click(object sender, EventArgs e) { if (txtPositionName.Text.Trim().Equals("")) { MessageBox.Show("Please enter position name.", "Add Position", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { string query = "INSERT into tblPosition(PositionName)" + "VALUES('" + txtPositionName.Text + "')"; int result = utilities.RunSQLCommand(query); if (result > 0) { MessageBox.Show("New Position Name Added Successfully!", "Add Position", MessageBoxButtons.OK, MessageBoxIcon.Information); txtPositionName.Text = ""; }else { MessageBox.Show("There is a problem saving a new Position", "Add Position", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } }