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); } }