private void advTree1_AfterNodeSelect(object sender, DevComponents.AdvTree.AdvTreeNodeEventArgs e) { curr_node = e.Node; if (curr_node == null) { return; } labelclient.Text = curr_node == null ? string.Empty : curr_node.Text; if (curr_node.Level == 0) { label3.Text = string.Empty; m_account = null; clear_grid_data(); fGrid.Enabled = false; return; } if (curr_node.Tag != null) { if (!fGrid.Enabled) { fGrid.Enabled = true; } m_account = curr_node.Tag as ic.accountC; LoadAccountDetail(m_account); label3.Text = curr_node.Text; } }
private void Recursive(DevComponents.AdvTree.Node _nd) { ic.accountC _acc = _nd.Tag as ic.accountC; iGRow _row = null; foreach (var t in _nd.Nodes.Cast <DevComponents.AdvTree.Node>()) { _row = fGrid.Rows.Add(); _row.Level = t.Level - 1; _row.Font = new Font("georgia", 12, FontStyle.Regular); _row.ReadOnly = iGBool.True; _row.Cells["Account Name"].Value = t.Text; _row.Cells["Alias"].Value = null; _row.Cells["section_index"].Value = _acc.account_dept_type.ToByte(); _row.Cells["section_name"].Value = _acc.account_dept_type.ToStringNullable(); _row.Key = _acc.account_id.ToStringNullable(); _row.AutoHeight(); if (t.Nodes.Count == 0) { continue; } _row.TreeButton = iGTreeButtonState.Visible; Recursive(t); } }
private void contextMenuFile_Opening(object sender, CancelEventArgs e) { if (advTree1.SelectedNode == null || advTree1.SelectedNode.Tag == null) { e.Cancel = true; return; } ic.accountC _acc = advTree1.SelectedNode.Tag as ic.accountC; if (_acc != null) { e.Cancel = true; //if (_acc.is_sys_account) //{ // e.Cancel = true; //} if (_acc.is_sys_account & LCB_ACCOUNT.IndexOf(_acc.account_id) > -1) { e.Cancel = false; } disableAccountToolStripMenuItem.Text = m_account.account_status == em.account_statusS.Enabled ? "Disable Account" : "Enable Account"; if (LCB_ACCOUNT.IndexOf(_acc.account_id) > -1) { linkToChurchGroupSharedToolStripMenuItem.Visible = true; } else { linkToChurchGroupSharedToolStripMenuItem.Visible = false; } } }
private void LoadAccountDetail(ic.accountC _acc) { clear_grid_data(); if (_acc == null) { return; } fGrid.Rows["alias"].Cells["desc"].Value = _acc.search_alias; fGrid.Rows["alias"].AutoHeight(); fGrid.Rows["account_id"].Cells["desc"].Value = _acc.account_id.ToStringNullable(); fGrid.Rows["account_id"].AutoHeight(); fGrid.Rows["account_status"].Cells["desc"].Value = _acc.account_status == em.account_statusS.Enabled ? "Enabled" : "Disabled"; fGrid.Rows["is_sys_account"].Cells["desc"].Value = _acc.is_sys_account ? "Yes" : "No"; }
private void MergeAccountsMaker_Load(object sender, EventArgs e) { CenterToScreen(); m_group_account = this.Tag as ic.accountC; if (m_group_account == null) { return; this.Close(); } backworker.RunWorkerAsync(); }
public void NewIncomeAccount(ic.accountC _inc) { if (_inc == null) { return; } var Parent_node = advTree1.FindNodeByName(string.Format("Account{0}", _inc.p_account_id)); if (Parent_node != null) { DevComponents.AdvTree.Node _nd = new DevComponents.AdvTree.Node(); _nd.ContextMenu = contextMenuFile; _nd.Text = _inc.account_name; _nd.Tag = _inc; _nd.Name = string.Format("Account{0}", _inc.account_id); if (_inc.account_status == em.account_statusS.Disabled) { _nd.Style = _disabled; } if (_inc.account_status == em.account_statusS.Enabled) { _nd.Style = _file_style; } Parent_node.Nodes.Add(_nd); _nd = null; Parent_node.Expand(); } if (_inc.PostType == em.postTypeS.cash_accounts_payable) { #region fill other_income_payable datam.GetAccountsPayable(null); var _gp = datam.GetAccountByAlias("OIPAYABLE"); if (_gp != null) { var parent_node = advTree1.FindNodeByName(string.Format("Account{0}", _gp.account_id)); DevComponents.DotNetBar.ElementStyle _tt = new DevComponents.DotNetBar.ElementStyle(); _tt.TextColor = Color.DeepPink; _tt.Font = new Font("verdana", 12, FontStyle.Regular); DevComponents.AdvTree.Node _nd = new DevComponents.AdvTree.Node(); _nd.Text = _inc.account_name; _nd.Style = _tt; _nd.Name = string.Format("PAYABLE{0}", _inc.account_id); parent_node.Nodes.Add(_nd); } #endregion } }
private void LoadMainGrid(IEnumerable <ic.cash_transferC> _list) { fGrid.BeginUpdate(); fGrid.Rows.Clear(); if (_list == null) { fGrid.EndUpdate(); return; } iGRow _row = null; ic.accountC _acc = null; foreach (var n in _list) { _row = fGrid.Rows.Add(); _row.ReadOnly = iGBool.True; _row.Font = new Font("georgia", 12, FontStyle.Regular); _row.Cells["date"].Value = n.fs_date.Value.ToMyShortDate(); _acc = datam.DATA_ACCOUNTS[n.source_id]; _row.Cells["from_account"].Value = _acc.account_name; // _acc = datam.DATA_ACCOUNTS[n.destination_id]; _row.Cells["to_account"].Value = _acc.account_name; if (_acc.account_id == -2355) { _row.Cells["to_account"].Value = "LCB"; } // _row.Cells["amount"].Value = n.amount; _row.Cells["amount"].TextAlign = iGContentAlignment.MiddleCenter; _row.Cells["amount"].ForeColor = Color.DarkBlue; // _row.Cells["details"].Value = n.transfer_reason; // _row.Key = n.un_id.ToStringNullable(); _row.Tag = n; _row.AutoHeight(); n.is_updated = false; } fGrid.EndUpdate(); fGrid.Cols.AutoWidth(); fGrid.AutoResizeCols = false; }
private void contextMenuFolder_Opening(object sender, CancelEventArgs e) { if (advTree1.SelectedNode == null || advTree1.SelectedNode.Tag == null) { e.Cancel = true; return; } ic.accountC _acc = advTree1.SelectedNode.Tag as ic.accountC; if (_acc != null) { if (_acc.account_dept_type != em.account_d_typeS.Expenses) { e.Cancel = true; } } if (curr_node != null) { toolStripMenuItem1.Visible = curr_node.Level == 2 ? false : true; } deleteToolStripMenuItem.Visible = curr_node.Nodes.Count == 0 ? true : false; }
private void checkBox1_CheckedChanged_1(object sender, EventArgs e) { checkBox1.Text = checkBox1.Checked ? "UnCheck To Show Sub Departments" : "Hide Sub Departments"; foreach (var _grid in new iGrid[] { fGrid, fGridnormal }) { _grid.BeginUpdate(); ic.accountC _acc = null; iGRow _row = null; var _row_list = from _r in _grid.Rows.Cast <iGRow>() where _r.Level == 0 & _r.Cells["has_children"].Value != null select _r; foreach (var k in _row_list) { try { _row = k; _row.Expanded = false; _row.TreeButton = checkBox1.Checked ? iGTreeButtonState.Absent : iGTreeButtonState.Visible; } catch (Exception ex) { continue; } // if ((_row.Index + 1) >= _grid.Rows.Count - 1) { break; } for (int j = (_row.Index + 1); j < _grid.Rows.Count; j++) { if (_grid.Rows[j].Level == _row.Level) { break; } _grid.Rows[j].Visible = checkBox1.Checked ? false : true; } } _grid.EndUpdate(); } }
private void buttoncreate_Click(object sender, EventArgs e) { if (fGrid.CurCell != null) { fGrid.CommitEditCurCell(); } if (!IsValid()) { return; } string _str = "Are You Sure You Want To Create This Account ??"; if (!dbm.WarningMessage(_str, "Save Warning")) { return; } ic.bank_reconc_accountC _acc = new ic.bank_reconc_accountC(); _acc.br_acc_name = fGrid.Rows["account_name"].Cells[1].Text.ToProperCase(); _acc.br_acc_type = (em.bank_reconc_typeS)(fGrid.Rows["account_type"].Cells[1].AuxValue as fnn.iGComboItemEX).ID; ic.accountC _sys_account = null; using (var xd = new xing()) { switch (_acc.br_acc_type) { case em.bank_reconc_typeS.deduction: { _sys_account = accn.CreateChildAccount(xd, accn.GetAccountByAlias("BANK_RECONCILIATION_EXPENSE").account_id, _acc.br_acc_name); break; } case em.bank_reconc_typeS.addition: { _sys_account = accn.CreateChildAccount(xd, accn.GetAccountByAlias("BANK_RECONCILATION_INCOME").account_id, _acc.br_acc_name); break; } } _acc.sys_account_id = _sys_account.account_id; // _acc.br_acc_id = xd.SingleInsertCommandTSPInt("acc_bank_reconc_accounts_tb", new string[] { "br_acc_name", "br_acc_type_id", "sys_account_id", "lch_id", "fs_time_stamp", }, new object[] { _acc.br_acc_name, _acc.br_acc_type.ToInt16(), _acc.sys_account_id, sdata.ChurchID, 0, } ); if (datam.DATA_BANK_RECONCILIATION_ACCOUNTS == null) { datam.DATA_BANK_RECONCILIATION_ACCOUNTS = new SortedList <int, ic.bank_reconc_accountC>(); } datam.DATA_BANK_RECONCILIATION_ACCOUNTS.Add(_acc.br_acc_id, _acc); xd.CommitTransaction(); } this.Tag = 1; sdata.ClearFormCache(em.fm.chart_of_accounts.ToInt16()); ClearGrid(); }
private void buttoncreate_Click(object sender, EventArgs e) { if (fGrid.CurCell != null) { fGrid.CommitEditCurCell(); } if (!IsValid()) { return; } string _str = "Are You Sure You Want To Perform This Operation ??"; if (!dbm.WarningMessage(_str, "Save Warning")) { return; } ic.accountC _from = (fGrid.Rows["account_from"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; ic.accountC _to = (fGrid.Rows["account_to"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; // using (var xd = new xing()) { string[] _cols = new string[] { "source_type_id", "source_id", "transaction_id", "destination_type_id", "destination_id", "amount", "fs_date", "fs_id", "fs_time_stamp", "lch_id" }; var _ts_id = accn.AccountsTransaction(xd, string.Format("Being Transfer Of Account Balance for {0} To {1}", _from.account_name, _to.account_name), sdata.CURR_DATE); var _amount = accn.GetFs_AccountBalance(xd, sdata.CURR_FS.fs_id, _from.account_id); var _ret_id = xd.SingleInsertCommandTSPInt("acc_cash_transfer_tb", _cols, new object[] { em.CashTransferSourceType.account, _from.account_id, _ts_id, em.CashTransferDestinationType.account, _to.account_id, _amount, sdata.CURR_DATE, sdata.CURR_FS.fs_id, 0, datam.LCH_ID }); // switch (m_group_account.account_dept_category) { case em.account_d_categoryS.Liablity: { accn.JournalBook(xd, sdata.CURR_DATE, em.j_sectionS.creditor, _ts_id, _from.account_id, _amount, 0); accn.JournalBook(xd, sdata.CURR_DATE, em.j_sectionS.creditor, _ts_id, _to.account_id, 0, _amount); // _from.account_status = em.account_statusS.DeActivated; datam.LoadCrExpOffItems(xd); var to_exp_link_obj = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.gen_account_id == _to.account_id & k._type == em.link_accTypes.creditor).FirstOrDefault(); var to_exp_sys_account_id = 0; ic.expense_accountC to_expense_account = null; if (to_exp_link_obj != null) { to_exp_sys_account_id = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.link_id == to_exp_link_obj.link_id & k._type == em.link_accTypes.expense_accrued).FirstOrDefault().gen_account_id; to_expense_account = datam.DATA_EXPENSE_ACCOUNTS.Values.Where(p => p.sys_account_id == to_exp_sys_account_id).FirstOrDefault(); } #region From var from_cr_inc_item = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.gen_account_id == _from.account_id & k._type == em.link_accTypes.creditor).FirstOrDefault(); if (from_cr_inc_item != null && from_cr_inc_item.cg_id == 0) { xd.SingleUpdateCommandALL("accounts_tb", new string[] { "account_status_id", "account_id" }, new object[] { em.account_statusS.DeActivated.ToInt16(), from_cr_inc_item.account_id }, 1); // xd.SingleUpdateCommandALL("accounts_tb", new string[] { "account_status_id", "account_id" }, new object[] { em.account_statusS.DeActivated.ToInt16(), _from.account_id }, 1); // var _exp_setting = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.link_id == from_cr_inc_item.link_id & k._type == em.link_accTypes.expense_accrued).FirstOrDefault(); if (_exp_setting != null) { ic.expense_accountC from_exp_account = (from k in datam.DATA_EXPENSE_ACCOUNTS.Values where k.sys_account_id == _exp_setting.gen_account_id select k).FirstOrDefault(); if (from_exp_account != null) { if (xd.ExecuteScalarInt(string.Format("select count(un_id) as cnt from acc_expense_trans_tb where exp_acc_id={0}", from_exp_account.exp_acc_id)) > 0) { if (to_expense_account != null) { string _upd_str = string.Format("update acc_expense_trans_tb set exp_cat_id={0},dept_id={1},dept_parent_id={2},exp_acc_id={3},sys_account_id={4},{5},fs_time_stamp={6} where exp_acc_id={7}", to_expense_account.exp_cat_id, to_expense_account.dept_id, to_expense_account.dept_parent_id, to_expense_account.exp_acc_id, to_expense_account.sys_account_id, dbm.ETS, SQLH.UnixStamp, from_exp_account.exp_acc_id); xd.SingleUpdateCommand(_upd_str); } } from_exp_account.exp_acc_status = em.exp_acc_statusS.invalid; xd.SingleUpdateCommandALL("acc_expense_accounts_tb", new string[] { "exp_acc_status", "exp_acc_id" }, new object[] { from_exp_account.exp_acc_status.ToInt16(), from_exp_account.exp_acc_id }, 1); } } } #endregion // break; } } xd.CommitTransaction(); } ClearGrid(); this.Close(); }
private void buttonX1_Click(object sender, EventArgs e) { if (!IsValid()) { return; } string _str = "Are You Sure You Want To Save This Record ??"; if (!dbm.WarningMessage(_str, "Save Warning")) { return; } ic.pledgeSettingC _pledge = new ic.pledgeSettingC(); _pledge.pledge_name = fGrid.Rows["pledge_name"].Cells[1].Text.Trim(); _pledge.pledge_name.ToProperCase(); _pledge.start_date = System.Convert.ToDateTime(fGrid.Rows["start_date"].Cells[1].AuxValue); _pledge.start_fs_id = fn.GetFSID(_pledge.start_date.Value); _pledge.status = em.pledge_setting_statusS.valid; if (fGrid.Rows["end_date"].Cells[1].AuxValue != null) { _pledge.end_date = System.Convert.ToDateTime(fGrid.Rows["end_date"].Cells[1].AuxValue); _pledge.end_fs_id = fn.GetFSID(_pledge.end_date.Value); } ic.accountC account = (fGrid.Rows["account"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; if (account != null) { _pledge.account_id = account.account_id; } using (var xd = new xing()) { _pledge.pls_id = xd.SingleInsertCommandTSPInt("pledge_settings_tb", new string[] { "account_id", "start_date", "start_fs_id", "end_date", "end_fs_id", "fs_date", "pc_us_id", "exp_type", "fs_time_stamp", "lch_id", "start_year", "pledge_name" }, new object[] { _pledge.account_id, _pledge.start_date, _pledge.start_fs_id, _pledge.end_date, _pledge.end_fs_id, sdata.CURR_DATE, sdata.PC_US_ID, emm.export_type.insert.ToByte(), 0, datam.LCH_ID, _pledge.start_date.Value.Year, _pledge.pledge_name }); xd.CommitTransaction(); } if (this.Owner is Pledge.PledgesManagerB) { (this.Owner as Pledge.PledgesManagerB).NewRecord(_pledge); } buttonX2.PerformClick(); }
private void buttoncreate_Click(object sender, EventArgs e) { if (fGrid.CurCell != null) { fGrid.CommitEditCurCell(); } if (!IsValid()) { return; } string _str = "Are You Sure You Want To Perform This Operation ??"; if (!dbm.WarningMessage(_str, "Save Warning")) { return; } ic.accountC _from = (fGrid.Rows["account_from"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; ic.accountC _to = (fGrid.Rows["account_to"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; // using (var xd = new xing()) { string[] _cols = new string[] { "source_type_id", "source_id", "transaction_id", "destination_type_id", "destination_id", "amount", "fs_date", "fs_id", "fs_time_stamp", "lch_id", "transfer_reason", "edate", "pc_us_id", "m_partition_id" }; var _ts_id = accn.AccountsTransaction(xd, string.Format("Being Transfer Of Account Balance from {0} To {1}", _from.account_name, _to.account_name), sdata.CURR_DATE); var _amount = fGrid.Rows["transfer_amount"].Cells[1].Value.ToInt32(); var _ret_id = xd.SingleInsertCommandTSPInt("acc_cash_transfer_tb", _cols, new object[] { em.CashTransferSourceType.account, _from.account_id, _ts_id, em.CashTransferDestinationType.account, _to.account_id, _amount, m_SelectedDate, fn.GetFSID(m_SelectedDate.Value), 0, datam.LCH_ID, fGrid.Rows["reason"].Cells[1].Text, sdata.CURR_DATE, sdata.PC_US_ID, string.Format("{0}{1}", m_SelectedDate.Value.Year, m_SelectedDate.Value.Month).ToInt32() }); em.j_sectionS?source_j_section = null; em.j_sectionS?dest_j_section = null; int source_dr = 0; int source_cr = 0; int dest_dr = 0; int dest_cr = 0; switch (_from.account_dept_category) { case em.account_d_categoryS.Liablity: { source_j_section = em.j_sectionS.creditor; source_dr = _amount; break; } case em.account_d_categoryS.Asset: { source_j_section = em.j_sectionS.asset; source_cr = _amount; break; } default: { MessageBox.Show("You Have Performed An Invalid Operation", "Invalid Operation"); return; } } switch (_to.account_dept_category) { case em.account_d_categoryS.Asset: { dest_j_section = em.j_sectionS.asset; dest_dr = _amount; break; } case em.account_d_categoryS.Liablity: { dest_j_section = em.j_sectionS.creditor; dest_cr = _amount; break; } case em.account_d_categoryS.PL: { dest_j_section = em.j_sectionS.income; dest_cr = _amount; break; } } /// accn.JournalBook(xd, m_SelectedDate.Value, source_j_section.Value, _ts_id, _from.account_id, source_dr, source_cr); accn.JournalBook(xd, m_SelectedDate.Value, dest_j_section.Value, _ts_id, _to.account_id, dest_dr, dest_cr); // if (accn.GetAccountBaseParent(_from.account_id).search_alias == "WITHDRAWN_CHEQUES") { //cheque stuff; int wdr_id = xd.ExecuteScalarInt(string.Format("select wdr_id from acc_bank_withdraw_tb where sys_account_id={0}", _from.account_id)); if (wdr_id > 0) { xd.UpdateFsTimeStamp("acc_bank_withdraw_tb"); var _st = string.Format("update acc_bank_withdraw_tb set cheque_balance=(cheque_balance-{0}),{1},fs_time_stamp={2} where wdr_id={3}", _amount, dbm.ETS, SQLH.UnixStamp, wdr_id); xd.SingleUpdateCommand(_st); } if (accn.GetAccountBaseParent(_to.account_id).search_alias == "WITHDRAWN_CHEQUES") { xd.UpdateFsTimeStamp("acc_bank_withdraw_tb"); wdr_id = xd.ExecuteScalarInt(string.Format("select wdr_id from acc_bank_withdraw_tb where sys_account_id={0}", _to.account_id)); if (wdr_id > 0) { xd.UpdateFsTimeStamp("acc_bank_withdraw_tb"); var _st = string.Format("update acc_bank_withdraw_tb set cheque_balance=(cheque_balance+{0}),{1},fs_time_stamp={2} where wdr_id={3}", _amount, dbm.ETS, SQLH.UnixStamp, wdr_id); xd.SingleUpdateCommand(_st); } } } xd.CommitTransaction(); } ClearGrid(); this.Tag = 1; this.Close(); }
private void FillAccountsByDate(DateTime?start_date) { m_SourceAccounts.Items.Clear(); m_DestinationAccounts.Items.Clear(); using (var xd = new xing()) { foreach (var _alias in new string[] { "LC_OFFERTORY_PAYABLE", "DISTRICT_PAYABLE", "CHURCH_SUBUNITS_PAYABLE", "WITHDRAWN_CHEQUES" }) { var clist = accn.GetChildAccounts(accn.GetAccountByAlias(_alias).account_id, em.account_typeS.ActualAccount); m_ChequeList.Clear(); foreach (var k in clist) { switch (_alias) { case "LC_OFFERTORY_PAYABLE": case "DISTRICT_PAYABLE": case "CHURCH_SUBUNITS_PAYABLE": { if (accn.GetFs_AccountBalance(xd, fn.GetFSID(start_date.Value), k.account_id) > 0) { m_SourceAccounts.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k }); } m_DestinationAccounts.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k }); break; } case "WITHDRAWN_CHEQUES": { if (accn.GetFs_AccountBalance(xd, fn.GetFSID(sdata.CURR_DATE), k.account_id) > 0) { m_SourceAccounts.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k }); } m_DestinationAccounts.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k }); m_ChequeList.Add(k.account_name); break; } } } } ic.accountC _lcb = accn.GetAccountByAlias("LCB_CREDITOR_REDUCTION_INCOME"); m_DestinationAccounts.Items.Add(new fnn.iGComboItemEX() { Value = "LCB", Tag = _lcb }); xd.CommitTransaction(); } }
private void fGrid_AfterCommitEdit(object sender, iGAfterCommitEditEventArgs e) { if (fGrid.Rows[e.RowIndex].Cells["desc"].DropDownControl != null && fGrid.Rows[e.RowIndex].Cells["desc"].AuxValue == null) { fGrid.Rows[e.RowIndex].Cells["desc"].Value = null; for (int y = (e.RowIndex + 1); y < fGrid.Rows.Count; y++) { fGrid.Rows[y].Cells["desc"].Value = null; fGrid.Rows[y].Cells["desc"].AuxValue = null; if (fGrid.Rows[y].Cells["desc"].Selectable == iGBool.True) { fGrid.Rows[y].Cells["desc"].Enabled = iGBool.False; } } if (fGrid.Rows[e.RowIndex].Key == "account_from") { FilterDestinationAccounts(null); } return; } switch (fGrid.Rows[e.RowIndex].Key) { case "transfer_date": { m_SelectedDate = System.Convert.ToDateTime(fGrid.Rows["transfer_date"].Cells[1].AuxValue); for (int y = (e.RowIndex + 1); y < fGrid.Rows.Count; y++) { fGrid.Rows[y].Cells["desc"].Value = null; fGrid.Rows[y].Cells["desc"].AuxValue = null; if (fGrid.Rows[y].Cells["desc"].Selectable == iGBool.True) { fGrid.Rows[y].Cells["desc"].Enabled = iGBool.False; } } FillAccountsByDate(m_SelectedDate); fGrid.Rows["account_from"].Cells[1].Enabled = iGBool.True; // break; } case "account_from": { ic.accountC _from = (fGrid.Rows["account_from"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; for (int y = (e.RowIndex + 1); y < fGrid.Rows.Count; y++) { fGrid.Rows[y].Cells["desc"].Value = null; fGrid.Rows[y].Cells["desc"].AuxValue = null; if (fGrid.Rows[y].Cells["desc"].Selectable == iGBool.True) { fGrid.Rows[y].Cells["desc"].Enabled = iGBool.False; } } using (var xd = new xing()) { fGrid.Rows["account_balance"].Cells[1].Value = accn.GetFs_AccountBalance(xd, fn.GetFSID(m_SelectedDate.Value), _from.account_id); } fGrid.Rows["account_to"].Cells[1].Enabled = iGBool.True; FilterDestinationAccounts(_from); break; } case "account_to": { for (int y = (e.RowIndex + 1); y < fGrid.Rows.Count; y++) { fGrid.Rows[y].Cells["desc"].Value = null; fGrid.Rows[y].Cells["desc"].AuxValue = null; if (fGrid.Rows[y].Cells["desc"].Selectable == iGBool.True) { fGrid.Rows[y].Cells["desc"].Enabled = iGBool.False; } } fGrid.Rows["transfer_amount"].Cells[1].Enabled = iGBool.True; fGrid.Rows["reason"].Cells[1].Enabled = iGBool.True; break; } case "transfer_amount": { if ((fGrid.Rows[e.RowIndex].Cells[1].Value.ToInt32() <= 0) | fGrid.Rows[e.RowIndex].Cells[1].Value.ToInt32() > fGrid.Rows["account_balance"].Cells[1].Value.ToInt32()) { MessageBox.Show("You Have Entered An Invalid Amount", "Invalid Amount", MessageBoxButtons.OK, MessageBoxIcon.Error); fGrid.Focus(); fGrid.Rows[e.RowIndex].Cells[1].Value = null; fGrid.SetCurCell(e.RowIndex, 1); return; } break; } } if (e.RowIndex != fGrid.Rows.Count - 1) { if (fGrid.Rows[e.RowIndex].Cells["desc"].Value == null) { return; } for (int k = e.RowIndex + 1; k < fGrid.Rows.Count; k++) { if (fGrid.Rows[k].Type == iGRowType.AutoGroupRow) { fGrid.Rows[k].Expanded = true; continue; } if (!fGrid.Rows[k].Visible) { continue; } if (fGrid.Rows[k].Cells[1].Enabled == iGBool.False) { continue; } if (fGrid.Rows[k].Cells[1].ReadOnly == iGBool.True) { continue; } if (string.IsNullOrEmpty(fGrid.Rows[k].Key)) { continue; } if ((e.RowIndex + 3) < fGrid.Rows.Count) { fGrid.Rows[(e.RowIndex + 3)].EnsureVisible(); } fGrid.SetCurCell(k, e.ColIndex); break; } } }
private void FilterDestinationAccounts(ic.accountC _source) { if (m_DestinationAccounts == null || m_DestinationAccounts.Items.Count == 0) { return; } if (_source == null) { foreach (var k in m_DestinationAccounts.Items.Cast <fnn.iGComboItemEX>()) { k.Visible = true; } return; } else { ic.accountC _base_parent = accn.GetAccountBaseParent(_source.account_id); if (_base_parent != null) { switch (_base_parent.search_alias) { case "WITHDRAWN_CHEQUES": { foreach (var k in m_DestinationAccounts.Items.Cast <fnn.iGComboItemEX>()) { if (m_ChequeList.IndexOf(k.Value.ToString()) > -1) { k.Visible = true; } else { k.Visible = false; } if (k.Value.ToString() == _source.account_name) { k.Visible = false; } } break; } case "ACC_PAYABLE": { foreach (var k in m_DestinationAccounts.Items.Cast <fnn.iGComboItemEX>()) { if (m_ChequeList.IndexOf(k.Value.ToString()) > -1) { k.Visible = false; } else { k.Visible = true; } if (k.Value.ToString() == _source.account_name) { k.Visible = false; } } break; } } } } // }
private void fGrid_AfterCommitEdit(object sender, iGAfterCommitEditEventArgs e) { iGRow _row = fGrid.Rows[e.RowIndex]; if (_row.Cells[1].DropDownControl != null && _row.Cells[1].AuxValue == null) { _row.Cells[1].Value = null; if (_row.Key == "account") { fGrid.Rows["end_date"].Cells[1].Value = null; fGrid.Rows["start_date"].Cells[1].Value = null; // fGrid.Rows["end_date"].Cells[1].Enabled = iGBool.False; fGrid.Rows["start_date"].Cells[1].Enabled = iGBool.False; // } return; } if (_row.Key == "start_date") { object _date_obj = Convert.ToDateTime(fGrid.Rows["start_date"].Cells["desc"].AuxValue); if (_date_obj == null) { _row.Cells["desc"].Value = sdata.CURR_DATE; return; } fGrid.Rows["end_date"].Cells[1].Value = null; fGrid.Rows["end_date"].Cells[1].AuxValue = null; var _date = Convert.ToDateTime(_date_obj); var _drop_down = fGrid.Rows["end_date"].Cells[1].DropDownControl as fnn.DropDownCalenderX; _drop_down.start_date = _date.AddDays(1); _drop_down.selected_date = _drop_down.start_date; _drop_down.end_date = _date.AddDays(366); // fGrid.Rows["end_date"].Cells[1].Enabled = iGBool.True; } // if (_row.Key == "account") { ic.accountC _acc = (fGrid.Rows["account"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; if (_acc != null) { var _saccount = (from k in datam.DATA_CURRENT_PLEDGE_SETTINGS.Values where k.account_id == _acc.account_id & k.status == em.pledge_setting_statusS.valid orderby k.pls_id descending select k).FirstOrDefault(); var _drop_down = fGrid.Rows["start_date"].Cells[1].DropDownControl as fnn.DropDownCalenderX; fGrid.Rows["start_date"].Cells[1].Value = null; fGrid.Rows["start_date"].Cells[1].AuxValue = null; if (_saccount != null) { _drop_down.start_date = _saccount.end_date.Value.AddDays(1); _drop_down.selected_date = _drop_down.start_date; _drop_down.end_date = _drop_down.start_date.Value.AddDays(365); } else { _drop_down.start_date = sdata.CURR_DATE.AddDays(-365); _drop_down.selected_date = sdata.CURR_DATE; _drop_down.end_date = sdata.CURR_DATE.AddDays(365); } fGrid.Rows["start_date"].Cells[1].Enabled = iGBool.True; fGrid.Rows["end_date"].Cells[1].Value = null; fGrid.Rows["end_date"].Cells[1].AuxValue = null; // fGrid.Rows["end_date"].Cells[1].Enabled = iGBool.False; } } if (_row.Key == "end_date") { if (_row.Cells[1].Value != null) { buttonX1.PerformClick(); } } if (e.RowIndex != fGrid.Rows.Count - 1) { if (fGrid.Rows[e.RowIndex].Cells["desc"].Value == null) { return; } for (int k = e.RowIndex + 1; k < fGrid.Rows.Count; k++) { if (fGrid.Rows[k].Type == iGRowType.AutoGroupRow) { fGrid.Rows[k].Expanded = true; continue; } if (!fGrid.Rows[k].Visible) { continue; } if (fGrid.Rows[k].Cells[1].Enabled == iGBool.False) { continue; } if (string.IsNullOrEmpty(fGrid.Rows[k].Key)) { continue; } if ((e.RowIndex + 3) < fGrid.Rows.Count) { fGrid.Rows[(e.RowIndex + 3)].EnsureVisible(); } fGrid.SetCurCell(k, e.ColIndex); break; } } }
private void fGrid_AfterCommitEdit(object sender, iGAfterCommitEditEventArgs e) { if (fGrid.Rows[e.RowIndex].Cells["desc"].DropDownControl != null && fGrid.Rows[e.RowIndex].Cells["desc"].AuxValue == null) { fGrid.Rows[e.RowIndex].Cells["desc"].Value = null; if (fGrid.Rows[e.RowIndex].Key == "account_from") { fGrid.Rows["account_to"].Cells[1].Value = null; fGrid.Rows["account_to"].Cells[1].AuxValue = null; fGrid.Rows["account_to"].Cells[1].Enabled = iGBool.False; } return; } if (fGrid.Rows[e.RowIndex].Key == "account_from") { fGrid.Rows["account_to"].Cells[1].Value = null; fGrid.Rows["account_to"].Cells[1].AuxValue = null; fGrid.Rows["account_to"].Cells[1].Enabled = iGBool.False; var icombo = fGrid.Rows["account_to"].Cells[1].DropDownControl as iGDropDownList; if (icombo == null) { icombo = fnn.CreateCombo(); fGrid.Rows["account_to"].Cells[1].DropDownControl = icombo; } ic.accountC _from = (fGrid.Rows["account_from"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag as ic.accountC; icombo.Items.Clear(); var nlist = accn.GetChildAccounts(m_group_account.account_id, em.account_typeS.ActualAccount); if (nlist != null) { foreach (var k in nlist) { if (k.account_status == em.account_statusS.DeActivated) { continue; } if (k.account_id == _from.account_id) { continue; } icombo.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k }); } } fGrid.Rows["account_to"].Cells[1].Enabled = iGBool.True; } if (e.RowIndex != fGrid.Rows.Count - 1) { if (fGrid.Rows[e.RowIndex].Cells["desc"].Value == null) { return; } for (int k = e.RowIndex + 1; k < fGrid.Rows.Count; k++) { if (fGrid.Rows[k].Type == iGRowType.AutoGroupRow) { fGrid.Rows[k].Expanded = true; continue; } if (!fGrid.Rows[k].Visible) { continue; } if (fGrid.Rows[k].Cells[1].Enabled == iGBool.False) { continue; } if (fGrid.Rows[k].Cells[1].ReadOnly == iGBool.True) { continue; } if (string.IsNullOrEmpty(fGrid.Rows[k].Key)) { continue; } if ((e.RowIndex + 3) < fGrid.Rows.Count) { fGrid.Rows[(e.RowIndex + 3)].EnsureVisible(); } fGrid.SetCurCell(k, e.ColIndex); break; } } }
private void LoadGrid() { var nlist = from k in datam.DATA_ACCOUNTS_PAYABLE.Values where k.balance != 0 & k.objAccount.account_type == em.account_typeS.ActualAccount orderby k.balance descending select k; iGRow _row = null; fGrid.BeginUpdate(); ic.accountC _acc = null; foreach (var r in nlist) { _row = fGrid.Rows.Add(); _row.Font = new Font("georgia", 12, FontStyle.Regular); _row.ReadOnly = iGBool.True; _acc = datam.DATA_ACCOUNTS[r.account_id]; if (r.account_id < 0) { _row.Cells["owner"].Value = "CUC"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; } _row.Cells["account"].Value = _acc.account_name; _row.Cells["balance"].Value = r.balance; _row.Cells["balance"].Font = new Font("verdana", 11, FontStyle.Regular); _row.Cells["balance"].ForeColor = Color.DarkBlue; _row.Cells["acc_category"].Value = datam.DATA_ACCOUNTS[_acc.p_account_id].account_name; // _row.Cells["owner"].Value = _acc.owner_name; switch (_acc.owner_type) { case em.AccountOwnerTypeS.CUC: { _row.Cells["owner"].Value = "CUC"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 1; break; } case em.AccountOwnerTypeS.CHURCH: { _row.Cells["owner"].Value = "Church"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 3; break; } case em.AccountOwnerTypeS.CHURCH_GROUP: { try { _row.Cells["owner"].Value = datam.DATA_CHURCH_GROUPS[_acc.owner_id].cg_name; } catch (Exception) { _row.Cells["owner"].Value = "Church Group"; } _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 5; break; } case em.AccountOwnerTypeS.CHURCH_MEMBER: { try { _row.Cells["owner"].Value = datam.DATA_MEMBER[_acc.owner_id].mem_name; } catch (Exception) { _row.Cells["owner"].Value = "Church Member"; } _row.Cells["svalue"].Value = "Church Members"; _row.Cells["s_id"].Value = 7; break; } case em.AccountOwnerTypeS.DEPARTMENT: { try { _row.Cells["owner"].Value = datam.DATA_DEPARTMENT[_acc.owner_id].dept_name; if (_row.Cells["owner"].Text.IndexOf("department") == -1) { _row.Cells["owner"].Value = _row.Cells["owner"].Text + " Department"; } } catch (Exception) { _row.Cells["owner"].Value = "Department"; } _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 4; break; } case em.AccountOwnerTypeS.DISTRICT: { _row.Cells["owner"].Value = "District"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 2; break; } case em.AccountOwnerTypeS.OTHER: { _row.Cells["owner"].Value = _acc.owner_name; _row.Cells["svalue"].Value = "Others"; _row.Cells["s_id"].Value = 6; break; } } if (r.objAccount.owner_id > 0) { try { var _cg = datam.DATA_CHURCH_GROUPS[r.objAccount.owner_id]; if (_cg != null) { _row.Cells["account"].Value = string.Format("{0} :: {1}", _acc.account_name, _cg.cg_name); _row.Cells["owner"].Value = _cg.cg_name; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 5; } } catch (Exception ex) { } } _row.AutoHeight(); _row.Key = string.Format("{0}{1}", r.account_id.ToString(), r.objAccount.owner_id); _row.Tag = r; r.is_updated = false; } ShowTotalCreditors(); fGrid.Cols.AutoWidth(); fGrid.AutoResizeCols = false; var Gtotal = from k in fGrid.Rows.Cast <iGRow>() group k by k.Cells["svalue"].Text into nw_gp select new { gp_name = nw_gp.Key, gp_total = nw_gp.Sum(p => p.Cells["balance"].Value.ToInt32()) }; m_GroupTotal.Clear(); foreach (var t in Gtotal) { m_GroupTotal.Add(t.gp_name, t.gp_total); } if (fGrid.GroupObject.Count == 0) { fGrid.GroupObject.Add("svalue"); } fGrid.Group(); fGrid.PerformAction(iGActions.CollapseAll); fGrid.EndUpdate(); }
private void CheckUpdates() { using (var _xd = new xing()) { datam.InitAccount(_xd); _xd.CommitTransaction(); } wdata.TABLE_STAMP["accounts_current_balance_tb"] = m_LastStamp; if (datam.GetAccountsPayable(null)) { m_LastStamp = wdata.TABLE_STAMP["accounts_current_balance_tb"]; var nlist = from k in datam.DATA_ACCOUNTS_PAYABLE.Values where k.is_updated & k.objAccount.account_type == em.account_typeS.ActualAccount select k; if (nlist.Count() == 0) { return; } var _selected_cell = fGrid.CurCell; var ex_list = fGrid.Rows.Cast <iGRow>().Where(t => t.Type == iGRowType.AutoGroupRow & t.Expanded).Select(p => p.Key).ToList(); iGRow _row = null; fGrid.BeginUpdate(); fGrid.GroupObject.Clear(); fGrid.Group(); ic.accountC _acc = null; foreach (var r in nlist) { try { _row = fGrid.Rows[string.Format("{0}{1}", r.account_id.ToString(), r.objAccount.owner_id)]; _acc = datam.DATA_ACCOUNTS[r.account_id]; _row.Cells["balance"].Value = r.balance; } catch (Exception ex) { #region new_row _row = fGrid.Rows.Add(); _row.Font = new Font("georgia", 12, FontStyle.Regular); _row.ReadOnly = iGBool.True; _acc = datam.DATA_ACCOUNTS[r.account_id]; if (r.account_id < 0) { _row.Cells["owner"].Value = "CUC"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; } _row.Cells["account"].Value = _acc.account_name; _row.Cells["balance"].Value = r.balance; _row.Cells["balance"].Font = new Font("verdana", 11, FontStyle.Regular); _row.Cells["balance"].ForeColor = Color.DarkBlue; _row.Cells["acc_category"].Value = datam.DATA_ACCOUNTS[_acc.p_account_id].account_name; // _row.Cells["owner"].Value = _acc.owner_name; switch (_acc.owner_type) { case em.AccountOwnerTypeS.CUC: { _row.Cells["owner"].Value = "CUC"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 1; break; } case em.AccountOwnerTypeS.CHURCH: { _row.Cells["owner"].Value = "Church"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 3; break; } case em.AccountOwnerTypeS.CHURCH_GROUP: { try { _row.Cells["owner"].Value = datam.DATA_CHURCH_GROUPS[_acc.owner_id].cg_name; } catch (Exception) { _row.Cells["owner"].Value = "Church Group"; } _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 5; break; } case em.AccountOwnerTypeS.CHURCH_MEMBER: { try { _row.Cells["owner"].Value = datam.DATA_MEMBER[_acc.owner_id].mem_name; } catch (Exception) { _row.Cells["owner"].Value = "Church Member"; } _row.Cells["svalue"].Value = "Church Members"; _row.Cells["s_id"].Value = 7; break; } case em.AccountOwnerTypeS.DEPARTMENT: { try { _row.Cells["owner"].Value = datam.DATA_DEPARTMENT[_acc.owner_id].dept_name; if (_row.Cells["owner"].Text.IndexOf("department") == -1) { _row.Cells["owner"].Value = _row.Cells["owner"].Text + " Department"; } } catch (Exception) { _row.Cells["owner"].Value = "Department"; } _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 4; break; } case em.AccountOwnerTypeS.DISTRICT: { _row.Cells["owner"].Value = "District"; _row.Cells["svalue"].Value = _row.Cells["owner"].Value; _row.Cells["s_id"].Value = 2; break; } case em.AccountOwnerTypeS.OTHER: { _row.Cells["owner"].Value = _acc.owner_name; _row.Cells["svalue"].Value = "Others"; _row.Cells["s_id"].Value = 6; break; } case em.AccountOwnerTypeS.CHURCH_GROUP_SHARED: { if (r.objAccount.owner_id == 0) { _row.Cells["owner"].Value = "Church"; _row.Cells["s_id"].Value = 3; } else { try { var _cg = datam.DATA_CHURCH_GROUPS[r.objAccount.owner_id]; if (_cg != null) { _row.Cells["account"].Value = string.Format("{0} :: {1}", _acc.account_name, _cg.cg_name); _row.Cells["owner"].Value = _cg.cg_name; _row.Cells["s_id"].Value = 5; } } catch (Exception er) { } } _row.Cells["svalue"].Value = _row.Cells["owner"].Value; break; } } #endregion _row.AutoHeight(); _row.Key = string.Format("{0}{1}", r.account_id.ToString(), r.objAccount.owner_id); _row.Tag = r; } r.is_updated = false; } ShowTotalCreditors(); fGrid.Cols.AutoWidth(); fGrid.AutoResizeCols = false; var Gtotal = from k in fGrid.Rows.Cast <iGRow>() group k by k.Cells["svalue"].Text into nw_gp select new { gp_name = nw_gp.Key, gp_total = nw_gp.Sum(p => p.Cells["balance"].Value.ToInt32()) }; m_GroupTotal.Clear(); foreach (var t in Gtotal) { m_GroupTotal.Add(t.gp_name, t.gp_total); } if (fGrid.GroupObject.Count == 0) { fGrid.GroupObject.Add("svalue"); } fGrid.Group(); fGrid.PerformAction(iGActions.CollapseAll); foreach (var y in ex_list) { try { fGrid.Rows[y].Expanded = true; } catch (Exception ex) { } } fGrid.EndUpdate(); } }
private void buttonadd_Click(object sender, EventArgs e) { if (m_action == action_type.create) { #region Insert Region ic.departmentC _dept = new MTOMS.ic.departmentC(); _dept.dept_name = textBox1.Text.Trim().ToProperCase(); if (curr_node.Level == 1) { _dept.parent_id = curr_node.Parent.Tag == null ? 0 : curr_node.Parent.Tag.ToInt32(); } if (curr_node.Level == 2) { _dept.parent_id = curr_node.Parent.Tag == null ? 0 : (curr_node.Parent.Tag as ic.departmentC).dept_id; } _dept.is_visible = true; _dept.level = curr_node.Level; _dept.index = curr_node.Index; string[] _cols = new string[] { "exp_type", "is_visible", "lch_id", "fs_time_stamp", "dept_name", "parent_id", "s_level", "s_index" }; object[] _row = new object[] { emm.export_type.insert.ToByte(), 1, sdata.ChurchID, 0, _dept.dept_name, _dept.parent_id, _dept.level, _dept.index }; using (var xd = new xing()) { if (datam.DuplicateDepartmentName(_dept.dept_name, xd)) { MessageBox.Show("The Department Name You Have Entered Already Exists", "Duplicate Department Name"); buttonclose.PerformClick(); return; } _dept.dept_id = xd.SingleInsertCommandTSPInt("dept_master_tb_ns", _cols, _row); curr_node.Tag = _dept; curr_node.Text = _dept.dept_name; curr_node.Name = string.Format("DEPT{0}", _dept.dept_id); if (_dept.parent_id > 0) { _dept.expense_sys_account_id = accn.CreateChildGroupAccount(xd, datam.DATA_DEPARTMENT[_dept.parent_id].expense_sys_account_id, _dept.dept_name).account_id; _dept.cr_sys_account_id = datam.DATA_DEPARTMENT[_dept.parent_id].cr_sys_account_id; _dept.income_sys_account_id = datam.DATA_DEPARTMENT[_dept.parent_id].income_sys_account_id; } else { _dept.expense_sys_account_id = accn.CreateChildGroupAccount(xd, -2386, _dept.dept_name).account_id; _dept.income_sys_account_id = accn.CreateChildGroupAccount(xd, -2370, _dept.dept_name).account_id; _dept.cr_sys_account_id = accn.CreateChildGroupAccount(xd, -2369, _dept.dept_name).account_id; xd.UpdateFsTimeStamp("accounts_tb"); xd.SingleUpdateCommand(string.Format("update accounts_tb set link_id={0},{1},fs_time_stamp={2} where account_id in ({3},{4},{5})", _dept.expense_sys_account_id, dbm.ETS, SQLH.UnixStamp, _dept.expense_sys_account_id, _dept.income_sys_account_id, _dept.cr_sys_account_id)); } // xd.SingleUpdateCommandALL("dept_master_tb_ns", new string[] { "sys_account_id", "inc_sys_account_id", "cr_sys_account_id", "dept_id" }, new object[] { _dept.expense_sys_account_id, _dept.income_sys_account_id, _dept.cr_sys_account_id, _dept.dept_id }, 1); // ic.expense_accountC _exp = new ic.expense_accountC(); _exp.dept_id = _dept.dept_id; _exp.dept_parent_id = _dept.parent_id; _exp.dept_sys_account_id = _dept.expense_sys_account_id; _exp.exp_acc_name = string.Format("GE :: {0}", _dept.dept_name); _exp.exp_acc_status = em.exp_acc_statusS.valid; _exp.exp_acc_type = em.exp_acc_typeS.system_department; datam.DATA_DEPARTMENT.Add(_dept.dept_id, _dept); accn.CreateExpenseAccount(_exp, xd); if (_dept.parent_id < 0) { #region ic.accountC _inc_dept = new MTOMS.ic.accountC(); _inc_dept.account_name = string.Format("GI :: {0}", _dept.dept_name); _inc_dept.account_status = em.account_statusS.Enabled; _inc_dept.opening_balance = 0; _inc_dept.start_date = sdata.CURR_DATE; _inc_dept.owner_type = em.AccountOwnerTypeS.DEPARTMENT; _inc_dept.owner_id = _dept.dept_id; _inc_dept.owner_name = _dept.dept_name; _inc_dept.PostType = em.postTypeS.cash_accounts_payable; ic.accountC parent_account = datam.DATA_ACCOUNTS[_dept.income_sys_account_id]; _inc_dept.account_dept_type = parent_account.account_dept_type; _inc_dept.account_dept_category = parent_account.account_dept_category; _inc_dept.account_status = em.account_statusS.Enabled; _inc_dept.account_type = em.account_typeS.ActualAccount; _inc_dept.p_account_id = parent_account.account_id; _inc_dept.a_level = (parent_account.a_level + 1).ToInt16(); _inc_dept.a_index = ((datam.DATA_ACCOUNTS.Values.Count(l => l.p_account_id == parent_account.account_id & l.account_type == em.account_typeS.ActualAccount)) + 1).ToInt16(); _cols = new string[] { "acc_d_cat_id", "acc_d_type_id", "account_name", "account_type_id", "account_alias", "a_level", "a_index", "p_account_id", "exp_type", "fs_time_stamp", "edate", "pc_us_id", "account_status_id", "search_alias", "is_sys_account", "post_type_id", "owner_type_id", "owner_id", "owner_name", "start_date", "end_date", "opening_balance", "account_short_name", "account_code", "description", "lch_id", "ex_cg_type_ids", "accounts_ext_purpose" }; xd.UpdateFsTimeStamp("accounts_tb"); _row = new object[] { _inc_dept.account_dept_category.ToByte(), _inc_dept.account_dept_type.ToByte(), _inc_dept.account_name, _inc_dept.account_type.ToByte(), _inc_dept.account_alias, _inc_dept.a_level, _inc_dept.a_index, _inc_dept.p_account_id, emm.export_type.insert.ToByte(), 0, datam.CURR_DATE, datam.PC_US_ID, _inc_dept.account_status.ToByte(), null, //search_alias 0, // is_sys_account _inc_dept.PostType.ToByte(), //post_type _inc_dept.owner_type.ToByte(), //owner_type _inc_dept.owner_id, //owner_id _inc_dept.owner_name, //owner name _inc_dept.start_date, _inc_dept.end_date, //end_date _inc_dept.opening_balance, //opening balance _inc_dept.account_short_name, //account_short_name _inc_dept.account_code, _inc_dept.description, //description sdata.ChurchID, null, _inc_dept.extension_purpose.ToByte() }; _inc_dept.account_id = xd.SingleInsertCommandTSPInt("accounts_tb", _cols, _row); xd.UpdateFsTimeStamp("accounts_tb"); xd.SingleUpdateCommand(string.Format("update accounts_tb set link_id={0},{1},fs_time_stamp={2} where account_id in ({3},{4})", _dept.expense_sys_account_id, dbm.ETS, SQLH.UnixStamp, _inc_dept.account_id, _exp.sys_account_id)); if (datam.DATA_ACCOUNTS != null) { try { datam.DATA_ACCOUNTS.Add(_inc_dept.account_id, _inc_dept); } catch (Exception) { } } #endregion } switch (curr_node.Level) { case 1: { curr_node.Style = _sb_dept_style; break; } case 2: { curr_node.Style = _sb_dept_style2; break; } } curr_node.ContextMenu = contextMenuFile; xd.CommitTransaction(); } #endregion _dept = null; m_action = action_type.none; if (!is_edited) { is_edited = true; } sdata.ClearFormCache(em.fm.expense_account_settings.ToInt16()); sdata.ClearFormCache(em.fm.chart_of_accounts.ToInt16()); // sdata.ClearFormCache(em.fm.income_accounts_settings.ToInt16()); sdata.ClearFormCache(em.fm.creditors.ToInt16()); buttonclose.PerformClick(); } if (m_action == action_type.update) { if (curr_node != null && curr_node.Tag != null) { var _dept = curr_node.Tag as ic.departmentC; if (_dept != null) { using (var xd = new xing()) { if (datam.DuplicateDepartmentName(textBox1.Text.Trim().ToProperCase(), xd, _dept.dept_id)) { MessageBox.Show("The Department Name You Have Entered Already Exists", "Duplicate Department Name"); buttonclose.PerformClick(); return; } xd.SingleUpdateCommandALL("dept_master_tb_ns", new string[] { "dept_name", "dept_id" }, new object[] { textBox1.Text.Trim().ToProperCase(), _dept.dept_id }, 1); xd.SingleUpdateCommandALL("accounts_tb", new string[] { "account_name", "account_id" }, new object[] { textBox1.Text.Trim().ToProperCase(), _dept.expense_sys_account_id }, 1); xd.CommitTransaction(); } _dept.dept_name = textBox1.Text.Trim().ToProperCase(); curr_node.Text = _dept.dept_name; if (!is_edited) { is_edited = true; } sdata.ClearFormCache(em.fm.expense_account_settings.ToInt16()); sdata.ClearFormCache(em.fm.chart_of_accounts.ToInt16()); buttonclose.PerformClick(); } } } }
public static void Get_AssetLiabilityAccountStatement(xing xd, int start_fs_id, int end_fs_id, int account_id, string _account_name) { datam.InitAccount(xd); datam.LoadCrExpOffItems(xd); ic.accountC PrimaryAccount = datam.DATA_ACCOUNTS[account_id]; switch (PrimaryAccount.account_dept_category) { case em.account_d_categoryS.Liablity: { var _cr_inc_item = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.gen_account_id == account_id & k._type == em.link_accTypes.creditor).FirstOrDefault(); if (_cr_inc_item == null) { return; } int cg_id = _cr_inc_item.cg_id; int _income_acc_id = _cr_inc_item.account_id; ic.accountC _parent = datam.DATA_ACCOUNTS[_income_acc_id].p_account_id == 0 ? null : datam.DATA_ACCOUNTS[datam.DATA_ACCOUNTS[_income_acc_id].p_account_id]; if (_parent != null && _parent.account_id == -2360) { ic.church_sub_unitC _unit = (from c in datam.DATA_CHURCH_SUB_UNIT.Values where c.sys_gp_account_id == _income_acc_id select c).FirstOrDefault(); if (_unit != null) { int _expense_acc_id = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.link_id == _cr_inc_item.link_id & k._type == em.link_accTypes.expense_accrued).FirstOrDefault().gen_account_id; // Get_OffAccountsStatement(xd, start_fs_id, end_fs_id, _unit, _account_name); Get_CreditorExpenseStatement(xd, start_fs_id, end_fs_id, _expense_acc_id); Get_AccountTransfers(xd, start_fs_id, end_fs_id, account_id); // } } else { int _expense_acc_id = datam.DATA_CR_EXP_OFFITEMS.Values.Where(k => k.link_id == _cr_inc_item.link_id & k._type == em.link_accTypes.expense_accrued).FirstOrDefault().gen_account_id; // var _income_account = datam.DATA_ACCOUNTS[_income_acc_id]; if (_income_account.owner_type == em.AccountOwnerTypeS.CHURCH_GROUP_SHARED | _income_account.account_id == -2435) { cg_id = _cr_inc_item.cg_id; } else { cg_id = -1; } Get_OffAccountsStatement(xd, start_fs_id, end_fs_id, _income_acc_id, cg_id, _account_name); Get_CreditorExpenseStatement(xd, start_fs_id, end_fs_id, _expense_acc_id); Get_AccountTransfers(xd, start_fs_id, end_fs_id, account_id); // } break; } case em.account_d_categoryS.Asset: { ic.accountC _account = datam.DATA_ACCOUNTS[account_id]; switch (_account.p_account_id) { case -2499: //accn.GetAccountByAlias("BANK_ACCOUNT").account_id: { datam.GetBankAccounts(xd); ic.bankAccountC _bank = (from k in datam.DATA_BANK_ACCOUNTS.Values where k.sys_account_id == account_id select k).FirstOrDefault(); if (_bank != null) { Get_BankingStatement(xd, start_fs_id, end_fs_id, _bank.un_id); Get_BankingWithDrawStatement(xd, start_fs_id, end_fs_id, _bank.un_id); Get_BankExpenseStatement(xd, start_fs_id, end_fs_id, account_id); } break; } case -2404: // accn.GetAccountByAlias("UNBANKED").account_id: { break; } } break; } } }