// Chạy được
        public bool InsertBangDia(string tieuDeCD, int maTL, int namSanXuat, string quocGia, int soLuong, int maNCC, decimal giaNhap, decimal giaThue)
        {
            string query = string.Format("INSERT INTO dbo.[DiaCD](TieuDeCD, MaTL, NamSanXuat, QuocGia, SoLuong, MaNCC, GiaNhap, GiaThue)" +
                "Values (N'{0}', {1}, {2}, N'{3}', {4}, {5}, {6}, {7})", tieuDeCD, maTL, namSanXuat, quocGia, soLuong, maNCC, giaNhap, giaThue);
            int resual = DataProvider.Instance.ExecuteNonQuery(query);
            return resual > 0;
        }



//Không chạy đc
        public bool InsertBangDia2(BangDia CD)
        {
            string query = string.Format("INSERT INTO dbo.[DiaCD](TieuDeCD, MaTL, NamSanXuat, QuocGia, SoLuong, MaNCC, GiaNhap, GiaThue)" +
                "Values (N'{0}', {1}, {2}, N'{3}', {4}, {5}, {6}, {7})", CD.TieuDeCD, CD.MaTL, CD.NamSanXuat, CD.QuocGia, CD.SoLuong, CD.MaNCC, CD.GiaNhap, CD.GiaThue);
            int resual = DataProvider.Instance.ExecuteNonQuery(query);
            return resual > 0;
        }