// generates C1.DataEngine table public static void Generate(Workspace workspace, int totalRows, DateTime minOrderDate, DateTime maxOrderDate, int minShippedDays, int maxShippedDays) { var list = Item.GenerateList(totalRows, minOrderDate, maxOrderDate, minShippedDays, maxShippedDays); var connector = new C1.DataEngine.ObjectConnector <Item>(workspace, list); connector.GetData(Name); }
// generates C1.DataEngine table public static void Generate(Workspace workspace, int totalRows, int maxUnitsInStock, int maxUnitsOnOrder) { var list = Item.GenerateList(totalRows, maxUnitsInStock, maxUnitsOnOrder); var connector = new C1.DataEngine.ObjectConnector <Item>(workspace, list); connector.GetData(Name); }
// add data to DataEngine table void AddToEngineTable(int count, bool firstTime) { // read initial data from database var command = new SqlCommand(Properties.Resources.SqlStatement, conn); if (firstTime || dataFromDB == null) { using (var reader = command.ExecuteReader()) { dataFromDB = Sale.GetSales(reader).ToList(); } } // add more rows, just for testing performance var connector = new C1.DataEngine.ObjectConnector <Sale>(_c1FlexPivotPage.FlexPivotPanel.Workspace, ChangeDataSize(dataFromDB, count)); DateTime dt = DateTime.Now; int idx = StartAddingRows(count); if (firstTime) { connector.GetData(tableName); } else { connector.AppendData(tableName); } EndAddingRows(count, dt, idx); // connect C1FlexPivot to DataEngine filled with data if (firstTime) { ConnectDataEngine(); } }
// generates C1.DataEngine table public static void Generate(Workspace workspace, int totalRows, int maxOrders, int maxProducts, int maxQuantity, int maxUnitPrices, int maxDiscounts) { var list = Item.GenerateList(totalRows, maxOrders, maxProducts, maxQuantity, maxUnitPrices, maxDiscounts); var connector = new C1.DataEngine.ObjectConnector <Item>(workspace, list); connector.GetData(Name); }
// Connect C1FlexPivot to data void SetData(int count) { // read initial data from database IList <Sale> dataFromDB; var command = new SqlCommand(Properties.Resources.SqlStatement, conn); using (var reader = command.ExecuteReader()) dataFromDB = Sale.GetSales(reader).ToList(); // add more rows, just for testing performance string tableName = "Sales"; DateTime dt = DateTime.Now; StartAddingRows(count); var connector = new C1.DataEngine.ObjectConnector <Sale>(_c1FlexPivotPage.FlexPivotPanel.Workspace, ChangeDataSize(dataFromDB, count)); connector.GetData(tableName); EndAddingRows(count, dt); var fPanel = _c1FlexPivotPage.FlexPivotPanel; fPanel.FlexPivotEngine.BeginUpdate(); // connect C1FlexPivot to DataEngine filled with data fPanel.ConnectDataEngine(tableName); // set initial view fPanel.ViewDefinition = initialView; // fill lookups FillLookup("Country", Properties.Resources.SqlLookupCountry); FillLookup("Product", Properties.Resources.SqlLookupProduct); FillLookup("Customer", Properties.Resources.SqlLookupCustomer); FillLookup("Employee", Properties.Resources.SqlLookupEmployee); FillLookup("Category", Properties.Resources.SqlLookupCategory); fPanel.FlexPivotEngine.EndUpdate(); }