public bool PutCalendar(CalendarPost calendarPost, long calendarId) { if (DatabaseManager.GetId($"SELECT * FROM Kalender WHERE Name={Json.SerializeString(calendarPost.name)}") != null) { return(false); } return(DatabaseManager.ExecutePut("Kalender", calendarId, calendarPost.ToDictionary())); }
public bool DeleteParticipant(Dictionary <string, string> booking) { var d = booking; var e = Json.GetKvpValue(d, "veranstaltung", false); var userId = Json.GetKvpValue(d, "nutzer", false); var id = DatabaseManager.GetId($"SELECT * FROM Teilnehmer WHERE Veranstaltung={e} AND Id={userId}"); var result = DatabaseManager.ExecuteDelete("Teilnehmer", Convert.ToInt64(id)); new VeranstaltungenModel().UpdateParticipantCount(Convert.ToInt64(e)); return(result); }
public long GetVerificationCodeId(string code) { var id = DatabaseManager.GetId($"SELECT * FROM Emailverifizierungen WHERE Code=\"{code}\""); if (id != null) { return(Convert.ToInt64(id)); } else { return(-1); } }
public long VerifyUser(long id) { DatabaseManager.ExecutePut("Nutzerdaten", id, new Dictionary <string, string> { { "Verifiziert", "1" } }); var user = DatabaseManager.ExecuteGet("Nutzerdaten", id, GetUserKeyTableDictionary()); var u = Json.DeserializeObject(user); var email = Json.GetKvpValue(u, "email", false); var vorname = Json.GetKvpValue(u, "vorname", false); var nachname = Json.GetKvpValue(u, "nachname", false); var abteilung = Json.GetKvpValue(u, "abteilung", false); var firstId = DatabaseManager.GetId($"SELECT * FROM Nutzerdaten WHERE Email={email} AND Verifiziert=1"); if (firstId == null) { return(-1); } var newId = Convert.ToInt64(firstId); if (newId < id) { var userPost = new UserPost { abteilung = Json.DeserializeString(abteilung), email = Json.DeserializeString(email), vorname = Json.DeserializeString(vorname), nachname = Json.DeserializeString(nachname) }; if (!PutUser(Convert.ToInt64(firstId), userPost)) { return(-1); } DatabaseManager.ExecuteNonQuery($"UPDATE Buchungen SET Nutzer={newId} WHERE Nutzer={id}"); } if (DatabaseManager.CountResults("SELECT * FROM Veranstalter WHERE Autorisiert=1") == 0 && DatabaseManager.CountResults($"SELECT * FROM Veranstalter WHERE Id={id}") == 1) { DatabaseManager.ExecutePut("Veranstalter", id, new Dictionary <string, string> { { "Autorisiert", "1" } }); } if (DatabaseManager.CountResults("SELECT * FROM Admins") == 0) { new AdminsModel().PostAdmin(id); } return(id); }
public long GetLoggedInOrganizer(LoginData loginData) { var email = Json.SerializeString(loginData.ml); var passwort = Json.SerializeString(loginData.pw); var result = DatabaseManager.GetId($"SELECT * FROM Veranstalter INNER JOIN Nutzerdaten ON Veranstalter.Id=Nutzerdaten.Id " + $"WHERE Email={email} AND Passwort={passwort} AND Verifiziert=1 AND Autorisiert=1"); if (result != null) { return(Convert.ToInt64(result)); } else { return(-1); } }
public long PostCalendar(CalendarPost calendarPost) { if (new VeranstalterModel().GetOrganizer(calendarPost.veranstalter) == null) { return(-1); } if (DatabaseManager.GetId($"SELECT * FROM Kalender WHERE Name={Json.SerializeString(calendarPost.name)}") != null) { return(-1); } var id = DatabaseManager.ExecutePost("Kalender", calendarPost.ToDictionary()); DatabaseManager.ExecutePost("Kalenderberechtigte", calendarPost.ToAuthorizationDictionary(id)); return(id); }
public bool DeleteCalendarOrganizer(long calendarId, long organizerId) { var c = DatabaseManager.CountResults($"SELECT * FROM Kalenderberechtigte WHERE Kalender={calendarId}"); if (c <= 1) { return(false); } else { var id = DatabaseManager.GetId($"SELECT * FROM Kalenderberechtigte WHERE Kalender={calendarId} AND Veranstalter={organizerId}"); if (id == null) { return(false); } else { return(DatabaseManager.ExecuteDelete("Kalenderberechtigte", Convert.ToInt64(id))); } } }
public string GetEventId(string eventUid) { eventUid = Json.DeserializeString(eventUid); return(DatabaseManager.GetId($"SELECT * FROM Veranstaltungen WHERE Uid=\"{eventUid}\"")); }
public string GetParticipants(string eventUid) { var id = Convert.ToInt64(DatabaseManager.GetId($"SELECT * FROM Veranstaltungen WHERE Uid=\"{eventUid}\"")); return(GetParticipants(id)); }