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