private void TxtCompany_OnKeyDown(object sender, KeyRoutedEventArgs e)
{
if (e.Key == VirtualKey.Enter)
{
TxtEmailAddress.Focus(FocusState.Programmatic);
e.Handled = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtIDNUMBER.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
txtIDNUMBER.Focus();
}
else if (TxtFirstName.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
TxtFirstName.Focus();
}
else if (TxtLastName.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
TxtLastName.Focus();
}
else if (TxtMiddleName.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
TxtLastName.Focus();
}
else if (TxtEmailAddress.Text == "")
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
TxtEmailAddress.Focus();
}
else if (cboPOstion.SelectedValue.ToString() == "")//Nothing selected
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
cboPOstion.Focus();
}
else if (cboDepartments.SelectedValue.ToString() == "")//Nothing selected
{
MessageBox.Show("This field is required!.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
cboDepartments.Focus();
}
else
{
string StringReturn = "";
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TRAN_SAVEWORKER";
cmd.Parameters.Add("@IDRef", SqlDbType.VarChar, 15).Value = txtIDNUMBER.Text.ToString();
cmd.Parameters.Add("@Lastname", SqlDbType.VarChar, 100).Value = TxtLastName.Text.ToString();
cmd.Parameters.Add("@Firstname", SqlDbType.VarChar, 100).Value = TxtFirstName.Text.ToString();
cmd.Parameters.Add("@MidName", SqlDbType.VarChar, 100).Value = TxtMiddleName.Text.ToString();
cmd.Parameters.Add("@EmailAddress", SqlDbType.VarChar, 100).Value = TxtEmailAddress.Text.ToString();
cmd.Parameters.Add("@DesignationCode", SqlDbType.VarChar, 4).Value = cboPOstion.SelectedValue.ToString();
cmd.Parameters.Add("@DeptCode", SqlDbType.VarChar, 15).Value = cboDepartments.SelectedValue.ToString();
cmd.Connection = con;
try
{
con.Open();
StringReturn = cmd.ExecuteScalar().ToString();
if (StringReturn == "EXISTS")
{
MessageBox.Show("ID Number Already Exists", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
}
if (StringReturn == "DONE")
{
MessageBox.Show("Record Saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
UserMaintainance um = new UserMaintainance();
um.Show();
this.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
}
