save data from a winfrom in to database

See more:

C#

MS-Access

On a form a have a button ho save data in the database, is ok to save data on a pres the button in 2 or 3 table in my data base, is ok the sintax i have.

private void btnVinde_Click(object sender, EventArgs e)
        {
            if (lblShared.Text == "1") { MessageBox.Show("Acest produse a fost vandut deja.", "Eroare.."); return; }
            if (txtVandutCu.Text.Trim().Length == 0) { MessageBox.Show("Nu ați introdus prețul de vâmzare.", "Datele introduse sunt incomplete."); return; }
            if (txtNumeComplet.Text.Trim().Length == 0) { MessageBox.Show("Selectați numele clientul pentru a putea vinde produsul.", "Datele introduse sunt incomplete."); return; }
            if (lblOperatie.Text == "1")
            {
                if (txtBonFiscal.Text.Trim().Length == 0)
                {
                    MessageBox.Show("Nu ați introdus numărului bonului fiscal.", "Datele introduse sunt incomplete."); return;
                }
            }

            if (lblOperatie.Text == "1")
            {
                Program.Connection.CommandText = "insert into IesiriProduse(NrContract,DescriereProdus,NrNir,PretIesire,DataIesire) values (@NrContract,@DescriereProdus,@NrNir,@PretIesire,@DataIesire)";

                Program.Connection.AddParameter("@NrContract", txtCodProdus.Text);
                Program.Connection.AddParameter("@DescriereProdus", lblDescriereProdus.Text + ", Vândut cu bon fiscal nr. " + txtBonFiscal.Text + ", Conform contract nr. " + txtCodProdus.Text);
                Program.Connection.AddParameter("@NrNir", lblNrNir.Text);
                Program.Connection.AddParameter("@PretIesire", txtVandutCu.Text);
                Program.Connection.AddParameter("@DataIesire", DateTime.Now.ToString("dd.MM.yyyy"));
                Program.Connection.ExecuteNonQuery();
            
            }

            Program.Connection.CommandText = "update ProduseAmanet set CodClient=@CodClient, Shared=@Shared  where IDProdus=" + CID;
            Program.Connection.AddParameter("@CodClient", lblCodClient.Text);
            Program.Connection.AddParameter("@Shared", Convert.ToInt32(1));
            Program.Connection.ExecuteNonQuery();



            Program.Connection.CommandText = "insert into ProduseVandute(IDProdus,IDClient,VandutDe,LaDataDe,LaOra,VandutCu,UserID,DescriereProdus,ContractNumar,PretAchizitie,SerialProdus,BonFiscal,AchizitiaLui,AlteInformatii) values (@IDProdus,@IDClient,@VandutDe,@LaDataDe,@LaOra,@VandutCu,@UserID,@DescriereProdus,@ContractNumar,@PretAchizitie,@SerialProdus,@BonFiscal,@AchizitiaLui,@AlteInformatii)";
            Program.Connection.AddParameter("@IDProdus", lblCodProdus.Text);
            Program.Connection.AddParameter("@IDClient", lblCodClient.Text);
            Program.Connection.AddParameter("@VandutDe", txtVandutDe.Text);
            Program.Connection.AddParameter("@LaDataDe",txtDataVanzare.Text);
            Program.Connection.AddParameter("@LaOra", txtOra.Text);
            Program.Connection.AddParameter("@VandutCu", txtVandutCu.Text);
            Program.Connection.AddParameter("@UserID", UserID);
            Program.Connection.AddParameter("@DescriereProdus", lblDescriereProdus.Text);
            Program.Connection.AddParameter("@ContractNumar", txtCodProdus.Text);
            Program.Connection.AddParameter("@PretAchizitie", lblPretAchiztie.Text);
            Program.Connection.AddParameter("@SerialProdus", txtSerialProdus.Text);
            Program.Connection.AddParameter("@BonFiscal", txtBonFiscal.Text);
            Program.Connection.AddParameter("@AchizitiaLui", lblAchizitielui.Text);
            Program.Connection.AddParameter("@AlteInformatii", txtAlteInformatii.Text);
            

            Program.Connection.ExecuteNonQuery();


            this.Close();



            //Create the object person and assign the values
            CertificatGarantie DateGarantie = new CertificatGarantie();
            DateGarantie.Name = txtNumeComplet.Text;
            DateGarantie.ContractCod = txtCodProdus.Text;
            DateGarantie.Country = txtDataVanzare.Text;
            DateGarantie.Email = lblAdresaClient.Text;
            DateGarantie.isSerialProdus = txtSerialProdus.Text;



            DateGarantie.DescriereProdus = lblDescriereProdus.Text;
            DateGarantie.IsMale = txtGarantieZile.Text;
            DateGarantie.isRetail = txtRetur.Text;
            DateGarantie.isUM = txtCantitate.Text;

            //Create the object Report and assign object to report
            HTMLReport html = new HTMLReport();
            //Assign the template file 
            html.Template = "SablonGarantie.htm";
            //Asign the new file name
            html.FileName = DateGarantie.Name;
            //Generate the new Page and open it. It uses default browser
            System.Diagnostics.Process.Start(html.Generate(DateGarantie));

        }