示例#1
0
        public bool rutTien(TextBox txtTien)
        {
            SqlCommand cmd = new SqlCommand("sp_RutTien");

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@tien", SqlDbType.Money).Value        = Convert.ToDecimal(txtTien.Text);
            cmd.Parameters.Add("@soTk", SqlDbType.NVarChar, 20).Value = GlobalVariable.sotaikhoan;

            bool re = m_dangnhap.ExecuteNonQuery(cmd);

            return(re);
        }
示例#2
0
        public bool changePassword(TextBox txtNewPass)
        {
            SqlCommand cmd = new SqlCommand("sp_ChangePassword");

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@newPass", SqlDbType.NVarChar, 20).Value = txtNewPass.Text;
            cmd.Parameters.Add("@soTk", SqlDbType.NVarChar, 20).Value    = GlobalVariable.sotaikhoan;

            bool rs = m_ketnoi.ExecuteNonQuery(cmd);

            return(rs);
        }