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