public long AddParticipant(Dictionary <string, string> booking) { var d = booking; var e = Json.GetKvpValue(d, "veranstaltung", false); var userId = Json.GetKvpValue(d, "nutzerId", false); var result = DatabaseManager.ExecutePost("Teilnehmer", new Dictionary <string, string> { { "Veranstaltung", e }, { "Nutzer", userId }, }); new VeranstaltungenModel().UpdateParticipantCount(Convert.ToInt64(e)); return(result); }
public bool PostBooking(BookingPost bookingPost, string eventUid) { var eventId = GetEventId(eventUid); bookingPost.veranstaltung = eventId; if (!CheckIfEventCanBeBooked(Convert.ToInt64(eventId))) { return(false); } var userId = new NutzerModel().PostUser(bookingPost.ToUserPost()); var d = bookingPost.ToDictionary(); d.Add("Nutzer", userId.ToString()); return(DatabaseManager.ExecutePost("Buchungen", d) != -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 PostCalendarOrganizer(long calendarId, CalendarPost calendarPost) { var organizerId = calendarPost.veranstalter; if (DatabaseManager.CountResults($"SELECT * FROM Veranstalter WHERE Id={organizerId} AND Autorisiert=1") != 1) { return(false); } if (DatabaseManager.CountResults($"SELECT * FROM Kalenderberechtigte WHERE Veranstalter={organizerId} AND Kalender={calendarId}") == 1) { return(false); } DatabaseManager.ExecutePost("Kalenderberechtigte", calendarPost.ToAuthorizationDictionary(calendarId)); return(true); }
public string PostEvent(long id, EventPost eventPost) { eventPost.kalender = id; var uid = CalendarManager.AddEvent(eventPost, id.ToString()); var d = eventPost.ToDictionary(); d["Uid"] = uid; d["Teilnehmerzahl"] = "0"; var result = DatabaseManager.ExecutePost("Veranstaltungen", d); if (result > 0) { return(uid); } else { return(null); } }
public long PostUser(UserPost userPost) { if (userPost == null) { return(-1); } var d = userPost.ToDictionary(); d.Add("Verifiziert", "0"); var id = DatabaseManager.ExecutePost("Nutzerdaten", d); if (id <= 0) { return(-1); } new EmailverifizierungenModel().AddNewCode(id, 12); return(id); }
public long PostOrganizer(OrganizerPost organizerPost) { var id = new NutzerModel().PostUser(organizerPost.ToUserPost()); if (id == -1) { return(-1); } var d = organizerPost.ToDictionary(); d.Add("Autorisiert", "0"); d.Add("id", id.ToString()); var result = DatabaseManager.ExecutePost("Veranstalter", d); return(result); }
public string AddNewCode(long userId, double hours) { var code = GenerateUniqueCode(); var dt = DateTime.Now.AddHours(hours); var dateTime = CalendarManager.GetDateTime(dt); var dict = new Dictionary <string, string> { { "Nutzer", userId.ToString() }, { "Zeitfrist", dateTime }, { "Code", code }, }; if (DatabaseManager.ExecutePost("Emailverifizierungen", dict) > 0) { return(code); } else { return(null); } }
public bool PostAdmin(long organizerId) { var organizer = new VeranstalterModel().GetOrganizer(organizerId); if (organizer != null && GetAdmin(organizerId) == null) { if (Json.GetKvpValue(organizer, "verifiziert", false) == "0" || Json.GetKvpValue(organizer, "autorisiert", false) == "0") { return(false); } var adminPost = new Dictionary <string, string> { { "id", organizerId.ToString() } }; return(DatabaseManager.ExecutePost("Admins", adminPost) == organizerId); } else { return(false); } }