/// <summary>
/// Login the current user
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns>Returns the number of rows</returns>
public int Login(string username, string password)
{
password = SHAEncrypt.GenerateSHA512String(password);
using (db = Database.Open("aSpecialDay"))
{
int loggedIn = db.QueryValue("SELECT COUNT(*) FROM Login WHERE Username = @0 AND Password = @1", username, password);
return(loggedIn);
}
}
/// <summary>
/// Register a new user to the website
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public int Register(string username, string password)
{
password = SHAEncrypt.GenerateSHA512String(password);
using (db = Database.Open("aSpecialDay"))
{
int insert = db.Execute("INSERT INTO Login (Username, Password) " +
"SELECT @0, @1 " +
"WHERE NOT EXISTS(SELECT Username FROM Login WHERE Username = @0)", username, password);
return(insert);
}
}