Hi guys am having a logical error here. Want to add the informaion to database,It catches the duplicate primary key record but still it adds the record anyway
Below is the event for adding the information to database
private void btnInsert_Click(object sender, EventArgs e)
{
char placeholder = '-';
string textStrng;
string var = txtFName.Text;
if (txtFName.Text=="")
{
MessageBox.Show("Please enter your name.",
"Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtFName.Focus();
txtFName.BackColor = Color.Moccasin;
}
else if (txtPassword.Text != txtRepassword.Text)
{
MessageBox.Show("Password missmatch",
"Error Password", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPassword.Focus();
txtPassword.BackColor = Color.Moccasin;
txtRepassword.BackColor = Color.Moccasin;
}
else
{
int sequence = 0;
try
{
newVar = var.Remove(3);
textStrng = newVar.ToUpper().ToString() + placeholder + 0 + sequence+1;
txtUserID.Text = textStrng.ToString();
users = new ClsUsers(Convert.ToString(txtFName.Text), Convert.ToString(txtLName.Text), Convert.ToString(txtUserID.Text),
Convert.ToString(txtEmail.Text), Convert.ToString(txtUsername.Text), Convert.ToString(txtPassword.Text),
Convert.ToString(txtRightsName.Text), Convert.ToString(txtDescription.Text));
bl.InsertUser(users);
sequence++;
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtFName.Focus();
txtFName.BackColor = Color.Moccasin;
}
MessageBox.Show("Added succsessfuly.\n\n" + "UserID: " + txtUserID.Text + "\nName: " + txtFName.Text + "\nSurname: " + txtLName.Text + "\nEmail: " + txtEmail.Text,
"Insert", MessageBoxButtons.OK, MessageBoxIcon.Information);
clearTextBoxes();
txtFName.Focus();
}
}
Below is the method to insert
#region Insert
public void InsertUser(ClsUsers users)
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand("procInsertUserInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@fName", SqlDbType.NVarChar, 20));
cmd.Parameters["@fName"].Value = users.FName;
cmd.Parameters.Add(new SqlParameter("@lname", SqlDbType.NVarChar, 50));
cmd.Parameters["@lname"].Value = users.SName;
cmd.Parameters.Add(new SqlParameter("@userID", SqlDbType.NVarChar, 7));
cmd.Parameters["@userID"].Value = users.UserID;
cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50));
cmd.Parameters["@email"].Value = users.Email;
cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 20));
cmd.Parameters["@username"].Value = users.Username;
cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 25));
cmd.Parameters["@password"].Value = users.Password;
cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 20));
cmd.Parameters["@name"].Value = users.RightName;
cmd.Parameters.Add(new SqlParameter("@desc", SqlDbType.NVarChar, 100));
cmd.Parameters["@desc"].Value = users.Desc;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception exp)
{
throw new ApplicationException(exp.Message);
}
}
}