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