public int DeleteUser(string id)
        {
            userparameters u = new userparameters();

            cmd.CommandText = "user_delete";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue(u.id, id);
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            int r = cmd.ExecuteNonQuery();

            con.Close();
            return(r);
        }
        public int PutUser(user_manager _u, string _id)
        {
            userparameters u = new userparameters();

            cmd.CommandText = "user_update";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue(u.id, _id);
            cmd.Parameters.AddWithValue(u.email, _u.p_email);
            cmd.Parameters.AddWithValue(u.f_name, _u.p_f_name);
            cmd.Parameters.AddWithValue(u.l_address, _u.p_l_address);
            cmd.Parameters.AddWithValue(u.l_name, _u.p_l_name);
            cmd.Parameters.AddWithValue(u.m_name, _u.p_m_name);
            cmd.Parameters.AddWithValue(u.p_address, _u.p_p_address);
            cmd.Parameters.AddWithValue(u.phone, _u.p_phone);
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            int r = cmd.ExecuteNonQuery();

            con.Close();
            return(r);
        }