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