public DataTable FilteredData(PatientLogModel db, DateTime start, DateTime end, List <string> users, List <string> hospitals, List <string> types, bool rounding)
{
//DbDataAdapter da = Db.CreateDataAdapter("SELECT * FROM [event] WHERE NOT (([eventend] <= @start) OR ([eventstart] >= @end))");
//Db.AddParameterWithValue(da.SelectCommand, "start", start);
//Db.AddParameterWithValue(da.SelectCommand, "end", end);
DataTable dt = new DataTable();
dt = DataCollections.getScheduleWorkArea(db, start, end, users, hospitals, types, rounding);
return(dt);
}