public static void UpdateKitchen(Kitchen kitchen) { DataBase.OpenAsync(); SqliteCommand command = new SqliteCommand("UPDATE KITCHENS SET Typeface = :typeface, typetable = :Typetable, LENGHT = :lenght where CHATID=:id", DataBase); command.Parameters.Add("typeface", SqliteType.Text).Value = kitchen.TypeFace; command.Parameters.Add("Typetable", SqliteType.Text).Value = kitchen.TypeTable; command.Parameters.Add("lenght", SqliteType.Integer).Value = kitchen.Lenght; command.Parameters.Add("id", SqliteType.Text).Value = kitchen.ChatId; try { command.ExecuteNonQuery(); DataBase.CloseAsync(); } catch (Exception ex) { Bot.MyLogger(ex.Message); Bot.MyLogger(ex.StackTrace); DataBase.CloseAsync(); } }
public static Kitchen GetKitchen(Client client) { Kitchen kit = new Kitchen(); DataBase.OpenAsync(); //SELECT EXISTS(SELECT 1 FROM myTbl WHERE u_tag="tag") SqliteCommand command = new SqliteCommand("SELECT * FROM KITCHENS WHERE CHATID = " + client.ChatId, DataBase); var reader = command.ExecuteReader(); while (reader.Read()) { kit.ChatId = long.Parse(reader.GetValue(0).ToString()); kit.TypeFace = reader.GetValue(1).ToString(); kit.TypeTable = reader.GetValue(2).ToString(); kit.Lenght = int.Parse(reader.GetValue(3).ToString()); } DataBase.CloseAsync(); return(kit); }
public static void AddKitchen(Kitchen kit) { DBHelper.AddKitchen(kit); }