private void deleteMemberPlegdeToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var _fm = new SdaHelperManager.ConfirmWPwd())
{
_fm.ShowDialog();
if (_fm.DialogResult != DialogResult.OK)
{
return;
}
}
var _obj = fGrid.SelectedRows[0].Tag as ic.pledgeC;
_obj.pledge_status = em.pledge_statusS.deleted;
string _str = "Are You Sure You Want To Delete This Member Pledge ??";
using (var xd = new xing())
{
var _d_obj = xd.ExecuteScalarObject("select pl_status from pledge_master_tb where pl_id=" + _obj.pl_id);
if (_d_obj != null)
{
if (_d_obj.ToInt16() == em.pledge_statusS.deleted.ToInt16())
{
MessageBox.Show("You Have Already Deleted This Member Pledge", "Already Deleted");
return;
}
}
if (!dbm.WarningMessage(_str, "Delete Warning"))
{
return;
}
//
xd.SingleUpdateCommandALL("pledge_master_tb", new string[] { "pl_status", "pl_id" }, new object[]
{
em.pledge_statusS.deleted.ToInt16(),
_obj.pl_id
}, 1);
//
xd.SingleUpdateCommandALL("pledge_payment_mvt_tb", new string[] { "status", "pl_id" }, new object[]
{
0,
_obj.pl_id
}, 1);
//
xd.SingleUpdateCommandALL("pledge_addition_tb", new string[] { "pl_status", "pl_id" }, new object[]
{
em.pledge_statusS.deleted.ToInt16(),
_obj.pl_id
}, 1);
//
accn.PledgeSummary(xd, (_obj.amount_pledged * -1), (_obj.amount_paid * -1), _obj.pls_id);
//
xd.CommitTransaction();
}
fGrid.Rows.RemoveAt(fGrid.Rows[_obj.pl_id.ToString()].Index);
if (this.Tag != null)
{
this.Tag = null;
}
}
private void ts_delete_Click(object sender, EventArgs e)
{
using (var _fm = new SdaHelperManager.ConfirmWPwd())
{
_fm.ShowDialog();
if (_fm.DialogResult != DialogResult.OK)
{
return;
}
}
string _str = "Are You Sure You Want To Delete The Expense Account ??";
iGRow _row = fGrid.SelectedRows[0];
var _obj = fGrid.SelectedRows[0].Tag as ic.expense_accountC;
if (_obj == null)
{
return;
}
if (dbm.ExecuteScalarInt(string.Format("select TOP 1 exp_acc_id from acc_expense_trans_tb where exp_acc_id={0}", _obj.exp_acc_id)) > 0)
{
MessageBox.Show("Cannot Delete This Expense Account Since Has Important Attachements To Other Records Already", "Delete Failure");
return;
}
if (!dbm.WarningMessage(_str, "Delete Warning"))
{
return;
}
using (var xd = new xing())
{
xd.SingleDeleteCommandExp("acc_expense_accounts_tb", new string[]
{
"exp_acc_id", "lch_id"
}, new int[] { _obj.exp_acc_id, datam.LCH_ID });
_row.Tag = null;
fGrid.Rows.RemoveAt(_row.Index);
datam.DATA_EXPENSE_ACCOUNTS.Remove(_obj.exp_acc_id);
//
xd.SingleDeleteCommandExp("accounts_tb", new string[]
{
"account_id",
}, new int[] { _obj.sys_account_id });
//
datam.DATA_ACCOUNTS.Remove(_obj.sys_account_id);
xd.CommitTransaction();
sdata.ClearFormCache(em.fm.chart_of_accounts.ToInt16());
}
}
private void reEnableAccountToolStripMenuItem_Click(object sender, EventArgs e)
{
string _str = "Are You Sure You Want To Re-Enable This Income Account ??";
iGRow _row = fGrid.SelectedRows[0];
var _obj = fGrid.SelectedRows[0].Tag as ic.accountC;
if (_obj == null)
{
return;
}
using (var _fm = new SdaHelperManager.ConfirmWPwd())
{
_fm.ShowDialog();
if (_fm.DialogResult != DialogResult.OK)
{
return;
}
}
if (!dbm.WarningMessage(_str, "Re-Enable Warning"))
{
return;
}
using (var xd = new xing())
{
xd.SingleUpdateCommandALL("accounts_tb", new string[]
{
"account_status_id",
"account_id"
}, new object[]
{
em.account_statusS.Enabled.ToByte(),
_obj.account_id
}, 1);
_obj.account_status = em.account_statusS.Enabled;
xd.CommitTransaction();
sdata.ClearFormCache(em.fm.chart_of_accounts.ToInt16());
sdata.ClearFormCache(em.fm.accounts_balances_manager.ToInt16());
sdata.ClearFormCache(em.fm.analyze_offering_weekly.ToInt16());
sdata.ClearFormCache(em.fm.offering_range_1.ToInt16());
sdata.ClearFormCache(em.fm.sabbath_cash_statement.ToInt16());
sdata.ClearFormCache(em.fm.quarter_cash.ToInt16());
}
(this.Owner as IncomeAccountsManager).EditRow(_obj);
fGrid.Rows.RemoveAt(fGrid.Rows[_obj.account_id.ToString()].Index);
}
private void deletePledgeToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var _fm = new SdaHelperManager.ConfirmWPwd())
{
_fm.ShowDialog();
if (_fm.DialogResult != DialogResult.OK)
{
return;
}
}
var _obj = iGrid1.SelectedRows[0].Tag as ic.pledgeSettingC;
_obj.status = em.pledge_setting_statusS.deleted;
string _str = "Are You Sure You Want To Delete This Pledge Account ??";
if (!dbm.WarningMessage(_str, "Cancel Warning"))
{
return;
}
using (var xd = new xing())
{
xd.SingleUpdateCommandALL("pledge_settings_tb", new string[] { "status", "pls_id" }, new object[]
{
em.pledge_setting_statusS.deleted.ToInt16(),
_obj.pls_id
}, 1);
//
xd.SingleUpdateCommandALL("pledge_master_tb", new string[] { "pl_status", "pls_id" }, new object[]
{
em.pledge_statusS.deleted.ToInt16(),
_obj.pls_id
}, 1);
//
xd.SingleUpdateCommandALL("pledge_payment_mvt_tb", new string[] { "status", "pls_id" }, new object[]
{
0,
_obj.pls_id
}, 1);
xd.CommitTransaction();
}
iGrid1.Rows.RemoveAt(iGrid1.Rows[_obj.pls_id.ToString()].Index);
}
