/// <summary>
/// Updates a user in the database.
/// </summary>
/// <returns><c>true</c>, if user was updated, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="password">Password.</param>
public static bool UpdateUser(string username, string password)
{
using (var bl = Storage.GetBuilder(SQLSafeName))
{
var hs = AuthenticatedUsers.Hash(username, password);
bl.Update(UserTable.TableName, new DataParameter[]
{
new DataParameter(UserTable.ColumnNames.Password, hs)
},
new WhereFilter(UserTable.ColumnNames.Username, username)
);
return(Storage.ExecuteNonQuery(bl) > 0);
}
}
/// <summary>
/// Creates a user.
/// </summary>
/// <returns><c>true</c>, if user was created, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="password">Password.</param>
/// <param name="op">If set to <c>true</c> op.</param>
public static bool CreateUser(string username, string password, bool op = false)
{
using (var bl = Storage.GetBuilder(SQLSafeName))
{
var hs = AuthenticatedUsers.Hash(username, password);
bl.InsertInto(UserTable.TableName, new DataParameter[]
{
new DataParameter(UserTable.ColumnNames.Username, username),
new DataParameter(UserTable.ColumnNames.Password, hs),
new DataParameter(UserTable.ColumnNames.IsOperator, op),
new DataParameter(UserTable.ColumnNames.DateAdded, DateTime.Now)
});
return(Storage.ExecuteNonQuery(bl) > 0);
}
}