public static List <VotesInfo> All(string type) { using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); cmd.CommandText = "SELECT * FROM votes"; using SQLiteDataReader rdr = cmd.ExecuteReader(); List <VotesInfo> votes = new List <VotesInfo>(); while (rdr.Read()) { VotesInfo vote = new VotesInfo() { voteId = rdr.GetInt32(0), studentId = rdr.GetInt32(1), upvotes = rdr.GetBoolean(2), description = rdr.GetString(3), creationDate = rdr.GetInt32(4), active = rdr.GetBoolean(5) }; votes.Add(vote); } return(votes); }
/// <summary> /// Get all votes of the specified student of the given type (upvote = true, downvote = false) /// </summary> /// <param name="studentId"></param> /// <param name="type">type of votes (upvote = true, downvote = false)</param> /// <returns></returns> public static List <VotesInfo> AllFromStudentId(int studentId, bool type) { using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); cmd.CommandText = $"SELECT * FROM votes WHERE studentId = {studentId} AND upvotes = {type}"; using SQLiteDataReader rdr = cmd.ExecuteReader(); List <VotesInfo> votesList = new List <VotesInfo>(); while (rdr.Read()) { VotesInfo voteInfo = new VotesInfo() { voteId = rdr.GetInt32(0), studentId = rdr.GetInt32(1), upvotes = rdr.GetBoolean(2), description = rdr.GetString(3), creationDate = rdr.GetInt32(4), active = rdr.GetBoolean(5) }; votesList.Add(voteInfo); } rdr.Close(); return(votesList); }