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