public void DisplayRetentionSchedules(IList <RetentionSchedule> retentionSchedules)
{
ViewState.Add("RetentionSchedules", retentionSchedules);
try
{ //Ref: CFF-21
if (retentionSchedules != null)
{
int selectedIndex = RetentionGridView.FocusedRowIndex;
RetentionGridView.DataSource = retentionSchedules;
RetentionGridView.DataBind();
if (RetentionGridView.Rows.Count > 0)
{
RetentionGridView.FocusedRowIndex = (selectedIndex < 0)?0:selectedIndex;
}
}
}
catch (Exception exc)
{
string excep = exc.Message;
throw exc.InnerException;
}
}
public void DisplayNonFactoredInvoices(IList <Invoice> nonFactoredInvoices)
{
ViewState.Add("NonFactoredInvoices", nonFactoredInvoices);
NonFactoredGridView.DataSource = nonFactoredInvoices;
NonFactoredGridView.DataBind();
}
public void DisplayInvoices(IList <Invoice> invoices)
{
ViewState.Add("Invoices", invoices);
InvoiceGridView.DataSource = invoices;
InvoiceGridView.DataBind();
}
public void DisplayLikelyRepurchases(IList <LikelyRepurchasesLine> likelyRepurchasesLine)
{
ViewState.Add("LikelyRepurchases", likelyRepurchasesLine);
LikelyRepurchasesGridView.DataSource = likelyRepurchasesLine;
if (likelyRepurchasesLine != null)
{
LikelyRepurchasesGridView.DataBind();
}
}
public void Display(RetentionReleaseEstimateReport report)
{
ViewState.Add("RetentionReleaseEstimateReport", report);
if (report != null)
{
RetentionReleaseEstimateReport retentionReleaseEstimateReport = report;
CffGGV_ReportGridView.DataSource = retentionReleaseEstimateReport.Records;
CffGGV_ReportGridView.DataBind();
ReleaseSummary releases = retentionReleaseEstimateReport.ReleaseSummary;
FundedTransactionReleaseLiteral.Text = releases.FundedTransactionRelease.ToString("C");
NonFundedTransactionReleaseLiteral.Text = releases.NonFundedTransactionRelease.ToString("C");
ReleaseTotal.Text = releases.Total.ToString("C");
Deductables deductables = retentionReleaseEstimateReport.Deductables;
UnclaimedCreditsLiteral.Text = deductables.UnclaimedCredits.ToString("C");
UnclaimedRepurchasesLiteral.Text = deductables.UnclaimedRepurchases.ToString("C");
UnclaimedDiscountsLiteral.Text = deductables.UnclaimedDiscounts.ToString("C");
LikelyRepurchasesLiteral.Text = deductables.LikelyRepurchases.ToString("C");
OverdueChargesLiteral.Text = deductables.OverdueCharges.ToString("C");
Fee chequeFee = deductables.ChequeFee;
ChequeFeeLiteral.Text = chequeFee.Rate.ToString("C");
NumberOfChequesLiteral.Text = chequeFee.Count.ToString();
ChequeFeesLiteral.Text = chequeFee.Total.ToString("C");
Fee postage = deductables.Postage;
PostageFeeLiteral.Text = postage.Rate.ToString("C");
NumberOfPostsLiteral.Text = postage.Count.ToString();
PostageFeesLiteral.Text = postage.Total.ToString("C");
Fee letterFee = deductables.LetterFees;
LetterFeeLiteral.Text = letterFee.Rate.ToString("C");
NumberOfLettersLiteral.Text = letterFee.Count.ToString();
LetterFeesLiteral.Text = letterFee.Total.ToString("C");
DeductablesTotalLiteral.Text = deductables.Total.ToString("C");
EstimatedReleaseLiteral.Text = retentionReleaseEstimateReport.EstimatedRelease.ToString("C");
DateViewedLiteral.Text = retentionReleaseEstimateReport.DateViewed.ToDateTimeString();
}
}
public void Display(CustomerTransactionReport report)
{
ViewState.Add("CustomerTransactionReport", report);
if (report != null)
{
ReportGridView.DataSource = report.Records;
ReportGridView.DataBind();
}
}
public void Display(AgedBalancesReport report)
{
ViewState.Add("AgedBalancesReport", report);
if (report != null)
{
if (this.isReportWithNotes)
{
}
else
{
reportGridView.DataSource = report.Records;
reportGridView.DataBind();
if (reportGridView.AllowSorting)
{
reportGridView.Sort("CustomerName", SortDirection.Ascending);
}
}
}
}
public void ShowTransactions(IList <Transaction> transactions)
{
// start related ref:CFF-18
if (SessionWrapper.Instance.Get != null)
{
if (SessionWrapper.Instance.Get.ClientFromQueryString != null)
{
targetName = ": " + SessionWrapper.Instance.Get.ClientFromQueryString.Name;
}
if (SessionWrapper.Instance.Get.CustomerFromQueryString != null)
{
if (targetName != null || !targetName.Equals(""))
{
targetName += " / ";
targetName = string.Concat(targetName, SessionWrapper.Instance.Get.CustomerFromQueryString.Name);
}
else
{
targetName = ": " + SessionWrapper.Instance.Get.CustomerFromQueryString.Name;
}
}
}
else if (QueryString.ViewIDValue != null)
{
if (SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).ClientFromQueryString != null)
{
if (SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).ClientFromQueryString != null)
{
targetName = ": " + SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).ClientFromQueryString.Name;
}
if (SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).CustomerFromQueryString != null)
{
if (targetName != null || !targetName.Equals(""))
{
targetName += " / ";
targetName = string.Concat(targetName, SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).CustomerFromQueryString.Name);
}
else
{
targetName = ": " + SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).CustomerFromQueryString.Name;
}
}
}
}
// end
ViewState.Add("Transactions", transactions);
TransactionGridView.DataSource = null;
TransactionGridView.DataSource = transactions;
TransactionGridView.DataBind();
TransactionsPanel.Wrap = true;
}
public void DisplayCreditsClaimed(IList <ClaimedCredit> creditsClaimed)
{
ViewState.Add("CreditsClaimed", creditsClaimed);
try
{
CffGGV_CreditsClaimedGridView.DataSource = creditsClaimed;
CffGGV_CreditsClaimedGridView.DataBind();
}
catch (Exception exc)
{
string msg = exc.Message;
}
}
public void Display(InvoicesTransactionReport report)
{
ViewState.Add("InvoicesTransactionReport", report);
if (report != null)
{
ReportGridView.DataSource = report.Records;
ReportGridView.DataBind();
FundedTotalLiteral.Text = report.FundedTotal.ToString("C");
NonFundedTotalLiteral.Text = report.NonFundedTotal.ToString("C");
MeanDebtorDaysByInvoiceLiteral.Text = report.MeanDebtorDays.ToString("#0.00");
MeanAgeOfUnpaidByInvoiceLiteral.Text = report.MeanAgeOfUnpaidRecords.ToString("#0.00");
MeanDebtorDaysByBOMLiteral.Text =
report.MeanDebtorDaysFromBeginningOfFollowingMonth.ToString("#0.00");
MeanAgeOfUnpaidByBOMLiteralLiteral.Text =
report.MeanAgeOfUnpaidRecordsFromBeginningOfFollowingMonth.ToString("#0.00");
PaidForRecordCountLiteral.Text = report.NumberOfRecordsPaidFor.ToString();
UnpaidForRecordCountLiteral.Text = report.NumberOfRecordsNotPaidFor.ToString();
}
}
public void DisplayReport(AccountTransactionReportBase accountTransactionsReport)
{
if (accountTransactionsReport != null)
{
ViewState.Add("AccountTransactions", accountTransactionsReport);
closingBalance = ((AccountTransactionReport)accountTransactionsReport).ClosingBalance;
movementAmount = Math.Abs(((AccountTransactionReport)accountTransactionsReport).Movement);
AccountTransactionsGridView.DataSource = ((AccountTransactionReport)accountTransactionsReport).Records;
AccountTransactionsGridView.DataBind();
//this.totalDebitLiteral.Text = accountTransactionsReport.TotalDebit.ToString("C");
//this.totalCreditLiteral.Text = Math.Abs(accountTransactionsReport.TotalCredit).ToString("C");
this.movementLiteral.Text = accountTransactionsReport.Movement.ToString("C");
this.closingBalanceliteral.Text = Math.Abs(accountTransactionsReport.ClosingBalance).ToString("C");
}
}
public void ShowReport(StatementReport report)
{
//ac = false;
if (report != null)
{
ManagementDetails managementDetails = report.ManagementDetails;
accountNameLiteral.Text = managementDetails.Name;
bankAndBranchLiteral.Text = managementDetails.BankDetails.NameAndBranch;
accountNumberLiteral.Text = accountNumberLiteralTwo.Text = managementDetails.BankDetails.AccountNumber;
PurchaserDetails purchaserDetails = report.PurchaserDetails;
customerNameLiteral.Text = purchaserDetails.Name;
customerAddressOneLiteral.Text = purchaserDetails.Address.AddressOne;
customerAddressTwoLiteral.Text = purchaserDetails.Address.AddressTwo;
customerAddressThreeLiteral.Text = purchaserDetails.Address.AddressThree;
customerAddressFourLiteral.Text = purchaserDetails.Address.AddressFour;
customerIdLiteral.Text = purchaserDetails.Id.ToString();
referenceLiteral.Text = referenceLiteralTwo.Text = referenceLiteralThree.Text = purchaserDetails.Reference;
configureGridColumns();
cffGGV_StatementGridView.DataSource = report.Records;
cffGGV_StatementGridView.DataBind();
AgeingBalances ageingBalances = report.AgeingBalances;
threeMonthsOrOverLiteral.Text = ageingBalances.ThreeMonthsAndOver.ToString("C");
twoMonthsLiteral.Text = ageingBalances.TwoMonthAgeing.ToString("C");
oneMonthLiteral.Text = ageingBalances.OneMonthAgeing.ToString("C");
currentLiteral.Text = ageingBalances.Current.ToString("C");
balanceLiteral.Text = ageingBalances.Balance.ToString("C");
//Summary
managementNameLiteral.Text = managementDetails.Name;
managementAddressOneLiteral.Text = managementDetails.Address.AddressOne;
managementAddressTwoLiteral.Text = managementDetails.Address.AddressTwo;
managementAddressThreeLiteral.Text = managementDetails.Address.AddressThree;
managementAddressFourLiteral.Text = managementDetails.Address.AddressFour;
customerNameLiteral2.Text = purchaserDetails.Name;
customerNumberLiteral.Text = purchaserDetails.Number.ToString();
monthEndingLiteral.Text = report.MonthEnding.ToString();
clientNameLiteral.Text = purchaserDetails.ClientName;
}
}
void detailGridView_BeforePerformDataSelect(object sender, EventArgs e)
{//HttpContext.Current.Session[this.dtKeyFieldName] = (sender as ASPxGridView).GetMasterRowKeyValue();
try
{
CffGenGridView masterGrid = sender as CffGenGridView;
//object kVal = masterGrid.GetMasterRowKeyValue();
if (this.dataSource != null)
{
IList <AgedBalancesReportRecord> xABR = dataSource as IList <AgedBalancesReportRecord>;
detailGridView.DataSource = (xABR[0] as AgedBalancesReportRecord).CustNoteList;
}
else
{
//AgedBalancesReportRecord dRow = masterGrid.GetRow(masterGrid.CurrentFocusedRow) as AgedBalancesReportRecord;
//detailGridView.DataSource = dRow.CustNoteList;
}
detailGridView.DataBind();
}
catch (Exception exc)
{
string Msg = exc.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblDatePrinted.Text = "Date Printed: " + DateTime.Now.ToLongDateString();
lblCopyRight.Text = "©2014 Cash Flow Funding Limited, 195 Main Highway Ellerslie Auckland.";
notesGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
notesGridView.InsertDataColumn("Created By", "createdByEmployeeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
notesGridView.InsertDataColumn("Modified", "ModifiedBy", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
notesGridView.InsertDataColumn("Modified By", "ModifiedByEmployeeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
notesGridView.InsertDataColumn("Comment", "Comment", CffGridViewColumnType.Memo, "25%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left);
var printable = SessionWrapper.Instance.Get.PrintBag as PrintablePermanentClientNotes;
if (printable != null)
{
this.ClientNameLabel.Text = printable.ClientName;
SetTitle("Client Permanent Notes", printable.ClientName);
notesGridView.Caption = this.Title;
notesGridView.DataSource = printable.Notes;
notesGridView.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblDatePrinted.Text = "Date Printed: " + DateTime.Now.ToLongDateString();
lblCopyRight.Text = "© " + DateTime.Now.Year.ToString() + " CashFlow Funding Limited, 195 Main Highway Ellerslie, Auckland.";
notesGridView.Columns.Clear();
notesGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.DateTime, "15%", "cffGGV_centerAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Center, System.Web.UI.WebControls.HorizontalAlign.Center, true);
notesGridView.InsertDataColumn("Created By", "createdByEmployeeName", CffGridViewColumnType.Text, "15%", "cffGGV_centerAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Center, System.Web.UI.WebControls.HorizontalAlign.Center, true);
notesGridView.InsertDataColumn("Comment", "Comment", CffGridViewColumnType.Memo, "70%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left);
//notesGridView.Width = Unit.Percentage(90);
var printable = SessionWrapper.Instance.Get.PrintBag as PrintableClientNotes;
if (printable != null)
{
SetTitle("Client Notes", printable.ClientName);
HeaderLiteral.Text = "Client Notes for " + printable.ClientName;
notesGridView.Caption = this.Title;
notesGridView.DataSource = printable.Notes;
notesGridView.DataBind();
}
}
public override void Export()
{
AgedBalancesReport report = ViewState["AgedBalancesReport"] as AgedBalancesReport;
System.Collections.Generic.IList <AgedBalancesReportRecord> exportRecordWithNotes = new System.Collections.Generic.List <AgedBalancesReportRecord>();
foreach (AgedBalancesReportRecord rptRecord in report.Records)
{
System.Collections.Generic.IList <CustomerNote> cnList = rptRecord.CustNoteList;
rptRecord.Note = "";
foreach (CustomerNote cNote in cnList)
{
if (!string.IsNullOrEmpty(cNote.Comment))
{
rptRecord.Note += "[" + cNote.CreatedByEmployeeName + "][" + cNote.Created.ToShortDateString() + "]";
rptRecord.Note += cNote.Comment + System.Environment.NewLine;
}
}
if (!string.IsNullOrEmpty(rptRecord.Note))
{
rptRecord.CustNoteList.Clear();
}
exportRecordWithNotes.Add(rptRecord);
}
//init columns
CffGenGridView exportGrid = this.reportGridView;
if (this.isReportWithNotes)
{
exportGrid.AllowSorting = true;
exportGrid.SetSortExpression = "CustomerName";
exportGrid.InsertDataColumn("Customer", "CustomerName");
exportGrid.InsertCurrencyColumn("Current", "CurrentBalance");
exportGrid.InsertCurrencyColumn("Month 1", "MonthOldBalance");
exportGrid.InsertCurrencyColumn("Month 2", "TwoMonthsOldBalance");
exportGrid.InsertCurrencyColumn("Month 3+", "ThreeMonthsOrOlderBalance");
exportGrid.InsertCurrencyColumn("Balance", "Balance");
exportGrid.InsertDataColumn("Next Call", "NextCallDate", CffGridViewColumnType.Date, "10%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
exportGrid.InsertDataColumn("Note", "Note");
exportGrid.Visible = false;
exportGrid.InsertDataColumn("Email", "Email");
exportGrid.InsertDataColumn("Contact", "Contact");
exportGrid.InsertDataColumn("Phone", "Phone");
exportGrid.InsertDataColumn("Mobile Phone", "Cell");
exportGrid.TotalsSummarySettings.SetColumnTotals("CurrentBalance, MonthOldBalance, TwoMonthsOldBalance, ThreeMonthsOrOlderBalance, Balance");
exportGrid.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
exportGrid.DataSource = exportRecordWithNotes;
exportGrid.DataBind();
}
if (report != null)
{
ExcelDocument document = new ExcelDocument();
document._HSFFGetSheet.SetColumnWidth(8, 400);
document.WriteTitle(report.Title);
if (IsReportWithNotesLiteral.Text.ToLower() == "true")
{
exportGrid.WriteToExcelDocument(document);
}
else
{
reportGridView.WriteToExcelDocument(document);
}
document.MoveToNextRow();
document.MoveToNextRow();
document.AddCell("Date Viewed");
document.AddCell(report.DateViewed.ToDateTimeString());
WriteToResponse(document.WriteToStream(), report.ExportFileName);
}
}
public void DisplayRetentionRepurchasesClaimed(IList <ClaimedRetentionRepurchase> claimedRetentionRepurchases)
{
ViewState.Add("claimedRetentionRepurchases", claimedRetentionRepurchases);
RetentionRepurchasesClaimedGridView.DataSource = claimedRetentionRepurchases;
RetentionRepurchasesClaimedGridView.DataBind();
}
public void DisplayCharges(IList <Charge> charges)
{
ViewState.Add("Charges", charges);
CffGGV_ChargesGridView.DataSource = charges;
CffGGV_ChargesGridView.DataBind();
}
public void Clear()
{
ViewState.Add("AccountTransactionReport", null);
ReportGridView.DataSource = null;
ReportGridView.DataBind();
}
public void ShowTransactionHistory(IList <HistoricalTransaction> historicalTransactions)
{
ViewState.Add("Transactions", historicalTransactions);
cffGGV_TransactionGridView.DataSource = historicalTransactions;
cffGGV_TransactionGridView.DataBind();
}
public void ClearTabData()
{
ReportGridView.DataSource = null;
ReportGridView.DataBind();
DateViewedLiteral.Text = string.Empty;
}
protected void Page_Load(object sender, EventArgs e)
{
lblDatePrinted.Text = "Date Printed: " + DateTime.Now.ToLongDateString();
lblCopyRight.Text = "©" + DateTime.Now.Year.ToString() + " Cash Flow Funding Limited, 195 Main Highway Ellerslie Auckland.";
notesGridView.Columns.Clear();
//notesGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Date, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Created By", "createdByEmployeeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Modified", "ModifiedBy", CffGridViewColumnType.Date, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Modified By", "ModifiedByEmployeeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Activity Type", "ActivityTypeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Note Type", "NoteTypeName", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left, true);
//notesGridView.InsertDataColumn("Comment", "Comment", CffGridViewColumnType.Memo, "30%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Left);
var printable = SessionWrapper.Instance.Get.PrintBag as PrintableCustomerNotes;
HeaderLiteral.Text = "Customer Notes";
if (printable != null)
{
if (!string.IsNullOrEmpty(printable.Reference))
{
SetTitle("Current Notes", printable.CustomerName);
HeaderLiteral.Text = "Current Notes - (Reference - " + printable.Reference + ")";
}
else
{
if (printable.ClientName == null)
{
SetTitle("Customer Notes", printable.CustomerName);
}
else
{
SetTitle("Customer Notes", printable.ClientName);
}
//if (SessionWrapper.Instance.Get.IsCustomerSelected) //dbb
// SetTitle("Customer Notes", printable.CustomerName);
//else
// SetTitle("Customer Notes", printable.ClientName);
}
try
{
if (printable.IsGroupByCustomerName)
{
HeaderLiteral.Text = "All Customer Notes";
SetTitle("", "");
HeaderLiteral.Text += " For " + printable.ClientName;
//notesGridView.GroupBySettings.GroupByExpression = "Customer";
notesGridView.SetSortExpression = "CustomerName";
notesGridView.SetSortDirection = SortDirection.Ascending;
notesGridView.GroupBySettings.GroupByExpression = "CustomerName";
notesGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell");
}
else
{
notesGridView.Caption = this.Title;
}
notesGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.DateTime, "12%", "cffGGV_centerAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Center, System.Web.UI.WebControls.HorizontalAlign.Center);
notesGridView.InsertDataColumn("Created By", "createdByEmployeeName", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Center, System.Web.UI.WebControls.HorizontalAlign.Center);
notesGridView.InsertDataColumn("Comment", "Comment", CffGridViewColumnType.Memo, "60%", "cffGGV_leftAlignedCell", System.Web.UI.WebControls.HorizontalAlign.Left, System.Web.UI.WebControls.HorizontalAlign.Center);
notesGridView.DataSource = printable.Notes;
notesGridView.DataBind();
}
catch { }
}
}