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;
}