public OrderTableCollection FetchAll() { OrderTableCollection coll = new OrderTableCollection(); Query qry = new Query(OrderTable.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
protected void update_ordertable_eta(int portid, int vesselid, DateTime?dteta) { try { SubSonic.SqlQuery _qry = DB.Select().From(DAL.Logistics.Tables.OrderTable).Where("DestinationPortID").IsEqualTo(portid).And("VesselID").IsEqualTo(vesselid); OrderTableCollection _orders = new OrderTableCollection(); _orders.LoadAndCloseReader(_qry.ExecuteReader()); if (_orders.Count > 0) { for (int _ix = 0; _ix < _orders.Count; _ix++) { _orders[_ix].Eta = dteta; _orders[_ix].VesselLastUpdated = DateTime.Now; } _orders.BatchSave(); //this.dxlblInfo.Text = string.Format("{0} Orders have been updated", _orders.Count.ToString()); //this.dxpnlMsg.Visible = true; } } catch (Exception ex) { string _err = ex.Message.ToString(); //this.dxlblErr.Text = _err; //this.dxpnlErr.Visible = true; } }
public OrderTableCollection FetchByQuery(Query qry) { OrderTableCollection coll = new OrderTableCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public OrderTableCollection FetchAll() { OrderTableCollection coll = new OrderTableCollection(); Query qry = new Query(OrderTable.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
protected void update_ordertable_eta(int portid, int vesselid, DateTime? dteta) { try { SubSonic.SqlQuery _qry = DB.Select().From(DAL.Logistics.Tables.OrderTable).Where("DestinationPortID").IsEqualTo(portid).And("VesselID").IsEqualTo(vesselid); OrderTableCollection _orders = new OrderTableCollection(); _orders.LoadAndCloseReader(_qry.ExecuteReader()); if (_orders.Count > 0) { for (int _ix = 0; _ix < _orders.Count; _ix++) { _orders[_ix].Eta = dteta; _orders[_ix].VesselLastUpdated = DateTime.Now; } _orders.BatchSave(); //this.dxlblInfo.Text = string.Format("{0} Orders have been updated", _orders.Count.ToString()); //this.dxpnlMsg.Visible = true; } } catch (Exception ex) { string _err = ex.Message.ToString(); //this.dxlblErr.Text = _err; //this.dxpnlErr.Visible = true; } }
public OrderTableCollection FetchByQuery(Query qry) { OrderTableCollection coll = new OrderTableCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }