//////////// Accounts / Permissions Tables public void CreateDefaultFSGAdminAccount() { string login = "******"; string password = FSManager.HashString("fsg1100"); UserPermission up = PullPermissionByLevel(99); NewAccount(login, password, up.DatabaseID, "FSG", "Admin"); }
public Booking PullNextBooking(string mac) { Booking b = null; long now = FSManager.GetSeconds(DateTime.Now); string query = "SELECT * FROM " + bookTbl + " WHERE " + bookTblV[1] + "='" + mac + "' AND " + bookTblV[2] + ">=" + now + " ORDER BY " + bookTblV[0] + " DESC LIMIT 1"; SQLiteDataReader dr = ReadExe(query); while (dr.Read()) { b = new Booking(Convert.ToInt32((long)dr[bookTblV[0]]), (string)dr[bookTblV[7]], (long)dr[bookTblV[2]], (long)dr[bookTblV[3]], (string)dr[bookTblV[4]], Convert.ToInt32((long)dr[bookTblV[5]]), Convert.ToInt32((long)dr[bookTblV[6]]), (string)dr[bookTblV[1]]); } dbc.Close(); return(b); }