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