public int ThemChuyenMuc(ChuyenMuc obj)
        {
            SqlParameter tcm = new SqlParameter("@TenChuyenMuc", obj.TenChuyenMuc);
            SqlParameter mt  = new SqlParameter("@MoTa", obj.MoTa);
            SqlParameter tt  = new SqlParameter("@TrangThai", obj.TrangThai);

            SqlParameter[] sqlParams = { tcm, mt, tt };
            return(dl.SaveChanges("INSERT INTO [dbo].[tblChuyenMuc]([TenChuyenMuc],[MoTa],[TrangThai]) VALUES(@TenChuyenMuc,@MoTa,@TrangThai)", sqlParams));
        }
        public int SuaChuyenMuc(ChuyenMuc obj)
        {
            SqlParameter mcm = new SqlParameter("@MaChuyenMuc", obj.MaChuyenMuc);
            SqlParameter tcm = new SqlParameter("@TenChuyenMuc", obj.TenChuyenMuc);
            SqlParameter mt  = new SqlParameter("@MoTa", obj.MoTa);
            SqlParameter tt  = new SqlParameter("@TrangThai", obj.TrangThai);

            SqlParameter[] sqlParams = { mcm, tcm, mt, tt };
            return(dl.SaveChanges("UPDATE tblChuyenMuc SET TenChuyenMuc = @TenChuyenMuc, MoTa = @MoTa, TRangThai = @TrangThai WHERE MaChuyenMuc = @MaChuyenMuc", sqlParams));
        }