//odobrenja pojedinacno
private void Button6_Click(object sender, EventArgs e)
{
BrisiDatagrid();
Odobrenja od = new Odobrenja();
UraStavka stavka = od.OdobrenjaPojedinacno(dataGridView1, datumOdBox, datumDoBox);
PopuniLabeleZbroja(stavka);
}
//ispis iz baze
private void Button4_Click(object sender, EventArgs e)
{
BrisiDatagrid();
URAIspPodIzBaze ispis = new URAIspPodIzBaze();
UraStavka stavka = new UraStavka();
ispis.Ispis(datumOdBox, datumDoBox, dataGridView1);
stavka = stavka.Zbroji(dataGridView1);
PopuniLabeleZbroja(stavka);
}
private void PopuniLabeleZbroja(UraStavka stavka)
{
label1.Text = "Ukupno: " + stavka.UkIznos.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label2.Text = "Osn.5%: " + stavka.Osn5.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label3.Text = "Osn.13%: " + stavka.Osn13.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label4.Text = "Osn.25%: " + stavka.Osn25.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label5.Text = "Osn.Uk: " + stavka.OsnovicaUkupno.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label8.Text = "Pretpor.Uk.: " + stavka.PretPorUk.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label9.Text = "Por.5%: " + stavka.Por5.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label10.Text = "Por.13%: " + stavka.Por13.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label11.Text = "Por.25%: " + stavka.Por25.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
label13.Text = "Neoporezivo: " + stavka.Neoporezivo.ToString("C", CultureInfo.CreateSpecificCulture("hr-HR"));
}
public UraStavka ZbrojiOdobrenja(DataGridView dataGridView1)
{
UraStavka stavka = new UraStavka();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.UkIznos += Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Neoporezivo += Convert.ToDouble(dataGridView1.Rows[i].Cells[8].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[9].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[10].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[11].Value.ToString());
}
stavka.OsnovicaUkupno = stavka.Osn5 + stavka.Osn13 + stavka.Osn25;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[13].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[14].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[15].Value.ToString());
}
//obilazak gubitka u lipama radi strojnog racunanja
//ukIznos = osn5 + osn13 + osn25 + por5 + por13 + por25;
stavka.PretPorUk = stavka.Por5 + stavka.Por13 + stavka.Por25;
return(stavka);
}
public UraStavka ZbrojiOdobrenjaZbirno(DataGridView dataGridView1)
{
UraStavka stavka = new UraStavka();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.UkIznos += Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.OsnovicaUkupno += Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[6].Value.ToString());
}
stavka.OsnovicaUkupno = stavka.Osn5 + stavka.Osn13 + stavka.Osn25;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[8].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[9].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[10].Value.ToString());
}
stavka.PretPorUk = stavka.Por5 + stavka.Por13 + stavka.Por25;
return(stavka);
}
//troskovi
private void Button7_Click(object sender, EventArgs e)
{
BrisiDatagrid();
Troskovi tr = new Troskovi();
UraStavka stavka = tr.Troškovi(dataGridView1, datumOdBox, datumDoBox);
PopuniLabeleZbroja(stavka);
foreach (DataGridViewRow Myrow in dataGridView1.Rows)
{
if (Convert.ToInt32(Myrow.Cells[14].Value) != 0)
{
Myrow.DefaultCellStyle.BackColor = Color.MistyRose;
}
}
}
private UraStavka ZbrojiTroskove(CustomDataGridView dataGridView1)
{
UraStavka stavka = new UraStavka();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.UkIznos += Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[8].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Osn25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[9].Value.ToString());
}
stavka.OsnovicaUkupno = stavka.Osn5 + stavka.Osn13 + stavka.Osn25;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.PretPorUk += Convert.ToDouble(dataGridView1.Rows[i].Cells[10].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por5 += Convert.ToDouble(dataGridView1.Rows[i].Cells[11].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por13 += Convert.ToDouble(dataGridView1.Rows[i].Cells[12].Value.ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
stavka.Por25 += Convert.ToDouble(dataGridView1.Rows[i].Cells[13].Value.ToString());
}
return(stavka);
}
//kreiraj xml
private void Button1_Click(object sender, EventArgs e)
{
BrisiDatagrid();
URAIspPodIzBaze ispis = new URAIspPodIzBaze();
ispis.Ispis(datumOdBox, datumDoBox, dataGridView1);
UraStavka stavka = new UraStavka();
stavka = stavka.Zbroji(dataGridView1);
PopuniLabeleZbroja(stavka);
PopuniXml popuniXml = new PopuniXml();
if (popuniXml.PopuniObrazac(datumOdBox, datumDoBox))
{
popuniXml.PopuniUkupno(stavka);
}
}
public void PopuniUkupno(UraStavka s)
{
XNamespace ns = "http://e-porezna.porezna-uprava.hr/sheme/zahtjevi/ObrazacURA/v1-0";
XDocument doc = XDocument.Load(put);
doc.Element(ns + "ObrazacURA").Element(ns + "Tijelo").Element(ns + "Ukupno").Add(
new XElement(ns + "U8", Math.Round(s.Osn5, 2)),
new XElement(ns + "U9", Math.Round(s.Osn13, 2)),
new XElement(ns + "U10", Math.Round(s.Osn25, 2)),
new XElement(ns + "U11", Math.Round(s.Osn5 + s.Osn13 + s.Osn25 + s.PretPorUk, 2)),
new XElement(ns + "U12", Math.Round(s.PretPorUk, 2)),
new XElement(ns + "U13", Math.Round(s.Por5, 2)),
new XElement(ns + "U14", "0.00"),
new XElement(ns + "U15", Math.Round(s.Por13, 2)),
new XElement(ns + "U16", "0.00"),
new XElement(ns + "U17", Math.Round(s.Por25, 2)),
new XElement(ns + "U18", "0.00"));
doc.Save(put);
}
