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