public InternetToDataBase(UserToCreate user, IApi VkClient)
{
vkClient = VkClient;
this.token = user.token;
this.URL = "https://vk.com/id" + user.vk_id;
this.user = user;
}
public void Update(UserToCreate user)
{
dbMaster.OpenConnection();
try
{
MySqlCommand command = dbMaster.GetConnection().CreateCommand();
command.CommandText = "UPDATE Users SET status = 1 WHERE vk_id = @idUser";
command.Parameters.AddWithValue("@idUser", user.vk_id);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
dbMaster.CloseConnection();
}
public void Insert(UserToCreate user)
{
dbMaster.OpenConnection();
try
{
MySqlCommand command = dbMaster.GetConnection().CreateCommand();
command.CommandText = "INSERT INTO userstokens (id_user, token) "
+ "VALUES ((SELECT id FROM Users WHERE id_vk = @vkid), @token)";
command.Parameters.AddWithValue("@vkid", user.vk_id);
command.Parameters.AddWithValue("@token", user.token);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
dbMaster.CloseConnection();
}