public static string ActivationAccount(string CommandPara) { SQLManager.Connection.Close(); ActivateAccountCommand Command = new ActivateAccountCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <ActivateAccountCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { Result.statusCode = 270; return(JsonConvert.SerializeObject(Result)); } CodeEmailSafe tmp = ActivationCodesSafe.getData(Command.EMail); if (Command.Code == tmp.Code) { ActivationCodesSafe.RemoveData(Command.EMail); Result.statusCode = 201; using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `HasActivated` = '1' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; } else { Result.statusCode = 202; } return(JsonConvert.SerializeObject(Result)); }
public static string ResetPassword(string CommandPara) { SQLManager.Connection.Close(); ResetPasswordCommand Command = new ResetPasswordCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <ResetPasswordCommand>(CommandPara); CodeEmailSafe tmp = PasswordCodesSafe.getData(Command.EMail); if (tmp == null) { Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } if (Command.Code == tmp.Code) { PasswordCodesSafe.RemoveData(Command.EMail); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `Password` = '" + Command.NewHash + "' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; } else { Result.statusCode = 202; } return(JsonConvert.SerializeObject(Result)); }