private void KreirajDIsketu() { string strPoziv = this.sifraugovaratelja.Text + "90"; strPoziv = strPoziv + Razno.KontrolniBroj(strPoziv); string str = "up5924-" + this.rkdp.Text + "-" + strPoziv; SaveFileDialog dialog2 = new SaveFileDialog { InitialDirectory = Conversions.ToString(0), FileName = str, RestoreDirectory = true }; SaveFileDialog dialog = dialog2; if (dialog.ShowDialog() == DialogResult.OK) { if (this.SnimiDisketuZaHZZO(dialog.FileName)) { MessageBox.Show("Datoteka za HZZO uspješno kreirana."); } else { MessageBox.Show("Greška prilikom kreiranja HZZO datoteke."); } } }
private bool SnimiDisketuZaHZZO(string strNazivDatoteke) { bool flag = false; if (this.olaksica == -1) { Interaction.MsgBox("Potrebno je odabrati olakšicu za koju želite izraditi datoteku", MsgBoxStyle.OkOnly, null); return(flag); } try { IEnumerator enumerator = null; SqlConnection connection = new SqlConnection(Configuration.ConnectionString); SqlCommand selectCommand = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(selectCommand); selectCommand.Connection = connection; S_OD_REKAP_OLAKSICEDataAdapter adapter2 = new S_OD_REKAP_OLAKSICEDataAdapter(); S_OD_REKAP_OLAKSICEDataSet dataSet = new S_OD_REKAP_OLAKSICEDataSet(); object obj2 = adapter2.Fill(dataSet, this.Obracun); if (dataSet.Tables[0].Rows.Count == 0) { MessageBox.Show("Ne postoje obračunate olakšice!"); return(flag); } DataView view = new DataView { Table = dataSet.S_OD_REKAP_OLAKSICE }; decimal num3 = DB.N20(RuntimeHelpers.GetObjectValue(view.Table.Compute("Sum(IZNOSOLAKSICE)", "IDOLAKSICE=" + Conversions.ToString(this.olaksica)))); decimal num = DB.N20(RuntimeHelpers.GetObjectValue(view.Table.Compute("count(idradnik)", "IDOLAKSICE=" + Conversions.ToString(this.olaksica)))); StreamWriter writer = new StreamWriter(strNazivDatoteke, false, Encoding.ASCII); writer.Write("0:5924-"); writer.Write(DB.BrojVodeceNule(this.rkdp.Text, 5, 0, false, "")); string strPoziv = this.sifraugovaratelja.Text + "90"; strPoziv = strPoziv + Razno.KontrolniBroj(strPoziv); writer.Write("-"); writer.Write(strPoziv); writer.Write(":"); writer.Write(this.nazivkorisnika); writer.Write(" :"); writer.Write(Conversions.ToDate(this.datum.Value).ToString("dd.MM.yyyy")); writer.Write(": "); writer.Write(num3.ToString("0.00").Replace(",", ".")); writer.Write(":" + Conversions.ToString(num)); writer.WriteLine(":"); int num2 = 0; try { enumerator = view.Table.Rows.GetEnumerator(); while (enumerator.MoveNext()) { DataRow current = (DataRow)enumerator.Current; if (Operators.ConditionalCompareObjectEqual(current["idolaksice"], this.olaksica, false)) { num2++; writer.Write("1:5924-"); writer.Write(this.rkdp.Text + "-"); writer.Write(RuntimeHelpers.GetObjectValue(current["ZADPOJEDINACNIPOZIV"])); writer.Write(":"); writer.Write(RuntimeHelpers.GetObjectValue(current["prezime"])); writer.Write(Operators.ConcatenateObject(" ", current["ime"])); writer.Write(":"); writer.Write(Conversions.ToDate(this.datum.Value).ToString("dd.MM.yyyy")); writer.Write(": "); decimal num4 = Conversions.ToDecimal(current["iznosolaksice"]); writer.Write(num4.ToString("0.00").Replace(",", ".")); writer.Write(":"); writer.Write(num2); writer.WriteLine(":"); } } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } writer.Close(); flag = true; } catch (System.Exception exception1) { throw exception1; //Interaction.MsgBox("Greška prilikom kreiranja datoteke za HZZO", MsgBoxStyle.OkOnly, null); //flag = false; } return(flag); }