static public Comand getComand(String id) { DataTable dTable = new DataTable(); String sqlQuery; Comand list = null; if (!isOpen) { return(list); } try { sqlQuery = "SELECT * FROM main where id = '" + id + "'"; SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, m_dbConn); adapter.Fill(dTable); if (dTable.Rows.Count > 0) { list = new Comand(dTable.Rows[0].ItemArray[0].ToString(), dTable.Rows[0].ItemArray[1].ToString(), dTable.Rows[0].ItemArray[2].ToString(), dTable.Rows[0].ItemArray[3].ToString(), dTable.Rows[0].ItemArray[4].ToString()); } } catch (SQLiteException ex) { Console.WriteLine("Error: " + ex.Message); } return(list); }
static public void putComand(Comand comand) { if (!isOpen) { return; } try { SQLiteCommand cmd = new SQLiteCommand("insert into main (Name, childID, ParentID, type) values('" + comand.Text + "', '','" + comand.ParentID + "', '" + comand.Type + "')"); cmd.Connection = m_dbConn; cmd.ExecuteNonQuery(); cmd.CommandText = ("update main set childID = childID || " + comand.Id + " || ';' where id = '" + comand.ParentID + "'"); cmd.ExecuteNonQuery(); } catch (SQLiteException ex) { Console.WriteLine("Error: " + ex.Message); } }
static void makeChoice(object sc, Telegram.Bot.Args.CallbackQueryEventArgs ev) { if (data == null) { return; } var message = ev.CallbackQuery.Data; Console.WriteLine(message); var chatID = ev.CallbackQuery.Message.Chat.Id; data = DBClass.getComands(Users[chatID]); try { String[] messArr = message.Split("_"); if (messArr[0] != Users[chatID]) { return; } if (messArr[1] == "back") { Comand t = DBClass.getComand(messArr[0]); Users[chatID] = t.ParentID; showMessage(chatID); } else if (messArr[1] == "helpyes") { workWithHelp(chatID, true); } else if (messArr[1] == "helpno") { Comand t = DBClass.getComand(messArr[0]); Users[chatID] = t.ParentID; showMessage(chatID); } else { Users[chatID] = data[Convert.ToInt32(messArr[1])].Id; showMessage(chatID); } } catch (Exception) { } }