//Returns DataTable showing all tenants in a location
public DataTable ListTenantsAt(string location)
{
//string sql = "SELECT Tenants.tenant, Tenants.Location, Tenants.Tag FROM Tenants WHERE Tenants.Location = '@Loction'", "@Location", location;
string sql = @"SELECT Tenants.tenant, Tenants.Location, Tenants.Tag FROM Tenants WHERE Tenants.Location = @Location";
DataTable data = DatabaseCommunication.GetDataTable(sql, "@Location", location);
return(data);
}
//Returns DataTable showing all entries by event in LogEntry
public DataTable FindEntriesByEvent(string eventInput)
{
string sql = @"SELECT LogEntry.Date, LogEntry.Door, LogEntry.Tag, LogEntry.Event,
Tenants.Location, Tenants.Tenant
FROM LogEntry
JOIN Tenants ON LogEntry.Tag=Tenants.Tag
WHERE LogEntry.Event LIKE @EventInput
ORDER BY LogEntry.Date DESC
LIMIT " + maxEntries + "";
DataTable data = DatabaseCommunication.GetDataTable(sql, "@EventInput", "%" + eventInput + "%");
return(data);
}
//Returns DataTable showing all entries by tag in LogEntry
public DataTable FindEntriesByTag(string tag)
{
string sql = @"SELECT LogEntry.Date, LogEntry.Door, LogEntry.Tag, LogEntry.Event,
Tenants.Location, Tenants.Tenant
FROM LogEntry
JOIN Tenants ON LogEntry.Tag=Tenants.Tag
WHERE Tenants.Tag LIKE @Tag
ORDER BY LogEntry.Date DESC
LIMIT " + maxEntries + "";
DataTable data = DatabaseCommunication.GetDataTable(sql, "@Tag", "%" + tag + "%");
return(data);
}
