public MasterDetailItemCollection FetchByQuery(Query qry) { MasterDetailItemCollection coll = new MasterDetailItemCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static MasterDetailItem GetResource(int moduleId, string cultureCode) { MasterDetailItemCollection itemResL = new MasterDetailItemCollection() .Where(MasterDetailItem.Columns.ModuleId, moduleId) .Where(MasterDetailItem.Columns.Culture, cultureCode) .Load(); if (null == itemResL || itemResL.Count == 0) { return(null); } else { return(itemResL[0]); } }
public MasterDetailItemCollection FetchAll() { MasterDetailItemCollection coll = new MasterDetailItemCollection(); Query qry = new Query(MasterDetailItem.Schema); // Begin Bayshore custom code block (rread 6/26/07) // Ignore records marked for deletion when doing a FetchAll if (MasterDetailItem.Schema.GetColumn("IsDeleted") != null) { qry.WHERE("IsDeleted <> true"); } else if (MasterDetailItem.Schema.GetColumn("Deleted") != null) { qry.WHERE("Deleted <> true"); } // End Bayshore custom code block coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public MasterDetailItemCollection FetchByID(object Id) { MasterDetailItemCollection coll = new MasterDetailItemCollection().Where("Id", Id).Load(); return(coll); }