Exemplo n.º 1
0
        public static async Task <string> ShowRezult(string type, string question, Find.Sh sh)
        {
            DataBase dataBase = new DataBase();

            string content = "";

            try
            {
                question.Replace(' ', '+');

                string url = $"https://api.themoviedb.org/3/search/{type}?api_key={Find.Search.API_key}&query={question}";
                if ((content = dataBase.Search(question, type, sh)) == null)
                {
                    if (type == "movie")
                    {
                        Find.AnswerMovie rez = await Find.Search.GetRezaltAsync <Find.AnswerMovie>(url);

                        Find.Genres genres = await Find.Search.GetRezaltAsync <Find.Genres>($"https://api.themoviedb.org/3/genre/movie/list?api_key={Find.Search.API_key}&language=en-US");

                        dataBase.Insert($"insert into Search_History(Text_Of_Search,Type,User_search) values('{question}','{type}','vlad')");

                        for (int o = 0; o < rez.results.Count; o++)
                        {
                            string genrez = "";
                            for (int q = 0; q < rez.results[o].genre_ids.Length; q++)
                            {
                                genrez += rez.results[o].genre_ids[q].ToString();
                                genrez += ",";
                            }
                            dataBase.Insert($"Insert into Content (Genre_ids,Popularity,Vote_count,Backdrop_path,Original_language,Vote_average,Overview," +
                                            $"Poster_path,Adult,Release_date,Original_title,Title,Video) values" +
                                            $"('{genrez}',{rez.results[o].popularity.ToString(CultureInfo.CreateSpecificCulture("en-US"))},{rez.results[o].vote_count},'{rez.results[o].backdrop_path}','{rez.results[o].original_language}'" +
                                            $",{rez.results[o].vote_average.ToString(CultureInfo.CreateSpecificCulture("en-US"))}, '{rez.results[o].overview.Replace("’", "").Replace("'", "")}','{rez.results[o].poster_path}'," +
                                            $"{(rez.results[o].adult ? 1 : 0)},'{rez.results[o].release_date}','{rez.results[o].original_title.Replace("’", "").Replace("'", "")}','{rez.results[o].title.Replace("’", "").Replace("'", "")}',{(rez.results[o].video ? 1 : 0)})");
                            dataBase.Insert($"insert into Content_Answer(Search_Id,Content_Id) values((select top(1) Id from Search_History where Text_Of_Search='{question}' and Type='{type}'),(select top(1) Id from Content where Original_title='{rez.results[o].original_title}'))");
                        }

                        for (int g = 0; g < genres.genres.Count; g++)
                        {
                            try
                            {
                                dataBase.Insert($"Insert into Genres(Id,Name) values('{genres.genres[g].id}','{genres.genres[g].name}')");
                            }
                            catch (Exception) { }
                        }
                        content = sh(rez, null, genres);
                    }
                    else
                    {
                        Find.AnswerTV reza = await Find.Search.GetRezaltAsync <Find.AnswerTV>(url);

                        Find.Genres genress = await Find.Search.GetRezaltAsync <Find.Genres>($"https://api.themoviedb.org/3/genre/tv/list?api_key={Find.Search.API_key}&language=en-US");

                        dataBase.Insert($"insert into Search_History(Text_Of_Search,Type,User_search) values('{question}','{type}','vlad')");

                        for (int o = 0; o < reza.results.Count; o++)
                        {
                            string genrez = "", countries = "";
                            for (int q = 0; q < reza.results[o].genre_ids.Length; q++)
                            {
                                genrez += reza.results[o].genre_ids[q].ToString();
                                genrez += ",";
                            }
                            for (int q = 0; q < reza.results[o].origin_country.Length; q++)
                            {
                                countries += reza.results[o].origin_country[q].ToString();
                                countries += ",";
                            }
                            dataBase.Insert($"Insert into Content(Genre_ids,Popularity,Vote_count,Backdrop_path,Original_language,Vote_average," +
                                            $"Overview,Poster_path,Original_name,Name,Origin_country,First_air_date)" +
                                            $" values('{genrez}',{reza.results[o].popularity.ToString(CultureInfo.CreateSpecificCulture("en-US"))}," +
                                            $"{reza.results[o].vote_count},'{reza.results[o].backdrop_path}','{reza.results[o].original_language}'," +
                                            $"{reza.results[o].vote_average.ToString(CultureInfo.CreateSpecificCulture("en-US"))}," +
                                            $"'{reza.results[o].overview.Replace("’", "").Replace("'", "")}','{reza.results[o].poster_path}','{reza.results[o].original_name.Replace("’", "").Replace("'", "")}','{reza.results[o].name.Replace("’", "").Replace("'", "")}','{countries}','{reza.results[o].first_air_date}')");

                            dataBase.Insert($"insert into Content_Answer(Search_Id,Content_Id) values((select top(1) Id from Search_History where Text_Of_Search='{question}' and Type='{type}'),(select top(1) Id from Content where Original_name='{reza.results[o].original_name}'))");
                        }
                        for (int g = 0; g < genress.genres.Count; g++)
                        {
                            try
                            {
                                dataBase.Insert($"Insert into Genres(Id,Name) values('{genress.genres[g].id}','{genress.genres[g].name}')");
                            }
                            catch (Exception) { }
                        }
                        content = sh(null, reza, genress);
                    }
                }
            }
            catch (Exception e)
            {
                IKernel kernel = new StandardKernel();
                ModuleLoader.Load(kernel, LoggerType.File);
                DIExperiment dI = kernel.Get <DIExperiment>();
                dI.UseLogger(e.Message);
            }
            return(content);
        }
