protected override void Process(IReadOnlyList <PSObject> data)
{
var propNames = new List <string>();
var elements = new Dictionary <string, List <object> >();
foreach (var row in data)
{
foreach (var prop in row.Properties)
{
if (!elements.ContainsKey(prop.Name))
{
propNames.Add(prop.Name);
elements.Add(prop.Name, new List <object>());
}
elements[prop.Name].Add(prop.Value);
}
}
foreach (var name in propNames)
{
var result = new DataSummary(elements[name].Select(x => Converter.ToDouble(x)).ToArray(), name);
WriteObject(result);
}
}
public List <DataSummary> GetDbSummarise()
{
List <DataSummary> summarise = new List <DataSummary>();
DbConnection conn = db.GetConnection();
DataTable dt = conn.GetSchema("Tables");
DataView dv = dt.DefaultView;
dv.Sort = "TABLE_NAME";
conn.Close();
SchemaContainer <XTableSchema> xtc = XTableSchemaContainer.Instance();
foreach (DataRowView dr in dv)
{
DataSummary tbSummary = new DataSummary();
tbSummary.Name = dr["TABLE_NAME"].ToString();
tbSummary.Description = dr["TABLE_NAME"].ToString();
tbSummary.Caption = dr["TABLE_NAME"].ToString();
tbSummary.Type = dr["TABLE_TYPE"].ToString();
XTableSchema ts = xtc.GetItem(tbSummary.Name);
if (xtc.Contains(tbSummary.Name))
{
tbSummary.Caption = ts.Title;
tbSummary.Description = ts.Description;
}
summarise.Add(tbSummary);
}
return(summarise);
}
public PageSummary(DataSummary summary)
{
InitializeComponent();
dataSummary = summary;
HelpTextBlock.Text = dataSummary.SummaryForDisplay();
}
public void TestMethod1()
{
var df = new DataSummary();
// throw new Exception("Test");
Assert.AreNotEqual(df.FormatedDate, null);
}
private void CalculateButton_OnClick(object sender, RoutedEventArgs e)
{
// -- Need Calculator object as non static
var calculator = new Calculator();
try
{
var controlData = false;
controlData = ControlHasValueCheck();
if (controlData)
{
// -- Get base data needed for room and tile
tile = GetSelectedTile();
room = HarvestData();
// -- create a DataSummary object to hold calculation outcomes
// -- This object will be passed to the PageSummary page
// -- and then displayed in the TextBlock
var dataForSummary = new DataSummary()
{
WholeRoomArea = RoomAreas.WholeRoomArea(room).ToString(),
Cutout1Area = RoomAreas.AreaCutout1(room).ToString(),
Cutout2Area = RoomAreas.AreaCutout2(room).ToString(),
TileSizeUsed = selectedTileName,
TilesNeededForRoom = calculator.NumberTilesForFloor(room, tile).ToString(),
LeftoverTileArea = calculator.AreaLeftoverTile(room, tile).ToString(),
PerimeterLength = RoomAreas.RoomPerimeter(room).ToString()
};
dataSummary = dataForSummary;
// -- DEBUG Test message
MessageBox.Show(dataSummary.SummaryForDisplay());
// -- Navigate to PageSummary with the dataSummary object
var pageSummary = new PageSummary(dataSummary);
var navigationService = NavigationService;
if (navigationService != null)
{
navigationService.Navigate(pageSummary);
}
}
else
{
MessageBox.Show("Some data is missing. Please check");
}
}
catch (Exception exception)
{
Console.WriteLine(exception);
throw;
}
}
public DataTable GetWarehouseDataTable()
{
try
{
return(DataSummary.GenerateWarehouse(purchaseManager.GetPurchaseOrders(), marketingManager.GetCustomersOrdersList()));
}
catch
{
return(null);
}
}
public DataTable GetBankDataTable()
{
try
{
return(DataSummary.GenerateBank(purchaseManager.GetPurchaseOrders(), marketingManager.GetCustomersOrdersList(), financeManager.CurrentBalance));
}
catch
{
return(null);
}
}
public DataTable GetSupplierOrdersDataTable()
{
try
{
return(DataSummary.GenerateSupplierOrdersDataTable(purchaseManager.GetPurchaseOrders()));
}
catch
{
return(null);
}
}
public DataTable GetCustomerOrdersDataTable()
{
try
{
return(DataSummary.GenerateCustomerOrdersDataTable(marketingManager.GetCustomersOrdersList()));
}
catch (Exception)
{
return(null);
}
}
public DataTable GetProductionsDataTable()
{
try
{
return(DataSummary.toolListToDT(productionManager.GetToolsList()));
}
catch
{
return(null);
}
}
private void LoadCategoryChart()
{
DataTable dt = DataSummary.GetCategoryCount();
string[] x = (from p in dt.AsEnumerable()
orderby p.Field <string>("category") ascending
select p.Field <string>("category")).ToArray();
int[] y = (from p in dt.AsEnumerable()
orderby p.Field <string>("category") ascending
select p.Field <int>("cat_count")).ToArray();
stockChart.Series[0].ChartType = SeriesChartType.Pie;
stockChart.Series[0].Points.DataBindXY(x, y);
stockChart.Legends[0].Enabled = true;
stockChart.ChartAreas[0].Area3DStyle.Enable3D = true;
}
public void TestAddDataSummaryExtension()
{
DataSummary ds1 = new DataSummary("Title1", "40");
DataSummary ds2 = new DataSummary("Title2", "60");
DataSummary ds3 = new DataSummary("Title3", "80");
Response res = new Response();
res.AddDataSummary(new List <DataSummary>()
{
ds1, ds2, ds3
});
Assert.NotEmpty(res.Dataset);
Assert.Equal <RenderingType>(RenderingType.DataSummary, res.Dataset.FirstOrDefault().RenderingProperties.Type);
foreach (DataRow row in res.Dataset.FirstOrDefault().Table.Rows)
{
Assert.Equal(3, row.ItemArray.Count());
}
}
public DataSummary GetCovidSummaryByNode()
{
var page = GetNcdcHtmlData();
var samplesTested = NodeUrlHelper.GetJustNumbers(page.OwnerDocument.DocumentNode.SelectSingleNode(NodeUrlHelper.SampleTestedNode).InnerText);
var confirmedCases = NodeUrlHelper.GetJustNumbers(page.OwnerDocument.DocumentNode.SelectSingleNode(NodeUrlHelper.ConfirmedCasesNode).InnerText);
var activeCases = NodeUrlHelper.GetJustNumbers(page.OwnerDocument.DocumentNode.SelectSingleNode(NodeUrlHelper.ActiveCasesNode).InnerText);
var dischargedCases = NodeUrlHelper.GetJustNumbers(page.OwnerDocument.DocumentNode.SelectSingleNode(NodeUrlHelper.DischargedCasesNode).InnerText);
var deaths = NodeUrlHelper.GetJustNumbers(page.OwnerDocument.DocumentNode.SelectSingleNode(NodeUrlHelper.DeathsNode).InnerText);
var model = new DataSummary
{
ActiveCases = activeCases,
ConfirmedCases = confirmedCases,
DischargedCases = dischargedCases,
Deaths = deaths,
SamplesTested = samplesTested
};
return(model);
}
private async Task <DataSummary> Update()
{
return(DataSummary.FromJson(await Web.DownloadStringTaskAsync(Config.ResultsEndpoint)));
}
