protected void save()
{
#region SetVariables
ChartofAccounts.acc_type_id = cboAccountType.SelectedValue.ToString();
ChartofAccounts.acc_number = txtAccountNumber.Text;
ChartofAccounts.bank = cboBank.SelectedValue.ToString();
ChartofAccounts.acc_name = txtAccountTitle.Text + "-" + txtAccountNumber.Text;
ChartofAccounts.opening_bal = decimal.Parse(txtOpeningBal.Text);
ChartofAccounts.debit_credit = cboCreditDebit.Text;
ChartofAccounts.branch_id = cboBranch.SelectedValue.ToString();
ChartofAccounts.usr_id_create = SystemConst._user_id;
ChartofAccounts.usr_id_update = SystemConst._user_id;
ChartofAccounts.usr_date_create = DateTime.Now;
ChartofAccounts.usr_date_update = DateTime.Now;
#endregion
if (lblID.Text == Globals.EmptyID)
{
ChartofAccounts.acc_id = Guid.NewGuid().ToString();
ChartofAccounts.save("save_account_details");
MessageBox.Show("Succefully saved new account details", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadChartofAccountsListing();
}
else
{
ChartofAccounts.acc_id = lblID.Text;
ChartofAccounts.save("update_account_details");
MessageBox.Show("Succefully updated account details", "update", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadChartofAccountsListing();
}
}
protected void LoadChartofAccountsListing()
{
dt = ChartofAccounts.LoadListing("select_chart_of_acounts_listing");
gdvList.DataSource = dt;
gdvList.Columns["acc_id"].Visible = false;
gdvList.Columns["acc_type_name"].HeaderText = "Account Type";
gdvList.Columns["acc_name"].HeaderText = "Account Name";
gdvList.Columns["acc_number"].HeaderText = "Account Number";
gdvList.Columns["opening_bal"].HeaderText = "Opening Balance";
gdvList.Columns["Bank"].HeaderText = "Bank";
gdvList.Columns["debit_credit"].HeaderText = "Debit/Credit";
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;
}
protected void LoadNorminalAccountList()
{
dt = ChartofAccounts.LoadListing("select_chart_of_acounts_listing");
DataRow dtRow = dt.NewRow();
dtRow["acc_id"] = string.Empty;
dtRow["acc_name"] = "select one";
dt.Rows.InsertAt(dtRow, 0);
cboNorminalAcc.DataSource = dt;
cboNorminalAcc.ValueMember = "acc_id";
cboNorminalAcc.DisplayMember = "acc_name";
cboNorminalAcc.AutoCompleteMode = AutoCompleteMode.Suggest;
cboNorminalAcc.AutoCompleteSource = AutoCompleteSource.ListItems;
dt = ChartofAccounts.LoadListing("select_chart_of_acounts_listing");
DataRow _dtRow = dt.NewRow();
_dtRow["acc_id"] = string.Empty;
_dtRow["acc_name"] = "select one";
dt.Rows.InsertAt(_dtRow, 0);
cboControlAccSearch.DataSource = dt;
cboControlAccSearch.ValueMember = "acc_id";
cboControlAccSearch.DisplayMember = "acc_name";
cboControlAccSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
cboControlAccSearch.AutoCompleteSource = AutoCompleteSource.ListItems;
}