public static string SendActivationCode(string CommandPara) { SQLManager.Connection.Close(); SendNewActivationCodeCommand Command = new SendNewActivationCodeCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <SendNewActivationCodeCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { Result.statusCode = 270; return(JsonConvert.SerializeObject(Result)); } int random = rand.Next(0, 999999); Mail_Server.sendActivationCode(random, Command.EMail); ActivationCodesSafe.addData(Command.EMail, random); Result.statusCode = 201; string test = JsonConvert.SerializeObject(Result); return(test); }
public static string SendPasswordCode(string CommandPara) { SQLManager.Connection.Close(); SendNewPasswordCodeCommand Command = new SendNewPasswordCodeCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <SendNewPasswordCodeCommand>(CommandPara); int random = rand.Next(0, 999999); Mail_Server.sendPasswordCode(random, Command.EMail); PasswordCodesSafe.addData(Command.EMail, random); Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
private static string SendInvite(string CommandPara) { SQLManager.Connection.Close(); SendInviteCommand Command = new SendInviteCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); int cid = 0; Command = JsonConvert.DeserializeObject <SendInviteCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { Result.statusCode = 270; return(JsonConvert.SerializeObject(Result)); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "SELECT CID FROM classes WHERE Creator='" + Command.EMail + "'"; MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); cid = mysqlreader.GetInt32("CID"); } else { mysqlreader.Close(); SQLManager.Connection.Close(); return(JsonConvert.SerializeObject(Result)); } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { mysqlCommand.CommandText = "SELECT EMail FROM users WHERE EMail='" + Command.EMail_Target + "'"; SQLManager.Connection.Open(); MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string MySQL_EMail = mysqlreader.GetString("EMail"); if (MySQL_EMail.Equals(Command.EMail_Target, StringComparison.InvariantCultureIgnoreCase)) { mysqlreader.Close(); SQLManager.Connection.Close(); } else { mysqlreader.Close(); SQLManager.Connection.Close(); Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } } else { mysqlreader.Close(); SQLManager.Connection.Close(); Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } } int random = rand.Next(0, 999999); Mail_Server.sendClassInviteCode(random, Command.EMail_Target); InviteCodesSafe.addData(Command.EMail_Target, random, cid); Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }