/// <summary>
/// Registers token to database
/// </summary>
/// <param name="PC_Unique">unique pc identifier</param>
/// <param name="Password">password</param>
/// <param name="Token">token</param>
public void RegisterToken(string PC_Unique, string Password, string Token)
{
using (MySqlConnection connection = WebApiConfig.Connection())
using (MySqlCommand command = new MySqlCommand(@"SELECT `Password` FROM `tbDaemons` WHERE `PC_Unique` = @PC_Unique", connection))
{
string DatabasePassword = null;
connection.Open();
command.Parameters.AddWithValue("@PC_Unique", PC_Unique);
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DatabasePassword = reader["Password"].ToString();
}
reader.Close();
}
Bcrypter bcrypter = new Bcrypter();
if (Password == DatabasePassword)
{
command.CommandText = @"UPDATE `tbDaemons` SET `Token`= @Token WHERE `PC_Unique` = @PC_Unique";
command.Parameters.AddWithValue("@Token", Token);
command.ExecuteNonQuery();
}
}
}
public RegisterData Register(Password password)
{
string token = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
Bcrypter encrypt = new Bcrypter();
using (MySqlConnection connection = WebApiConfig.Connection())
{
connection.Open();
mySqlCom.RegisterDaemonAndGetId(password.daemon, password.password);
mySqlCom.DaemonSeen((int)mySqlCom.GetDaemonId(password.daemon), connection);
connection.Close();
}
mySqlCom.RegisterToken(password.daemon.PC_Unique, password.password, token);
return(new RegisterData()
{
Token = token, TimerTick = mySqlAdmin.GetTimerTick((int)mySqlCom.GetDaemonId(password.daemon))
});
}
