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);
}
