public static ShippingInfoResult RequestShippingInformation(ShippingInfoRequest infoRequest)
{
var channel = new ChannelFactory <IOrderProcessing>("*").CreateChannel();
var result = channel.GetShippingRequest(infoRequest);
return(result);
}
public ShippingInfoResult GetShippingInfo(ShippingInfoRequest request)
{
var result = new ShippingInfoResult();
try
{
using (var cmd = new SqlCommand("usp_GetShippingInfoByDateRange", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime)
{
Value = request.StartDate
});
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime)
{
Value = request.EndDate
});
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
result.Manifests = new List <ItemTracking>();
while (reader.Read())
{
var itemStatus = new ItemTracking
{
OrderLineItemId = reader.GetString(OrderLineItemIdOrdinal),
Carrier = reader.GetString(CarrierOrdinal),
ShipDate = reader.GetDateTime(ShipDateOrdinal),
TrackingNumber = reader.GetString(TrackingNumberOrdinal),
TrackingUrl = reader.GetString(TrackingUrlOrdinal)
};
result.Manifests.Add(itemStatus);
}
}
else
{
// TODO: Throw an exception indicating no rows were returned.
}
}
}
catch (SqlException ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSqlException(ex);
}
catch (Exception ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSystemException(ex);
}
return(result);
}
public static ShippingInfoResult RequestShippingInformation(ShippingInfoRequest infoRequest)
{
//var binding = new WSHttpBinding();
//var address = new EndpointAddress(@"http://*****:*****@"net.tcp://localhost:8080/OrderProcessingService");
var factory = new ChannelFactory <IOrderProcessing>(binding, address);
var channel = factory.CreateChannel();
var result = channel.GetShippingRequest(infoRequest);
return(result);
}
public ShippingInfoResult GetShippingInfo(ShippingInfoRequest request)
{
var result = new ShippingInfoResult();
try
{
using (var cmd = new SqlCommand("usp_GetShippingInfoByDateRange", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime) {Value = request.StartDate});
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime) {Value = request.EndDate});
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
result.Manifests = new List<ItemTracking>();
while (reader.Read())
{
var itemStatus = new ItemTracking
{
OrderLineItemId = reader.GetString(OrderLineItemIdOrdinal),
Carrier = reader.GetString(CarrierOrdinal),
ShipDate = reader.GetDateTime(ShipDateOrdinal),
TrackingNumber = reader.GetString(TrackingNumberOrdinal),
TrackingUrl = reader.GetString(TrackingUrlOrdinal)
};
result.Manifests.Add(itemStatus);
}
}
else
{
// TODO: Throw an exception indicating no rows were returned.
}
}
}
catch (SqlException ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSqlException(ex);
}
catch (Exception ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSystemException(ex);
}
return result;
}
private void buttonRequestShippingInfo_Click(object sender, EventArgs e)
{
var startDate = dateTimeStartDate.Value.Date;
var endDate = dateTimeEndDate.Value.Date;
var shipInfoRequest = new ShippingInfoRequest {
StartDate = startDate, EndDate = endDate
};
var result = ServiceCommuincation.RequestShippingInformation(shipInfoRequest);
if (!result.HasException)
{
DisplayShippingInfoResults(result);
}
}
public ShippingInfoResult GetShippingRequest(ShippingInfoRequest request)
{
var requestor = new GetShippingRequestHandler(connectString);
return(requestor.GetShippingInfo(request));
}
