public override void Execute(Chat chatId, string message)
{
//waiting for message
if (message == null)
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Now write some countries, separated by column.");
return;
}
List <string> countries = FilmBot.SplitRowByColumn(new List <string>(), FilmBot.RemoveWhitespace(message), 0);
countries = FilmBot.MakeProperStringWithUpperCase(countries);
string query2 = "select distinct movie_name from big_kino_data where movie_country = '";
bool flag = false;
foreach (var country in countries)
{
if (flag)
{
query2 += " and movie_country = '";
}
query2 += country.Trim() + "'";
flag = true;
}
//add random
query2 += " order by RANDOM() limit 10";
var filmsList1 = FilmBot.databaseWorker.LoadData(query2);
if (filmsList1 != null)
{
string text = $"List of films: {Environment.NewLine}";
foreach (var s in filmsList1)
{
text += s + Environment.NewLine;
}
FilmBot.filmBot.SendTextMessageAsync(chatId, text: text);
}
else
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Some error happened during the request process :c");
}
}
public override void Execute(Chat chatId, string message)
{
//waiting for message
if (message == null)
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Now write some prefered actor or actors, separated by column. Russian is case sensitive.");
return;
}
List <string> actors = FilmBot.SplitRowByColumn(new List <string>(), message, 0);
List <int> actorsId = new List <int>();
if (FilmBot.dataContext != null)
{
for (int i = 0; i < actors.Count; i++)
{
string actor = actors[i].ToLower().Trim();
foreach (var y in FilmBot.dataContext.Persons)
{
if (actor == y.Name.ToLower())
{
actorsId.Add(y.Id);
break;
}
}
}
}
//if found actors in database
if (actorsId.Count != 0)
{
List <string> filmsList = new List <string>();
string query = "with t0 as ";
string query1 = "select Title from Movies where Id in (select m0 from t0 ";
string column = ",";
bool isColumn = false;
for (int i = 0; i < actorsId.Count; i++)
{
if (isColumn)
{
query += column + $"t{i} as ";
query1 += $"inner join t{i} on m{i - 1} = m{i} ";
}
query += $"(select Movie_Id 'm{i}' from PersonMovies where Person_Id = {actorsId[i]})";
isColumn = true;
}
query += query1 + ")";
List <string> movies = FilmBot.dataContext.Database.SqlQuery <string>(query).ToList();
string text1 = $"List of films: {Environment.NewLine}";
for (int j = 0; j < 10 && j < movies.ToList().Count(); j++)
{
text1 += movies.ToList()[j] + Environment.NewLine;
}
FilmBot.filmBot.SendTextMessageAsync(chatId, text: text1);
}
//check in other database
else
{
string query = "select distinct movie_name from kino_data where ";
bool isAnd = false;
for (int i = 0; i < 2 && i < actors.Count; i++)
{
if (isAnd)
{
query += " and ";
}
isAnd = true;
query += $"movie_actor{i + 1} = '{actors[i].Trim()}' ";
}
query += " order by RANDOM() limit 10";
var filmsList = FilmBot.databaseWorker.LoadData(query);
if (filmsList != null)
{
string text = $"List of films: {Environment.NewLine}";
foreach (var s in filmsList)
{
text += s + Environment.NewLine;
}
if (filmsList.Count == 0)
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Oops, can't find such actor :c");
}
else
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: text);
}
}
else
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Some error happened during the request process :c");
}
}
}
public override void Execute(Chat chatId, string message)
{
//waiting for message
if (message == null)
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Now write some prefered genre or genres, separated by column.");
return;
}
List <string> genres = FilmBot.SplitRowByColumn(new List <string>(), FilmBot.RemoveWhitespace(message), 0);
List <int> genresId = new List <int>();
for (int i = 0; i < genres.Count; i++)
{
foreach (var y in FilmBot.dataContext.Genres)
{
if (genres[i].ToLower() == y.Name.ToLower())
{
genresId.Add(y.Id);
}
}
}
if (genresId.Count != 0)
{
List <string> filmsList = new List <string>();
string query = "with t0 as ";
string query1 = "select Title from Movies where Id in (select m0 from t0 ";
string column = ",";
bool isColumn = false;
for (int i = 0; i < genresId.Count; i++)
{
if (isColumn)
{
query += column + $"t{i} as ";
query1 += $"inner join t{i} on m{i - 1} = m{i} ";
}
query += $"(select Movie_Id 'm{i}' from MovieGenres where Genre_Id = {genresId[i]})";
isColumn = true;
}
query += query1 + ")";
List <string> movies = FilmBot.dataContext.Database.SqlQuery <string>(query).ToList();
string text1 = $"List of films: {Environment.NewLine}";
for (int j = 0; j < 10 && j < movies.ToList().Count(); j++)
{
text1 += movies.ToList()[j] + Environment.NewLine;
}
FilmBot.filmBot.SendTextMessageAsync(chatId, text1);
}
else
{
string query = "select distinct movie_name from kino_data where ";
bool isAnd = false;
for (int i = 0; i < genres.Count; i++)
{
if (isAnd)
{
query += " and ";
}
query += $"movie_genres like '%{genres[i].ToLower()}%'";
isAnd = true;
}
query += " order by RANDOM() limit 10";
var filmsList = FilmBot.databaseWorker.LoadData(query);
if (filmsList != null)
{
string text = $"List of films: {Environment.NewLine}";
for (int i = 0; i < filmsList.Count; i++)
{
text += filmsList[i] + Environment.NewLine;
}
if (filmsList.Count == 0)
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Oops, can't find any films :c");
}
else
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: text);
}
}
else
{
FilmBot.filmBot.SendTextMessageAsync(chatId, text: "Some error happened during the request process :c");
}
}
}
