public void RefreshDisplay()
{
_lookup = ForwardedBalance.CollectAll();
_viewModel = new ForwardedBalanceViewModel();
_viewModel.Collection = ForwardedBalance.CollectAll();
DataContext = _viewModel;
}
public void Add()
{
var addForwardedBalanceView = new AddForwardedBalanceView();
if (addForwardedBalanceView.ShowDialog() == true)
{
_viewModel.Collection = _lookup = ForwardedBalance.CollectAll();
}
}
public AddForwardedBalanceView()
{
InitializeComponent();
AddButton.Click += AddButtonOnClick;
MemberCodeSearchBox.Click += MemberCodeSearchBoxOnClick;
AccountCodeSearchBox.Click += AccountCodeSearchBoxOnClick;
_newItem = new ForwardedBalance();
DataContext = _newItem;
}
public void Delete()
{
if (_viewModel.SelectedItem == null)
{
return;
}
if (MessageWindow.ConfirmDeleteRecord() == MessageBoxResult.Yes)
{
_viewModel.SelectedItem.Destroy();
_viewModel.Collection = _lookup = ForwardedBalance.CollectAll();
}
}
public EditForwardedBalanceView(int id) : this()
{
_currentItem = new ForwardedBalance();
_currentItem.Find(id);
DataContext = _currentItem;
if (_listTimeDepositCode.Contains(_currentItem.AccountCode) ||
_listLoanReceivableCode.Contains(_currentItem.AccountCode))
{
btnDetails.Visibility = Visibility.Visible;
}
else
{
btnDetails.Visibility = Visibility.Hidden;
}
}
public static List <AccountSummary> Find(string memberCode, DateTime asOf)
{
// StoredProcedure Information
// procedure nane : sp_account_summary
// parameters : ps_member_code VARCHAR(10), pd_as_of DATE
// return fields : member_code, member_name, account_code, account_title, certificate_no
// debit_account, credit_account,
// ending_balance, as_of
DataTable dataTable;
var sqlParams = new List <SqlParameter>
{
new SqlParameter("ts_member_code", memberCode),
new SqlParameter("td_as_of", asOf)
};
DateTime forwardedDate = ForwardedBalance.MaxDocumentDate();
if (forwardedDate != Convert.ToDateTime(string.Format("12/31/{0}", asOf.Year - 1)))
{
sqlParams.Add(new SqlParameter("ts_present_database", DatabaseController.GetDatabaseByYear(asOf.Year)));
sqlParams.Add(new SqlParameter("ts_previous_database",
DatabaseController.GetDatabaseByYear(forwardedDate.Year)));
dataTable = DatabaseController.ExecuteStoredProcedure("sp_account_summary_opening_year",
sqlParams.ToArray());
}
else
{
dataTable = DatabaseController.ExecuteStoredProcedure("sp_account_summary_per_date", sqlParams.ToArray());
}
return((from DataRow row in dataTable.Rows
select new AccountSummary
{
MemberCode = memberCode,
MemberName = DataConverter.ToString(row["member_name"]),
AccountCode = DataConverter.ToString(row["account_code"]),
AccountTitle = DataConverter.ToString(row["account_title"]),
CertificateNo = DataConverter.ToString(row["certificate_no"]),
DebitAccount = DataConverter.ToDecimal(row["debit_account"]),
CreditAccount = DataConverter.ToDecimal(row["credit_account"]),
Balance = DataConverter.ToDecimal(row["ending_balance"]),
AsOf = DataConverter.ToDateTime(row["as_of"])
}).ToList());
}
public static List <AccountDetail> Find(string memberCode,
string accountCode,
string certificateNo,
DateTime asOf)
{
var sqlParams = new List <SqlParameter>
{
new SqlParameter("ts_member_code", memberCode),
new SqlParameter("ts_account_code", accountCode),
new SqlParameter("ts_certificate_no", certificateNo),
new SqlParameter("td_as_of", asOf)
};
DataTable dataTable;
DateTime forwardedDate = ForwardedBalance.MaxDocumentDate();
if (forwardedDate != Convert.ToDateTime(string.Format("12/31/{0}", asOf.Year - 1)))
{
sqlParams.Add(new SqlParameter("ts_present_database", DatabaseController.GetDatabaseByYear(asOf.Year)));
sqlParams.Add(new SqlParameter("ts_previous_database",
DatabaseController.GetDatabaseByYear(forwardedDate.Year)));
dataTable = DatabaseController.ExecuteStoredProcedure("sp_account_details_opening_year", sqlParams.ToArray());
}
else
{
dataTable = DatabaseController.ExecuteStoredProcedure("sp_account_details_per_date", sqlParams.ToArray());
}
var result = new List <AccountDetail>();
foreach (DataRow dataRow in dataTable.Rows)
{
var detail = new AccountDetail();
detail.SetPropertiesFromDataRow(dataRow);
var voucherLog = new VoucherLog();
voucherLog.Find(detail.VoucherType, detail.VoucherNumber);
detail.Initial = voucherLog.Initials;
detail.Remarks = voucherLog.Remarks;
result.Add(detail);
}
return(result);
}
