public override void ExecutePL(RootObject update, VkApi client, SqlConnection Con)
{
var chatId = [email protected]_id;
MessagesSendParams @params = new MessagesSendParams();
try
{
ShowWorld showWorld = new ShowWorld();
showWorld.Execute(update, client, Con);
}
catch (Exception ee)
{
@params.Message = "Ошибка в SelectBackCommand: " + ee.Message;
@params.Attachments = null;
@params.Keyboard = null;
@params.UserId = 59111081;
@params.RandomId = GetRandomId();
client.Messages.SendAsync(@params);
}
}
public override void ExecutePL(RootObject update, VkApi client, SqlConnection Con)
{
MessagesSendParams @params = new MessagesSendParams();
var chatId = [email protected]_id;
var keyboardBuilder = new KeyboardBuilder().Clear();
Regex regex = new Regex("[^0-9]");
try
{
//var ids = new long[] { chatId };
//var user = client.Users.Get(ids);
//TO DO: switch-case role
SqlCommand editUser = new SqlCommand("UPDATE Users SET study = @study, state = @state, tag = @tag, health = @health, " +
"experience = @experience, gold = @gold WHERE chatId = @chatId;", Con);
editUser.Parameters.AddWithValue("@chatId", chatId);
editUser.Parameters.AddWithValue("@study", 1);
editUser.Parameters.AddWithValue("@state", 1);
editUser.Parameters.AddWithValue("@experience", 0);
editUser.Parameters.AddWithValue("@gold", 150);
editUser.Parameters.AddWithValue("@health", 0);
editUser.Parameters.AddWithValue("@tag", "Новичок - Обучение");
editUser.ExecuteNonQuery();
ShowWorld showWorld = new ShowWorld();
showWorld.Execute(update, client, Con);
}
catch (Exception ee)
{
@params.Message = "‼Ошибка в SelectEducationCommand: " + ee.Message;
@params.Attachments = null;
@params.Keyboard = null;
@params.UserId = 59111081;
@params.RandomId = GetRandomId();
client.Messages.SendAsync(@params);
}
}
