public DataTable Dynamic_Pixel(OrderVariables oVariables, string SPname, string pixcd)
{
CommonModels oComm = new CommonModels();
dbConn.dbConnector.dbConn oDBConn;
DataTable pixeltb = new DataTable();
DataSet VpixData = new DataSet();
try
{
//DBConn and SP execution
oDBConn = new dbConn.dbConnector.dbConn();
oDBConn.regKey = ConfigurationManager.AppSettings["SQLConn"].ToString();
VpixData = oDBConn.ExecSPReturnSingleDS(SPname, pixcd);
pixeltb = VpixData.Tables[0];
return pixeltb;
}
catch (Exception ex)
{
oComm.SendEmail("Dynamic_Pixel() <br />Exception Raised from Confirmaiton Page in EM Landers. Exception: " + ex.Message.ToString() + ".<br />More Data (Offer URL): " + oVariables.referring_url + ". <br />More Data (Order Id):" + oVariables.order_id);
return null;
}
finally
{
oDBConn = null;
pixeltb = null;
VpixData = null;
}
}
private DataTable SelectMeissaDataStatus(string strCode)
{
try
{
string SQLString = System.Configuration.ConfigurationManager.AppSettings["SQLConn"].ToString();
dbConn.dbConnector.dbConn oDBConn = new dbConn.dbConnector.dbConn();
oDBConn.regKey = SQLString;
DataTable dt = oDBConn.ExecSPReturnSingleDS("SelectMelissaDataStatusForCode", strCode).Tables[0];
return dt;
}
catch (Exception ex)
{
throw;
}
}