public static List <Model.Movies> MoviesRequest(string name) { List <Model.Movies> movie = new List <Model.Movies>(); Model.Movies u = new Model.Movies(); int control = 1; for (int i = 0; i < control; i++) { string action = string.Format("https://jsonmock.hackerrank.com/api/movies/search/?Title={0}&page={1}", name, i); HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Get, action); HttpResponseMessage response = HttpInstance.GetHttpClientInstance().SendAsync(request).Result; JObject dados = JObject.Parse(response.Content.ReadAsStringAsync().Result); control = dados["data"].ToObject <List <Movies> >().Count() > 0 ? control + 1 : i; movie.AddRange(dados["data"].ToObject <List <Model.Movies> >()); } return(movie); }
//添加电影信息 public int InsertMovies(Model.Movies movies) { return(SQLHelp.ExecQuery("insert into [Movies]([MoviesID],[MoviesName],[MoviesNameID],[ReleaseDate],MoviesType],[MoviesLanguage],[MoviesRegion],[MoviesYears],[MoviesDirector],[MoviesActors],[MoviesDesc]) " + "values('" + movies.MoviesID + "','" + movies.MoviesName + "','" + movies.MoviesNameID + "','" + movies.ReleaseDate + "'+'" + movies.MoviesType + "','" + movies.MoviesLanguage + "','" + movies.MoviesRegion + "','" + movies.MoviesDirector + "','" + movies.MoviesActors + "'," + movies.MoviesDesc + "',0,0)")); }