public object RunQuery(Guid _portletID)
{
CUS.OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
Portlet portlet = Jenzabar.Common.ObjectFactoryWrapper.GetInstance <IPortletFacade>().FindByGuid(_portletID);
if (portlet.ParentPage.CanView(PortalUser.Current))
{
try
{
NHSimpleQueryMapper mapper = new NHSimpleQueryMapper();
NHSimpleQuery NHS = mapper.GetById(_portletID);
if (NHS.ConfigFile.Contains(".config"))
{
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3("~/ClientConfig/" + NHS.ConfigFile);
}
else
{
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3(NHS.ConfigFile);
}
odbcConn.ConnectionTest();
Exception exError = null;
try
{
DataTable dt = new DataTable();
if (NHS.QueryTimeout > 0)
{
dt = odbcConn.ConnectToERP(NHS.FilledQueryString(), ref exError, NHS.QueryTimeout);
}
else
{
dt = odbcConn.ConnectToERP(NHS.FilledQueryString(), ref exError);
}
StoreExportData(NHS, dt, _portletID, PortletUtilities.GetSettingValue(portlet, "DisplayColumnHeadings") == "Checked", portlet);
JSDataTableConverter jsdtc = new JSDataTableConverter(dt, NHS.ExpandedColumns.Split(','), NHS.ColumnLabels.Split(','));
JSDataTable data = jsdtc.GetJsDataTable();
if (exError != null)
{
throw exError;
}
return(new
{
success = true,
data = data.data,
columns = data.columns
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = "Query Failed. " + (PortalUser.Current.IsSiteAdmin ? ": " + ex : "")
});
}
}
catch (Exception ex)
{
return(new
{
success = false,
message = "Connection failed before query was executed." + (PortalUser.Current.IsSiteAdmin ? ": " + ex : "")
});
}
}
else
{
return(new
{
success = false,
message = "You do not have permissions to view this portlet"
});
}
}
public object RunQuery(Guid _portletID)
{
CUS.OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
Portlet portlet = Jenzabar.Common.ObjectFactoryWrapper.GetInstance<IPortletFacade>().FindByGuid(_portletID);
if (portlet.ParentPage.CanView(PortalUser.Current))
{
try
{
NHSimpleQueryMapper mapper = new NHSimpleQueryMapper();
NHSimpleQuery NHS = mapper.GetById(_portletID);
if (NHS.ConfigFile.Contains(".config"))
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3("~/ClientConfig/" + NHS.ConfigFile);
else
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3(NHS.ConfigFile);
odbcConn.ConnectionTest();
Exception exError = null;
try
{
DataTable dt = new DataTable();
if (NHS.QueryTimeout > 0)
dt = odbcConn.ConnectToERP(NHS.FilledQueryString(), ref exError, NHS.QueryTimeout);
else
dt = odbcConn.ConnectToERP(NHS.FilledQueryString(), ref exError);
StoreExportData(NHS, dt, _portletID, PortletUtilities.GetSettingValue(portlet, "DisplayColumnHeadings") == "Checked", portlet);
JSDataTableConverter jsdtc = new JSDataTableConverter(dt, NHS.ExpandedColumns.Split(','), NHS.ColumnLabels.Split(','));
JSDataTable data = jsdtc.GetJsDataTable();
if (exError != null)
throw exError;
return new
{
success = true,
data = data.data,
columns = data.columns
};
}
catch (Exception ex)
{
return new
{
success = false,
message = "Query Failed. " + (PortalUser.Current.IsSiteAdmin ? ": " + ex : "")
};
}
}
catch (Exception ex)
{
return new
{
success = false,
message = "Connection failed before query was executed." + (PortalUser.Current.IsSiteAdmin ? ": " + ex : "")
};
}
}
else
{
return new
{
success = false,
message = "You do not have permissions to view this portlet"
};
}
}
