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 string GetCalendarOrganizers(long calendarId) { var reader = DatabaseManager.ExecuteReader($"SELECT * FROM Kalenderberechtigte WHERE Kalender={calendarId}"); var ids = DatabaseManager.ReadAsJsonArray(new Dictionary <string, string> { { "id", "Veranstalter" } }, reader); var array = Json.DeserializeArray(ids); var idList = new List <long>(); foreach (var a in array) { idList.Add(Convert.ToInt64(Json.GetKvpValue(a, "id", false))); } var result = new NutzerModel().GetUsers(idList.ToArray()); return(Json.SerializeObject(new Dictionary <string, string> { { "veranstalter", result } })); }
public bool AuthorizeOrganizer(long id) { var organizer = GetOrganizer(id); if (organizer == null) { return(false); } var user = new NutzerModel().GetUser(id); if (Json.GetValue(user, "verifiziert", false) == "0") { return(false); } return(DatabaseManager.ExecutePut("Veranstalter", id, new Dictionary <string, string> { { "autorisiert", "1" } })); }
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); }