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