public DataTable GetUserList() { Postgre db = new Postgre(); DataTable dt = new DataTable(); string sql = "SELECT * FROM person WHERE isadmin = false"; dt = db.Select(sql); return(dt); }
public DataTable GetExam(string user) { Postgre db = new Postgre(); DataTable dt = new DataTable(); // Dictionary to send parameters in format key-value Dictionary <string, string> myParams = new Dictionary <string, string>(); myParams.Add("@uname", user); string sql = "select distinct on (\"username\") * from examresult WHERE username = @uname ORDER BY username, date DESC"; dt = db.Select(sql, myParams); return(dt); }
public DataTable AdmLogin() { Postgre db = new Postgre(); DataTable dt = new DataTable(); Dictionary <string, string> myParams = new Dictionary <string, string>(); myParams.Add("@username", Username); myParams.Add("@password", Password); // Sql query with parameters string sql = "SELECT * FROM person " + "WHERE username = @username AND " + "password = @password AND " + "isadmin = true"; dt = db.Select(sql, myParams); return(dt); }