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); }
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); }