public void Execute(IJobExecutionContext context)
        {
            long   lastUpdate = bd.LastUpDates.First().Lastupdate;
            string addres     = BaseUrl + token + "/getUpdates?offset=" + (lastUpdate + 1);
            string res        = client.DownloadString(addres);
            var    k          = JsonConvert.DeserializeObject <TelegramUpdate>(res);

            //  var kzz = bd.Categorys.ToArray();
            if (!k.ok || k.result.Length == 0)
            {
                return;
            }
            foreach (Result item in k.result)
            {
                lastUpdate = item.update_id;
                //   item.call_back.
                if (item.message != null)
                {
                    SendAnswer(item.message.chat.id, item.message.text);
                }
                if (item.callback_query != null)
                {
                    AnswerIqQuery(item);
                }
            }
            using (UpdateDbContext bd = new UpdateDbContext())
            {
                bd.LastUpDates.First().Lastupdate = lastUpdate;
                bd.SaveChanges();
            }
        }
        string Shop(string shop, out string reply_markup)
        {
            string answer = "Магазин продуктов";

            reply_markup = "";
            Category categories;

            char[]   spl      = { ' ' };
            string[] shops    = shop.Split(spl, StringSplitOptions.RemoveEmptyEntries);
            string   ncat     = shops[0];
            string   nproduct = "q";

            if (shops.Length > 1)
            {
                nproduct = shops[1];
            }
            Product pr = new Product();
            List <InlineKeyboardButton> kb = new List <InlineKeyboardButton>();

            using (UpdateDbContext db = new UpdateDbContext())
            {
                if (shops.Length == 1)
                {
                    var product = db.Products.ToList();
                    categories = db.Categorys.Where(x => x.NameCategory == ncat).First();
                }
                else
                {
                    var product = db.Products.ToList();
                    //categories = db.Categorys.Where(x => x.NameCategory == ncat).First();
                    categories = db.Categorys.Where(x => x.NameCategory == ncat).First();
                    pr         = categories.Products.Where(x => x.NameProduct == nproduct).First();
                }
            }
            InlineKeyboard keyboard = new InlineKeyboard();
            int            i        = 0;

            if (shops.Length == 1)
            {
                foreach (var item in categories.Products)
                {
                    keyboard.AddButton(new InlineKeyboardButton(item.NameProduct, item.Category.NameCategory + " " + item.NameProduct), i++ / 2);
                }
            }
            if (shops.Length > 1)
            {
                foreach (var item in categories.Products)
                {
                    keyboard.AddButton(new InlineKeyboardButton(item.NameProduct, item.Category.NameCategory + " " + item.NameProduct), i++ / 2);
                }
                answer = pr.NameProduct + "    " + pr.Price + "   " + pr.Description;
            }
            AddMainButton(keyboard);
            reply_markup = JsonConvert.SerializeObject(keyboard);


            return(answer);
        }
        private string MainMenu(out string reply_markup)
        {
            List <Category>             categories;
            List <InlineKeyboardButton> kb = new List <InlineKeyboardButton>();

            using (UpdateDbContext db = new UpdateDbContext())
            {
                categories = db.Categorys.ToList();
            }
            InlineKeyboard keyboard = new InlineKeyboard();
            int            i        = 0;

            foreach (var item in categories)
            {
                keyboard.AddButton(new InlineKeyboardButton(item.NameCategory, item.NameCategory), i++ / 2);
            }
            AddMainButton(keyboard);
            reply_markup = JsonConvert.SerializeObject(keyboard);
            return("Все категории магазина");
        }