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.getSchedule(db, start, end, users, hospitals, types, rounding); return(dt); }