public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptWebGiftDetails rpt = new rptWebGiftDetails();
rpt.Site = this.Site;
return rpt;
}
private void subConfigureCrystalReports()
{
string strSQL = "";
string strWHERE = "";
strWHERE="WHERE tblWebGift.lngGiftWebID="+lngGiftWebID.ToString();
strSQL = "SELECT tblWebGift.blnPledgeReminders, tblWebGift.blnPledgeAutopay, " +
"tblWebGift.intPledgeFreq, tblWebGift.intPledgeTerm, " +
"tblWebGift.lngGiftWebID, tblWebGift.lngRecordWebID, " +
"tblWebGift.curAmount, " +
"tblWebGift.dteGiftDate, " +
"tlkpCampaignCodes.strCampaignCode, tblGiftCategory.strOLDesc, tlkpPaymentType.strPaymentType, tblWebGift.strInHonorOf, tblWebGift.strAcctNum, tblWebGift.strBankName, tblWebGift.strCCNumber, tblWebGift.strRoutingNum, tblWebGift.strMemorialName, tblWebGift.strPNRef, tblWebGift.strXCAlias, tblWebGift.strXCTransID, tblWebGift.strEPSTransID, tblWebGift.strEPSApprovalNumber, tblWebGift.strEPSValidationCode, tblWebGift.strEPSPmtAcctID, tblWebRecords.strFirstName, tblWebRecords.strLastCoName, tblWebRecords.strAddress, tblWebRecords.strCity, tlkpStates.strState, tblWebRecords.strZip, tblWebRecords.strEmail, tblWebRecords.strHomePhone, tblWebRecords.strCellPhone " +
"FROM ((((tblWebGift " +
"LEFT JOIN tlkpCampaignCodes ON tblWebGift.lngCampaignID = tlkpCampaignCodes.lngCampaignID) " +
"LEFT JOIN tblGiftCategory ON tblWebGift.lngGiftCategoryID = tblGiftCategory.lngGiftCategoryID) " +
"INNER JOIN tblWebRecords ON tblWebGift.lngRecordWebID = tblWebRecords.lngRecordWebID) " +
"LEFT JOIN tlkpStates ON tblWebRecords.lngStateID = tlkpStates.lngStateID) " +
"LEFT JOIN tlkpPaymentType ON tblWebGift.lngPaymentTypeID = tlkpPaymentType.lngPaymentTypeID " +
strWHERE;
conCTMain_B.ConnectionString = clsAppSettings.GetAppSettings().strCTConn;
daWebGiftDetails.SelectCommand.CommandText = strSQL;
daWebGiftDetails.Fill(dsWebGiftDetails, "qrptWebGiftDetails");
wgdWebGiftDetails = new rptWebGiftDetails();
wgdWebGiftDetails.SetDataSource(dsWebGiftDetails);
rvwWebGiftDetails.ReportSource = wgdWebGiftDetails;
int intPledgeFreq=0;
string strPledgeFreq = "";
using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn))
{
conDB.Open();
strSQL = "SELECT intPledgeFreq " +
"FROM tblWebGift " +
"WHERE lngGiftWebID=" + lngGiftWebID.ToString();
using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB))
{
try { intPledgeFreq = Convert.ToInt32(cmdDB.ExecuteScalar()); }
catch { intPledgeFreq = 0; }
}
conDB.Close();
}
switch (intPledgeFreq)
{
case 0:
strPledgeFreq = "";
break;
case 1:
strPledgeFreq = "Weekly";
break;
case 2:
strPledgeFreq = "Monthly";
break;
case 3:
strPledgeFreq = "Quarterly";
break;
case 4:
strPledgeFreq = "Semi-Annually";
break;
case 5:
strPledgeFreq = "Annually";
break;
case 6:
strPledgeFreq = "Bi-Monthly";
break;
case 7:
strPledgeFreq = "Bi-Weekly";
break;
}
//determine applicable pledge frequency
((TextObject)wgdWebGiftDetails.ReportDefinition.ReportObjects["txtPledgeFreq"]).Text = strPledgeFreq;
//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;
}
}*/
}
