public static ClassData DownloadClassData()
{
GetClassDataCommand command = new GetClassDataCommand();
command.EMail = EMAIL;
command.Hash = HASH;
return(JsonConvert.DeserializeObject <ClassData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))));
}
private static string GetClassData(string CommandPara)
{
SQLManager.Connection.Close();
ClassData Result = new ClassData();
GetClassDataCommand Command = new GetClassDataCommand();
Command = JsonConvert.DeserializeObject <GetClassDataCommand>(CommandPara);
int cid = 0;
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 users WHERE EMail='" + Command.EMail + "'";
MySqlDataReader mysqlreader;
mysqlreader = mysqlCommand.ExecuteReader();
if (mysqlreader.HasRows)
{
mysqlreader.Read();
cid = mysqlreader.GetInt32("CID");
}
mysqlreader.Close();
SQLManager.Connection.Close();
}
using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
{
SQLManager.Connection.Open();
mysqlCommand.CommandText = "SELECT Name,Description,School , Creator, Perm_changeStundenplan, Perm_createAufgabe, Perm_deleteAufgabe, Perm_createTermin, Perm_deleteTermin, Stundenplan, Aufgaben, Termine FROM classes WHERE CID='" + cid + "'";
MySqlDataReader mysqlreader;
mysqlreader = mysqlCommand.ExecuteReader();
if (mysqlreader.Read())
{
Result.ClassName = mysqlreader.GetString("Name");
Result.Description = mysqlreader.GetString("Description");
Result.School = mysqlreader.GetString("School");
Result.Creator = mysqlreader.GetString("Creator");
Result.changeStundenplan = mysqlreader.GetBoolean("Perm_changeStundenplan");
Result.createAufgabe = mysqlreader.GetBoolean("Perm_createAufgabe");
Result.deleteAufgabe = mysqlreader.GetBoolean("Perm_deleteAufgabe");
Result.createTermin = mysqlreader.GetBoolean("Perm_createTermin");
Result.deleteTermin = mysqlreader.GetBoolean("Perm_deleteTermin");
Result.Stundenplan = mysqlreader.GetString("Stundenplan");
Result.Aufgabe = mysqlreader.GetString("Aufgaben");
Result.Termin = mysqlreader.GetString("Termine");
}
mysqlreader.Close();
SQLManager.Connection.Close();
Result.statusCode = 201;
return(JsonConvert.SerializeObject(Result));
}
}
