public Dictionary <string, object> Sorting(Dictionary <string, object> jsonResult) { htmlHelper.PopulateData(jsonResult["currentReport"].ToString()); dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), ProductSales.GetSalesData(), jsonResult["sortedHeaders"].ToString()); return(dict); }
public Dictionary <string, object> NodeDropped(Dictionary <string, object> jsonResult) { htmlHelper.PopulateData(jsonResult["currentReport"].ToString()); dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), ProductSales.GetSalesData(), null, jsonResult["dropAxis"].ToString(), jsonResult["headerTag"].ToString(), jsonResult.ContainsKey("filterParams") ? jsonResult["filterParams"].ToString() : null, jsonResult["sortedHeaders"].ToString(), jsonResult["valueSorting"].ToString()); return(dict); }
public static ProductSalesCollection GetSalesData() { /// Geography string[] countries = new string[] { "Australia", "Canada", "France", "Germany", "United Kingdom", "United States" }; string[] ausStates = new string[] { "New South Wales", "Queensland", "South Australia", "Tasmania", "Victoria" }; string[] canadaStates = new string[] { "Alberta", "British Columbia", "Brunswick", "Manitoba", "Ontario", "Quebec" }; string[] franceStates = new string[] { "Charente-Maritime", "Essonne", "Garonne (Haute)", "Gers", }; string[] germanyStates = new string[] { "Bayern", "Brandenburg", "Hamburg", "Hessen", "Nordrhein-Westfalen", "Saarland" }; string[] ukStates = new string[] { "England" }; string[] ussStates = new string[] { "New York", "North Carolina", "Alabama", "California", "Colorado", "New Mexico", "South Carolina" }; /// Time string[] dates = new string[] { "FY 2005", "FY 2006", "FY 2007", "FY 2008", "FY 2009" }; /// Products string[] products = new string[] { "Bike", "Van", "Car" }; Random r = new Random(123345345); int numberOfRecords = 2000; ProductSalesCollection listOfProductSales = new ProductSalesCollection(); for (int i = 0; i < numberOfRecords; i++) { ProductSales sales = new ProductSales(); sales.Country = countries[r.Next(1, countries.GetLength(0))]; sales.Quantity = r.Next(1, 12); /// 1 percent discount for 1 quantity double discount = (30000 * sales.Quantity) * (double.Parse(sales.Quantity.ToString()) / 100); sales.Amount = (30000 * sales.Quantity) - discount; sales.Date = dates[r.Next(r.Next(dates.GetLength(0) + 1))]; sales.Product = products[r.Next(r.Next(products.GetLength(0) + 1))]; switch (sales.Product) { case "Car": { sales.Date = "FY 2005"; break; } } switch (sales.Country) { case "Australia": { sales.State = ausStates[r.Next(ausStates.GetLength(0))]; break; } case "Canada": { sales.State = canadaStates[r.Next(canadaStates.GetLength(0))]; break; } case "France": { sales.State = franceStates[r.Next(franceStates.GetLength(0))]; break; } case "Germany": { sales.State = germanyStates[r.Next(germanyStates.GetLength(0))]; break; } case "United Kingdom": { sales.State = ukStates[r.Next(ukStates.GetLength(0))]; break; } case "United States": { sales.State = ussStates[r.Next(ussStates.GetLength(0))]; break; } } listOfProductSales.Add(sales); } return(listOfProductSales); }
public Dictionary <string, object> CellEditing(Dictionary <string, object> jsonResult) { htmlHelper.PopulateData(jsonResult["currentReport"].ToString()); dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), ProductSales.GetSalesData(), null, jsonResult["index"].ToString(), jsonResult["summaryValues"].ToString(), null, jsonResult["valueHeaders"].ToString(), jsonResult["valueSorting"].ToString()); return(dict); }
public Dictionary <string, object> DeferUpdate(Dictionary <string, object> jsonResult) { htmlHelper.PopulateData(jsonResult["currentReport"].ToString()); dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), ProductSales.GetSalesData(), null, null, null, jsonResult["sortedHeaders"].ToString(), jsonResult["filterParams"].ToString(), jsonResult["valueSorting"].ToString()); return(dict); }
public Dictionary <string, object> CalculatedField(Dictionary <string, object> jsonResult) { htmlHelper.PopulateData(jsonResult["currentReport"].ToString()); dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), ProductSales.GetSalesData(), null, null, jsonResult["headerTag"].ToString(), null, null, jsonResult["valueSorting"].ToString()); return(dict); }