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 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;
}
}
private void configureGridColumns()
{
cffGGV_StatementGridView.Columns.Clear();
cffGGV_StatementGridView.InsertDataColumn("Date", "Dated", CffGridViewColumnType.Date, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
cffGGV_StatementGridView.InsertDataColumn("Description", "Description", CffGridViewColumnType.Text, "10%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
cffGGV_StatementGridView.InsertDataColumn("Invoice", "Number", CffGridViewColumnType.Text, "10%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
cffGGV_StatementGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "10%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
cffGGV_StatementGridView.InsertCurrencyColumn("Debits", "Debits", "10%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
cffGGV_StatementGridView.InsertCurrencyColumn("Credits", "Credits", "10%", "cffGGV_currencyCell", false, HorizontalAlign.Right, HorizontalAlign.Right);
}
protected void ConfigureGridColumns()
{
CffGGV_ChargesGridView.Columns.Clear();
CffGGV_ChargesGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_ChargesGridView.InsertDataColumn("Description", "Description", CffGridViewColumnType.Text, "38%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
CffGGV_ChargesGridView.InsertCurrencyColumn("Amount", "Amount", "6%", "cffGGV_currencyCellAgedBal", false, HorizontalAlign.Right, HorizontalAlign.Right);
CffGGV_ChargesGridView.ShowFooter = true;
CffGGV_ChargesGridView.TotalsSummarySettings.SetColumnTotals("Amount");
CffGGV_ChargesGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
CffGGV_ChargesGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
}
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);
}
private void InsertCommonColumns()
{
reportGridView.InsertDataColumn("Processed", "Factored", CffGridViewColumnType.Date, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "2%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Transactions", "Number", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("Reference", "Reference", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertCurrencyColumn("Charges", "Charges", "4%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("With GST", "ChargesWithGst", "4%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Amount", "Amount", "4%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertCurrencyColumn("Balance", "Balance", "4%", "cffGGV_rightAlignedCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertDataColumn("Status", "Status", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal2");
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
ReportGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Processed", "ProcessedDate", CffGridViewColumnType.Date, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Invoice", "Invoice", CffGridViewColumnType.Text, "8", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Ref", "Reference", CffGridViewColumnType.Text, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertCurrencyColumn("Amount", "Amount", "10%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.TotalsSummarySettings.SetColumnTotals("Amount");
ReportGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Amount", "cffGGV_currencyCell");
}
public AgedBalNotesDetailRowTemplateNew(object dataSource, string strKFieldName)
{
this.dataSource = dataSource;
this.currentRow = 0;
this.dtKeyFieldName = strKFieldName;
detailGridView = new CffGenGridView();
detailGridView.InsertDataColumn("Created By", "CreatedByEmployeeName");
detailGridView.InsertDataColumn("Comment", "Comment");
detailGridView.InsertDataColumn("Created", "Created");
detailGridView.Enabled = false;
}
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();
}
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);
}
public void ConfigureGridColumns()
{
ReportGridView.Columns.Clear();
ReportGridView.InsertDataColumn("Date", "Date", CffGridViewColumnType.Date, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Processed", "ProcessedDate", CffGridViewColumnType.Date, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Type", "Type", CffGridViewColumnType.Text, "8%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.InsertDataColumn("Invoice", "Invoice", CffGridViewColumnType.Text, "8", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertCurrencyColumn("Amount", "Amount", "12%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Ref", "Reference", CffGridViewColumnType.Text, "9%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
ReportGridView.ShowFooter = true;
ReportGridView.TotalsSummarySettings.SetColumnTotals("Amount");
ReportGridView.CustomFooterSettings = CffCustomFooterMode.ShowTotals | CffCustomFooterMode.DefaultSettings;
}
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("Title", "Title", CffGridViewColumnType.Text, "4%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Due", "Due", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertCurrencyColumn("Balance", "Balance", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
reportGridView.InsertDataColumn("Age", "Age", CffGridViewColumnType.Text, "3%", "cffGGV_centerAlignedCell", HorizontalAlign.Center, HorizontalAlign.Center, true);
reportGridView.InsertDataColumn("First Name", "FirstName", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Last Name", "LastName", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Phone", "Phone", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Mobile Phone", "Cellphone", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
reportGridView.InsertDataColumn("Fax", "Fax", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
}
public AgedBalNotesDetailRowTemplateNew(string strKFieldName)
{
this.dtKeyFieldName = strKFieldName;
this.currentRow = 0;
detailGridView = new CffGenGridView();
detailGridView.AutoGenerateColumns = false;
detailGridView.CssClass = "scroll";
detailGridView.Visible = true;
detailGridView.InsertDataColumn("Created By", "CreatedByEmployeeName");
detailGridView.InsertDataColumn("Comment", "Comment");
detailGridView.InsertDataColumn("Created", "Created");
detailGridView.Enabled = false;
}
public AgedBalNotesDetailRowTemplateNew(string strKFieldName, object dSource, string pID, int cRow)
{
this.dtKeyFieldName = strKFieldName;
this.dataSource = dSource;
this.ID = pID;
this.currentRow = cRow;
detailGridView = new CffGenGridView();
detailGridView.InsertDataColumn("Created By", "CreatedByEmployeeName");
detailGridView.InsertDataColumn("Comment", "Comment");
detailGridView.InsertDataColumn("Created", "Created");
detailGridView.Visible = true;
detailGridView.Enabled = false;
}
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 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);
}
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);
}
}
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);
}
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);
}
private void ConfigureGridColumns()
{
//this.totalDebitLiteral.Text = string.Empty;
//this.totalCreditLiteral.Text = string.Empty;
this.movementLiteral.Text = string.Empty;
this.closingBalanceliteral.Text = string.Empty;
AccountTransactionsGridView.Columns.Clear();
AccountTransactionsGridView.InsertDataColumn("Reference", "TranRef", CffGridViewColumnType.Text, "6%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
AccountTransactionsGridView.InsertDataColumn("TransDate", "TranDate", CffGridViewColumnType.Date, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
AccountTransactionsGridView.InsertDataColumn("TransType", "TranType", CffGridViewColumnType.Text, "5%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
AccountTransactionsGridView.InsertCurrencyColumn("Debit", "Debit", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
AccountTransactionsGridView.InsertCurrencyColumn("Credit", "Credit", "6%", "cffGGV_currencyCellAgedBal", true, HorizontalAlign.Right, HorizontalAlign.Right);
AccountTransactionsGridView.InsertDataColumn("Description", "Description", CffGridViewColumnType.Text, "34%", "cffGGV_leftAlignedCellAgedBal", HorizontalAlign.Left, HorizontalAlign.Left, true, "cffGGVHeaderLeftAgedBal1");
AccountTransactionsGridView.ShowFooter = true;
AccountTransactionsGridView.TotalsSummarySettings.SetColumnTotals("Debit,Credit");
AccountTransactionsGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Debit", "cffGGV_rightAlignedCell");
AccountTransactionsGridView.TotalsSummarySettings.SetTotalsColumnCssStyle("Credit", "cffGGV_rightAlignedCell");
AccountTransactionsGridView.CustomFooterSettings = CffCustomFooterMode.DefaultSettings | CffCustomFooterMode.ShowTotals;
}
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);
}
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();
}
}
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 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);
}
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.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 InsertCommonColumns()
{
ReportGridView.InsertDataColumn("#", "CustomerNumber", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertBoundHyperLinkColumn("Customer", "CustomerName", "CustomerId", "14%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left);
ReportGridView.InsertCurrencyColumn("Current", "CurrentBalance", "5%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Month 1", "MonthOldBalance", "6%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Month 2", "TwoMonthsOldBalance", "7%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Month 3+", "ThreeMonthsOrOlderBalance", "7%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Balance", "Balance", "7%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertCurrencyColumn("Limit", "Limit", "7%", "cffGGV_currencyCell", true, HorizontalAlign.Right, HorizontalAlign.Right);
ReportGridView.InsertDataColumn("Next Call", "NextCallDate", CffGridViewColumnType.Text, "3%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Contact", "Contact", CffGridViewColumnType.Text, "10%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Phone", "Phone", CffGridViewColumnType.Text, "6%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Mobile Phone", "Cell", CffGridViewColumnType.Text, "6%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
ReportGridView.InsertDataColumn("Email", "Email", CffGridViewColumnType.Text, "12%", "cffGGV_leftAlignedCell", HorizontalAlign.Left, HorizontalAlign.Left, true);
}
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 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;
}