/// <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); }