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)); }
private static string Register(string CommandPara) { SQLManager.Connection.Close(); ResultWithNoData result = new ResultWithNoData(); RegisterCommand Command = new RegisterCommand(); Command = JsonConvert.DeserializeObject <RegisterCommand>(CommandPara); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "SELECT EMail FROM users WHERE EMail='" + Command.EMail + "'"; MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string MySQL_EMail = mysqlreader.GetString("EMail"); if (MySQL_EMail.Equals(Command.EMail, StringComparison.InvariantCultureIgnoreCase)) { mysqlreader.Close(); SQLManager.Connection.Close(); result.statusCode = 301; return(JsonConvert.SerializeObject(result)); } } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "INSERT INTO users (Firstname,Lastname,Gender,EMail,Password) VALUES (?Firstname,?Lastname,?Gender,?EMail,?Password)"; mysqlCommand.Parameters.AddWithValue("?Firstname", Command.FirstName); mysqlCommand.Parameters.AddWithValue("?LastName", Command.LastName); mysqlCommand.Parameters.AddWithValue("?Gender", Command.Gender); mysqlCommand.Parameters.AddWithValue("?EMail", Command.EMail); mysqlCommand.Parameters.AddWithValue("?Password", Command.PasswordHash); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } result.statusCode = 201; return(JsonConvert.SerializeObject(result)); }
public static string SendActivationCode(string CommandPara) { SQLManager.Connection.Close(); SendNewActivationCodeCommand Command = new SendNewActivationCodeCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <SendNewActivationCodeCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { Result.statusCode = 270; return(JsonConvert.SerializeObject(Result)); } int random = rand.Next(0, 999999); Mail_Server.sendActivationCode(random, Command.EMail); ActivationCodesSafe.addData(Command.EMail, random); Result.statusCode = 201; string test = JsonConvert.SerializeObject(Result); return(test); }
public static int SendNewPasswordCode(string EMail) { SendNewPasswordCodeCommand command = new SendNewPasswordCodeCommand(); command.EMail = EMail; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
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); }
public static int ResetPassword(string newPassword, int Code, string Email) { ResetPasswordCommand command = new ResetPasswordCommand(); command.EMail = Email; command.NewHash = TCPManager.Hash(newPassword); command.Code = Code; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
public static string JoinClass(string CommandPara) { SQLManager.Connection.Close(); JoinClassCommand Command = new JoinClassCommand(); ResultWithNoData Result = new ResultWithNoData(); Command = JsonConvert.DeserializeObject <JoinClassCommand>(CommandPara); CodeEMailCIDSafe tmp = InviteCodesSafe.getData(Command.EMail); if (tmp == null) { Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } if (Command.Code == tmp.Code) { InviteCodesSafe.RemoveData(Command.EMail); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `CID` = '" + tmp.CID + "' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE users SET HasSelected = 1 WHERE EMail = ?email"; mysqlCommand.Parameters.AddWithValue("?email", Command.EMail); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; } else { Result.statusCode = 202; } return(JsonConvert.SerializeObject(Result)); }
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); }
public static int DeleteTermin(int id) { DeleteTerminCommand command = new DeleteTerminCommand(); command.EMail = EMAIL; command.Hash = HASH; command.ID = id; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
public static int SendNewActivationCode() { SendNewActivationCodeCommand command = new SendNewActivationCodeCommand(); command.EMail = EMAIL; command.Hash = HASH; string test = TCPManager.SendRequest(JsonConvert.SerializeObject(command)); ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(test); return(result.statusCode); }
public static int SendInvite(string EMail_target) { SendInviteCommand command = new SendInviteCommand(); command.EMail = EMAIL; command.Hash = HASH; command.EMail_Target = EMail_target; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
public static int ActivateAccount(int Code) { ActivateAccountCommand command = new ActivateAccountCommand(); command.EMail = EMAIL; command.Hash = HASH; command.Code = Code; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
public static int Register(string firstName, string lastName, string email, string password, string gender) { RegisterCommand command = new RegisterCommand(); command.FirstName = firstName; command.LastName = lastName; command.EMail = email; command.PasswordHash = TCPManager.Hash(password); command.Gender = gender; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
public static int SetClassData(string ClassName, string Description, string School) { SetClassDataCommand command = new SetClassDataCommand(); command.EMail = EMAIL; command.Hash = HASH; command.ClassName = ClassName; command.Description = Description; command.School = School; ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); return(result.statusCode); }
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); }
public static int Login(string email, string passwordhash) { LoginCommand command = new LoginCommand(); command.EMail = email; command.Hash = TCPManager.Hash(passwordhash); ResultWithNoData result = JsonConvert.DeserializeObject <ResultWithNoData>(TCPManager.SendRequest(JsonConvert.SerializeObject(command))); if (result.statusCode == 201) { setLoginData(command.EMail, command.Hash); getLoginData(); } return(result.statusCode); }
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); }
public static int CreateClass(string ClassName, string Description, string School, bool changeStundenplan, bool createAufgabe, bool deleteAufgabe, bool createTermin, bool deleteTermin) { CreateClassCommand command = new CreateClassCommand(); command.EMail = EMAIL; command.Hash = HASH; command.ClassName = ClassName; command.Description = Description; command.School = School; 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); }
public static string SendPasswordCode(string CommandPara) { SQLManager.Connection.Close(); SendNewPasswordCodeCommand Command = new SendNewPasswordCodeCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <SendNewPasswordCodeCommand>(CommandPara); int random = rand.Next(0, 999999); Mail_Server.sendPasswordCode(random, Command.EMail); PasswordCodesSafe.addData(Command.EMail, random); Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
public static string ActivationAccount(string CommandPara) { SQLManager.Connection.Close(); ActivateAccountCommand Command = new ActivateAccountCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <ActivateAccountCommand>(CommandPara); if (CheckUserData(Command.EMail, Command.Hash) == false) { Result.statusCode = 270; return(JsonConvert.SerializeObject(Result)); } CodeEmailSafe tmp = ActivationCodesSafe.getData(Command.EMail); if (Command.Code == tmp.Code) { ActivationCodesSafe.RemoveData(Command.EMail); Result.statusCode = 201; using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `HasActivated` = '1' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; } else { Result.statusCode = 202; } return(JsonConvert.SerializeObject(Result)); }
private static string Login(string CommandPara) { SQLManager.Connection.Close(); LoginCommand Command = new LoginCommand(); Command = JsonConvert.DeserializeObject <LoginCommand>(CommandPara); ResultWithNoData result = new ResultWithNoData(); if (CheckUserData(Command.EMail, Command.Hash)) { result.statusCode = 201; } else { result.statusCode = 202; } return(JsonConvert.SerializeObject(result)); }
public static string ResetPassword(string CommandPara) { SQLManager.Connection.Close(); ResetPasswordCommand Command = new ResetPasswordCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); Command = JsonConvert.DeserializeObject <ResetPasswordCommand>(CommandPara); CodeEmailSafe tmp = PasswordCodesSafe.getData(Command.EMail); if (tmp == null) { Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } if (Command.Code == tmp.Code) { PasswordCodesSafe.RemoveData(Command.EMail); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `Password` = '" + Command.NewHash + "' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; } else { Result.statusCode = 202; } return(JsonConvert.SerializeObject(Result)); }
private static string SetClassData(string CommandPara) { SQLManager.Connection.Close(); SetClassDataCommand Command = new SetClassDataCommand(); ResultWithNoData Result = new ResultWithNoData(); int cid = 0; Command = JsonConvert.DeserializeObject <SetClassDataCommand>(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 Name = ?classname, Description = ?beschreibung, School = ?school WHERE CID = ?CID"; mysqlCommand.Parameters.AddWithValue("?CID", cid); mysqlCommand.Parameters.AddWithValue("?classname", Command.ClassName); mysqlCommand.Parameters.AddWithValue("?beschreibung", Command.Description); mysqlCommand.Parameters.AddWithValue("?school", Command.School); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
public static string CreateClass(string CommandPara) { SQLManager.Connection.Close(); CreateClassCommand Command = new CreateClassCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); int cid = 0; Command = JsonConvert.DeserializeObject <CreateClassCommand>(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 Creator FROM classes WHERE Creator='" + Command.EMail + "'"; MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string MySQL_EMail = mysqlreader.GetString("Creator"); if (MySQL_EMail.Equals(Command.EMail, StringComparison.InvariantCultureIgnoreCase)) { mysqlreader.Close(); SQLManager.Connection.Close(); Result.statusCode = 301; return(JsonConvert.SerializeObject(Result)); } } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "INSERT INTO classes (Creator,Name,Description,School,Perm_changeStundenplan, Perm_createAufgabe, Perm_deleteAufgabe, Perm_createTermin, Perm_deleteTermin ) VALUES (?Creator,?ClassName,?Description,?School,?changeStundenplan, ?createAufgabe, ?deleteAufgabe, ?createTermin, ?deleteTermin )"; mysqlCommand.Parameters.AddWithValue("?Creator", Command.EMail); mysqlCommand.Parameters.AddWithValue("?ClassName", Command.ClassName); mysqlCommand.Parameters.AddWithValue("?Description", Command.Description); mysqlCommand.Parameters.AddWithValue("?School", Command.School); 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(); } 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"); } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `CID` = '" + cid + "' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE `users` SET `HasSelected` = '1' WHERE `EMail` = '" + Command.EMail + "'"; mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
private static string SendInvite(string CommandPara) { SQLManager.Connection.Close(); SendInviteCommand Command = new SendInviteCommand(); ResultWithNoData Result = new ResultWithNoData(); Random rand = new Random(); int cid = 0; Command = JsonConvert.DeserializeObject <SendInviteCommand>(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 { mysqlreader.Close(); SQLManager.Connection.Close(); return(JsonConvert.SerializeObject(Result)); } mysqlreader.Close(); SQLManager.Connection.Close(); } using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { mysqlCommand.CommandText = "SELECT EMail FROM users WHERE EMail='" + Command.EMail_Target + "'"; SQLManager.Connection.Open(); MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string MySQL_EMail = mysqlreader.GetString("EMail"); if (MySQL_EMail.Equals(Command.EMail_Target, StringComparison.InvariantCultureIgnoreCase)) { mysqlreader.Close(); SQLManager.Connection.Close(); } else { mysqlreader.Close(); SQLManager.Connection.Close(); Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } } else { mysqlreader.Close(); SQLManager.Connection.Close(); Result.statusCode = 202; return(JsonConvert.SerializeObject(Result)); } } int random = rand.Next(0, 999999); Mail_Server.sendClassInviteCode(random, Command.EMail_Target); InviteCodesSafe.addData(Command.EMail_Target, random, cid); Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
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)); }
private static string DeleteTask(string CommandPara) { SQLManager.Connection.Close(); DeleteTaskCommand Command = new DeleteTaskCommand(); ResultWithNoData Result = new ResultWithNoData(); Aufgaben auf = new Aufgaben(); AufgabenListViewItem list = new AufgabenListViewItem(); int cid = 0; Command = JsonConvert.DeserializeObject <DeleteTaskCommand>(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 Aufgaben FROM classes WHERE CID='" + cid + "'"; MySqlDataReader mysqlreader; mysqlreader = mysqlCommand.ExecuteReader(); if (mysqlreader.HasRows) { mysqlreader.Read(); string aufm = mysqlreader.GetString("Aufgaben"); if (aufm != "") { auf = JsonConvert.DeserializeObject <Aufgaben>(aufm); } } mysqlreader.Close(); SQLManager.Connection.Close(); } list = auf.Tasks.Find(x => x.Id.ToString().Contains(Command.ID.ToString())); auf.Tasks.Remove(list); using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand()) { SQLManager.Connection.Open(); mysqlCommand.CommandText = "UPDATE classes SET Aufgaben = ?aufgaben WHERE CID = ?CID"; mysqlCommand.Parameters.AddWithValue("?CID", cid); mysqlCommand.Parameters.AddWithValue("?aufgaben", JsonConvert.SerializeObject(auf)); mysqlCommand.ExecuteNonQuery(); SQLManager.Connection.Close(); } Result.statusCode = 201; return(JsonConvert.SerializeObject(Result)); }
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)); }