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