private void cboVrstaNaloga_SelectedIndexChanged(object sender, EventArgs e) { string vrstaNaloga = ""; int selectedIndex = ((ComboBox)sender).SelectedIndex; vrstaNaloga = GetVrstaNaloga(selectedIndex); selectedNalogGk = null; DisplayNalogGk(); GetNalogGk(vrstaNaloga); }
private void GetNalogGk(string vrstaNaloga) { if ((vrstaNaloga != "") && NalogGkDB.DbfFileExists(dbfFolderName) && ItemGkDB.DbfFileExists(dbfFolderName)) { FillItemsGk(vrstaNaloga); } else { selectedNalogGk = null; DisplayNalogGk(); } }
private void FillItemsGk(string vrstaNaloga) { try { selectedNalogGk = NalogGkDB.GetNalogGkByPocSt(dbfFolderName, vrstaNaloga); } catch (Exception ex) { MessageBox.Show("Greška u toku čitanja naloga glavne knjige." + "\n" + ex.Message, "Greška tokom čitanja podataka", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (selectedNalogGk != null) { try { progressBar.Visible = true; bckWorkerGetGk.RunWorkerAsync(); } catch (Exception ex) { MessageBox.Show("Greška u toku čitanja knjiženja naloga glavne knjige." + "\n" + ex.Message, "Greška tokom čitanja podataka", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void nalogGkDataGridView_SelectionChanged(object sender, EventArgs e) { if (backgroundWorker2.IsBusy) { return; } if (nalogGkDataGridView.SelectedRows.Count > 0) { DataGridViewRow row = nalogGkDataGridView.SelectedRows[0]; selectedNalogGk = (NalogGk)row.DataBoundItem; string currentBrojNaloga = selectedNalogGk.BrojNaloga; FillItemsGk(currentBrojNaloga); } else { itemGkBindingSource.Clear(); itemGkDataGridView.Rows.Clear(); this.txtDuguje.Text = ""; this.txtPotrazuje.Text = ""; this.txtSaldo.Text = ""; } }
public static SortableSearchableList<NalogGk> GetListaNalogaGk(string folderName) { SortableSearchableList<NalogGk> listaNalogaGk = new SortableSearchableList<NalogGk>(); string sqlStatement = "SELECT BrojNal, DatumNal, PocSt, OpisNal " + "FROM Nalog " + "ORDER BY BrojNal"; OleDbConnection conn = KnjigovodstvoDB.GetConnection(folderName); OleDbCommand command = new OleDbCommand(sqlStatement, conn); try { conn.Open(); OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { NalogGk nalogGk = new NalogGk(); nalogGk.BrojNaloga = reader["BrojNal"].ToString(); nalogGk.DatumNaloga = Convert.ToDateTime(reader["DatumNal"]); nalogGk.VrstaNaloga = reader["PocSt"].ToString(); nalogGk.OpisNaloga = reader["OpisNal"].ToString(); listaNalogaGk.Add(nalogGk); } reader.Close(); } catch (OleDbException ex) { // global::System.Windows.Forms.MessageBox.Show(ex.Message + "\n" + ex.StackTrace); throw ex; } finally { conn.Close(); } return listaNalogaGk; }
public static NalogGk GetNalogGkByPocSt(string folderName, string pocSt) { NalogGk nalogGk = null; string sqlStatement = "SELECT BrojNal, DatumNal, PocSt, OpisNal " + "FROM Nalog " + "WHERE PocSt = @PocSt"; OleDbConnection conn = KnjigovodstvoDB.GetConnection(folderName); OleDbCommand command = new OleDbCommand(sqlStatement, conn); command.Parameters.AddWithValue("PocSt", pocSt); try { conn.Open(); OleDbDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { nalogGk = new NalogGk(); nalogGk.BrojNaloga = reader["BrojNal"].ToString(); nalogGk.DatumNaloga = Convert.ToDateTime(reader["DatumNal"]); nalogGk.VrstaNaloga = reader["PocSt"].ToString(); nalogGk.OpisNaloga = reader["OpisNal"].ToString(); } reader.Close(); } catch (OleDbException ex) { // global::System.Windows.Forms.MessageBox.Show(ex.Message + "\n" + ex.StackTrace); throw ex; } finally { conn.Close(); } return nalogGk; }