public LTLShipmentDataset SearchLTLShipments(DateTime shipDateStart, DateTime shipDateEnd, string clientNumber, string shipperNumber, int consigneeNumber)
{
//
LTLShipmentDataset shipments = new LTLShipmentDataset();
LTLClientService2Client client = new LTLClientService2Client();
try {
if (clientNumber != null && clientNumber.Trim().Length > 0)
{
LTLSearch2 criteria = new LTLSearch2();
criteria.ShipDateStart = shipDateStart;
criteria.ShipDateEnd = shipDateEnd;
criteria.ClientNumber = clientNumber;
criteria.ShipperNumber = shipperNumber;
criteria.ConsigneeNumber = consigneeNumber;
DataSet ds = client.SearchLTLShipments(criteria);
if (ds != null && ds.Tables["LTLShipmentTable"] != null && ds.Tables["LTLShipmentTable"].Rows.Count > 0)
{
shipments.Merge(ds);
}
}
client.Close();
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException <LTLFault> dfe) { client.Abort(); throw new ApplicationException(dfe.Detail.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(shipments);
}
public DataSet SearchLTLShipments(LTLSearch2 criteria)
{
//
DataSet shipments = null;
try {
shipments = new DataService().FillDataset(SQL_CONNID, USP_SHIPMENTS_SEARCH, TBL_SHIPMENT,
new object[] {
criteria.ShipDateStart, criteria.ShipDateEnd,
criteria.ClientNumber,
(criteria.ShipperNumber != null && criteria.ShipperNumber.Trim().Length > 0 ? criteria.ShipperNumber : null),
(criteria.ConsigneeNumber > 0 ? criteria.ConsigneeNumber : null as object)
});
}
catch (Exception ex) { throw new ApplicationException(ex.Message, ex); }
return(shipments);
}
private void OnSearchClick(object sender, EventArgs e)
{
//
this.Cursor = Cursors.WaitCursor;
try {
this.grdSearch.Text = "Search Results for " + this.cboClient2.Text;
this.mSearch.Clear();
LTLSearch2 criteria = new LTLSearch2();
criteria.ShipDateStart = this.dtpShipDateStart.Value;
criteria.ShipDateEnd = this.dtpShipDateEnd.Value;
criteria.ClientNumber = this.cboClient2.SelectedValue.ToString();
criteria.ShipperNumber = this.cboShipper.SelectedValue.ToString();
criteria.ConsigneeNumber = (int)this.cboConsignee.SelectedValue;
this.mSearch.Merge(FreightGateway.SearchLTLShipments(criteria));
}
catch (Exception ex) { App.ReportError(ex, true, LogLevel.Error); }
finally { setUserServices(); this.Cursor = Cursors.Default; }
}
public static FreightDataset SearchLTLShipments(LTLSearch2 criteria)
{
//
FreightDataset shipments = new FreightDataset();
LTLAdminService2Client client = new LTLAdminService2Client();
try {
DataSet ds = client.SearchLTLShipmentsForAdmin(criteria);
if (ds != null && ds.Tables["LTLShipmentTable"] != null && ds.Tables["LTLShipmentTable"].Rows.Count > 0)
{
shipments.Merge(ds);
}
client.Close();
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException <LTLFault> dfe) { client.Abort(); throw new ApplicationException(dfe.Detail.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(shipments);
}
