public static int CreateTermin(string Title, string Description, string EndDate) { NewTerminCommand command = new NewTerminCommand(); command.EMail = EMAIL; command.Hash = HASH; command.Title = Title; command.Description = Description; command.EndDate = EndDate; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
private static string AddTermin(string CommandPara) { SQLManager.Connection.Close(); NewTerminCommand Command = new NewTerminCommand(); ResultWithNoData Result = new ResultWithNoData(); Termine auf = new Termine(); TerminListViewItem list = new TerminListViewItem(); int cid = 0; Command = JsonConvert.DeserializeObject <NewTerminCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { 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 { return(JsonConvert.SerializeObject(Result)); } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "SELECT Termine FROM classes WHERE CID='" + cid + "'"; MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string aufm = mysqlreader.GetString("Termine"); if (aufm != "") { auf = JsonConvert.DeserializeObject <Termine>(aufm); } } mysqlreader.Close(); SQLManager.Connection.Close(); } list.Title = Command.Title; list.Description = Command.Description; list.EndDate = Command.EndDate; auf.Tasks.Add(list); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE classes SET Termine = ?termine WHERE CID = ?CID"; mysqlCommand.Parameters.AddWithValue("?CID", cid); mysqlCommand.Parameters.AddWithValue("?termine", JsonConvert.SerializeObject(auf)); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }