private void BtnSubmitQuery(object sender, RoutedEventArgs e)
{
try
{
DataSet _data = null;
if (txtRslName.Text == "")
{
GenevaParams genevaParams = new GenevaParams();
genevaParams.IsQuery = true;
genevaParams.RslQuery = txtGenevaQuery.Text.Replace("\n", " ").Replace("\r", " ");
_data = GenevaHelper.ExecuteRSLQuery(getGenevaConnection(), genevaParams);
}
else
{
GenevaParams genevaParams = GetDataParams();
genevaParams.RslReportName = txtRslName.Text;
_data = GenevaHelper.ExecuteRSLQuery(getGenevaConnection(), genevaParams);
}
grdGenevaReuslts.ItemsSource = _data.Tables.Count > 1 ? _data.Tables["Data"] : _data.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show( ex.Message, "Geneva Error");
}
}
private GenevaParams GetDataParams()
{
string startDate = DateTime.Parse( CtlStartDatePicker.Text).ToShortDateString() + ":00:00:00" ;
string endDate = DateTime.Parse(CtlEndDatePicker.Text).ToShortDateString() + ":23:59:59" ;
string startDateMinu = DateTime.Parse(CtlStartDatePicker.Text).AddDays(-1).ToShortDateString() + ":23:59:59" ;
string knowledgeDate = DateTime.Parse(CtlKnowledgeDatePicker.Text).ToShortDateString() + ":23:59:59";
GenevaParams param = new GenevaParams("", "", TxtPortfolio.Text, startDate, endDate, knowledgeDate, "", startDateMinu,txtCustomFilter.Text,txtAcctFilter.Text);
return param;
}
private static DataSet Execute(GenevaConnection pConnection, GenevaParams pParameters)
{
DataSet _getRSLData = new DataSet();
GenWebAccessAccess queryMan = new GenWebAccessAccess(pConnection);
if (pParameters.IsQuery)
{
_getRSLData = queryMan.runReportSelectLiteralDS( pParameters.RslQuery);
}
else
{
_getRSLData = queryMan.getReportResultsLiteralDS(pParameters.RslReportName, GetParameterString(pParameters));
}
return _getRSLData;
}
private static String GetParameterString(GenevaParams pParameters)
{
StringBuilder query = new StringBuilder();
if (!String.IsNullOrEmpty(pParameters.Portfolio))
query.Append(" -p " + pParameters.Portfolio);
if (!String.IsNullOrEmpty(pParameters.PeriodStartDate))
query.Append(" -ps " + pParameters.PeriodStartDate);
if (!String.IsNullOrEmpty(pParameters.PeriodEndDate))
query.Append(" -pe " + pParameters.PeriodEndDate);
if (!String.IsNullOrEmpty(pParameters.KnowledgeBeginDate))
query.Append(" -kd " + pParameters.KnowledgeBeginDate);
if (pParameters.ReportType == GenevaParams.GenevaReportType.Detail)
query.Append(" --ReportType " + "Detail");
else if (pParameters.ReportType == GenevaParams.GenevaReportType.Summary)
query.Append(" --ReportType " + "Summary");
if (!String.IsNullOrEmpty(pParameters.Custom))
query.Append(" " + pParameters.Custom);
if (!String.IsNullOrEmpty(pParameters.Consolidate))
query.Append(" --Consolidate " + pParameters.Consolidate);
if (!String.IsNullOrEmpty(pParameters.AcctParameter))
query.Append(" -ap " + pParameters.AcctParameter);
if (!String.IsNullOrEmpty(pParameters.AcctParameter))
query.Append(" -ap " + pParameters.AcctParameter);
if (!String.IsNullOrEmpty(pParameters.AcctParameter))
query.Append(" -af " + pParameters.AcctFilters);
return query.ToString();
}
public static DataSet ExecuteRSLReport(GenevaConnection pConnection, GenevaParams pParameters)
{
return Execute(pConnection, pParameters);
}