protected void Load_stations()
{
DataTable dt = new DataTable();
dt = LegacyReports.LoadBranches("select_station_list");
DataRow emptyRow = dt.NewRow();
emptyRow["branch"] = "All";
emptyRow["accounts_code"] = "-1";
dt.Rows.InsertAt(emptyRow, 0);
cboBranch.DataSource = dt;
cboBranch.DisplayMember = "branch";
cboBranch.ValueMember = "accounts_code";
DataTable _dt = new DataTable();
_dt = LegacyReports.LoadBranches("select_station_list");
DataRow _emptyRow = _dt.NewRow();
_emptyRow["branch"] = "select one";
_emptyRow["accounts_code"] = "-1";
_dt.Rows.InsertAt(_emptyRow, 0);
cbostation.DataSource = _dt;
cbostation.DisplayMember = "branch";
cbostation.ValueMember = "accounts_code";
}
protected void LoadRecords()
{
dt = LegacyReports.LoadLegacyAccountEntries("select_legacy_transaction_entries", Convert.ToInt32(cboYear.Text));
gdvList.DataSource = dt;
gdvList.Columns["dat"].HeaderText = "Date";
gdvList.Columns["tref"].HeaderText = "Reference Number";
gdvList.Columns["chq"].HeaderText = "Cheque Number";
gdvList.Columns["payee"].HeaderText = "Payee";
gdvList.Columns["dcode"].HeaderText = "Debit Account code";
gdvList.Columns["dtitle"].HeaderText = "Debit Account Title";
gdvList.Columns["ccode"].HeaderText = "Credit Account code";
gdvList.Columns["ctitle"].HeaderText = "Credit Account Title";
gdvList.Columns["sub"].HeaderText = "Sub-Ledger";
gdvList.Columns["amt"].HeaderText = "Amount";
gdvList.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdvList.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
gdvList.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdvList.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdvList.RowHeadersDefaultCellStyle.BackColor = Color.Black;
gdvList.DefaultCellStyle.SelectionBackColor = Color.Cyan;
gdvList.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in this.gdvList.Columns)
{
c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12f, GraphicsUnit.Pixel);
}
this.gdvList.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
this.gdvList.EnableHeadersVisualStyles = false;
}
private void cbostation_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = LegacyReports.LoadClients("select_client_list", cbostation.SelectedValue.ToString());
DataRow emptyRow = dt.NewRow();
emptyRow["stitle"] = "All";
emptyRow["scode"] = "-1";
dt.Rows.InsertAt(emptyRow, 0);
cboclient.DataSource = dt;
cboclient.DisplayMember = "stitle";
cboclient.ValueMember = "scode";
}
