public ShiftCollection FetchByQuery(Query qry) { ShiftCollection coll = new ShiftCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public ShiftCollection FetchAll() { ShiftCollection coll = new ShiftCollection(); Query qry = new Query(Shift.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static AVManager.DAL.ShiftCollection GetShiftCollection(int varEmployeeID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM Shift INNER JOIN EmployeeDepartmentHistory ON " + "Shift.ShiftID=EmployeeDepartmentHistory.ShiftID WHERE EmployeeDepartmentHistory.EmployeeID=@EmployeeID", Employee.Schema.Provider.Name); cmd.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); ShiftCollection coll = new ShiftCollection(); coll.LoadAndCloseReader(rdr); return(coll); }