/// <summary>
/// Guarda um User com os seus dados na Base de Dados
/// </summary>
public override void saveUser(User user, string password)
{
Hashtable param = new Hashtable();
param.Add("@user_id", user.UserId);
if (password != string.Empty)
{
param.Add("@user_pass", hashPassword(password));
}
param.Add("@user_ruler_id", user.RulerId);
param.Add("@user_nick", user.Nick);
param.Add("@user_skin", user.Skin);
param.Add("@user_lang", user.Lang);
param.Add("@user_website", user.Website);
param.Add("@user_avatar", user.Avatar);
param.Add("@user_msn", user.Msn);
param.Add("@user_icq", user.Icq);
param.Add("@user_jabber", user.Jabber);
param.Add("@user_aim", user.Aim);
param.Add("@user_yahoo", user.Yahoo);
param.Add("@user_signature", user.Signature);
param.Add("@user_imagesDir", user.ImagesDir);
param.Add("@user_rank", user.EloRanking);
SqlServerUtility.executeNonQuery("OrionsBelt_UsersUpdateUser", param);
}
/// <summary>Actualiza a data do ltimo login</summary>
public override void updateLastLogin(string userMail)
{
Hashtable param = new Hashtable();
param.Add("@user_mail", userMail);
SqlServerUtility.executeNonQuery("OrionsBelt_UsersUpdateLastLogin", param);
}
/// <summary>Regista uma nova notícia</summary>
protected override void Register(Entry entry)
{
Hashtable parameters = new Hashtable();
parameters.Add("@title", entry.Title);
parameters.Add("@content", entry.Content);
SqlServerUtility.executeNonQuery("OrionsBelt_InsertNews", parameters);
}
/// <summary>
/// Regista um User
/// </summary>
public override void registerUser(string nick, string mail, string pass)
{
Hashtable param = new Hashtable();
param.Add("@user_mail", mail);
param.Add("@user_pass", hashPassword(pass));
param.Add("@user_nick", nick);
param.Add("@user_lang", CultureModule.RequestLanguage);
SqlServerUtility.executeNonQuery("OrionsBelt_UsersRegisterUser", param);
}
/// <summary>
/// Salva a informação da excepção
/// </summary>
/// <param name="exceptionInfo">objecto que encapsula a informação da excepção</param>
public override void save(ExceptionInfo exceptionInfo)
{
Hashtable parameters = new Hashtable();
parameters.Add("@name", exceptionInfo.Name);
parameters.Add("@message", exceptionInfo.Message);
parameters.Add("@stackTrace", exceptionInfo.StackTrace);
parameters.Add("@date", exceptionInfo.Date);
SqlServerUtility.executeNonQuery("OrionsBelt_ExceptionLogSave", parameters);
}
/// <summary>Regista um scan</summary>
public override void Register(Scan scan)
{
MemoryStream stream = new MemoryStream();
formatter.Serialize(stream, scan);
byte[] data = stream.ToArray();
Hashtable parameters = new Hashtable();
parameters.Add("@sourcePlanetId", scan.SourcePlanetId);
parameters.Add("@data", data);
SqlServerUtility.executeNonQuery("OrionsBelt_InsertScans", parameters);
}
public override bool resetPassword(string userMail, string newPassword)
{
Hashtable param = new Hashtable();
param.Add("@user_mail", userMail);
bool result = SqlServerUtility.checkResults("OrionsBelt_UsersCheckUserMail", param);
if (result)
{
param.Add("@user_password", newPassword);
SqlServerUtility.executeNonQuery("OrionsBelt_UsersResetPassword", param);
}
return(result);
}
/// <summary>
/// remove todas as excepções
/// </summary>
public override void removeAll()
{
SqlServerUtility.executeNonQuery("OrionsBelt_ExceptionLogRemoveAllExceptions");
}
/// <summary>
/// remove a excepção com o identificador id
/// </summary>
/// <param name="id">identifucador da excepção</param>
public override void remove(int id)
{
SqlServerUtility.executeNonQuery("OrionsBelt_ExceptionLogRemoveException", "@id", id);
}
/// <summary>
/// faz reset ao id do user
/// </summary>
public override void resetUserRulerId()
{
SqlServerUtility.executeNonQuery("OrionsBelt_UsersResetUserRulerId", null);
}
