private void InsertCommonColumns()
{
reportGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
reportGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Processed", "Factored", CffGridViewColumnType.Date, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Number", "Number", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertCurrencyColumn("Amount", "Amount", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Opening Balance", "OpeningBalance", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Receipts", "Receipts", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Credits", "Credits", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Discounts", "Discounts", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Journals", "Journals", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Prepaid", "Repurchases", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Other", "Other", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertDataColumn("LastTrans", "LastTransaction", CffGridViewColumnType.Date, "4%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertCurrencyColumn("Balance", "Balance", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Residual", "Retention", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Charges", "Charges", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
//reportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "8%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
//reportGridView.InsertDataColumn("Repurchased", "RepurchaseDate", CffGridViewColumnType.Date, "8%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Center, true, "cffGGVHeaderLeftAgedBal2");
//reportGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "8%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
reportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Prepayments", "RepurchaseDate", CffGridViewColumnType.Date, "3%", "cffGGV_centerAlignedCellAgedBal", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCellAgedBal", HorizontalAlign.Center, HorizontalAlign.Center, true);
}
private void InsertCommonColumns()
{
if (isReportWithNotes)
{
if (!this.isReportWithNotesInitialized)
{
this.reportPlaceholder.Visible = false;
IsReportWithNotesLiteral.Text = "true";
IsReportWithNotesLiteral.Visible = false;
}
}
else
{
this.reportPlaceholder.Visible = true;
reportGridView.NestedSettings.Enabled = false;
reportGridView.Columns.Clear();
reportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "8%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "8%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
reportGridView.InsertCurrencyColumn("Current", "CurrentBalance", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Month 1", "MonthOldBalance", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Month 2", "TwoMonthsOldBalance", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Month 3+", "ThreeMonthsOrOlderBalance", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Balance", "Balance", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertDataColumn("Next Call", "NextCallDate", CffGridViewColumnType.Text, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Email", "Email", CffGridViewColumnType.Text, "15%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Contact", "Contact", CffGridViewColumnType.Text, "12%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Phone", "Phone", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
//reportGridView.InsertDataColumn("Cell", "Cell", CffGridViewColumnType.Text, "12%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
reportGridView.InsertDataColumn("Cell", "Cell", CffGridViewColumnType.Text, "12%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true);
this.reportPlaceholder.Controls.Clear();
this.reportPlaceholder.Controls.Add(reportGridView);
}
}
public void ConfigureAllClientsGridColumns()
{
reportGridView.Columns.Clear();
reportGridView.InsertDataColumn("#", "ClientNumberLabel", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, true);
reportGridView.InsertBoundHyperLinkColumn("Client", "ClientName", "ClientNumber", "12%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center);
reportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, true);
reportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerID", "13%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center);
reportGridView.InsertDataColumn("Title", "Title", CffGridViewColumnType.Text, "8%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, true);
InsertCommonColumns();
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
if (SessionWrapper.Instance.IsAllClientsSelected)
{
ReportGridView.InsertBoundHyperLinkColumn("Client", "ClientName", "ClientNumber", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
}
InsertCommonColumns();
}
private void InsertCommonColumns()
{
reportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
reportGridView.InsertDataColumn("Title", "Title", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertCurrencyColumn("Balance", "Balance", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertDataColumn("Details", "Details", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Next Call", "Due", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
}
private void InsertCommonColumns()
{
ReportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "2%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
ReportGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Processed", "ProcessedDate", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Invoice", "Invoice", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Ref", "Reference", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertCurrencyColumn("Amount", "Amount", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Balance", "Balance", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center);
}
protected void ConfigureGridColumns()
{
CffGGV_CreditsClaimedGridView.Columns.Clear();
CffGGV_CreditsClaimedGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_CreditsClaimedGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "18%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
CffGGV_CreditsClaimedGridView.InsertDataColumn("Transaction", "Transaction", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_CreditsClaimedGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_CreditsClaimedGridView.InsertCurrencyColumn("Amount", "Amount", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
CffGGV_CreditsClaimedGridView.InsertCurrencyColumn("Sum", "Sum", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
CffGGV_CreditsClaimedGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "5%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, "", "cffGGVHeaderLeftAgedBal2");
CffGGV_CreditsClaimedGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Date, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_CreditsClaimedGridView.Width = Unit.Percentage(50);
}
protected void ConfigureGridColumns()
{
InvoiceGridView.Columns.Clear();
InvoiceGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "15%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
InvoiceGridView.InsertDataColumn("Transaction", "TransactionNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertDataColumn("Processed", "FactoredDate", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
InvoiceGridView.InsertCurrencyColumn("Balance", "Balance", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
InvoiceGridView.InsertDataColumn("Status", "TransactionStatus", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true); //, "cffGGVHeaderLeftAgedBal2");
InvoiceGridView.InsertDataColumn("Prepaid", "Repurchased", CffGridViewColumnType.Date, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
InvoiceGridView.InsertDataColumn("Purch.Order", "PurchaseOrder", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true); // "cffGGVHeaderWPad15");
InvoiceGridView.ShowFooter = true;
InvoiceGridView.TotalsSummarySettings.SetColumnTotals("Amount,Balance");
InvoiceGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
InvoiceGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Balance", "cffGGV_currencyCell");
InvoiceGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
InvoiceGridView.Width = Unit.Percentage(60);
InvoiceGridView.Height = Unit.Percentage(100);
}
private void ConfigureGridColumns()
{
RetentionGridView.Columns.Clear();
//removed as per marty's suggestions
/* var commandColumn = new CffCommandField();
* commandColumn.ButtonType = ButtonType.Image;
* commandColumn.ControlStyle.CssClass = "cffGGV_centerAlignedCell";
* commandColumn.ControlStyle.Width = Unit.Pixel(50);
* commandColumn.ItemStyle.Height= Unit.Pixel(30);
*
* commandColumn.SelectText = "View Retention Statements";
* commandColumn.Visible = true;
* commandColumn.SelectImageUrl = "~/images/btn_view_retention.png";
* commandColumn.ShowSelectButton = true;
* commandColumn.VisibleIndex = 0;
* RetentionGridView.Columns.Add(commandColumn);
* RetentionGridView.Columns[0].ItemStyle.Width = Unit.Percentage(5);
*/
//RetentionGridView.CssClass = "cffGGV";
RetentionGridView.HeaderStyle.CssClass = "cffGGVHeader";
RetentionGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Honeydew;
RetentionGridView.ShowHeaderWhenEmpty = true;
RetentionGridView.EmptyDataText = "No data to display";
RetentionGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
RetentionGridView.RowCssClass = "dxgvDataRow";
RetentionGridView.InsertBoundHyperLinkColumn("Client", "ClientName", "ClientId", "20%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center);
RetentionGridView.InsertBoundCommandButtonColumn("End Of Month", "EndOfMonth", "8%", "cffGGV_underlineBoundButton", HorizontalAlign.Center, "cffGGV_centerAlignedCell", "Click to view schedule", true, true);
RetentionGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
RetentionGridView.InsertDataColumn("Released", "ReleaseDate", CffGridViewColumnType.Date, "8", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
RetentionGridView.InsertDataColumn("Notes", "Notes", CffGridViewColumnType.Text, "65%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
bool isAllClientsSelected = (SessionWrapper.Instance.Get == null)
? SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).IsAllClientsSelected
: SessionWrapper.Instance.Get.IsAllClientsSelected;
if (isAllClientsSelected)
{
//RetentionGridView.Columns["ClientName"].Visible = true;
RetentionGridView.Columns[0].Visible = true;
allClientsDatePickerDiv.Visible = true;
datePicker.Visible = true;
MonthRangePicker.Visible = false;
}
else
{
//RetentionGridView.Columns["ClientName"].Visible = false;
RetentionGridView.Columns[0].Visible = false;
datePicker.Visible = false;
allClientsDatePickerDiv.Visible = false;
MonthRangePicker.Visible = true;
}
}
protected void ConfigureGridColumns()
{
CreditsGridView.Columns.Clear();
CreditsGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CreditsGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
CreditsGridView.InsertDataColumn("Transaction", "TransactionNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CreditsGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CreditsGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
CreditsGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "4%", "cffGGV_HyperLinkLeftPW10", HorizontalAlign.Left, HorizontalAlign.Left, "", "cffGGVHeaderLeftAgedBal2");
CreditsGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CreditsGridView.ShowFooter = true;
CreditsGridView.TotalsSummarySettings.SetColumnTotals("Amount");
CreditsGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
CreditsGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
CreditsGridView.Width = Unit.Percentage(50);
CreditsGridView.Height = Unit.Percentage(100);
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
ReportGridView.ShowHeaderWhenEmpty = true;
ReportGridView.EmptyDataText = "No data to display";
ReportGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
ReportGridView.AutoGenerateColumns = false;
ReportGridView.PageSize = 250; //rows per page
if (SessionWrapper.Instance.IsAllClientsSelected)
{
ReportGridView.InsertDataColumn("#", "ClientNumberLabel", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, true);
ReportGridView.InsertBoundHyperLinkColumn("Client", "ClientName", "ClientNumber", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center);
}
InsertCommonColumns();
ReportGridView.CustomPagerSettingsMode = CffCustomPagerMode.Rows | CffCustomPagerMode.Page | CffCustomPagerMode.FirstLast | CffCustomPagerMode.PreviousNext;
reportPlaceholder.Controls.Clear();
reportPlaceholder.Controls.Add(ReportGridView);
}
private void InitializeGridView()
{
ReportGridView = new CffGenGridView();
ReportGridView.AutoGenerateColumns = false;
ReportGridView.SetSortExpression = "Date";
//ReportGridView.CssClass = "cffGGV";
ReportGridView.HeaderStyle.CssClass = "cffGGVHeader";
ReportGridView.ShowHeaderWhenEmpty = true;
ReportGridView.EmptyDataText = "No data to display";
ReportGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
ReportGridView.EnableViewState = true;
ReportGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Honeydew;
ReportGridView.BorderWidth = Unit.Pixel(1);
ReportGridView.Width = Unit.Percentage(70);
ReportGridView.Columns.Clear();
ReportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerID", "19%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
ReportGridView.InsertDataColumn("Title", "Title", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Factored", "Factored", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Aged", "Age", CffGridViewColumnType.Text, "2%", "cffGGV_rightAlignedCell", HorizontalAlign.Right, HorizontalAlign.Right, true);
ReportGridView.InsertDataColumn("Transaction", "Number", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
ReportGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertCurrencyColumn("Charges", "Charges", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("GST Charges", "ChargesWithGst", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Amount", "Amount", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Balance", "Balance", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.ShowFooter = true;
ReportGridView.TotalsSummarySettings.SetColumnTotals("Charges,ChargesWithGst,Amount,Balance");
string[] strDummy = "Charges,ChargesWithGst,Amount,Balance".Split(',');
foreach (string x in strDummy)
{
ReportGridView.TotalsSummarySettings.SetTotalsColumnCssStyle(x, "cffGGV_currencyCell");
}
ReportGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
ReportGridView.PageSize = 1000;
ReportGridView.DefaultPageSize = 1000;
ReportGridView.AllowPaging = false; //removed as per marty's suggestions
//ReportGridView.CustomPagerSettingsMode = CffCustomPagerMode.Rows | CffCustomPagerMode.Page | CffCustomPagerMode.FirstLast | CffCustomPagerMode.PreviousNext | CffCustomPagerMode.Bottom;
ReportGridView.ViewStateMode = System.Web.UI.ViewStateMode.Enabled;
GVPlaceHolder.Controls.Clear();
GVPlaceHolder.Controls.Add(ReportGridView);
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
if (SessionWrapper.Instance.IsAllClientsSelected)
{
ReportGridView.InsertDataColumn("#", "ClientNumberLabel", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("Client", " ClientName", "ClientNumber", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
}
ReportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
ReportGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Processed", "ProcessedDate", CffGridViewColumnType.Date, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Invoice", "Invoice", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Ref", "Reference", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Status-Age", "StatusAge", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
ReportGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "3%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Center, HorizontalAlign.Center, "", "cffGGVHeaderLeftAgedBal2");
ReportGridView.InsertCurrencyColumn("Batch Total", "BatchTotal", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
}
protected void ConfigureGridColumns()
{
TransactionGridView.Columns.Clear();
TransactionGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, false);
TransactionGridView.InsertDataColumn("Processed", "Processed", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, false);
TransactionGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
TransactionGridView.InsertDataColumn("Number", "Number", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, false);
TransactionGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Left, HorizontalAlign.Center, false);
TransactionGridView.InsertCurrencyColumn("Amount", "Amount", "8%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
TransactionGridView.InsertCurrencyColumn("Balance", "Balance", "8%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
TransactionGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center);
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
ReportGridView.KeyFieldName = "tranref";
if (SessionWrapper.Instance.IsAllClientsSelected)
{
ReportGridView.InsertDataColumn("#", "ClientNumberLabel", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("ClientName", "Client", "ClientNumber", "20%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
}
InsertCommonColumns();
}
private void ConfigureGridColumns()
{
RetentionRepurchasesClaimedGridView.Columns.Clear();
RetentionRepurchasesClaimedGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RetentionRepurchasesClaimedGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "25%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
RetentionRepurchasesClaimedGridView.InsertDataColumn("Transaction", "Transaction", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RetentionRepurchasesClaimedGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
//RetentionRepurchasesClaimedGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "10%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true); //as per marty
RetentionRepurchasesClaimedGridView.InsertCurrencyColumn("Amount", "Amount", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
RetentionRepurchasesClaimedGridView.InsertDataColumn("Batch", "Batch", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Center, HorizontalAlign.Center, true, "cffGGVHeaderLeftAgedBal2");
RetentionRepurchasesClaimedGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Date, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RetentionRepurchasesClaimedGridView.Width = Unit.Percentage(50);
}
protected override void OnInit(EventArgs e)
{
RepurchasesGridView = new CffGenGridView();
RepurchasesGridView.BorderWidth = Unit.Pixel(1); //modified by dbb
RepurchasesGridView.AutoGenerateColumns = false;
RepurchasesGridView.ShowHeaderWhenEmpty = true;
//RepurchasesGridView.CssClass = "cffGGV";
RepurchasesGridView.HeaderStyle.CssClass = "cffGGVHeader";
RepurchasesGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Honeydew;
RepurchasesGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
RepurchasesGridView.EmptyDataText = "No data to display";
RepurchasesGridView.EnableViewState = true;
RepurchasesGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
RepurchasesGridView.Columns.Clear();
RepurchasesGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RepurchasesGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
RepurchasesGridView.InsertDataColumn("Transaction", "TransactionNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RepurchasesGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RepurchasesGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
RepurchasesGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "4%", "cffGGV_HyperLinkLeftPW10", HorizontalAlign.Left, HorizontalAlign.Left, "", "cffGGVHeaderLeftAgedBal2");
RepurchasesGridView.InsertDataColumn("Created", "Created", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
RepurchasesGridView.ShowFooter = true;
RepurchasesGridView.TotalsSummarySettings.SetColumnTotals("Amount");
RepurchasesGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
RepurchasesGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
RepurchasesGridView.ViewStateMode = System.Web.UI.ViewStateMode.Enabled;
RepurchasesGridView.Width = Unit.Percentage(50);
RepurchasesGridView.Height = Unit.Percentage(100);
GVPlaceHolder.Controls.Clear();
GVPlaceHolder.Controls.Add(RepurchasesGridView);
}
protected override void OnInit(EventArgs e)
{
NonFactoredGridView = new CffGenGridView();
NonFactoredGridView.PageSize = 1000;
NonFactoredGridView.DefaultPageSize = 1000;
NonFactoredGridView.AllowPaging = false;
NonFactoredGridView.AllowCustomPaging = false;
NonFactoredGridView.AutoGenerateColumns = false;
NonFactoredGridView.ShowHeaderWhenEmpty = true;
NonFactoredGridView.EmptyDataText = "No data to display";
//NonFactoredGridView.CssClass = "cffGGV";
NonFactoredGridView.HeaderStyle.CssClass = "cffGGVHeader";
NonFactoredGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Honeydew;
NonFactoredGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
//if (((System.Web.Configuration.HttpCapabilitiesBase)(Request.Browser)).Browser == "IE")
// NonFactoredGridView.BorderWidth = Unit.Pixel(0);
//else
NonFactoredGridView.BorderWidth = Unit.Pixel(1);
NonFactoredGridView.Columns.Clear();
NonFactoredGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
NonFactoredGridView.InsertDataColumn("Transaction", "TransactionNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertDataColumn("Processed", "FactoredDate", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
NonFactoredGridView.InsertCurrencyColumn("Balance", "Balance", "6%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
NonFactoredGridView.InsertDataColumn("Status", "TransactionStatus", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true); //, "cffGGVHeaderLeftAgedBal2");
NonFactoredGridView.InsertDataColumn("Modified", "Modified", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertDataColumn("Repurchased", "Repurchased", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
NonFactoredGridView.InsertDataColumn("Purch.Order", "PurchaseOrder", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true); //, "cffGGVHeaderWPad15");
NonFactoredGridView.Width = Unit.Percentage(60);
//NonFactoredGridView.Height = Unit.Percentage(100);
NonFactoredGridView.ShowFooter = true;
NonFactoredGridView.TotalsSummarySettings.SetColumnTotals("Amount,Balance");
NonFactoredGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
NonFactoredGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Balance", "cffGGV_currencyCell");
NonFactoredGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
GVPlaceHolder.Controls.Clear();
GVPlaceHolder.Controls.Add(NonFactoredGridView);
}
protected void ConfigureGridColumns()
{
TransactionGridView.Columns.Clear();
TransactionGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
TransactionGridView.InsertDataColumn("Archived", "Archived", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
TransactionGridView.InsertDataColumn("Processed", "Processed", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
TransactionGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
TransactionGridView.InsertDataColumn("Number", "Number", CffGridViewColumnType.Text, "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
TransactionGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
TransactionGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
TransactionGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "4%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
TransactionGridView.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, "Type:Invoice:On:IsReversed");
TransactionGridView.ShowFooter = true;
TransactionGridView.TotalsSummarySettings.TableClass = "dxgvFooter"; //dbb
TransactionGridView.TotalsSummarySettings.SetColumnTotals("Amount");
TransactionGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyTotalTrxArch");
TransactionGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
}
private void ConfigureGridColumns()
{
LikelyRepurchasesGridView.Columns.Clear();
LikelyRepurchasesGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
LikelyRepurchasesGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustId", "24%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
LikelyRepurchasesGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
LikelyRepurchasesGridView.InsertCurrencyColumn("Amount", "Amount", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
LikelyRepurchasesGridView.InsertCurrencyColumn("Balance", "Balance", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
LikelyRepurchasesGridView.InsertCurrencyColumn("Sum", "Sum", "7%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
LikelyRepurchasesGridView.InsertDataColumn("Dated", "Dated", CffGridViewColumnType.Date, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
LikelyRepurchasesGridView.InsertDataColumn("Processed", "Processed", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
LikelyRepurchasesGridView.InsertDataColumn("Transaction", "Transaction", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
LikelyRepurchasesGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
LikelyRepurchasesGridView.TotalsSummarySettings.SetColumnTotals("Amount, Balance, Sum");
LikelyRepurchasesGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
LikelyRepurchasesGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Balance", "cffGGV_currencyCell");
LikelyRepurchasesGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Sum", "cffGGV_currencyCell");
LikelyRepurchasesGridView.ShowFooter = true;
LikelyRepurchasesGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
}
protected override void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
if (this.CurrentScope() == Scope.CustomerScope)
{
//start child grid initialization
cffGGV_TransactionGridViewChild = new CffGenGridView();
cffGGV_TransactionGridViewChild.AllowSorting = true;
cffGGV_TransactionGridViewChild.AutoGenerateColumns = false;
cffGGV_TransactionGridViewChild.SetSortExpression = "Date";
cffGGV_TransactionGridViewChild.Width = Unit.Percentage(50);
cffGGV_TransactionGridViewChild.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
cffGGV_TransactionGridViewChild.ViewStateMode = System.Web.UI.ViewStateMode.Enabled;
//cffGGV_TransactionGridViewChild.BorderColor = System.Drawing.Color.AliceBlue;
//cffGGV_TransactionGridViewChild.RowStyleHighlightColour = System.Drawing.Color.Honeydew;
//cffGGV_TransactionGridViewChild.AlternatingRowStyle.BackColor = System.Drawing.Color.AliceBlue;
//note: for nested grid leave some space for maximize/minimize button
cffGGV_TransactionGridViewChild.Columns.Clear();
cffGGV_TransactionGridViewChild.InsertDataColumn("Date", "Date", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridViewChild.InsertDataColumn("Processed", "Processed", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridViewChild.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridViewChild.InsertDataColumn("Number", "Number", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridViewChild.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridViewChild.InsertCurrencyColumn("Debit", "Amount", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridViewChild.InsertCurrencyColumn("Credit", "Balance", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridViewChild.InsertBoundHyperLinkColumn("Batch", "Batch", "Batch", "5%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, "Type:Invoice:On:IsReversed");
cffGGV_TransactionGridViewChild.Columns[7].ItemStyle.HorizontalAlign = HorizontalAlign.Left;
cffGGV_TransactionGridViewChild.EnableViewState = true;
cffGGV_TransactionGridViewChild.NestedSettings.Enabled = false;
cffGGV_TransactionGridViewChild.TotalsSummarySettings.TableClass = "dxgvFooter"; //dbb
cffGGV_TransactionGridViewChild.TotalsSummarySettings.SetColumnTotals("Balance, Amount");
cffGGV_TransactionGridViewChild.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Balance", "cffGGV_currencyCell");
cffGGV_TransactionGridViewChild.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Amount", "cffGGV_currencyCell");
cffGGV_TransactionGridViewChild.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
}
//start parent grid initialization
cffGGV_TransactionGridView = new CffGenGridView();
cffGGV_TransactionGridView.AllowSorting = true;
cffGGV_TransactionGridView.AutoGenerateColumns = false;
cffGGV_TransactionGridView.SetSortExpression = "YrMonth";
cffGGV_TransactionGridView.Width = Unit.Percentage(100);
cffGGV_TransactionGridView.BorderColor = System.Drawing.Color.LightGray;
cffGGV_TransactionGridView.PageSize = 250;
cffGGV_TransactionGridView.EnableViewState = true;
if (Request.Browser.Id.ToUpper().Contains("IE"))
{
cffGGV_TransactionGridView.BorderWidth = Unit.Pixel(1);
}
cffGGV_TransactionGridView.HeaderStyle.CssClass = "dxgvHeader td";
cffGGV_TransactionGridView.ViewStateMode = System.Web.UI.ViewStateMode.Enabled;
cffGGV_TransactionGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Honeydew;
//cffGGV_TransactionGridView.RowStyleHighlightColour = System.Drawing.Color.Honeydew;
cffGGV_TransactionGridView.EmptyDataRowStyle.CssClass = "dxgvEmptyDataRow td";
if (this.CurrentScope() == Scope.CustomerScope)
{
cffGGV_TransactionGridView.NestedSettings.Enabled = true;
cffGGV_TransactionGridView.NestedSettings.Expanded = false;
cffGGV_TransactionGridView.NestedSettings.ExpandingButtonHeight = System.Web.UI.WebControls.Unit.Pixel(10);
cffGGV_TransactionGridView.NestedSettings.ExpandingButtonWidth = System.Web.UI.WebControls.Unit.Pixel(10);
cffGGV_TransactionGridView.NestedSettings.ExpandingColumnWidth = System.Web.UI.WebControls.Unit.Percentage(2);
cffGGV_TransactionGridView.NestedSettings.childGrid = cffGGV_TransactionGridViewChild;
}
else
{
cffGGV_TransactionGridView.NestedSettings.Enabled = false;
}
cffGGV_TransactionGridView.InsertDataColumn("Month", "YrMonth", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, false);
cffGGV_TransactionGridView.InsertCurrencyColumn("Funding", "Factored", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Non Funding", "NonFactored", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Credit", "Credit", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Receipt", "Receipt", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Journal", "Journal", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Discount", "Discount", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("Prepayments", "Repurchase", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.InsertCurrencyColumn("OverPayment", "OverPayment", "8%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_TransactionGridView.EnableViewState = true;
cffGGV_TransactionGridView.CaptionHeaderSettings.BoldCaption = true;
//set summary settings
cffGGV_TransactionGridView.TotalsSummarySettings.SetColumnTotals("Factored, NonFactored, Credit, Receipt, Journal, Discount, Repurchase, OverPayment");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Factored", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("NonFactored", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Credit", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Receipt", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Journal", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Discount", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("Repurchases", "cffGGV_currencyCell");
cffGGV_TransactionGridView.TotalsSummarySettings.SetSummaryTotalColumnCssStyle("OverPayment", "cffGGV_currencyCell");
cffGGV_TransactionGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
cffGGV_TransactionGridView.ShowFooter = true;
cffGGV_TransactionGridView.AllowPaging = true;
cffGGV_TransactionGridView.TotalsSummarySettings.TableClass = "dxgvFooter"; //dbb
cffGGV_TransactionGridView.CustomPagerSettingsMode = CffCustomPagerMode.Rows | CffCustomPagerMode.Page | CffCustomPagerMode.FirstLast | CffCustomPagerMode.PreviousNext | CffCustomPagerMode.Bottom;
cffGGV_TransactionGridView.ViewStateMode = System.Web.UI.ViewStateMode.Enabled;
TransactionGridViewPH.Controls.Clear();
TransactionGridViewPH.Controls.Add(cffGGV_TransactionGridView);
}
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 { }
}
}