public static bool SuaVaiTro(VaiTroDTO vt)
{
DataProvider p = new DataProvider();
p.Connect();
SqlParameter p0 = new SqlParameter("@MaVaiTro", SqlDbType.Int)
{
Value = vt.MaVaiTro
};
SqlParameter p1 = new SqlParameter("@Ten", SqlDbType.NVarChar, 255)
{
Value = vt.Ten
};
SqlParameter p2 = new SqlParameter("@PhanQuyen", SqlDbType.Bit)
{
Value = vt.PhanQuyen
};
SqlParameter p3 = new SqlParameter("@DoiMatKhau", SqlDbType.Bit)
{
Value = vt.DoiMatKhau
};
SqlParameter p4 = new SqlParameter("@NhatKyHeThong", SqlDbType.Bit)
{
Value = vt.NhatKyHeThong
};
SqlParameter p5 = new SqlParameter("@SaoLuu", SqlDbType.Bit)
{
Value = vt.SaoLuu
};
SqlParameter p6 = new SqlParameter("@PhucHoi", SqlDbType.Bit)
{
Value = vt.PhucHoi
};
SqlParameter p7 = new SqlParameter("@KhuVuc", SqlDbType.Bit)
{
Value = vt.KhuVuc
};
SqlParameter p8 = new SqlParameter("@KhachHang", SqlDbType.Bit)
{
Value = vt.KhachHang
};
SqlParameter p9 = new SqlParameter("@NhaCungCap", SqlDbType.Bit)
{
Value = vt.NhaCungCap
};
SqlParameter p10 = new SqlParameter("@KhoHang", SqlDbType.Bit)
{
Value = vt.KhoHang
};
SqlParameter p11 = new SqlParameter("@DonViTinh", SqlDbType.Bit)
{
Value = vt.DonViTinh
};
SqlParameter p12 = new SqlParameter("@NhomHang", SqlDbType.Bit)
{
Value = vt.NhomHang
};
SqlParameter p13 = new SqlParameter("@HangHoa", SqlDbType.Bit)
{
Value = vt.HangHoa
};
SqlParameter p14 = new SqlParameter("@TyGia", SqlDbType.Bit)
{
Value = vt.TyGia
};
SqlParameter p15 = new SqlParameter("@BoPhan", SqlDbType.Bit)
{
Value = vt.BoPhan
};
SqlParameter p16 = new SqlParameter("@NhanVien", SqlDbType.Bit)
{
Value = vt.NhanVien
};
SqlParameter p17 = new SqlParameter("@MuaHang", SqlDbType.Bit)
{
Value = vt.MuaHang
};
SqlParameter p18 = new SqlParameter("@BanHang", SqlDbType.Bit)
{
Value = vt.BanHang
};
SqlParameter p19 = new SqlParameter("@TonKho", SqlDbType.Bit)
{
Value = vt.TonKho
};
SqlParameter p20 = new SqlParameter("@ChuyenKho", SqlDbType.Bit)
{
Value = vt.ChuyenKho
};
SqlParameter p21 = new SqlParameter("@ThuTien", SqlDbType.Bit)
{
Value = vt.ThuTien
};
SqlParameter p22 = new SqlParameter("@TraTien", SqlDbType.Bit)
{
Value = vt.TraTien
};
SqlParameter p23 = new SqlParameter("@BaoCaoKhohang", SqlDbType.Bit)
{
Value = vt.BaoCaoKhoHang
};
SqlParameter p24 = new SqlParameter("@BaoCaoBanHang", SqlDbType.Bit)
{
Value = vt.BaoCaoBanHang
};
int n = p.ExecuteNonQuery("sp_SuaVaiTro", CommandType.StoredProcedure, p0, p1, p2, p3, p4, p5, p6, p7,
p8, p9, p10, p11, p12, p13, p14, p15, p16, p17,
p18, p19, p20, p21, p22, p23, p24);
p.Disconnect();
if (n == 0)
{
return(false);
}
return(true);
}
