Beispiel #1
0
        private static async void BotClient_OnCallbackQuery(object sender, CallbackQueryEventArgs e)
        {
            var callbackQuery = e.CallbackQuery;

            Console.WriteLine("The " + e.CallbackQuery.From.Id + " Select: " + e.CallbackQuery.Data);
            //return;
            var users = DBUser.Users;

            foreach (User u in users)
            {
                if (u.ChatId == e.CallbackQuery.From.Id && u.Topic == "Topic")
                {
                    await BotClient.SendTextMessageAsync(callbackQuery.From.Id, "Please, wait a second)");

                    {
                        u.Topic      = callbackQuery.Data;
                        u.TopicWords = SqlModel.GetWords(callbackQuery.Data);
                    }
                    int nt = random.Next(1, u.TopicWords.Count);
                    u.Output = GetStringList(u.TopicWords[nt].English);
                    await BotClient.SendTextMessageAsync(callbackQuery.From.Id, "Please, translate it)\n" +
                                                         $"{u.TopicWords[nt].Russian}");

                    u.TopicWords.RemoveAt(nt);
                }
            }
            await DBUser.SaveChangesAsync();
        }
Beispiel #2
0
 private static void InsertFromExcel()
 {
     excel = new Excel(path, 1);
     string[] names = excel.GetNames();
     for (int i = 0; i < excel.GetSheet(); i++)
     {
         Console.WriteLine($"I am working on {names[i]}");
         SqlModel.RecreateTable(names[i]);
         excel.SelectWorkSheet(i + 1);
         for (int j = 0; j <= excel.GetColump(); j++)
         {
             SqlModel.InsertTable(names[i], excel.ReadExcelString(j, 2), excel.ReadExcelString(j, 0));
         }
     }
     excel.Close();
 }
Beispiel #3
0
        private static async void BotClient_OnMessage(object sender, MessageEventArgs e)
        {
            if (e.Message.Text == null || e.Message.Type != MessageType.Text)
            {
                return;
            }
            var message = e.Message;

            Console.WriteLine("The " + e.Message.Chat.FirstName + " Write: " + e.Message.Text);
            //return;
            //if (e.Message.Chat.Id == 386219611) { await BotClient.SendTextMessageAsync(message.Chat, $"Not for you, Kristina)"); return; }
            //if (e.Message.Chat.Id == 425901772) { await BotClient.SendTextMessageAsync(message.Chat, $"Пошел нахууй!"); return; }
            var users = DBUser.Users;

            foreach (User u in users)
            {
                if (u.ChatId == message.Chat.Id)
                {
                    here = true;
                }
            }
            if (!here)
            {
                if (!SqlModel.Check("Programming"))
                {
                    InsertFromExcel();
                }
                DBUser.Users.Add(new User {
                    ChatId = message.Chat.Id
                });
                DBUser.SaveChanges();
            }

            users = DBUser.Users;
            foreach (User u in users)
            {
                if (u.ChatId == message.Chat.Id)
                {
                    switch (message.Text)
                    {
                    case "/start":
                        await BotClient.SendTextMessageAsync(message.Chat, $"Hi, {message.Chat.FirstName}\n" +
                                                             $"I was created only for Danil Kravchenko))\n" +
                                                             $"So, if you are not Danil, be happy, you are his friend))\n" +
                                                             $"Write 3 forms like \"first/second/third\"");

                        u.Topic = "Topic";
                        await BotClient.SendTextMessageAsync(message.Chat, $"Select the topic:\n",
                                                             replyMarkup : keyboardTopic);

                        break;

                    case "/insert":
                        await BotClient.SendTextMessageAsync(message.Chat, $"I am working");

                        InsertFromExcel();
                        u.Topic = "Topic";
                        await BotClient.SendTextMessageAsync(message.Chat, $"Select the topic:\n",
                                                             replyMarkup : keyboardTopic);

                        break;

                    case "/topic":
                        u.Topic = "Topic";
                        await BotClient.SendTextMessageAsync(message.Chat, $"Select the topic:\n",
                                                             replyMarkup : keyboardTopic); break;

                    case "/stop":
                        u.Topic      = string.Empty;
                        u.TopicWords = new List <Word>();
                        await BotClient.SendTextMessageAsync(message.Chat, $"Good game\n" +
                                                             $"Hurry back, I`m waiting for you)*");

                        break;

                    default:
                        if (u.Topic == string.Empty)
                        {
                            await BotClient.SendTextMessageAsync(message.Chat, $"I don`t understand you\n" +
                                                                 $"Please, write /topic - to select a topic and start a game");

                            return;
                        }
                        u.Input = GetStringList(message.Text);
                        foreach (string str in u.Input)
                        {
                            if (!u.Output.Contains(str))
                            {
                                await BotClient.SendTextMessageAsync(message.Chat, $"Oh no, you made mistake\n" +
                                                                     $"The right translate is \"{ToStringList(u.Output)}\"");

                                if (u.TopicWords.Count == 0)
                                {
                                    u.Topic = string.Empty;
                                    await BotClient.SendTextMessageAsync(message.Chat, "Good job, you translate all word\n" +
                                                                         "write:\n" +
                                                                         "/topic - to reselect a topic\n" +
                                                                         "/stop - to stop a game"); return;
                                }
                                int n = random.Next(0, u.TopicWords.Count);
                                u.Output = GetStringList(u.TopicWords[n].English);
                                await BotClient.SendTextMessageAsync(message.Chat, "Please, translate it)\n" +
                                                                     $"{u.TopicWords[n].Russian}");

                                u.TopicWords.RemoveAt(n);
                                return;
                            }
                        }
                        await BotClient.SendTextMessageAsync(message.Chat, $"Cool, you are right\n" +
                                                             $"Translate is \"{ToStringList(u.Output)}\"");

                        if (u.TopicWords.Count == 0)
                        {
                            u.Topic = string.Empty;
                            await BotClient.SendTextMessageAsync(message.Chat, "Good job, you translate all words\n" +
                                                                 "write:\n" +
                                                                 "/topic - to reselect a topic\n" +
                                                                 "/stop - to stop a game"); return;
                        }
                        int nt = random.Next(0, u.TopicWords.Count);
                        u.Output = GetStringList(u.TopicWords[nt].English);
                        await BotClient.SendTextMessageAsync(message.Chat, "Please, translate it)\n" +
                                                             $"{u.TopicWords[nt].Russian}");

                        u.TopicWords.RemoveAt(nt);
                        break;
                    }
                }
            }
            await DBUser.SaveChangesAsync();
        }