public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptDXDetails rpt = new rptDXDetails();
rpt.Site = this.Site;
return rpt;
}
private void subConfigureCrystalReports()
{
string strSQL = "";
string strWHERE = "";
strWHERE = "WHERE tblDonorExpress.lngDonorExpressID=" + lngDonorExpressID.ToString();
strSQL = "SELECT tblDonorExpress.blnProcessed, " +
"tblDonorExpress.lngDonorExpressID, tblDonorExpress.lngPaymentTypeID, " +
"tblDonorExpress.dteCreated, tblDonorExpress.dteSubmitted, " +
"tblDonorExpress.curGiftAmt, " +
"tblDonorExpress.strEmail, tblDonorExpress.strFName, tblDonorExpress.strLName, tblDonorExpress.strAddress, tblDonorExpress.strCity, tblDonorExpress.strState, tblDonorExpress.strZip, tblDonorExpress.strHomePhone, tblDonorExpress.strReferredBy, tblDonorExpress.strIMO, tblDonorExpress.strIHO, tblDonorExpress.strCheckNumber, tblDonorExpress.strAcctNum, tblDonorExpress.strBankName, tblDonorExpress.strCCExpDate, tblDonorExpress.strCCNumber, tblDonorExpress.strCCValCode, tblDonorExpress.strRoutingNum, tblDonorExpress.strAuthNum, tblDonorExpress.strPNRef, tblDonorExpress.strXCAlias, tblDonorExpress.strXCTransID, tblDonorExpress.strXCEFTAuthCode, tblDonorExpress.strXCEFTRefID, tblDonorExpress.strEPSTransID, tblDonorExpress.strEPSApprovalNumber, tblDonorExpress.strEPSValidationCode, tblDonorExpress.strEPSPmtAcctID " +
"FROM tblDonorExpress " +
strWHERE;
conCTMain_B.ConnectionString = clsAppSettings.GetAppSettings().strCTConn;
daDXDetails.SelectCommand.CommandText = strSQL;
daDXDetails.Fill(dsDXDetails, "qrptDonorExpress");
//set data sources for sub-reports
//custom gift fields
string strSQL_CustomFields = "";
strSQL_CustomFields = "SELECT tblDonorExpressCustomVals.lngDonorExpressID, " +
"tblDonorExpressCustomVals.strFieldName, tblDonorExpressCustomVals.strValue " +
"FROM tblCustomFieldsGiftDef " +
"LEFT JOIN tblDonorExpressCustomVals ON tblCustomFieldsGiftDef.strFieldName = tblDonorExpressCustomVals.strFieldName " +
"ORDER BY tblCustomFieldsGiftDef.intSortOrder";
daDXDetails_CustomFields.SelectCommand.CommandText = strSQL_CustomFields;
daDXDetails_CustomFields.Fill(dsDXDetails_CustomFields, "sqryDonorExpres_CustomFields");
dxdToPrint = new rptDXDetails();
dxdToPrint.SetDataSource(dsDXDetails);
dxdToPrint.Subreports[0].SetDataSource(dsDXDetails_CustomFields);
rvwDXDetails.ReportSource = dxdToPrint;
//determine which live charge fields to display
//initially hide all live charge controls
//cashlinq
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblPNRef"]).Text = "";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblPNRef"]).Width = 0;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Width = 0;
//xcharge
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCTransID"]).Text = "";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCTransID"]).Width = 0;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Width = 0;
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCAlias"]).Text = "";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCAlias"]).Width = 0;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtXCAlias"]).Width = 0;
//eps
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSTransID"]).Text = "";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSTransID"]).Width = 0;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Width = 0;
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSPmtAcctID"]).Text = "";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSPmtAcctID"]).Width = 0;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtEPSPmtAcctID"]).Width = 0;
//select which cc val codes to display
switch (clsLiveCharge.fcnGetLiveChargeMethod())
{
//lblPNRef
//txtPNRef
//lblXCAuthCode
//txtXCAuthCode
case clsGlobalEnum.conLIVECHARGE.CashLinq:
{
//show pnref
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblPNRef"]).Text = "PN Ref:";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblPNRef"]).Width = 1560;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Width = 1800;
break;
}
case clsGlobalEnum.conLIVECHARGE.XCharge:
{
//show xc
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCTransID"]).Text = "XC Trans ID:";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCTransID"]).Width = 1560;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Width = 1800;
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCAlias"]).Text = "XC Alias:";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblXCAlias"]).Width = 1560;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtXCAlias"]).Width = 1800;
break;
}
case clsGlobalEnum.conLIVECHARGE.EPS:
{
//show eps
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSTransID"]).Text = "EPS Trans ID:";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSTransID"]).Width = 1560;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Width = 1800;
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSPmtAcctID"]).Text = "EPS Pmt Acct ID:";
((TextObject)dxdToPrint.ReportDefinition.ReportObjects["lblEPSPmtAcctID"]).Width = 1560;
((FieldObject)dxdToPrint.ReportDefinition.ReportObjects["txtEPSPmtAcctID"]).Width = 3600;
break;
}
}
}