public static string method() { using (Code_DBDataContext db = new Code_DBDataContext()) { var query = db.mainTables.GroupBy(x => x.C_HOUR).OrderBy(x => x.Key).Select( g => new { g.Key, Count = g.Count() }).ToList(); string result =""; //string r=""; result +=query[0].Count + ","; result += query[11].Count + ",";//("2:00")).Count().ToString() + ","; result += query[16].Count + ",";//("3:00")).Count().ToString() + ","; result += query[17].Count + ",";//("4:00")).Count().ToString() + ","; result += query[18].Count + ",";//("5:00")).Count().ToString() + ","; result += query[19].Count + ",";//("6:00")).Count().ToString() + ","; result += query[20].Count + ",";//("7:00")).Count().ToString() + ","; result += query[21].Count + ",";//("8:00")).Count().ToString() + ","; result += query[22].Count + ",";//("9:00")).Count().ToString() + ","; result += query[1].Count + ",";//("10:00")).Count().ToString() + ","; result += query[2].Count + ",";//("11:00")).Count().ToString() + ","; result += query[3].Count + ",";//("12:00")).Count().ToString() + ","; result += query[4].Count + ",";//("13:00")).Count().ToString() + ","; result += query[5].Count + ",";//("14:00")).Count().ToString() + ","; result += query[6].Count + ",";//("15:00")).Count().ToString() + ","; result += query[7].Count + ",";//("16:00")).Count().ToString() + ","; result += query[8].Count + ",";//("17:00")).Count().ToString() + ","; result += query[9].Count + ",";//("18:00")).Count().ToString() + ","; result += query[10].Count + ",";//("19:00")).Count().ToString() + ","; result += query[12].Count + ",";//("20:00")).Count().ToString() + ","; result += query[13].Count + ",";//("21:00")).Count().ToString() + ","; result += query[14].Count + ",";//("22:00")).Count().ToString() + ","; result += query[15].Count + ",";//("23:00")).Count().ToString() + ","; result += query[23].Count;//("Midnight")).Count().ToString(); result = result.TrimEnd(','); return result; } }
public static string method() { using (Code_DBDataContext db = new Code_DBDataContext()) { var query = db.mainTables.GroupBy(x => x.C_HOUR).OrderBy(x => x.Key).Select(g => new { g.Key, Count = g.Count() }).ToList(); string result = ""; //string r=""; result += query[0].Count + ","; result += query[11].Count + ","; //("2:00")).Count().ToString() + ","; result += query[16].Count + ","; //("3:00")).Count().ToString() + ","; result += query[17].Count + ","; //("4:00")).Count().ToString() + ","; result += query[18].Count + ","; //("5:00")).Count().ToString() + ","; result += query[19].Count + ","; //("6:00")).Count().ToString() + ","; result += query[20].Count + ","; //("7:00")).Count().ToString() + ","; result += query[21].Count + ","; //("8:00")).Count().ToString() + ","; result += query[22].Count + ","; //("9:00")).Count().ToString() + ","; result += query[1].Count + ","; //("10:00")).Count().ToString() + ","; result += query[2].Count + ","; //("11:00")).Count().ToString() + ","; result += query[3].Count + ","; //("12:00")).Count().ToString() + ","; result += query[4].Count + ","; //("13:00")).Count().ToString() + ","; result += query[5].Count + ","; //("14:00")).Count().ToString() + ","; result += query[6].Count + ","; //("15:00")).Count().ToString() + ","; result += query[7].Count + ","; //("16:00")).Count().ToString() + ","; result += query[8].Count + ","; //("17:00")).Count().ToString() + ","; result += query[9].Count + ","; //("18:00")).Count().ToString() + ","; result += query[10].Count + ","; //("19:00")).Count().ToString() + ","; result += query[12].Count + ","; //("20:00")).Count().ToString() + ","; result += query[13].Count + ","; //("21:00")).Count().ToString() + ","; result += query[14].Count + ","; //("22:00")).Count().ToString() + ","; result += query[15].Count + ","; //("23:00")).Count().ToString() + ","; result += query[23].Count; //("Midnight")).Count().ToString(); result = result.TrimEnd(','); return(result); } }
public static string getGraphData() { Code_DBDataContext db = new Code_DBDataContext(); var QueryResultNoInjuryPosition = db.getNoInjuryDataForPsition(); var QueryResultInjuryPosition = db.getInjuryDataForPsition(); var QueryResultFatalityPosition = db.getFatalityDataForPsition(); Dictionary <string, List <customDataType> > dicObject = new Dictionary <string, List <customDataType> >(); dicObject = parseNoInjuryQuery(dicObject, QueryResultNoInjuryPosition); dicObject = parseInjuryQuery(dicObject, QueryResultInjuryPosition); dicObject = parseFatalitiesQuery(dicObject, QueryResultFatalityPosition); string series1Data = ""; string series2Data = ""; string series3Data = ""; string categories = ""; int count = 0; foreach (string dictKey in dicObject.Keys) { if (categories == "") { categories += dictKey; } else { categories += "," + dictKey; } foreach (customDataType instance in dicObject[dictKey]) { if (instance.MyPropertyType.Equals("No Injury")) { if (series1Data == "") { series1Data += instance.MyPropertyTypeTotal.ToString(); } else { series1Data += "," + instance.MyPropertyTypeTotal.ToString(); } } else if (instance.MyPropertyType.Equals("Injury")) { if (series2Data == "") { series2Data += instance.MyPropertyTypeTotal.ToString(); } else { series2Data += "," + instance.MyPropertyTypeTotal.ToString(); } } else if (instance.MyPropertyType.Equals("Fatalities")) { if (series3Data == "") { series3Data += instance.MyPropertyTypeTotal.ToString(); } else { series3Data += "," + instance.MyPropertyTypeTotal.ToString(); } } } count++; } return(categories + ";" + series1Data + ";" + series2Data + ";" + series3Data); }
public static string getGraphData() { Code_DBDataContext db = new Code_DBDataContext(); var QueryResultNoInjuryPosition = db.getNoInjuryDataForPsition(); var QueryResultInjuryPosition = db.getInjuryDataForPsition(); var QueryResultFatalityPosition = db.getFatalityDataForPsition(); Dictionary<string, List<customDataType>> dicObject = new Dictionary<string, List<customDataType>>(); dicObject = parseNoInjuryQuery(dicObject, QueryResultNoInjuryPosition); dicObject = parseInjuryQuery(dicObject, QueryResultInjuryPosition); dicObject = parseFatalitiesQuery(dicObject, QueryResultFatalityPosition); string series1Data = ""; string series2Data = ""; string series3Data = ""; string categories = ""; int count = 0; foreach (string dictKey in dicObject.Keys) { if (categories == "") { categories += dictKey; } else { categories += "," + dictKey ; } foreach (customDataType instance in dicObject[dictKey]) { if (instance.MyPropertyType.Equals("No Injury")) { if (series1Data == "") { series1Data += instance.MyPropertyTypeTotal.ToString(); } else { series1Data += "," + instance.MyPropertyTypeTotal.ToString(); } } else if (instance.MyPropertyType.Equals("Injury")) { if (series2Data == "") { series2Data += instance.MyPropertyTypeTotal.ToString(); } else { series2Data += "," + instance.MyPropertyTypeTotal.ToString(); } } else if (instance.MyPropertyType.Equals("Fatalities")) { if (series3Data == "") { series3Data += instance.MyPropertyTypeTotal.ToString(); } else { series3Data += "," + instance.MyPropertyTypeTotal.ToString(); } } } count++; } return (categories + ";" + series1Data+";"+series2Data+";"+series3Data); }