public static SortableSearchableList<SintetickiKonto> GetSintetickiKontniPlan(string folderName)
{
SortableSearchableList<SintetickiKonto> listaSKP = new SortableSearchableList<SintetickiKonto>();
string sqlStatement =
"SELECT SintKto, NazivKto, AktPas, AOPOzn " +
"FROM SintKP " +
"ORDER BY SintKto";
OleDbConnection conn = KnjigovodstvoDB.GetConnection(folderName);
OleDbCommand command = new OleDbCommand(sqlStatement, conn);
try
{
conn.Open();
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SintetickiKonto skp = new SintetickiKonto();
skp.Konto = reader["SintKto"].ToString();
skp.NazivKonta = reader["NazivKto"].ToString();
skp.AktivniPasivni = reader["AktPas"].ToString();
skp.AOPOznaka = reader["AopOzn"].ToString();
listaSKP.Add(skp);
}
reader.Close();
}
catch (OleDbException ex)
{
// global::System.Windows.Forms.MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
//throw ex;
throw new Exception(ex.Message + "\n" + ex.StackTrace);
}
finally
{
conn.Close();
}
return listaSKP;
}
private void DisplayKonto()
{
string sintKonto = "";
if (cboKonto.Text.Length >= 3)
{
sintKonto = cboKonto.Text.Substring(0, 3);
selectedSintKonto = SintetickiKontoDB.GetSintetickiKonto(dbfKontaFolderName, sintKonto);
}
else
{
selectedSintKonto = null;
}
selectedKonto = AnalitickiKontoDB.GetAnalitickiKonto(dbfKontaFolderName, cboKonto.Text);
if (selectedKonto != null)
{
txtAOPOznaka.Text = selectedKonto.AOPOznaka;
txtNazivAnalitickogKonta.Text = selectedKonto.NazivKonta;
}
else
{
txtNazivAnalitickogKonta.Text = "";
txtAOPOznaka.Text = "";
chbKontoIspravke.Checked = false;
}
if (selectedSintKonto != null)
{
txtNazivSintetickogKonta.Text = selectedSintKonto.NazivKonta;
}
else
{
txtNazivSintetickogKonta.Text = "";
}
}
public static SintetickiKonto GetSintetickiKonto(string folderName, string sintKto)
{
SintetickiKonto sintetickiKonto = null;
string sqlStatement =
"SELECT SintKto, NazivKto, AktPas, AOPOzn " +
"FROM SintKP " +
"WHERE SintKto = @SintKto";
OleDbConnection conn = KnjigovodstvoDB.GetConnection(folderName);
OleDbCommand command = new OleDbCommand(sqlStatement, conn);
command.Parameters.AddWithValue("@SintKto", sintKto);
try
{
conn.Open();
OleDbDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
sintetickiKonto = new SintetickiKonto();
sintetickiKonto.Konto = reader["SintKto"].ToString();
sintetickiKonto.NazivKonta = reader["NazivKto"].ToString();
sintetickiKonto.AktivniPasivni = reader["AktPas"].ToString();
sintetickiKonto.AOPOznaka = reader["AopOzn"].ToString();
}
reader.Close();
}
catch (OleDbException ex)
{
// global::System.Windows.Forms.MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
//throw ex;
throw new Exception(ex.Message + "\n" + ex.StackTrace);
}
finally
{
conn.Close();
}
return sintetickiKonto;
}
