//////////// 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);
}
