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();
}
}
