public static int SetRechte(bool changeStundenplan, bool createAufgabe, bool deleteAufgabe, bool createTermin, bool deleteTermin)
{
SetRechteCommand command = new SetRechteCommand();
command.EMail = EMAIL;
command.Hash = HASH;
command.changeStundenplan = changeStundenplan;
command.createAufgabe = createAufgabe;
command.deleteAufgabe = deleteAufgabe;
command.createTermin = createTermin;
command.deleteTermin = deleteTermin;
ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command)));
return(result.statusCode);
}
private static string SetRechte(string CommandPara)
{
SQLManager.Connection.Close();
SetRechteCommand Command = new SetRechteCommand();
ResultWithNoData Result = new ResultWithNoData();
int cid = 0;
Command = JsonConvert.DeserializeObject <SetRechteCommand>(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
{
Result.statusCode = 270;
return(JsonConvert.SerializeObject(Result));
}
mysqlreader.Close();
SQLManager.Connection.Close();
}
using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
{
SQLManager.Connection.Open();
mysqlCommand.CommandText = "UPDATE classes SET Perm_changeStundenplan = ?changeStundenplan, Perm_createAufgabe = ?createAufgabe, Perm_deleteAufgabe = ?deleteAufgabe, Perm_createTermin = ?createTermin , Perm_deleteTermin = ?deleteTermin WHERE CID = ?CID";
mysqlCommand.Parameters.AddWithValue("?CID", cid);
mysqlCommand.Parameters.AddWithValue("?changeStundenplan", Command.changeStundenplan);
mysqlCommand.Parameters.AddWithValue("?createAufgabe", Command.createAufgabe);
mysqlCommand.Parameters.AddWithValue("?deleteAufgabe", Command.deleteAufgabe);
mysqlCommand.Parameters.AddWithValue("?createTermin", Command.createTermin);
mysqlCommand.Parameters.AddWithValue("?deleteTermin", Command.deleteTermin);
mysqlCommand.ExecuteNonQuery();
SQLManager.Connection.Close();
}
Result.statusCode = 201;
return(JsonConvert.SerializeObject(Result));
}
