อยากทราบวิธีการใช้ transactionscope ใน C# หน่อยครับ

private void insertInto()
        {
            
            string sql = "insert into customer (customer_id,customer_name) values(@customer_id, @customer_name)";
            SqlTransaction ts = conn.BeginTransaction();
            cmd = new SqlCommand(sql,conn);
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@customer_id",txtCus_id.Text.Trim());
            cmd.Parameters.AddWithValue("@customer_name", txtCus_name.Text.Trim());
            cmd.Transaction = ts;
            int rowaffected = 0;
            rowaffected = cmd.ExecuteNonQuery();
            if (rowaffected > 0)
            {
                ts.Commit();
                string sql_sale = "insert into sale (sale_id,sale_number,date,customer_id) values(@sale_id,@sale_number,@date,@customer_id)";
                ts = conn.BeginTransaction();
                cmd = new SqlCommand(sql_sale,conn);
                cmd.Parameters.AddWithValue("@sale_id", txtSale_id.Text.Trim());
                cmd.Parameters.AddWithValue("@sale_number", txtSale_number.Text.Trim());
                cmd.Parameters.AddWithValue("@date", Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString()));
                cmd.Parameters.AddWithValue("@customer_id", txtCus_id.Text.Trim());
                cmd.Transaction = ts;
                int rowaffected1 = 0;
                rowaffected1 = cmd.ExecuteNonQuery();
                if (rowaffected1 > 0)
                {
                    ts.Commit();
                    string sql_detail = "insert into detail(detail_id,product_name) values(@detail_id,@product_name)";
                    ts = conn.BeginTransaction();
                    cmd = new SqlCommand(sql_detail,conn);
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@detail_id", txtSale_id.Text.Trim());
                    cmd.Parameters.AddWithValue("@product_name", txtProduct_name.Text.Trim());
                    cmd.Transaction = ts;
                    int rowaffected2 = 0;
                    rowaffected2 = cmd.ExecuteNonQuery();
                    if (rowaffected2 > 0)
                    {
                        ts.Commit();
                    }
                    else {
                        ts.Rollback();
                    }                      
                }
                else {
                    ts.Rollback();
                    
                }
            }
            else {
                ts.Rollback();
            }
            queryDB();
        }

private void insertInto()
        {
            ts = conn.BeginTransaction(IsolationLevel.ReadCommitted);
            try
            {
                string sql = "insert into customer (customer_id,customer_name) values(@customer_id, @customer_name)";
                cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@customer_id", txtCus_id.Text);
                if (txtProduct_name.Text != "")
                {
                    cmd.Parameters.AddWithValue("@customer_name", txtCus_name.Text);
                }
                cmd.Transaction = ts;
                cmd.ExecuteNonQuery();
                //MessageBox.Show("cus");

                string sql_sale = "insert into sale (sale_id,sale_number,date,customer_id) values(@sale_id,@sale_number,@date,@customer_id)";
                cmd = new SqlCommand(sql_sale, conn);
                cmd.Parameters.AddWithValue("@sale_id", id);
                if (txtSale_number.Text != "")
                {
                    cmd.Parameters.AddWithValue("@sale_number", txtSale_number.Text);
                }
                cmd.Parameters.AddWithValue("@date", Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString()));
                if (txtCus_id.Text != "")
                {
                    cmd.Parameters.AddWithValue("@customer_id", txtCus_id.Text);
                }
                cmd.Transaction = ts;
                cmd.ExecuteNonQuery();
                //MessageBox.Show("sale");
                string sql_detail = "insert into detail(detail_id,product_name) values(@detail_id,@product_name)";
                cmd = new SqlCommand(sql_detail, conn);
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@detail_id", id);
                if (txtProduct_name.Text != "")
                {
                    cmd.Parameters.AddWithValue("@product_name", txtProduct_name.Text);
                }
                cmd.Transaction = ts;
                cmd.ExecuteNonQuery();
                //MessageBox.Show("detail");

                for (int i = 0; i < dataGridView1.RowCount - 1; i++)
                {
                    string sql_1 = "insert into invoice(invoice_id,customer_id,customer_name,sale_id,sale_number,date)";
                    sql_1 += " values(@invoice_id,@customer_id,@customer_name,@sale_id,@sale_number,@date)";
                    cmd = new SqlCommand(sql_1, conn);
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@invoice_id", dataGridView1.Rows[i].Cells[2].Value.ToString());
                    cmd.Parameters.AddWithValue("@customer_id", dataGridView1.Rows[i].Cells[0].Value.ToString());
                    cmd.Parameters.AddWithValue("@customer_name", dataGridView1.Rows[i].Cells[1].Value.ToString());
                    cmd.Parameters.AddWithValue("@sale_id", dataGridView1.Rows[i].Cells[2].Value.ToString());
                    cmd.Parameters.AddWithValue("@sale_number", dataGridView1.Rows[i].Cells[3].Value.ToString());
                    cmd.Parameters.AddWithValue("@date", Convert.ToDateTime(dataGridView1.Rows[i].Cells[4].Value.ToString()));
                    cmd.Transaction = ts;
                    cmd.ExecuteNonQuery();
                 }
                 ts.Commit();
                 queryDB();
            }
            catch {
                ts.Rollback();
                MessageBox.Show("ไม่สามารถบันทึกข้อมูลได้");
            }
        }