/*-------------------------------------------------------------------EDIT UPDATE DELETE--------------------------------*/
public void btnSubmit_Click_one(Object Src, EventArgs E)
{
get_connection();
try
{
connection.Open();
command = new SqlCommand("SELECT * FROM content", connection);
reader = command.ExecuteReader();
MovieResults.DataSource = reader;
MovieResults.DataBind();
reader.Close();
}
catch (Exception err)
{
// Handle an error by displaying the information.
lblInfo.Text = "Error reading the database. ";
lblInfo.Text += err.Message;
}
finally
{
// Either way, make sure the connection is properly closed.
// (Even if the connection wasn't opened successfully,
// calling Close() won't cause an error.)
connection.Close();
lblInfo.Text += "<br /><b>Now Connection Is:</b> ";
lblInfo.Text += connection.State.ToString();
}
}
public void btnSubmit_update_record(Object Src, GridViewUpdateEventArgs e)
{
get_connection();
try
{
int id = int.Parse(MovieResults.DataKeys[e.RowIndex].Value.ToString());
connection.Open();
command = new SqlCommand("UPDATE content SET MovieTitle=@MovieTitle, MovieDescription=@MovieDescription WHERE MovieID=@MovieID", connection);
command.Parameters.AddWithValue("MovieID", SqlDbType.Int).Value = id;
command.Parameters.AddWithValue("@MovieTitle",
((TextBox)MovieResults.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString());
command.Parameters.AddWithValue("@MovieDescription",
((TextBox)MovieResults.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString());
command.ExecuteNonQuery();
MovieResults.DataBind();
}
catch (Exception err)
{
lblInfo.Text = "Error reading the database. ";
lblInfo.Text += err.Message;
}
finally
{
connection.Close();
lblInfo.Text += "<br /><b>Update was successfull</b> ";
lblInfo.Text += connection.State.ToString();
}
}
public async Task <IList <Result> > GetSearchAsync(string query, int pageIndex, int pageSize)
{
//Fazendo um GET no serviço
string sURL = Settings.ApiUrl + "/search/movie?api_key=" + Settings.ApiKey + "&language=" + Settings.Language + "&query=" + query + "&include_adult=false&page=" + pageIndex + "";
var uri = new Uri(string.Format(sURL));
//Classe para deserializar o retorno
var resultMovies = new MovieResults();
try
{
var responsepaci = await client.GetAsync(uri);
//verificando se o status code é OK
if (responsepaci.IsSuccessStatusCode)
{
//pegando o retorno de lendo em async
var content = responsepaci.Content.ReadAsStringAsync().Result;
//deserializando o conteudo para a classe result
resultMovies = JsonConvert.DeserializeObject <MovieResults>(content);
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(resultMovies.results);
}
private void SetMovieData(MovieResults data)
{
if (data is not null)
{
Results = data.Results;
Page = data.Page;
TotalPages = data.Total_Pages;
TotalResults = data.Total_Results;
}
}
public async Task <MovieResults> getUpcommingMovies(int page)
{
moviesRoutes = returnRepositoryConfiguration();
try
{
var result = await moviesRoutes.GetUpcomingMovies(page, Config.Apikey);
return(result);
}
catch (Exception ex)
{
var result = new MovieResults();
result.statusCode = 500;
result.statusMessage = $"Aconteceu um erro com a sua solicitação: {ex.Message}";
return(result);
}
}
/*-----------------------------------------------------------------SEARCH----------------------------*/
protected void Search_func(Object src, EventArgs e)
{
get_connection();
connection.Open();
command = new SqlCommand("SELECT * FROM Content", connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
MovieResults.Visible = true;
}
MovieResults.DataSource = reader;
MovieResults.DataBind();
reader.Close();
}
public async Task <MovieResults> SearchMovies(int page, string query)
{
moviesRoutes = returnConfigurationService();
try
{
var result = await moviesRoutes.SearchMovies(page, query, Constantes.Apikey);
return(result);
}
catch (Exception ex)
{
var result = new MovieResults();
result.statusCode = 500;
result.statusMessage = $"Aconteceu um erro com a sua solicitação: {ex.Message}";
return(result);
}
}
public IEnumerator FindMovie(string urlName, System.Action <MovieData> returnMethod)
{
bool looping = true;
//Wait until the request limit is not reached.
while (looping)
{
if (numCalls >= 40)
{
yield return(null);
}
else
{
numCalls++;
callsCounting = true;
break;
}
}
//Request movie data from TMDB
WWW www = new WWW("https://api.themoviedb.org/3/search/movie?api_key=e2ffb845e5d5fca810eaf5054914f41b&language=en-US&query=" + urlName + "&page=1&include_adult=false", null, headers);
//Wait for download to finish.
while (!www.isDone)
{
yield return(null);
}
//Convert json file to movie data
var json = www.text;
MovieResults results = JsonConvert.DeserializeObject <MovieResults>(json);
MovieData[] j = results.results;
if (j == null)
{
Debug.Log("Nothing here");
}
returnMethod(j[0]);
}
public void GetLatestMovie()
{
var url = "https://api.themoviedb.org/3/movie/upcoming?api_key=" + Config.ApiKey + "&language=en-US";
var syncClient = new WebClient();
string content = syncClient.DownloadString(url);
MovieResults mr = new MovieResults();
// Create the Json serializer and parse the movie results response
mr = JSONHelper.Deserialise <MovieResults>(content);
var movieData = mr.results.FirstOrDefault(); //to get the first item of the results and parse
m = new Movie();
m.id = movieData.id;
m.overview = movieData.overview;
m.title = movieData.title;
m.poster_path = movieData.poster_path;
if (MovieDbOps.checkValueExists(movieData.id))
{
System.Diagnostics.Debug.WriteLine("Already Posted on Fb");
}
else
{
MovieDbOps.UploadDbContent(m.id, m.title);
System.Diagnostics.Debug.WriteLine("Data saved in db");
var videoUrl = "https://api.themoviedb.org/3/movie/" + m.id + "/videos?api_key=" + Config.ApiKey + "&language=en-US";
string videoContent = syncClient.DownloadString(videoUrl);
VideoResults vr = new VideoResults();
// Create the Json serializer and parse the videourl response
vr = JSONHelper.Deserialise <VideoResults>(videoContent);
var videoData = vr.results.FirstOrDefault();
string videoKey = "https://www.youtube.com/watch?v=" + videoData.key.ToString();
PostOnFb(m, videoKey);
}
}