Check for Duplicate Records Insert in Database and display error message in Windows Forms Application

Code

 private void btnSaveDetails_Click(object sender, EventArgs e)
        {
            this.SaveUserDetails();
        }

        private void SaveUserDetails()
        {
            bool IsAvailable = false;
            using (SqlConnection con = new SqlConnection(@"data source=192.168.0.1\SQL2005;Database=Sample;User Id=sa;Password=pass@123;"))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "SaveEmployeeDetails";
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@EmpRollNo", this.txtRollNo.Text.Trim());
                    cmd.Parameters.AddWithValue("@EmpName", this.txtName.Text.Trim());
                    cmd.Parameters.AddWithValue("@EmpCompName", this.txtCompName.Text.Trim());
                    con.Open();
                    IsAvailable = Convert.ToBoolean(cmd.ExecuteScalar());
                    if (IsAvailable)
                    {
                        MessageBox.Show("Record Of Particular Member Already Inserted");
                    }
                    con.Close();
                }
            }
        }

SQL Code

CREATE PROCEDURE SaveEmployeeDetails
@EmpRollNo VARCHAR(50)
,@EmpName VARCHAR(50)
,@EmpCompName VARCHAR(50)
AS
BEGIN	
	SET NOCOUNT ON;
	DECLARE @IsAvailable BIT;
	IF EXISTS(SELECT emp_roll_no
			  FROM Employees
			  WHERE emp_name = @EmpName
			  OR emp_roll_no = @EmpRollNo)
	BEGIN
	SET @IsAvailable = 1
	END
	ELSE
	BEGIN
		SET @IsAvailable = 0
		INSERT INTO Employees(emp_roll_no,emp_name,emp_comp_name) VALUES(@EmpRollNo,@EmpName,@EmpCompName)
	END	
	SELECT @IsAvailable
END
GO

Namespaces

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;