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