public static bool AddPickup(PickupDS.PickupTableRow pickup)
{
//
bool ret = false;
ret = App.Mediator.ExecuteNonQuery(USP_PICKUP_NEW, new object[] {
pickup.Rt_Date,
pickup.Driver,
pickup.Rt_Name,
pickup.RetnTime,
pickup.Customer_ID,
pickup.CustomerName,
pickup.CustType,
pickup.Address,
pickup.City,
pickup.State,
pickup.Zip,
pickup.OrderID,
pickup.ActOrdSize,
pickup.ActOrdLbs,
pickup.Unsched_PU,
pickup.Comments,
pickup.OrdTyp,
pickup.ActCmdty,
pickup.Depot
});
return(ret);
}
public static bool UpdatePickups(PickupDS pickups)
{
//
bool ret = false;
if (pickups.HasChanges())
{
PickupDS _pickups = (PickupDS)pickups.GetChanges(DataRowState.Modified);
for (int i = 0; i < _pickups.PickupTable.Rows.Count; i++)
{
PickupDS.PickupTableRow pickup = _pickups.PickupTable[i];
bool changed = UpdatePickup(pickup);
}
pickups.AcceptChanges();
}
ret = true;
return(ret);
}
public static bool UpdatePickup(PickupDS.PickupTableRow pickup)
{
//
bool ret = false;
ret = App.Mediator.ExecuteNonQuery(USP_PICKUP_UPDATE, new object[] {
pickup.RecordID,
pickup.Driver,
pickup.Rt_Name,
pickup.Customer_ID,
pickup.CustomerName,
pickup.CustType,
pickup.Address,
pickup.City,
pickup.State,
pickup.Zip,
pickup.ActOrdSize,
pickup.ActOrdLbs,
pickup.Unsched_PU,
pickup.Comments,
pickup.ActCmdty
});
return(ret);
}
public Pickup(PickupDS.PickupTableRow pickup)
{
//Constructor
try {
if (pickup != null)
{
if (!pickup.IsIDNull())
{
this._id = pickup.ID;
}
if (!pickup.IsClientNumberNull())
{
this._clientnumber = pickup.ClientNumber.Trim();
}
if (!pickup.IsDivisionNumberNull())
{
this._divisionnumber = pickup.DivisionNumber.Trim();
}
if (!pickup.IsClientNameNull())
{
this._clientname = pickup.ClientName.Trim();
}
if (!pickup.IsShipperNumberNull())
{
this._shippernumber = pickup.ShipperNumber.Trim();
}
if (!pickup.IsShipperNameNull())
{
this._shippername = pickup.ShipperName.Trim();
}
if (!pickup.IsPickUpDateNull())
{
this._pickupdate = pickup.PickUpDate;
}
if (!pickup.IsPickupNumberNull())
{
this._pickupnumber = pickup.PickupNumber;
}
if (!pickup.IsFreightTypeNull())
{
this._freighttype = pickup.FreightType.Trim();
}
if (!pickup.IsTDSNumberNull())
{
this._tdsnumber = pickup.TDSNumber;
}
if (!pickup.IsVendorKeyNull())
{
this._vendorkey = pickup.VendorKey.Trim();
}
if (!pickup.IsTrailerNumberNull())
{
this._trailernumber = pickup.TrailerNumber.Trim();
}
if (!pickup.IsSealNumberNull())
{
this._sealnumber = pickup.SealNumber.Trim();
}
}
}
catch (Exception ex) { throw new ApplicationException("", ex); }
}
