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