private bool Datoteka_HYPO(ref string parDatoteka)
{
bool flag = false;
try
{
string str2 = "";
string str = "";
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT KORISNIK.KORISNIK1NAZIV, KORISNIK.MBKORISNIK FROM KORISNIK WHERE IDKORISNIK = 1";
selectCommand.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter2.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
str2 = Conversions.ToString(dataTable.Rows[0]["KORISNIK1NAZIV"]);
str = Conversions.ToString(dataTable.Rows[0]["MBKORISNIK"]);
}
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
object obj2 = adapter.Fill(dataSet, this.SifraObracuna, this.VBDI);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za HYPO banku");
return(flag);
}
StreamWriter writer = new StreamWriter(parDatoteka, false, Encoding.GetEncoding(0x354));
StreamWriter writer2 = writer;
writer2.Write("10");
writer2.Write(str2.PadRight(40));
writer2.Write("\r\n");
int num2 = dataSet.Tables[0].Rows.Count - 1;
for (int i = 0; i <= num2; i++)
{
writer2.Write("20");
writer2.Write("15");
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Rows[i]["TEKUCI"])), 10, 0, false, ""));
writer2.Write(DB.BrojVodecePraznine(DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Rows[i]["UKUPNOZAISPLATU"])), 11, 2, true, "."));
writer2.Write(new string(' ', 3));
writer2.Write(new string(' ', 6));
writer2.Write("\r\n");
}
writer2.Close();
writer2 = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška!!! ", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Disketa_Karlovacka(string NazivDatoteke)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
object obj2 = adapter.Fill(dataSet, this.SifraObracuna, this.VBDI);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za KARLOVAČKU banku");
return(flag);
}
StreamWriter writer = new StreamWriter(NazivDatoteke, false, Encoding.ASCII);
DataTable table = dataSet.Tables[0];
int num = 0;
try
{
enumerator = table.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 10, 0, false, ""));
writer.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 8, 2, false, ""));
writer.Write("\r\n");
num++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer.Close();
table = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_Erste(string strNazivDatoteke)
{
bool flag = false;
try
{
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT ZRNBANKE FROM BANKE WHERE VBDIBANKE = '" + this.strVBDIBanke + "'";
selectCommand.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter2.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
this.ZiroBanke = Conversions.ToString(dataTable.Rows[0]["zrnbanke"]);
}
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
int num = adapter.Fill(dataSet, this.SifraObracuna, this.strVBDIBanke);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za Erste banku");
return(flag);
}
decimal num2 = DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
StreamWriter writer = new StreamWriter(strNazivDatoteke, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write(string.Format("Z1{0}-{1}", this.strVBDIBanke.PadRight(7), this.ZiroBanke.PadRight(10)));
writer2.Write("\r\n");
writer2.Write("Z2" + this.Ziro.PadRight(0x12));
writer2.Write("\r\n");
int num4 = dataSet.Tables[0].Rows.Count - 1;
for (int i = 0; i <= num4; i++)
{
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Rows[i]["TEKUCI"])), 10, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Rows[i]["UKUPNOZAISPLATU"])), 8, 2, false, ""));
writer2.Write("\r\n");
}
writer2.Close();
writer2 = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox(string.Format("Greška!", new object[0]), MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_Raiffeisen(string NazivDatoteke)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
string str3 = Conversions.ToString(this.BrojPoslovnice.Value);
string str = "0";
string str2 = "0";
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT KORISNIK.MBKORISNIK, KORISNIK.MBKORISNIKJEDINICA FROM KORISNIK WHERE IDKORISNIK = 1";
selectCommand.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter2.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
str = Conversions.ToString(dataTable.Rows[0]["MBKORISNIK"]);
str2 = Conversions.ToString(dataTable.Rows[0]["MBKORISNIKJEDINICA"]);
if (str2.Length > 3)
{
str2 = str2.Substring(0, 3);
}
}
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
int vBroj = adapter.Fill(dataSet, this.sifraObracuna, this.VBDI);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za Raiffeissenbanku");
return(flag);
}
decimal num2 = DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
vBroj = Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("count(idradnik)", ""))));
StreamWriter writer = new StreamWriter(NazivDatoteke, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write("19101");
writer2.Write(this.BrojPoslovnice.Text);
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.datUplate.Text.Trim() == "", " ", Conversions.ToDate(this.datUplate.Value).ToString("yyyyMMdd"))));
writer2.Write(DB.BrojVodecePraznine(vBroj, 6, 0, false, ""));
writer2.Write(DB.BrojVodecePraznine(num2, 14, 2, true, "."));
writer2.Write("\r\n");
int num3 = 0;
try
{
enumerator = dataSet.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer2.Write(DB.BrojVodecePraznine(RuntimeHelpers.GetObjectValue(current["TEKUCI"]), 10, 0, false, "").Substring(0, 10));
writer2.Write(DB.BrojVodecePraznine(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 14, 2, true, "."));
writer2.Write("\r\n");
num3++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer2 = null;
writer.Close();
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_Zaba(string sDatoteka)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
string vBroj = Conversions.ToString(this.BrojPoslovnice.Value);
string str3 = "0";
string str = "0";
string str2 = "0";
KORISNIKDataAdapter adapter2 = new KORISNIKDataAdapter();
KORISNIKDataSet dataSet = new KORISNIKDataSet();
adapter2.FillPage(dataSet, 0, 1);
if (dataSet.KORISNIK.Rows.Count > 0)
{
str = Conversions.ToString(dataSet.KORISNIK.Rows[0]["MBKORISNIK"]);
str2 = Conversions.ToString(dataSet.KORISNIK.Rows[0]["MBKORISNIKJEDINICA"]);
if (str2.Length > 3)
{
str2 = str2.Substring(0, 3);
}
}
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet set2 = new sp_diskete_za_bankuDataSet();
adapter.Fill(set2, this.sifraObracuna, this.VBDI);
object obj2 = DB.N20(RuntimeHelpers.GetObjectValue(set2.Tables[0].Compute("count(idradnik)", "")));
if (set2.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za ZAGREBAČKU banku");
return(flag);
}
decimal num = DB.N20(RuntimeHelpers.GetObjectValue(set2.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
StreamWriter writer = new StreamWriter(sDatoteka, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write("030");
writer2.Write("0000000");
writer2.Write("3234495");
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.datumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.datumUplate.Value).ToString("ddMMyy"))));
writer2.Write("0000000000000");
writer2.Write(DB.BrojVodeceNule(num, 11, 2, false, ""));
writer2.Write(DB.BrojVodeceNule(RuntimeHelpers.GetObjectValue(obj2), 4, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(str, 8, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(str2, 3, 0, false, ""));
writer2.Write(new string('0', 6));
writer2.Write(DB.BrojVodeceNule(vBroj, 6, 0, false, ""));
writer2.Write("*");
writer2.Write(" ");
writer2.Write("\r\n");
int num2 = 0;
try
{
enumerator = set2.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer2.Write("031");
writer2.Write("0000000");
writer2.Write(DB.BrojVodeceNule(str3, 6, 0, false, ""));
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.datumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.datumUplate.Value).ToString("ddMMyy"))));
writer2.Write("01");
writer2.Write("50");
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 9, 2, false, ""));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 10, 0, false, ""));
writer2.Write(new string('0', 6));
writer2.Write(DB.BrojVodeceNule(str, 8, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(str2, 3, 0, false, ""));
writer2.Write(new string('0', 12));
writer2.Write("*");
writer2.Write(" ");
writer2.Write("\r\n");
num2++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer2.Close();
writer2 = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška:", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_Jadranska(string sDatoteka)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT ZRNBANKE FROM BANKE WHERE VBDIBANKE = '" + this.VBDI + "'";
selectCommand.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter2.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
this.ZRNBANKE = Conversions.ToString(dataTable.Rows[0]["zrnbanke"]);
}
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
object obj2 = adapter.Fill(dataSet, this.Obracun, this.VBDI);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za JADRANSKU banku!");
return(flag);
}
decimal vNumber = DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
StreamWriter writer = new StreamWriter(sDatoteka, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write("00 ");
writer2.Write(this.utxtSifraPoduzeca.Text);
writer2.Write(DB.BrojVodeceNule(DB.N20(vNumber), 13, 2, false, ""));
writer2.Write(Strings.Space(10));
writer2.Write("\r\n");
int num2 = 0;
try
{
enumerator = dataSet.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer2.Write("11");
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 10, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 13, 2, false, ""));
writer2.Write(Strings.Space(10));
writer2.Write("\r\n");
num2++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer2.Close();
writer2 = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška: ", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_PBZ(string NazivDatoteke)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
int vBroj = 0;
string str = "0";
string str2 = "0";
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT KORISNIK.MBKORISNIK, KORISNIK.MBKORISNIKJEDINICA FROM KORISNIK WHERE IDKORISNIK = 1";
selectCommand.CommandType = CommandType.Text;
adapter = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
str = Conversions.ToString(dataTable.Rows[0]["MBKORISNIK"]);
str2 = Conversions.ToString(dataTable.Rows[0]["MBKORISNIKJEDINICA"]);
if (str2.Length > 3)
{
str2 = str2.Substring(0, 3);
}
}
sp_diskete_za_bankuDataAdapter adapter2 = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
adapter2.Fill(dataSet, this.sifraObracuna, this.VBDI);
int count = dataSet.Tables[0].Rows.Count;
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za PBZ banku");
return(flag);
}
decimal num3 = DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
StreamWriter writer = new StreamWriter(NazivDatoteke, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write("0");
writer2.Write(DB.IzvuciSamoBrojke(this.Ziro, true).PadRight(0x11));
writer2.Write(DB.IzvuciSamoBrojke(this.ModelZaduzenja.Text, true).PadRight(2));
writer2.Write(this.PozivNaBrojZaduzenja.Text.PadRight(0x16));
writer2.Write(new string(' ', 3));
writer2.Write("\r\n");
writer2.Write("9");
writer2.Write("1");
writer2.Write(DB.BrojVodeceNule(count, 5, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(num3, 13, 2, false, ""));
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.ultraDatumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.ultraDatumUplate.Value).ToString("ddMMyyyy"))));
writer2.Write(DB.BrojVodeceNule(str, 8, 0, false, ""));
writer2.Write(new string(' ', 7));
writer2.Write("\r\n");
int num4 = 0;
try
{
enumerator = dataSet.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
vBroj++;
writer2.Write("1");
writer2.Write(DB.BrojVodeceNule(vBroj, 5, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 10, 0, false, ""));
writer2.Write(Strings.Space(1));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 13, 2, false, ""));
writer2.Write(new string(' ', 13));
writer2.Write("\r\n");
num4++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer2 = null;
writer.Close();
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška: ", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_Splitska(string sDatoteka)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
string str = "";
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT KORISNIK1NAZIV FROM KORISNIK WHERE IDKORISNIK = 1";
selectCommand.CommandType = CommandType.Text;
adapter = new SqlDataAdapter(selectCommand);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
str = Conversions.ToString(dataTable.Rows[0]["KORISNIK1NAZIV"]);
}
sp_diskete_za_bankuDataAdapter adapter2 = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet dataSet = new sp_diskete_za_bankuDataSet();
int num3 = adapter2.Fill(dataSet, this.sifraObracuna, this.VBDI);
if (dataSet.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za Splitsku banku");
return(flag);
}
decimal vBroj = DB.N20(RuntimeHelpers.GetObjectValue(dataSet.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", "")));
StreamWriter writer = new StreamWriter(sDatoteka, false, Encoding.ASCII);
writer.Write("ST");
writer.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.udteDatumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.udteDatumUplate.Value).ToString("ddMMyy"))));
writer.Write(DB.BrojVodeceNule(vBroj, 13, 2, false, ""));
writer.Write("\r\n");
writer.Write("ST");
writer.Write(str.PadRight(0x19).Substring(0, 0x19));
writer.Write("\r\n");
int num2 = 0;
try
{
enumerator = dataSet.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 11, 0, false, ""));
writer.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 13, 2, false, ""));
writer.Write(" ");
writer.Write("\r\n");
num2++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer.Close();
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
private bool Datoteka_HPB(string strNazivDatoteke)
{
bool flag = false;
try
{
IEnumerator enumerator = null;
string str2 = "0";
string str3 = "0";
string str = "";
SqlConnection connection = new SqlConnection(Configuration.ConnectionString);
SqlCommand selectCommand = new SqlCommand();
SqlDataAdapter adapter4 = new SqlDataAdapter(selectCommand);
selectCommand.Connection = connection;
KORISNIKDataSet dataSet = new KORISNIKDataSet();
new KORISNIKDataAdapter().Fill(dataSet);
str2 = Conversions.ToString(dataSet.KORISNIK.Rows[0]["MBKORISNIK"]);
str3 = Conversions.ToString(dataSet.KORISNIK.Rows[0]["MBKORISNIKJEDINICA"]);
if (str3.Length > 3)
{
str3 = str3.Substring(0, 3);
}
VIRMANIDataAdapter adapter3 = new VIRMANIDataAdapter();
Placa.VIRMANIDataSet set = new Placa.VIRMANIDataSet();
adapter3.FillBySIFRAOBRACUNAVIRMAN(set, this.SifraObracuna);
str = Conversions.ToString(set.VIRMANI.Rows[0]["brojracunapla"]);
sp_diskete_za_bankuDataAdapter adapter = new sp_diskete_za_bankuDataAdapter();
sp_diskete_za_bankuDataSet set3 = new sp_diskete_za_bankuDataSet();
int num2 = adapter.Fill(set3, this.SifraObracuna, this.vbdiBanke);
if (set3.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Ne postoje isplate za HPB banku!");
return(flag);
}
decimal vBroj = Conversions.ToDecimal(set3.Tables[0].Compute("Sum(UKUPNOZAISPLATU)", ""));
StreamWriter writer = new StreamWriter(strNazivDatoteke, false, Encoding.ASCII);
StreamWriter writer2 = writer;
writer2.Write("98");
writer2.Write(new string(' ', 0x77));
writer2.Write("0");
writer2.Write("\r\n");
writer2.Write("94");
writer2.Write(str.PadRight(0x15));
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.DatumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.DatumUplate.Value).ToString("ddMMyy"))));
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.DatumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.DatumUplate.Value).ToString("ddMMyy"))));
writer2.Write(DB.BrojVodeceNule(vBroj, 13, 2, false, ""));
writer2.Write(new string('0', 60));
writer2.Write(new string(' ', 11));
writer2.Write("0");
writer2.Write("\r\n");
int num3 = 0;
try
{
enumerator = set3.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
writer2.Write("070000011");
writer2.Write("2");
writer2.Write(new string(' ', 10));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["TEKUCI"])), 11, 0, false, ""));
writer2.Write(DB.BrojVodeceNule(DB.N20(RuntimeHelpers.GetObjectValue(current["UKUPNOZAISPLATU"])), 9, 2, false, ""));
writer2.Write(RuntimeHelpers.GetObjectValue(Interaction.IIf(this.DatumUplate.Text.Trim() == "", " ", Conversions.ToDate(this.DatumUplate.Value).ToString("ddMMyy"))));
writer2.Write(new string(' ', 0x49));
writer2.Write("0");
writer2.Write("\r\n");
num3++;
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
writer2.Write("99");
writer2.Write(new string(' ', 0x77));
writer2.Write("0");
writer2.Write("\r\n");
writer2.Close();
writer2 = null;
flag = true;
}
catch (System.Exception exception1)
{
throw exception1;
//Interaction.MsgBox("Greška: ", MsgBoxStyle.OkOnly, null);
//flag = false;
}
return(flag);
}
