public DespatchNoteItemCollection FetchAll()
 {
     DespatchNoteItemCollection coll = new DespatchNoteItemCollection();
     Query qry = new Query(DespatchNoteItem.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public DespatchNoteItemCollection FetchByQuery(Query qry)
 {
     DespatchNoteItemCollection coll = new DespatchNoteItemCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public DespatchNoteItemCollection FetchByID(object ItemId)
 {
     DespatchNoteItemCollection coll = new DespatchNoteItemCollection().Where("item_id", ItemId).Load();
     return coll;
 }