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