public static List <ChartData> GetDBChartData(string daystr)
{
var qdata = new List <ChartData>();
using (VIDEAEntities dc = new VIDEAEntities())
{
var qresults = from c in dc.TVMazeShows
where c.day == daystr && c.network.Length < 4
group c.rating by c.network into g
select new
{
Network = g.Key,
MaxRatings = g.ToList().Max()
};
//var rx = res.ToList(); //GetResults("Tuesday");
foreach (var row in qresults)
{
qdata.Add(new ChartData(row.Network, (int)row.MaxRatings, "Highest Rated TV Shows by Networks", "Sunday"));
}
}
return(qdata);
}
public ActionResult TruncateShows()
{
VIDEAEntities dbx = new VIDEAEntities();
dbx.Database.ExecuteSqlCommand("truncate table [VIDEA].[dbo].[TVMazeShows]");
return(RedirectToAction("Index"));
}
public ActionResult ReloadShows()
{
var rezult = getUriData("http://api.tvmaze.com/shows");
List <TVMazeShow> ShowList = new List <TVMazeShow>();
dynamic jsonObj = JsonConvert.DeserializeObject(rezult);
var x = 0;
foreach (var obj in jsonObj)
{
var aTVShow = new TVMazeShow();
x++;
// Filter for several TV Shows only
if (x == 24 || x == 25 || x == 26 || x == 32 || x == 73 || x == 115 || x == 163 || x == 167 || x == 176 || x == 189)
{
continue;
}
if (obj.name != null)
{
aTVShow.id = (int)x; //(int)obj.id;
aTVShow.name = (string)obj.name;
aTVShow.status = (string)obj.status;
aTVShow.runtime = (int)obj.runtime;
aTVShow.premiered = (string)obj.premiered;
aTVShow.day = (string)obj.schedule.days[0];
aTVShow.time = (string)obj.schedule.time;
aTVShow.status = (string)obj.status;
aTVShow.network = (string)obj.network.name;
var tempRating = (string)obj.rating.average;
decimal?tvrating = !string.IsNullOrEmpty(tempRating) ?
decimal.Parse(tempRating.Replace(",", "")) :
(decimal?)null;
aTVShow.rating = tvrating; //(decimal)obj.rating.average;
aTVShow.photo = (string)obj.image.original;
using (var dbc = new VIDEAEntities())
{
dbc.TVMazeShows.Add(aTVShow);
dbc.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
