private static string SetStundenplan(string CommandPara) { SQLManager.Connection.Close(); SetStundenplanCommand Command = new SetStundenplanCommand(); ResultWithNoData Result = new ResultWithNoData(); int cid = 0; Command = JsonConvert.DeserializeObject <SetStundenplanCommand>(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 users WHERE EMail='" + 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 Stundenplan = ?Stundenplan WHERE CID = ?CID"; mysqlCommand.Parameters.AddWithValue("?CID", cid); mysqlCommand.Parameters.AddWithValue("?Stundenplan", Command.Stundenplan); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
public static string GetStundenplan() { SetStundenplanCommand command = new SetStundenplanCommand(); command.EMail = EMAIL; command.Hash = HASH; return(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); }
public static int SetStundenplan(string Stundenplan) { SetStundenplanCommand command = new SetStundenplanCommand(); command.EMail = EMAIL; command.Hash = HASH; command.Stundenplan = Stundenplan; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }