public TblManagementUnitCollection FetchByQuery(Query qry) { var coll = new TblManagementUnitCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public TblManagementUnitCollection FetchAll() { var coll = new TblManagementUnitCollection(); var qry = new Query(TblManagementUnit.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static TblManagementUnitCollection GetTblManagementUnitCollection(string varPkSuid) { var cmd = new QueryCommand( "SELECT * FROM [dbo].[tbl_ManagementUnit] INNER JOIN [tbl_RolesForUsers] ON [tbl_ManagementUnit].[PK_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", Schema.Provider.Name); cmd.AddParameter("@FP_sBranchID", varPkSuid, DbType.String); IDataReader rdr = DataService.GetReader(cmd); var coll = new TblManagementUnitCollection(); coll.LoadAndCloseReader(rdr); return(coll); }