public static object[] GetDataForDualAxesLineAndColumnChart(string stationName, DateTime fromDate, DateTime toDate, string displayMode, string tempParam)
{
SmartCityEntities db = new SmartCityEntities();
switch (tempParam)
{
case "AvgTemp":
return db.fc_DualAxesLineAndColumn(stationName, fromDate, toDate, displayMode).Select(x => x.AvgTemp).ToArray().Cast<object>().ToArray();
case "AvgRainFall":
return db.fc_DualAxesLineAndColumn(stationName, fromDate, toDate, displayMode).Select(x => x.AvgRainFall).ToArray().Cast<object>().ToArray();
default:
return null;
}
}
public static object[] GetMonlyAvgSeriesForAGivenYear(string stationName, int year, string param)
{
SmartCityEntities db = new SmartCityEntities();
switch (param)
{
case "AirPolutionLevel":
return db.Adm_Weather.Where(x => x.Station == stationName && x.WeatherDate.Year == year).Select(x => x.AirPolutionLevel).Take(12).ToArray().Cast<object>().ToArray();
case "MinTemp":
return db.Adm_Weather.Where(x => x.Station == stationName && x.WeatherDate.Year == year).Select(x => x.MinTemp).Take(12).ToArray().Cast<object>().ToArray();
case "MaxTemp":
return db.Adm_Weather.Where(x => x.Station == stationName && x.WeatherDate.Year == year).Select(x => x.MaxTemp).Take(12).ToArray().Cast<object>().ToArray();
case "RainFall":
return db.Adm_Weather.Where(x => x.Station == stationName && x.WeatherDate.Year == year).Select(x => x.RainFall).Take(12).ToArray().Cast<object>().ToArray();
default:
return null;
}
}
public static object[] GetDataForBaseLineChart(string stationName, DateTime fromDate, DateTime toDate, string displayMode, string compareParam)
{
SmartCityEntities db = new SmartCityEntities();
switch (compareParam)
{
case "AirPolutionLevel":
return db.fc_BaseLine(stationName, fromDate, toDate, displayMode).Select(x => x.AirPolutionLevel).ToArray().Cast<object>().ToArray();
case "MinTemp":
return db.fc_BaseLine(stationName, fromDate, toDate, displayMode).Select(x => x.MinTemp).ToArray().Cast<object>().ToArray();
case "MaxTemp":
return db.fc_BaseLine(stationName, fromDate, toDate, displayMode).Select(x => x.MaxTemp).ToArray().Cast<object>().ToArray();
case "RainFall":
return db.fc_BaseLine(stationName, fromDate, toDate, displayMode).Select(x => x.RainFall).ToArray().Cast<object>().ToArray();
default:
return null;
}
}
public void getInputDataToPredictSeries(DateTime date, double[] input, List<double[]> predictHistory, double airPollutionLevel)
{
SmartCityEntities _dbo = new SmartCityEntities();
var tempinput = (from a in _dbo.fc_PreditInput(date, "Kathmandu")
select new WeatherSamples
{
date = a.MeaureDate,
station = a.Station,
airPollutionLevel = a.AirPolutionLevel,
rainfall = a.RainFall,
maxTemp = a.MaxTemp,
minTemp = a.MinTemp
}).ToList();
foreach (double[] predict in predictHistory)
{
tempinput.RemoveAt(0);
tempinput.Add(new WeatherSamples
{
date = tempinput[8].date.AddDays(+1),
station = tempinput[8].station,
airPollutionLevel = airPollutionLevel,
rainfall = predict[2],
maxTemp = predict[1],
minTemp = predict[0]
});
}
for (int i = 0; i < this.inputSize; i++)
{
WeatherSamples sample = (WeatherSamples)tempinput[i];
input[i] = sample.airPollutionLevel;
input[i + this.inputSize] = sample.minTemp;
input[i + this.inputSize * 2] = sample.maxTemp;
input[i + this.inputSize * 3] = sample.rainfall;
}
}
//retutn inputset for prediction.
public void getInputDataToPredict(DateTime date, double[] input)
{
SmartCityEntities _dbo = new SmartCityEntities();
var tempinput = (from a in _dbo.fc_PreditInput(date, "Kathmandu")
select new WeatherSamples
{
date = a.MeaureDate,
station = a.Station,
airPollutionLevel = a.AirPolutionLevel,
rainfall = a.RainFall,
maxTemp = a.MaxTemp,
minTemp = a.MinTemp
}).ToList();
for (int i = 0; i < this.inputSize; i++)
{
WeatherSamples sample = (WeatherSamples)tempinput[i];
input[i] = sample.airPollutionLevel;
input[i + this.inputSize] = sample.minTemp;
input[i + this.inputSize * 2] = sample.maxTemp;
input[i + this.inputSize * 3] = sample.rainfall;
}
}
//Datebase connection to get the past records.
public void load(string station = "Kathmandu")
{
SmartCityEntities _dbo = new SmartCityEntities();
this.samples = (from a in _dbo.Adm_Weather
where a.Station == station
select new WeatherSamples { date = (DateTime)a.WeatherDate, station = a.Station, airPollutionLevel = a.AirPolutionLevel, rainfall = a.RainFall, maxTemp = a.MaxTemp, minTemp = a.MinTemp }).ToList();
}
public static IEnumerable<WeatherResultModel> GetWeathers()
{
SmartCityEntities db = new SmartCityEntities();
return (from c in db.Adm_Weather select new WeatherResultModel
{ WeatherDate=c.WeatherDate, StationName=c.Station,MinTemp=c.MinTemp,MaxTemp=c.MaxTemp,RainFall=c.RainFall}).Take(100);
}
public static Series[] GetSeriesArray(string stationName, DateTime fromDate, DateTime toDate)
{
SmartCityEntities db = new SmartCityEntities();
var rawData = db.sp_GetDataForColLineAndPie(stationName, fromDate, toDate).Select(x => x).ToArray();
string[] measureParam=new string[] {"AirPollution","MinTemp","MaxTemp","RainFall"};
Series[] seriesArray = new Series[rawData.Count()];
for (int i = 0; i < rawData.Count(); i++)
{
sp_GetDataForColLineAndPie_Result tempObj = ((sp_GetDataForColLineAndPie_Result)rawData.GetValue(i));
seriesArray[i] = new Series
{
Type = i<rawData.Count()-1?ChartTypes.Column:ChartTypes.Spline,
Name = tempObj.Station,
Data = new Data(new object[]
{
tempObj.AvgAirPollutionLevel, tempObj.AvgMinTemp, tempObj.AvgMaxTemp, tempObj.AvgRainFall
}
)
};
}
Series[] series = new[]
{
new Series
{
Type = ChartTypes.Column,
Name = "Kathmandu",
Data = new Data(new object[] { 3, 2, 1, 3 })
},
new Series
{
Type = ChartTypes.Column,
Name = "Pokhara",
Data = new Data(new object[] { 2, 3, 5, 7 })
},
new Series
{
Type = ChartTypes.Column,
Name = "Butwal",
Data = new Data(new object[] { 4, 3, 3, 9 })
},
new Series
{
Type = ChartTypes.Column,
Name = "Bhairahawa",
Data = new Data(new object[] { 3, 2.67, 3, 6.33})
}//,
// new Series
//{
// Type = ChartTypes.Spline,
// Name = "Average",
// Data = new Data(new object[] { 3, 2.67, 3, 6.33, 3.33 })
//}//,
//new Series
//{
// Type = ChartTypes.Pie,
// Name = "Total consumption",
// Data = new Data(new[]
// {
// new DotNet.Highcharts.Options.Point
// {
// Name = "Jane",
// Y = 13,
// Color = Color.FromName("Highcharts.getOptions().colors[0]")
// },
// new DotNet.Highcharts.Options.Point
// {
// Name = "John",
// Y = 23,
// Color = Color.FromName("Highcharts.getOptions().colors[1]")
// },
// new DotNet.Highcharts.Options.Point
// {
// Name = "Joe",
// Y = 19,
// Color = Color.FromName("Highcharts.getOptions().colors[2]")
// }
// }
// )
//}
};
return seriesArray;
}
public static IEnumerable<TabularModel> GetTabularReport(string stationName, DateTime fromDate, DateTime toDate, string displayMode, string compareParam = "")
{
SmartCityEntities db = new SmartCityEntities();
switch (compareParam)
{
case "AirPolutionLevel":
var a = (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station=c.Station,
AirPolutionLevel = c.AirPolutionLevel
}
).ToList();
return (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station=c.Station,
AirPolutionLevel = c.AirPolutionLevel
}
).ToList();
case "MinTemp":
return (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station = c.Station,
MinTemp = c.MinTemp
}
).ToList();
case "MaxTemp":
return (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station = c.Station,
MaxTemp = c.MaxTemp
}
).ToList();
case "RainFall":
return (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station = c.Station,
RainFall = c.RainFall
}
).ToList();
default:
return (from c in db.fc_rpt_Tabular(stationName, fromDate, toDate, displayMode)
select new TabularModel
{
WeatherDate = c.MeaureDate,
Station = c.Station,
AirPolutionLevel = c.AirPolutionLevel,
MaxTemp = c.MaxTemp,
MinTemp = c.MinTemp,
RainFall = c.RainFall
}
).ToList();
}
}
