public void Validate()
{
var con = DbHelper.GetDbConnection();
con.Open();
var name = "Justin_Vazquez";
var password = "******";
if (!string.IsNullOrWhiteSpace(UserAccess.GetName(con, name)))
{
var userID = UserAccess.GetIdByName(con, name);
var hash = UserAccess.GetHash(con, userID);
var salt = UserAccess.GetSalt(con, userID);
try
{
if (SaltHashHelper.ValidatePassword(password, hash, salt))
{
Console.Write(UserAccess.GetUser(con, name, hash));
}
else
{
Console.Write("Error");
}
}
catch (Exception error)
{
Console.Write(error);
}
finally
{
con.Close();
}
}
}
/// <summary>
/// Methode um einen User für den Login zu Validieren
/// </summary>
/// <param name="name">User Name</param>
/// <param name="password">User Password</param>
/// <returns>Ein Objekt vom Typ User</returns>
public UserModel Login(string name, string password)
{
var con = DbHelper.GetDbConnection();
con.Open();
//Wenn der User existiert dann weiter.
if (!string.IsNullOrWhiteSpace(UserAccess.GetName(con, name)))
{
//Hash und Salt aus der Datenbank anhand der UserID die durch den Username ermittelt wird
var userID = UserAccess.GetIdByName(con, name);
var hash = UserAccess.GetHash(con, userID);
var salt = UserAccess.GetSalt(con, userID);
try
{
//Validiert den Hash aus der Datenbank mit dem Passwort aus der Login-Form
if (SaltHashHelper.ValidatePassword(password, hash, salt))
{
var user = UserAccess.GetUser(con, name, hash);
user.KlassenName = StundeplanAccess.GetKlasseText(con, user.Klasse);
return(user);
}
else
{
return(null);
}
}
catch (Exception error)
{
Console.Write(error);
}
finally
{
con.Close();
}
}
return(null);
}