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);
}
