protected void save()
{
if (txt_name.Text.Trim() == string.Empty || txtCode.Text.Trim() == string.Empty)
{
MessageBox.Show("Fill in all required missing values", "Save", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
SubLedgerCategory.sub_ledger_category_name = txt_name.Text.Trim();
SubLedgerCategory.sub_ledger_category_id = txtCode.Text.Trim();
SubLedgerCategory.active = chkActive.Checked ? true : false;
SubLedgerCategory.usr_date_create = DateTime.Now;
SubLedgerCategory.usr_date_update = DateTime.Now;
SubLedgerCategory.usr_id_create = SystemConst._user_id;
SubLedgerCategory.usr_id_update = SystemConst._user_id;
if (SubLedgerCategory.LoadRecord("select_sub_ledger_category_details", txtCode.Text.Trim()).Rows.Count > 0)
{
SubLedgerCategory.save("update_sub_ledger_category");
MessageBox.Show("Succefully updated sub ledger category", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadListing();
}
else
{
SubLedgerCategory.save("save_sub_ledger_category");
MessageBox.Show("Succefully created sub ledger category", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadListing();
}
}
}
protected void LoadSubLedger()
{
dt = SubLedgerCategory.LoadRecord("select_sub_ledger_category_details", string.Empty);
DataRow dtRow = dt.NewRow();
dtRow["sub_ledger_category_id"] = string.Empty;
dtRow["sub_ledger_category_name"] = "select one";
dt.Rows.InsertAt(dtRow, 0);
cboLedgerCategory.DataSource = dt;
cboLedgerCategory.ValueMember = "sub_ledger_category_id";
cboLedgerCategory.DisplayMember = "sub_ledger_category_name";
cboLedgerCategory.AutoCompleteMode = AutoCompleteMode.Suggest;
cboLedgerCategory.AutoCompleteSource = AutoCompleteSource.ListItems;
dt = SubLedgerCategory.LoadRecord("select_sub_ledger_category_details", string.Empty);
DataRow _dtRow = dt.NewRow();
_dtRow["sub_ledger_category_id"] = string.Empty;
_dtRow["sub_ledger_category_name"] = "select one";
dt.Rows.InsertAt(_dtRow, 0);
cboSubLedgerSearch.DataSource = dt;
cboSubLedgerSearch.ValueMember = "sub_ledger_category_id";
cboSubLedgerSearch.DisplayMember = "sub_ledger_category_name";
cboSubLedgerSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
cboSubLedgerSearch.AutoCompleteSource = AutoCompleteSource.ListItems;
}
protected void LoadListing()
{
dt = SubLedgerCategory.LoadRecord("select_sub_ledger_category_details", string.Empty);
if (dt != null)
{
this.gdv_List.DataSource = dt;
this.gdv_List.Columns["usr_id_create"].Visible = false;
this.gdv_List.Columns["usr_id_update"].Visible = false;
this.gdv_List.Columns["usr_date_create"].Visible = false;
this.gdv_List.Columns["usr_date_update"].Visible = false;
this.gdv_List.Columns["sub_ledger_category_id"].HeaderText = "SubLedger Category Code";
this.gdv_List.Columns["sub_ledger_category_name"].HeaderText = "SubLedger Category Name";
this.gdv_List.Columns["active"].HeaderText = "Active";
this.gdv_List.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_List.DefaultCellStyle.SelectionForeColor = Color.Black;
this.gdv_List.RowsDefaultCellStyle.BackColor = Color.LightGray;
this.gdv_List.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.gdv_List.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
this.gdv_List.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_List.RowHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_List.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_List.DefaultCellStyle.SelectionForeColor = Color.Black;
}
}
