using (MySqlConnection connection = new MySqlConnection(connectionString)) {
MySqlCommand command;
string sql;
connection.Open();
sql = "SELECT
id
FROM
main
.
accounts
WHERE serial =
@serial and login =
@login and password =
@password;";
command = connection.CreateCommand();
command.CommandText = sql;
command.Parameters.AddWithValue("
@serial", sender.Serial);
command.Parameters.AddWithValue("
@login", login);
command.Parameters.AddWithValue("
@password", password);
try {
string result = command.ExecuteScalar().ToString();
if (result != null)
isAuth = true;
} catch { isAuth = false; }
connection.Close();
}