public IActionResult SaveVIPData() { //After running for the first time comment this part //Start comment here HttpClient httpClient; httpClient = new HttpClient(); httpClient.DefaultRequestHeaders.Accept.Clear(); //httpClient.DefaultRequestHeaders.Add("X-Api-Key", API_KEY); httpClient.DefaultRequestHeaders.Accept.Add( new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); APIHandler api = new APIHandler(); for (int i = 2000; i < 2020; i++) { List <ResponseVip> responses = api.GetData <List <ResponseVip> >("vip", i.ToString(), httpClient); foreach (ResponseVip response in responses) { dbContext.ResponseVips.Add(response); } } dbContext.SaveChanges(); //End comment here IOrderedEnumerable <ResponseVip> rows = dbContext.ResponseVips.ToList().OrderBy(r => r.time_slot_date); return(new EmptyResult()); }
public IActionResult Catdata() { APIHandler webHandler = new APIHandler(); List <Result> viewcatsdata = webHandler.GetData(); return(View(viewcatsdata)); }
public IActionResult Products() { APIHandler webHandler = new APIHandler(); Rootobject results = webHandler.GetData(); return(View(results)); }
public IActionResult Parks() { APIHandler webHandler = new APIHandler(); Parks results = webHandler.GetData(); return(View(results)); }
public IActionResult Art() { APIHandler webHandler = new APIHandler(); Rootobject artcol = webHandler.GetData(); return(View(artcol)); }
public IActionResult Information() { APIHandler webHandler = new APIHandler(); var a = webHandler.GetData(); ViewData["Message"] = "Information"; return(View()); }
public HomeController(ILogger <HomeController> logger, ApplicationDbContext context, IMapper mapper) { _logger = logger; dbContext = context; _mapper = mapper; APIHandler webHandler = new APIHandler(); var dataList = webHandler.GetData(); LoadData(dataList); }
public static void Initialize(ApplicationDbContext dbContext) { APIHandler webHandler = new APIHandler(); List <RootData> jsonData = webHandler.GetData(); List <CrimeIncidents> crimeIncidents1 = new List <CrimeIncidents>(); List <CMAgency> Agency = new List <CMAgency>(); foreach (RootData data in jsonData) { var validIds = dbContext.crimeIncident.Select(t => t.objectid).ToList(); if (!validIds.Contains(data.objectid)) { CrimeIncidents incident = new CrimeIncidents(); CMAgency agency = new CMAgency(); agency.kilonbr = data.kilonbr; agency.cmid = data.cmid; agency.cmagency = data.cmagency; incident.objectid = data.objectid; incident.cmid = data.cmid; incident.Agency = agency; incident.date = data.date; incident.blockaddress = data.blockaddress; incident.score = data.score; incident.side = data.side; incident.type = data.type; incident.status = data.status; incident.favorite = 0; agency.crimeIncident = incident; crimeIncidents1.Add(incident); Agency.Add(agency); } } foreach (CrimeIncidents incident in crimeIncidents1) { // crimeIncident.RemoveRange(); dbContext.crimeIncident.Add(incident); dbContext.SaveChanges(); } foreach (CMAgency agency in Agency) { // dbContext.Agency.RemoveRange(); dbContext.Agency.Add(agency); dbContext.SaveChanges(); } dbContext.SaveChanges(); }
public void OnNavigatingTo(NavigationParameters parameters) { Weather = api.GetData(parameters["city"].ToString()); }