public static DataRowCollection ListTenantsAt(string tenantList)
{
// Hämtar ID till hyresgästen
var tenantIDLocation = GettingID.GettingTenantID(tenantList);
// Definierar en sökning
string sqlListTenants = $@"
Select * FROM Tenants
WHERE Location = @location
";
// Returnerar Rows från datatabellen som kommer ifrån sökningen
return(DBHandler.GetDataTable(sqlListTenants, "@location", tenantList).Rows);
}
public static DataRowCollection FindEntriesByLocation(string location)
{
var locationID = GettingID.GettingLocationID(location);
string sqlLocation = $@"
SELECT Dates.Date, Doors.Door, DoorCodes.DoorCode, Tenants.Tag, Tenants.Name
FROM Events
JOIN Dates ON Events.DateID = Dates.ID
JOIN Doors ON Events.DoorID=Doors.ID
JOIN DoorCodes ON Events.DoorcodeID=DoorCodes.ID
JOIN Tenants ON Events.TenantID=Tenants.ID
WHERE Events.DoorID = {locationID}
ORDER BY date
LIMIT {MaxEntries}
";
return(DBHandler.GetDataTable(sqlLocation)?.Rows);
}
public static DataRowCollection FindEntriesByTag(string tag)
{
// Hämtar ID till taggen
var tagID = GettingID.GettingTagID(tag);
// Definierar en sökning
string sqlTag = $@"
SELECT Dates.Date, Doors.Door, DoorCodes.DoorCode, Tenants.Tag, Tenants.Name
FROM Events
JOIN Dates ON Events.DateID = Dates.ID
JOIN Doors ON Events.DoorID=Doors.ID
JOIN DoorCodes ON Events.DoorcodeID=DoorCodes.ID
JOIN Tenants ON Events.TenantID=Tenants.ID
WHERE Events.TagID = {tagID}
ORDER BY date
LIMIT {MaxEntries}
";
// Returnerar Rows från datatabellen som kommer ifrån sökningen
return(DBHandler.GetDataTable(sqlTag)?.Rows);
}
