private void Refresh() { dataGridView1.Rows.Clear(); DataAcess da = new DataAcess(); SqlConnection conn = da.getConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * from tblReprodukcija where FMajka = '" + tbSifra.Text + "' order by OsemenuvanjeDatum asc"); cmd.Connection = conn; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string Zensko = reader["FMajka"].ToString(); string Masko = reader["MTatko"].ToString(); string Osemena = reader["OsemenuvanjeDatum"].ToString(); bool Kontrola = Boolean.Parse(reader["Kontrola"].ToString()); string Oprasena = reader["OprasuvanjeDatum"].ToString(); string KontrolaDatum = reader["KontrolaDatum"].ToString(); float Rodeni = 0; if (reader["ZivoRodeniPrasinja"].ToString().Length != 0) { Rodeni = float.Parse(reader["ZivoRodeniPrasinja"].ToString()); } float MrtvoRodeni = 0; if (reader["MrtvoRodeniPrasinja"].ToString().Length != 0) { MrtvoRodeni = float.Parse(reader["MrtvoRodeniPrasinja"].ToString()); } float Nevitalni = 0; if (reader["NevitalniPrasinja"].ToString().Length != 0) { Nevitalni = float.Parse(reader["NevitalniPrasinja"].ToString()); } string Odbivanje = reader["OdbivanjeDatum"].ToString(); float OdbieniPrasinja = 0; if (reader["OdbieniPrasinja"].ToString() != "") { OdbieniPrasinja = float.Parse(reader["OdbieniPrasinja"].ToString()); } int n = dataGridView1.Rows.Add(); dataGridView1.Rows[n].Cells[0].Value = Zensko; dataGridView1.Rows[n].Cells[1].Value = Masko; dataGridView1.Rows[n].Cells[2].Value = Osemena; dataGridView1.Rows[n].Cells[3].Value = KontrolaDatum; dataGridView1.Rows[n].Cells[4].Value = Kontrola; dataGridView1.Rows[n].Cells[5].Value = Oprasena; dataGridView1.Rows[n].Cells[6].Value = Rodeni; dataGridView1.Rows[n].Cells[7].Value = MrtvoRodeni; dataGridView1.Rows[n].Cells[8].Value = Nevitalni; dataGridView1.Rows[n].Cells[9].Value = Odbivanje; dataGridView1.Rows[n].Cells[10].Value = OdbieniPrasinja; //listBox1.Items.Add(new Reproduction(Zensko, Masko, Osemena, Kontrola, KontrolaDatum, Oprasena, Rodeni, MrtvoRodeni, Nevitalni, Odbivanje, OdbieniPrasinja).ToString()); } conn.Close(); }
public DvizenjeForm() { InitializeComponent(); DA = new DataAcess(); SqlConnection conn = DA.getConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("Select Top 1 * from tblDvizenje where ID = '1'"); cmd.Connection = conn; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { textBox3.Text = reader["Priem"].ToString(); } conn.Close(); conn.Open(); cmd = new SqlCommand("Select Top 1 * from tblDvizenje where ID = '2'"); cmd.Connection = conn; reader = cmd.ExecuteReader(); while (reader.Read()) { textBox4.Text = reader["Priem"].ToString(); } conn.Close(); conn.Open(); cmd = new SqlCommand("Select Top 1 * from tblDvizenje where ID = '3'"); cmd.Connection = conn; reader = cmd.ExecuteReader(); while (reader.Read()) { textBox5.Text = reader["Priem"].ToString(); } conn.Close(); }
public IzvestajZadaci() { InitializeComponent(); DataAcess da = new DataAcess(); SqlConnection conn = da.getConnection(); List <String> aktivni = new List <string>(); conn.Open(); SqlCommand cmd = new SqlCommand("Select FMajka From tblOS Where Aktivno = 1"); cmd.Connection = conn; SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { aktivni.Add(reader["FMajka"].ToString()); //listBoxKontrola.Items.Add(reader["FMajka"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); } for (int i = 0; i < aktivni.Count; i++) { cmd = new SqlCommand("SELECT Top 1 * From tblReprodukcija Where FMajka = '" + aktivni[i] + "' order by OsemenuvanjeDatum desc"); cmd.Connection = conn; reader = cmd.ExecuteReader(); try { while (reader.Read()) { string Zensko = reader["FMajka"].ToString(); string Masko = reader["MTatko"].ToString(); string Osemena = reader["OsemenuvanjeDatum"].ToString(); string KontrolaDatum = reader["KontrolaDatum"].ToString(); bool Kontrola = Boolean.Parse(reader["Kontrola"].ToString()); string Oprasena = reader["OprasuvanjeDatum"].ToString(); float Rodeni = 0; //if (reader["ZivoRodeniPrasinja"].ToString() != "") Rodeni = float.Parse(reader["ZivoRodeniPrasinja"].ToString()); float MrtvoRodeni = 0; //if (reader["MrtvoRodeniPrasinja"].ToString() != "") MrtvoRodeni = float.Parse(reader["MrtvoRodeniPrasinja"].ToString()); float Nevitalni = 0; //if (reader["NevitalniPrasinja"].ToString() != "") Nevitalni = float.Parse(reader["NevitalniPrasinja"].ToString()); string Odbivanje = reader["OdbivanjeDatum"].ToString(); float OdbieniPrasinja = 0; //if (reader["OdbieniPrasinja"].ToString() != "") OdbieniPrasinja = float.Parse(reader["OdbieniPrasinja"].ToString()); Reproduction pom = new Reproduction(Zensko, Masko, Osemena, Kontrola, KontrolaDatum, Oprasena, Rodeni, MrtvoRodeni, Nevitalni, Odbivanje, OdbieniPrasinja); if (zaOsemenuvanje(pom)) { listBoxOsemenuvanje.Items.Add(pom.Zensko); } else if (zaOdbivanje(pom)) { listBoxOdbivanje.Items.Add(pom.Zensko); } else if (zaOprasuvanje(pom)) { listBoxOprasuvanje.Items.Add(pom.Zensko); } else if (zaKontrola(pom)) { listBoxKontrola.Items.Add(pom.Zensko); } else { MessageBox.Show("Wrong input" + pom.ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { reader.Close(); } } }
private void buttonSave_Click(object sender, EventArgs e) { if ((cm1.Text.Trim().Length != 0 && numericUpDown1.Value != 0 && mbDatum1.Text.Trim().Length == 10) || (numericUpDown2.Value != 0 && mbDatum2.Text.Trim().Length == 10)) { if (cbSkladiliste1.SelectedIndex != -1) { if (cm1.SelectedIndex != -1) { if ((int)numericUpDown1.Value != 0) { if (mbDatum1.Text.Length == 10) { DA = new DataAcess(); if (cm1.SelectedItem.ToString().Equals("Купено") || cm1.SelectedItem.ToString().Equals("Родено")) { SqlCommand cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem,Izdavanje,Datum)" + " Values(0,N'" + cbSkladiliste1.SelectedItem.ToString() + "',N'" + cm1.SelectedItem.ToString() + "',N'" + (int)numericUpDown1.Value + "', '0', cast('" + MakeDate.makeDate(mbDatum1.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); if (cbSkladiliste1.SelectedItem.ToString().Equals("Прасилиште")) { int tmp = int.Parse(textBox3.Text); textBox3.Text = (tmp + (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox3.Text) + "' where id = '1'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } else if (cbSkladiliste1.SelectedItem.ToString().Equals("Б-Фаза")) { int tmp = int.Parse(textBox4.Text); textBox4.Text = (tmp + (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox4.Text) + "' where id = '2'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } else { int tmp = int.Parse(textBox5.Text); textBox5.Text = (tmp + (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox5.Text) + "' where id = '3'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } } else { SqlCommand cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem,Izdavanje,Datum) " + "Values(0,N'" + cbSkladiliste1.SelectedItem.ToString() + "',N'" + cm1.SelectedItem.ToString() + "', '0', N'" + (int)numericUpDown1.Value + "',cast('" + MakeDate.makeDate(mbDatum1.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); if (cbSkladiliste1.SelectedItem.ToString().Equals("Прасилиште")) { int tmp = int.Parse(textBox3.Text); textBox3.Text = (tmp - (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox3.Text) + "' where id = '1'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } else if (cbSkladiliste1.SelectedItem.ToString().Equals("Б-Фаза")) { int tmp = int.Parse(textBox4.Text); textBox4.Text = (tmp - (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox4.Text) + "' where id = '2'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } else { int tmp = int.Parse(textBox5.Text); textBox5.Text = (tmp - (int)numericUpDown1.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox5.Text) + "' where id = '3'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } } } } } } else if (cbSkladiliste2.SelectedIndex != -1) { if ((int)numericUpDown2.Value != 0) { if (mbDatum2.Text.Length == 10) { DataAcess DA = new DataAcess(); if (cbSkladiliste2.SelectedItem.ToString().Equals("Прасилиште - Б-Фаза")) { SqlCommand cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem, Izdavanje, Datum) " + "Values(0,N'Прасилиште', N'Пренос', '0', N'" + (int)numericUpDown2.Value + "', cast('" + MakeDate.makeDate(mbDatum2.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); int tmp = int.Parse(textBox3.Text); textBox3.Text = (tmp - (int)numericUpDown2.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox3.Text) + "' where id = '1'", DA.getConnection()); DA.cmdCommand(cmd1); cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem, Izdavanje,Datum) " + "Values(0,N'Б-Фаза', N'Пренос', N'" + (int)numericUpDown2.Value + "', '0', cast('" + MakeDate.makeDate(mbDatum2.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); tmp = int.Parse(textBox4.Text); textBox4.Text = (tmp + (int)numericUpDown2.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox4.Text) + "' where id = '2'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } else { SqlCommand cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem,Izdavanje,Datum) " + "Values(0,N'Б-Фаза', N'Пренос', '0', N'" + (int)numericUpDown2.Value + "', cast('" + MakeDate.makeDate(mbDatum2.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); int tmp = int.Parse(textBox4.Text); textBox4.Text = (tmp - (int)numericUpDown2.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox4.Text) + "' where id = '2'", DA.getConnection()); DA.cmdCommand(cmd1); cmd1 = new SqlCommand("Insert Into tblDvizenje(ID,Skladiste,VidDvizenje,Priem,Izdavanje,Datum) " + "Values(0,N'Товилиште', N'Пренос', N'" + (int)numericUpDown2.Value + "', '0', cast('" + MakeDate.makeDate(mbDatum2.Text) + "' as datetime))", DA.getConnection()); DA.cmdCommand(cmd1); tmp = int.Parse(textBox5.Text); textBox5.Text = (tmp + (int)numericUpDown2.Value).ToString(); cmd1 = new SqlCommand("Update tblDvizenje set Priem = '" + int.Parse(textBox5.Text) + "' where id = '3'", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } } } } } else { MessageBox.Show("Внеси ги потребните податоци!"); } }
private void buttonIzbrisi_Click(object sender, EventArgs e) { ReprodukcijaFormIzbrisi newForm = new ReprodukcijaFormIzbrisi(); if (newForm.ShowDialog() == DialogResult.Yes) { DataAcess DA = new DataAcess(); SqlCommand cmd1 = new SqlCommand("Delete from tblReprodukcija Where FMajka = N'" + newForm.Zensko + "' and MTatko = N'" + newForm.Masko + "'and OsemenuvanjeDatum = cast('" + newForm.Osemenuvanje + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } }
private void buttonDodadi_Click(object sender, EventArgs e) { ReprodukcijaFormDodadi newForm = new ReprodukcijaFormDodadi(); if (newForm.ShowDialog() == DialogResult.Yes) { DataAcess DA = new DataAcess(); SqlCommand cmd1 = new SqlCommand("Insert Into tblReprodukcija(ID,FMajka,MTatko,OsemenuvanjeDatum,Kontrola) " + "Values(0,N'" + newForm.Reprodukcija.Zensko + "',N'" + newForm.Reprodukcija.Masko + "',cast('" + newForm.Reprodukcija.Osemena + "' as datetime),'" + newForm.Reprodukcija.Kontrola + "')", DA.getConnection()); DA.cmdCommand(cmd1); Refresh(); } }
public ReprodukcijaFormPromeni(String zensko) { InitializeComponent(); DataAcess da = new DataAcess(); SqlConnection conn = da.getConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("select Top 1 * from tblReprodukcija Where FMajka = '" + zensko + "' order by OsemenuvanjeDatum desc"); cmd.Connection = conn; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Zensko = reader["Fmajka"].ToString(); tbZensko.Text = reader["FMajka"].ToString(); Masko = reader["Mtatko"].ToString(); tbMasko.Text = reader["Mtatko"].ToString(); Osemena = reader["OsemenuvanjeDatum"].ToString(); tbDatumOsemenuvanje.Text = reader["OsemenuvanjeDatum"].ToString(); if (reader["KontrolaDatum"].ToString().Length != 0) { textBox1.Text = reader["KontrolaDatum"].ToString(); if (bool.Parse(reader["Kontrola"].ToString()) == true) { comboBox1.Text = "Да"; } else { comboBox1.Text = "Не"; } if (reader["OprasuvanjeDatum"].ToString().Length != 0) { textBox2.Text = reader["OprasuvanjeDatum"].ToString(); numericUpDown1.Value = decimal.Parse(reader["ZivoRodeniPrasinja"].ToString()); numericUpDown2.Value = decimal.Parse(reader["MrtvoRodeniPrasinja"].ToString()); numericUpDown3.Value = decimal.Parse(reader["NevitalniPrasinja"].ToString()); if (reader["OdbivanjeDatum"].ToString().Length != 0) { textBox3.Text = reader["OprasuvanjeDatum"].ToString(); numericUpDown4.Value = int.Parse(reader["OdbieniPrasinja"].ToString()); } else { mtbDatumOdbivanje.Enabled = true; numericUpDown4.Enabled = true; } } else { if (comboBox1.SelectedItem.Equals("Да")) { mtbDatumOprasuvanje.Enabled = true; numericUpDown1.Enabled = true; numericUpDown2.Enabled = true; numericUpDown3.Enabled = true; } } } else { mtbDatumKontrola.Enabled = true; comboBox1.Enabled = true; } } conn.Close(); }
private void button1_Click(object sender, EventArgs e) { DataAcess DA = new DataAcess(); if (mtbDatumKontrola.Enabled) { SqlCommand cmd1 = new SqlCommand("UPDATE tblReprodukcija SET KontrolaDatum = cast('" + MakeDate.makeDate(mtbDatumKontrola.Text) + "' as datetime) Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); if (comboBox1.SelectedItem.Equals("Да")) { cmd1 = new SqlCommand("UPDATE tblReprodukcija SET Kontrola = '1' Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); } } if (mtbDatumOprasuvanje.Enabled) { SqlCommand cmd1 = new SqlCommand("UPDATE tblReprodukcija SET OprasuvanjeDatum = cast('" + MakeDate.makeDate(mtbDatumOprasuvanje.Text) + "' as datetime) Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); cmd1 = new SqlCommand("UPDATE tblReprodukcija SET ZivoRodeniPrasinja = '" + (int)numericUpDown1.Value + "',MrtvoRodeniPrasinja = N'" + (int)numericUpDown2.Value + "',NevitalniPrasinja = N'" + (int)numericUpDown3.Value + "' Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); } if (mtbDatumOdbivanje.Enabled) { SqlCommand cmd1 = new SqlCommand("UPDATE tblReprodukcija SET OdbivanjeDatum = cast('" + MakeDate.makeDate(mtbDatumOdbivanje.Text) + "' as datetime) Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); cmd1 = new SqlCommand("UPDATE tblReprodukcija SET OdbieniPrasinja = '" + (int)numericUpDown4.Value + "',MrtvoRodeniPrasinja = N'" + (int)numericUpDown2.Value + "',NevitalniPrasinja = N'" + (int)numericUpDown3.Value + "' Where FMajka = N'" + tbZensko.Text + "' and MTatko = N'" + tbMasko.Text + "'and OsemenuvanjeDatum = cast('" + tbDatumOsemenuvanje.Text + "' as datetime)", DA.getConnection()); DA.cmdCommand(cmd1); } DialogResult = DialogResult.Yes; }
private void buttonOsnoven_Click(object sender, EventArgs e) { Document pdfDoc = new Document(); SqlDataReader reader = null; try { string FileName = null; if (FileName == null) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Osnoven izvestaj (*.pdf)|*.pdf"; saveFileDialog.Title = "Save Osnoven izvestaj"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { FileName = saveFileDialog.FileName; } else { return; } } PdfWriter pdf = PdfWriter.GetInstance(pdfDoc, new FileStream(FileName, FileMode.Create)); pdfDoc.Open(); string myFont = @"C:\Windows\Fonts\arial.ttf"; iTextSharp.text.pdf.BaseFont bfR; bfR = iTextSharp.text.pdf.BaseFont.CreateFont(myFont, iTextSharp.text.pdf.BaseFont.IDENTITY_H, iTextSharp.text.pdf.BaseFont.EMBEDDED); iTextSharp.text.BaseColor clrBlack = new iTextSharp.text.BaseColor(0, 0, 0); iTextSharp.text.Font fntHead = new iTextSharp.text.Font(bfR, 12, iTextSharp.text.Font.NORMAL, clrBlack); //pdfDoc.Add(new Paragraph("ТЕСТ", fntHead)); PdfPTable table = new PdfPTable(5); //PdfPCell cell = new PdfPCell(new Phrase("ОСНОВЕН ИЗВЕШТАЈ")); PdfPCell cell = new PdfPCell(new Phrase("OSNOVEN IZVESTAJ")); cell.Colspan = 5; cell.HorizontalAlignment = 1; table.AddCell(cell); table.AddCell("Meseci"); table.AddCell("Rodeni"); table.AddCell("Mrtvo Rodeni"); table.AddCell("Nevitalni"); table.AddCell("Odbieni prasinja"); long vkupnoRodeni = 0; long vkupnoMrtvoRodeni = 0; long vkupnoNevitalni = 0; long vkupnoOdbieniPrasinja = 0; DataAcess da = new DataAcess(); SqlConnection conn = da.getConnection(); conn.Open(); for (int i = 1; i < 13; i++) { int k = i + 1; String str = String.Format("Select * FROM tblReprodukcija Where OdbivanjeDatum > DATEADD(MONTH, {0}, GetDate()) and OdbivanjeDatum < DATEADD(MONTH, {1}, GetDate())", -k, -i); SqlCommand cmd = new SqlCommand(str); //SqlCommand cmd = new SqlCommand("Select * FROM tblReprodukcija Where OdbivanjeDatum > DATEADD(MONTH, -'" + k + "' , GetDate()) and OdbivanjeDatum < DATEADD(MONTH, -'" + i +"', GetDate())"); cmd.Connection = conn; reader = cmd.ExecuteReader(); List <Reproduction> lista = new List <Reproduction>(); while (reader.Read()) { string Zensko = reader["FMajka"].ToString(); string Masko = reader["MTatko"].ToString(); string Osemena = reader["OsemenuvanjeDatum"].ToString(); string KontrolaDatum = reader["KontrolaDatum"].ToString(); bool Kontrola = Boolean.Parse(reader["Kontrola"].ToString()); string Oprasena = reader["OprasuvanjeDatum"].ToString(); float Rodeni = 0; if (reader["ZivoRodeniPrasinja"].ToString() != "") { Rodeni = float.Parse(reader["ZivoRodeniPrasinja"].ToString()); } float MrtvoRodeni = 0; if (reader["MrtvoRodeniPrasinja"].ToString() != "") { MrtvoRodeni = float.Parse(reader["MrtvoRodeniPrasinja"].ToString()); } float Nevitalni = 0; if (reader["NevitalniPrasinja"].ToString() != "") { Nevitalni = float.Parse(reader["NevitalniPrasinja"].ToString()); } string Odbivanje = reader["OdbivanjeDatum"].ToString(); float OdbieniPrasinja = 0; if (reader["OdbieniPrasinja"].ToString() != "") { OdbieniPrasinja = float.Parse(reader["OdbieniPrasinja"].ToString()); } Reproduction pom = new Reproduction(Zensko, Masko, Osemena, Kontrola, KontrolaDatum, Oprasena, Rodeni, MrtvoRodeni, Nevitalni, Odbivanje, OdbieniPrasinja); lista.Add(pom); } int rodeni = 0; int Mrtvi = 0; int nevitalni = 0; int odbieni = 0; for (int m = 0; m < lista.Count; m++) { rodeni += (int)lista[i].Rodeni; Mrtvi += (int)lista[i].MrtvoRodeni; nevitalni += (int)lista[i].Nevitalni; odbieni += (int)lista[i].OdbieniPrasinja; } table.AddCell(i.ToString()); vkupnoRodeni += rodeni; table.AddCell(rodeni.ToString()); vkupnoMrtvoRodeni += Mrtvi; table.AddCell(Mrtvi.ToString()); vkupnoNevitalni += nevitalni; table.AddCell(nevitalni.ToString()); vkupnoOdbieniPrasinja += odbieni; table.AddCell(odbieni.ToString()); reader.Close(); } table.AddCell("Vkupno"); table.AddCell(vkupnoRodeni.ToString()); table.AddCell(vkupnoMrtvoRodeni.ToString()); table.AddCell(vkupnoNevitalni.ToString()); table.AddCell(vkupnoOdbieniPrasinja.ToString()); pdfDoc.Add(table); MessageBox.Show("Креаиран е PDF"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { pdfDoc.Close(); } }