public static int LeaveClass() { LeaveClassCommand command = new LeaveClassCommand(); command.EMail = EMAIL; command.Hash = HASH; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
private static string LeaveClass(string CommandPara) { SQLManager.Connection.Close(); LeaveClassCommand Command = new LeaveClassCommand(); ResultWithNoData Result = new ResultWithNoData(); int cid = 0; Command = JsonConvert.DeserializeObject <LeaveClassCommand>(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 { mysqlreader.Close(); SQLManager.Connection.Close(); return(JsonConvert.SerializeObject(Result)); } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE users SET HasSelected = 0 WHERE EMail = ?email"; mysqlCommand.Parameters.AddWithValue("?email", Command.EMail); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE users SET CID = 0 WHERE EMail = ?email"; mysqlCommand.Parameters.AddWithValue("?email", Command.EMail); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }