private void DisplayShippingInfoResults(ShippingInfoResult result)
{
var stringType = Type.GetType("System.String");
var dateTimeType = Type.GetType("System.DateTime");
var displayTable = new DataTable();
// ReSharper disable AssignNullToNotNullAttribute
displayTable.Columns.Add(new DataColumn("OrderLineItemID", stringType));
displayTable.Columns.Add(new DataColumn("Carrier", stringType));
displayTable.Columns.Add(new DataColumn("ShipDate", dateTimeType));
displayTable.Columns.Add(new DataColumn("TrackingNumber", stringType));
displayTable.Columns.Add(new DataColumn("TrackingURL", stringType));
// ReSharper restore AssignNullToNotNullAttribute
foreach (var itemTracking in result.Manifests)
{
var newRow = displayTable.NewRow();
newRow[0] = itemTracking.OrderLineItemId;
newRow[1] = itemTracking.Carrier;
newRow[2] = itemTracking.ShipDate;
newRow[3] = itemTracking.TrackingNumber;
newRow[4] = itemTracking.TrackingUrl;
displayTable.Rows.Add(newRow);
}
dataGridViewShippingStatus.DataSource = displayTable;
}
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 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;
}
