public string GetRecordCountByString(List <EwavRule_Base> rules, string s, string tableName, string dsName)
{
try
{
EpiDashboard.GadgetParameters inputs = new EpiDashboard.GadgetParameters();
inputs.TableName = tableName;
inputs.DatasourceName = dsName;
EpiDashboard.DashboardHelper dashboardHelper = new EpiDashboard.DashboardHelper(inputs, s, rules);
dashboardHelper.UseAdvancedUserDataFilter = true;
dashboardHelper.AdvancedUserDataFilter = s;
//EntityManager em = new EntityManager();
//return em.GetRecordsCount(dsName, tableName, s);
dashboardHelper.EwavConstructTableColumnNames(inputs);
dashboardHelper.GenerateView(inputs);
string totalRecords = dashboardHelper.DataSet.Tables[0].Rows.Count.ToString();
string filteredRecords = dashboardHelper.DataSet.Tables[0].DefaultView.Count.ToString();
string result = totalRecords + "," + filteredRecords;
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message + " -- " + ex.StackTrace);
}
}
/// <summary>
/// Exports the Data in to DatatableBag
/// </summary>
/// <param name="dsName"></param>
/// <param name="tableName"></param>
/// <param name="ewavDataFilters"></param>
/// <param name="rules"></param>
/// <returns></returns>
public DatatableBag ExportData(string dsName, string tableName,
IEnumerable <EwavDataFilterCondition> ewavDataFilters, List <EwavRule_Base> rules)
{
DatatableBag dtb = new DatatableBag();
EpiDashboard.GadgetParameters gp = new EpiDashboard.GadgetParameters();
gp.DatasourceName = dsName;
gp.TableName = tableName;
EpiDashboard.DashboardHelper dbHelper = new EpiDashboard.DashboardHelper(gp, ewavDataFilters, rules);
dbHelper.PopulateDataSet();
DataView dv = dbHelper.DataSet.Tables[0].DefaultView;
///Write code here
return(dtb);
}
public string ReadFilterString(List <EwavDataFilterCondition> filterList, List <EwavRule_Base> rules, string tableName, string dsName)
{
try
{
EpiDashboard.GadgetParameters inputs = new EpiDashboard.GadgetParameters();
inputs.TableName = tableName;
inputs.DatasourceName = dsName;
EpiDashboard.DashboardHelper dashboardHelper = new EpiDashboard.DashboardHelper(inputs, filterList, rules);
dashboardHelper.EwavConstructTableColumnNames(inputs);
dashboardHelper.CreateDataFilters(filterList);
return(dashboardHelper.GenerateDataFilterString());
}
catch (Exception ex)
{
throw new Exception(ex.Message + " -- " + ex.StackTrace);
}
}
public string GetRecordCount(List <EwavDataFilterCondition> filterList, List <EwavRule_Base> rules, string tableName, string dsName)
{
Assembly assembly = Assembly.GetExecutingAssembly();
String version = assembly.FullName.Split(',')[1];
String fullversion = version.Split('=')[1];
try
{
string result;
if (filterList.Count == 0 && rules.Count == 0)
{
EntityManager em = new EntityManager();
int recordCount = em.GetRawDataTableRecordCount(dsName, tableName);
result = recordCount.ToString() + "," + recordCount.ToString();
}
else
{
EpiDashboard.GadgetParameters inputs = new EpiDashboard.GadgetParameters();
inputs.TableName = tableName;
inputs.DatasourceName = dsName;
EpiDashboard.DashboardHelper dashboardHelper = new EpiDashboard.DashboardHelper(inputs, filterList, rules);
dashboardHelper.EwavConstructTableColumnNames(inputs);
dashboardHelper.CreateDataFilters(filterList);
dashboardHelper.GenerateView(inputs);
string totalRecords = dashboardHelper.DataSet.Tables[0].Rows.Count.ToString();
string filteredRecords = dashboardHelper.DataSet.Tables[0].DefaultView.Count.ToString();
result = totalRecords + "," + filteredRecords;
}
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message + " -- " + ex.StackTrace);
}
}
