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 string GetEvents(List <string> events, string queryString) { var es = events; var result = new List <string>(); for (int i = 0; i < es.Count; i++) { var uid = Json.GetKvpValue(es[i], "uid", false); var dbData = DatabaseManager.ExecuteGet("Veranstaltungen", Json.DeserializeString(uid), GetEventKeyTableDictionary()); if (dbData != null) { result.Add(Json.MergeObjects(new string[] { es[i], dbData }, true)); } } var jsonData = Json.SerializeObject(new Dictionary <string, string> { { "veranstaltungen", Json.SerializeArray(result.ToArray()) } }); return(Json.QueryJsonData(jsonData, queryString, -1, false, false, Json.ArrayEntryOrKvpValue.ArrayEntry)); }
public string GetUsers(long[] ids) { return(DatabaseManager.ExecuteGet("Nutzerdaten", ids, GetUserKeyTableDictionary())); }
public string GetCalendars(long[] ids) { return(DatabaseManager.ExecuteGet("Kalender", ids, GetCalendarKeyTableDictionary())); }