internal bool checkAdmin() { string SQL = "select admin from Users where uID = @id"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = SQL; cmd.Connection = Starter.GetConnection(); cmd.Parameters.Add(new SqlParameter("id", uID)); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); try { return(reader.GetBoolean(0)); } catch (Exception e) { } return(false); }
//Statische Methoden, aufgerufen von der Starter-Klasse, damit alle Datenbank-Aufrufe über dieses Objekt in der //derselben Klasse gesammelt sind //bei Select * Abfrage gibt er folgende Reihenfolge aus: postID, uid, cid, date, content, tid, cid, name, tid, name, uid, username, pwHash, admin internal static Countries getAllCountries() { SqlCommand cmd = new SqlCommand("select c.cid, c.name, p.postID from Countries as c left join Posts as p on c.cid = p.cid", Starter.GetConnection()); SqlDataReader reader = cmd.ExecuteReader(); Countries allCountries = new Countries(); //initialisiere lehre Liste Country currentObject = new Country(); currentObject.cID = 0; while (reader.Read()) { if (currentObject.cID != reader.GetInt32(0)) { Country oneCountry = new Country(); currentObject = oneCountry; allCountries.Add(currentObject); currentObject.cID = reader.GetInt32(0); currentObject.countryName = reader.GetString(1); } try { currentObject.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(allCountries); }
public Transport getTransport() { //Load transport from DB Transport loadedTransport = new Transport(); SqlCommand cmd = new SqlCommand("select t.tid, t.name, p.postID from Transport as t left join Posts as p on t.tid = p.tid where t.tid = @id", Starter.GetConnection()); cmd.Parameters.Add(new SqlParameter("id", transport.transportID)); SqlDataReader reader = cmd.ExecuteReader(); loadedTransport.transportID = 0; while (reader.Read()) { if (loadedTransport.transportID != reader.GetInt32(0)) { loadedTransport.transportID = reader.GetInt32(0); loadedTransport.transportName = reader.GetString(1); } try { loadedTransport.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(loadedTransport); }
public Country getCountry() { //Load country from DB Country loadedCountry = new Country(); SqlCommand cmd = new SqlCommand("select c.cid, c.name, p.postID from Countries as c left join Posts as p on c.cid = p.cid where c.cid = @id", Starter.GetConnection()); cmd.Parameters.Add(new SqlParameter("id", country.cID)); SqlDataReader reader = cmd.ExecuteReader(); loadedCountry.cID = 0; while (reader.Read()) { if (loadedCountry.cID != reader.GetInt32(0)) { loadedCountry.cID = reader.GetInt32(0); loadedCountry.countryName = reader.GetString(1); } try { loadedCountry.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(loadedCountry); }
public User getUser() { //Load user from DB User loadedUser = new User(); SqlCommand cmd = new SqlCommand("select u.uid, u.username, p.postID from Users as u left join Posts as p on u.uid = p.uid where u.uid = @id", Starter.GetConnection()); cmd.Parameters.Add(new SqlParameter("id", user.uID)); SqlDataReader reader = cmd.ExecuteReader(); loadedUser.uID = 0; while (reader.Read()) { if (loadedUser.uID != reader.GetInt32(0)) { loadedUser.uID = reader.GetInt32(0); loadedUser.userName = reader.GetString(1); } try { loadedUser.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(loadedUser); }
internal static Post getOnePost(int postID) { Post onePost = new Post(); SqlCommand cmd = new SqlCommand("select * from Posts as p inner join Countries as c on p.cid = c.cid inner join Transport as t on p.tid = t.tid inner join Users as u on p.uid = u.uid where postID = @id", Starter.GetConnection()); cmd.Parameters.Add(new SqlParameter("id", postID)); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { onePost = fillPostFromSQLDataReader(reader); } return(onePost); }
internal static Posts getAllPosts() { SqlCommand cmd = new SqlCommand("select * from Posts as p inner join Countries as c on p.cid = c.cid inner join Transport as t on p.tid = t.tid inner join Users as u on p.uid = u.uid;", Starter.GetConnection()); SqlDataReader reader = cmd.ExecuteReader(); Posts allPosts = new Posts(); //initialisiere lehre Liste while (reader.Read()) { Post onePost = fillPostFromSQLDataReader(reader); allPosts.Add(onePost); } return(allPosts); }
internal static Transports getAllTransports() { SqlCommand cmd = new SqlCommand("select t.tid, t.name, p.postID from Transport as t left join Posts as p on t.tid = p.tid", Starter.GetConnection()); SqlDataReader reader = cmd.ExecuteReader(); Transports allTransports = new Transports(); //initialisiere lehre Liste Transport currentObject = new Transport(); currentObject.transportID = 0; while (reader.Read()) { if (currentObject.transportID != reader.GetInt32(0)) { Transport oneTransport = new Transport(); currentObject = oneTransport; allTransports.Add(currentObject); currentObject.transportID = reader.GetInt32(0); currentObject.transportName = reader.GetString(1); } try { currentObject.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(allTransports); }
internal static Users getAllUsers() { SqlCommand cmd = new SqlCommand("select u.uid, u.username, p.postID from Users as u left join Posts as p on u.uid = p.uid", Starter.GetConnection()); SqlDataReader reader = cmd.ExecuteReader(); Users allUsers = new Users(); //initialisiere lehre Liste User currentObject = new User(); currentObject.uID = 0; while (reader.Read()) { if (currentObject.uID != reader.GetInt32(0)) { User oneUser = new User(); currentObject = oneUser; allUsers.Add(currentObject); currentObject.uID = reader.GetInt32(0); currentObject.userName = reader.GetString(1); } try { currentObject.postIDs.Add(reader.GetInt32(2)); } catch (Exception e) { } } return(allUsers); }