Exemplo n.º 2
0
        public string Search(string question, string type, Find.Sh sh)
        {
            string    rezalts    = null;
            DataTable dataTable  = new DataTable("dataBase");
            DataTable dataTable1 = new DataTable("dataBase");

            SqlCommand sqlCommand = sqlConnection.CreateCommand();

            sqlCommand.CommandText = $"select Id,Genre_ids,Popularity,Vote_count,Backdrop_path,Original_language,Vote_average,Overview," +
                                     $"Poster_path,Adult,Release_date,Original_title,Title,Video,Original_name,Name,Origin_country,First_air_date from Content where Id=any(select Content_Id from Content_Answer where Search_Id=(select top(1) Id from Search_History where Type='{type}' and Text_Of_Search='{question}'))";
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);

            sqlDataAdapter.Fill(dataTable);

            SqlCommand sqlCommand1 = sqlConnection.CreateCommand();

            sqlCommand1.CommandText = $"select * from Genres";
            SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sqlCommand1);

            sqlDataAdapter1.Fill(dataTable1);



            if (type == "movie")
            {
                Find.AnswerMovie rez = new Find.AnswerMovie();
                rez.results = new List <Find.Movie>();
                Find.Genres genress = new Find.Genres();
                genress.genres = new List <Find.Genres.genre>();
                for (int u = 0; u < dataTable1.Rows.Count; u++)
                {
                    Find.Genres.genre genre = new Find.Genres.genre();
                    genre.id   = (int)dataTable1.Rows[u].ItemArray[0];
                    genre.name = (string)dataTable1.Rows[u].ItemArray[1];
                    genress.genres.Add(genre);
                }
                for (int r = 0; r < dataTable.Rows.Count; r++)
                {
                    rez.results.Add(new Find.Movie());
                    rez.results[r].adult             = (bool)dataTable.Rows[r].ItemArray[9];
                    rez.results[r].video             = (bool)dataTable.Rows[r].ItemArray[13];
                    rez.results[r].vote_average      = (float)(double)dataTable.Rows[r].ItemArray[6];
                    rez.results[r].vote_count        = (int)dataTable.Rows[r].ItemArray[3];
                    rez.results[r].title             = (string)dataTable.Rows[r].ItemArray[12];
                    rez.results[r].release_date      = (string)dataTable.Rows[r].ItemArray[10];
                    rez.results[r].poster_path       = (string)dataTable.Rows[r].ItemArray[8];
                    rez.results[r].popularity        = (float)(double)dataTable.Rows[r].ItemArray[2];
                    rez.results[r].overview          = (string)dataTable.Rows[r].ItemArray[7];
                    rez.results[r].original_title    = (string)dataTable.Rows[r].ItemArray[11];
                    rez.results[r].original_language = (string)dataTable.Rows[r].ItemArray[5];
                    rez.results[r].id            = (int)dataTable.Rows[r].ItemArray[0];
                    rez.results[r].backdrop_path = (string)dataTable.Rows[r].ItemArray[4];

                    string     str = "";
                    int        e   = 0;
                    List <int> vs  = new List <int>();
                    for (int i = 0; i < dataTable.Rows[r].ItemArray[1].ToString().Length; i++)
                    {
                        while (i != dataTable.Rows[r].ItemArray[1].ToString().Length)
                        {
                            if (dataTable.Rows[r].ItemArray[1].ToString()[i] == ',')
                            {
                                break;
                            }
                            str += dataTable.Rows[r].ItemArray[1].ToString()[i];
                            i++;
                        }
                        vs.Add(Convert.ToInt32(str));
                        str = "";
                    }
                    rez.results[r].genre_ids = vs.ToArray();
                }
                rez.total_results = rez.results.Count;
                if (dataTable.Rows.Count != 0)
                {
                    rezalts = sh(rez, null, genress);
                }
            }
            else
            {
                Find.AnswerTV rez = new Find.AnswerTV();
                rez.results = new List <Find.TV>();
                Find.Genres genress = new Find.Genres();
                genress.genres = new List <Find.Genres.genre>();
                for (int u = 0; u < dataTable1.Rows.Count; u++)
                {
                    Find.Genres.genre genre = new Find.Genres.genre();
                    genre.id   = (int)dataTable1.Rows[u].ItemArray[0];
                    genre.name = (string)dataTable1.Rows[u].ItemArray[1];
                    genress.genres.Add(genre);
                }
                for (int r = 0; r < dataTable.Rows.Count; r++)
                {
                    rez.results.Add(new Find.TV());
                    rez.results[r].original_name     = (string)dataTable.Rows[r].ItemArray[14];
                    rez.results[r].name              = (string)dataTable.Rows[r].ItemArray[15];
                    rez.results[r].vote_average      = (float)(double)dataTable.Rows[r].ItemArray[6];
                    rez.results[r].vote_count        = (int)dataTable.Rows[r].ItemArray[3];
                    rez.results[r].first_air_date    = (string)dataTable.Rows[r].ItemArray[17];
                    rez.results[r].poster_path       = (string)dataTable.Rows[r].ItemArray[8];
                    rez.results[r].popularity        = (float)(double)dataTable.Rows[r].ItemArray[2];
                    rez.results[r].overview          = (string)dataTable.Rows[r].ItemArray[7];
                    rez.results[r].original_language = (string)dataTable.Rows[r].ItemArray[5];
                    rez.results[r].id            = (int)dataTable.Rows[r].ItemArray[0];
                    rez.results[r].backdrop_path = (string)dataTable.Rows[r].ItemArray[4];

                    string        str = "", str1 = "";
                    int           e   = 0;
                    List <int>    vs  = new List <int>();
                    List <string> vs1 = new List <string>();
                    for (int i = 0; i < dataTable.Rows[r].ItemArray[1].ToString().Length; i++)
                    {
                        while (i != dataTable.Rows[r].ItemArray[1].ToString().Length)
                        {
                            if (dataTable.Rows[r].ItemArray[1].ToString()[i] == ',')
                            {
                                break;
                            }
                            str += dataTable.Rows[r].ItemArray[1].ToString()[i];
                            i++;
                        }
                        vs.Add(Convert.ToInt32(str));
                        str = "";
                    }
                    rez.results[r].genre_ids = vs.ToArray();

                    for (int i = 0; i < dataTable.Rows[r].ItemArray[16].ToString().Length; i++)
                    {
                        while (i != dataTable.Rows[r].ItemArray[16].ToString().Length)
                        {
                            if (dataTable.Rows[r].ItemArray[16].ToString()[i] == ',')
                            {
                                break;
                            }
                            str1 += dataTable.Rows[r].ItemArray[16].ToString()[i];
                            i++;
                        }
                        vs1.Add(str1);

                        str1 = "";
                    }

                    rez.results[r].origin_country = vs1.ToArray();
                }
                rez.total_results = rez.results.Count;
                if (dataTable.Rows.Count != 0)
                {
                    rezalts = sh(null, rez, genress);
                }
            }
            return(rezalts);
        }