public DeliverySubSubTableCollection FetchAll()
 {
     DeliverySubSubTableCollection coll = new DeliverySubSubTableCollection();
     Query qry = new Query(DeliverySubSubTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
    protected void bind_formview(string mode)
    {
        //have to use a collection as formview needs to bind to enumerable
        DeliverySubSubTableCollection _tbl = new DeliverySubSubTableCollection();

        if (mode != "Insert")
        {
            int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
            DeliverySubSubTable _ct = new DeliverySubSubTable(_pid);
            _tbl.Add(_ct);
            this.fmvDimensions.DataSource = _tbl;
            this.fmvDimensions.DataBind();
        }
        else //there's no insert option on this form it's jsut fer editting book/cartrton dimension
        {
            this.dxlblErr.Text          = "This option is not available";
            this.dxpnlErr.ClientVisible = true;
        }
    }
 public DeliverySubSubTableCollection FetchByQuery(Query qry)
 {
     DeliverySubSubTableCollection coll = new DeliverySubSubTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public DeliverySubSubTableCollection FetchByID(object SubDeliveryID)
 {
     DeliverySubSubTableCollection coll = new DeliverySubSubTableCollection().Where("SubDeliveryID", SubDeliveryID).Load();
     return coll;
 }
 public DeliverySubSubTableCollection FetchByOrderNumber(object OrderNumber)
 {
     DeliverySubSubTableCollection coll = new DeliverySubSubTableCollection().Where("OrderNumber", OrderNumber).Load();
     return coll;
 }
 protected void bind_formview(string mode)
 {
     //have to use a collection as formview needs to bind to enumerable
     DeliverySubSubTableCollection _tbl = new DeliverySubSubTableCollection();
     if (mode != "Insert")
     {
         int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
         DeliverySubSubTable  _ct = new DeliverySubSubTable(_pid);
         _tbl.Add(_ct);
         this.fmvDimensions.DataSource = _tbl;
         this.fmvDimensions.DataBind();
 
     }
     else //there's no insert option on this form it's jsut fer editting book/cartrton dimension
     {
         this.dxlblErr.Text = "This option is not available";
         this.dxpnlErr.ClientVisible = true;
     }
 }