private void button3_Click(object sender, EventArgs e) { if (raportId != 0) { file.IncarcaHeader(); file.CreazaBonPdf(); } else { MessageBox.Show("Selectati o inregistrare pentru a fi printat documentul"); } }
private void buttonPrintTicet_Click(object sender, EventArgs e) { #region Adaugare Furnizor { string sqlf = "SELECT COUNT(*) FROM Furnizori WHERE ID_furnizor = '" + textBoxCifF.Text + textBoxAdresaF.Text + "' "; SqlCommand cmdf = new SqlCommand(sqlf, con); con.Open(); int valoaref = Convert.ToInt32(cmdf.ExecuteScalar()); con.Close(); if (valoaref == 0) { f.Nume = textBoxFurnizor.Text; f.Adresa = textBoxAdresaF.Text; f.Cod_fiscal = textBoxCifF.Text; bool success1 = fdal.Insert(f, con); if (success1 == true) { MessageBox.Show("Furnizorul a fost adaugat"); autocompleteFurnizori(); } else { MessageBox.Show("Nu s a putut adauga furnizor"); } } } #endregion #region Adaugare Client { string sqlc = "SELECT COUNT(*) FROM Clienti WHERE ID_client = '" + textBoxCifC.Text + textBoxAdresaC.Text + "' "; SqlCommand cmdc = new SqlCommand(sqlc, con); con.Open(); int valoarec = Convert.ToInt32(cmdc.ExecuteScalar()); con.Close(); if (valoarec == 0) { c.Nume = textBoxClient.Text; c.Adresa = textBoxAdresaC.Text; c.Cod_fiscal = textBoxCifC.Text; bool success2 = cdal.Insert(c, con); if (success2 == true) { MessageBox.Show("Clientul a fost adaugat"); autocompleteFurnizori(); } else { MessageBox.Show("Nu s a putut adauga Client"); } } } #endregion #region Adaugare Produs string sqlp = "SELECT COUNT(*) FROM Produse WHERE ID_produs = '" + textBoxTipProdus.Text + textBoxLot.Text + "' "; SqlCommand cmdp = new SqlCommand(sqlp, con); con.Open(); int valoarep = Convert.ToInt32(cmdp.ExecuteScalar()); con.Close(); if (valoarep == 0) { p.Cod = textBoxCodP.Text; p.Nume = textBoxTipProdus.Text; p.Natura = textBoxProdus.Text; p.Lot = textBoxLot.Text; p.DataExpirare = textBoxDataExp.Text; bool success4 = pdal.Insert(p, con); if (success4 == true) { MessageBox.Show("Produsul a fost adaugat"); autocompleteProduse(); } else { MessageBox.Show("Nu s a putut adauga produs"); } } #endregion #region Creare raport r.Cod_produs = textBoxTipProdus.Text + textBoxLot.Text; r.Cod_client = textBoxCifC.Text + textBoxAdresaC.Text; r.Cod_furnizor = textBoxCifF.Text + textBoxAdresaF.Text; r.Greutate_NET = float.Parse(textBoxGreutateNet.Text); r.DataTimpI = DateTime.Now; file.DataTichet = (DateTime.Now).ToString(); DataTable dt1; dt1 = bdal.Select(con); int numar0 = int.Parse(dt1.Rows[0].ItemArray[0].ToString()); int numar_bonuri = int.Parse(dt1.Rows[0].ItemArray[1].ToString()); r.Numar_bon = numar0 + numar_bonuri; // file.NrTichet = (numar0 + numar_bonuri).ToString(); // numar_bonuri++; b.Bonuri_printate = numar_bonuri; b.Primul_bon = numar0; bool success3 = bdal.Update(b, con); #region INSERT IN RAPOARTE bool success = rdal.Insert(r, con); if (success == true) { MessageBox.Show("Raport creat cu succes"); ParseTextBox(); file.IncarcaHeader(); file.CreazaBonPdf(); //de verificat cand o sa printez tichet Clear(); } else { MessageBox.Show("Nu s a putut crea"); } con.Close(); #endregion #endregion }