// Insert Problem data into a database
        public bool User_Data_Insert(User_Data D)
        {
            // Create a Default Return
            bool flag = false;

            //  Step 1 : Connecton to database
            SqlConnection conn = new SqlConnection(myconnstring);

            try
            {
                // Step 2 : Create a SQL Query to Insert data
                string sql = "insert into User_Data_Table (Reg_no,Name,Email_Id,Contact_no,Gender,Designation,Problem_Domain) VALUES(@Reg_no,@Name,@Email_Id,@Contact_no,@Gender,@Designation,@Problem_Domain)";

                // Step 3 : Create Sql Command using sql and conn
                SqlCommand cmd = new SqlCommand(sql, conn);

                // Step 4 : Create Parameters to add data
                cmd.Parameters.AddWithValue("@Reg_no", D.Reg_no);
                cmd.Parameters.AddWithValue("@Name", D.Full_name);
                cmd.Parameters.AddWithValue("@Email_Id", D.Email_id);
                cmd.Parameters.AddWithValue("@Contact_no", D.Contact);
                cmd.Parameters.AddWithValue("@Gender", D.Gender);
                cmd.Parameters.AddWithValue("@Designation", D.Designation);
                cmd.Parameters.AddWithValue("@Problem_Domain", D.Problem_Domain);


                // Connection Open Here
                conn.Open();
                int rows = cmd.ExecuteNonQuery();

                // If query runs successfully than the value of rows is grater than zero
                if (rows > 0)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(" Error : " + ex);
            }
            finally
            {
                conn.Close();
            }

            return(flag);
        }
        // Insert Problem data into a database
        public bool Problem_Data_Insert(User_Data D)
        {
            // Create a Default Return
            bool flag = false;

            //  Step 1 : Connecton to database
            SqlConnection conn = new SqlConnection(myconnstring);

            try
            {
                // Step 2 : Create a SQL Query to Insert data
                string sql = "insert into User_Problem_Data_Table (problem_id, User_Reg_no, Referal_Reg_no, Block, Room_no, Problem, Discription, Status) VALUES (@problem_id, @User_Reg_no, @Referal_Reg_no, @Block, @Room_no, @Problem, @Discription, @Status)";

                // Step 3 : Create Sql Command using sql and conn
                SqlCommand cmd = new SqlCommand(sql, conn);

                // Step 4 : Create Parameters to add data
                cmd.Parameters.AddWithValue("@problem_id", Int32.Parse(D.problem_id));
                cmd.Parameters.AddWithValue("@User_Reg_no", D.User_Reg_no);
                cmd.Parameters.AddWithValue("@Referal_Reg_no", D.Referal_Reg_no);
                cmd.Parameters.AddWithValue("@Block", D.Block);
                cmd.Parameters.AddWithValue("@Room_no", D.Room_no);
                cmd.Parameters.AddWithValue("@Problem", D.Problem);
                cmd.Parameters.AddWithValue("@Discription", D.Discription);
                cmd.Parameters.AddWithValue("@Status", D.Status);

                // Connection Open Here
                conn.Open();
                int rows = cmd.ExecuteNonQuery();

                // If query runs successfully than the value of rows is grater than zero
                if (rows > 0)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(" Error : " + ex);
            }
            finally
            {
                conn.Close();
            }

            return(flag);
        }