private void GetIdAndOrderDate(OrderStatusRequest request, OrderStatusResult result)
{
using (var cmd = new SqlCommand("usp_GetOrderDateAndID", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 255) {Value = request.OrderNumber});
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
id = reader.GetInt32(OrderIdOrdinal);
result.OrderDate = reader.GetDateTime(OrderedDateOrdinal);
}
reader.Close();
}
}
public async Task Consume(ConsumeContext <CheckOrderStatus> context)
{
int orderId = Convert.ToInt32(context.Message.OrderId);
OrderStatusResult orderStatusResult = new OrderStatusResult();
if (orderId % 2 == 0)
{
orderStatusResult.StatusText = "Failed";
}
else
{
orderStatusResult.StatusText = "OK";
}
await context.RespondAsync <OrderStatusResult>(orderStatusResult);
}
private void DisplayRequestOrderStatusResults(OrderStatusResult result)
{
var itemStatuses = result.ItemStatuses;
textOrderStatusLineItemId1.Text = itemStatuses[0].OrderlineItemId;
textOrderStatusProductId1.Text = itemStatuses[0].ProductIdentifier;
textOrderStatusQty1.Text = Convert.ToString(itemStatuses[0].QtyOrdered);
if (itemStatuses.Count < 2)
{
return;
}
textOrderStatusLineItemId2.Text = itemStatuses[1].OrderlineItemId;
textOrderStatusProductId2.Text = itemStatuses[1].ProductIdentifier;
textOrderStatusQty2.Text = Convert.ToString(itemStatuses[1].QtyOrdered);
if (itemStatuses.Count < 3)
{
return;
}
textOrderStatusLineItemId3.Text = itemStatuses[2].OrderlineItemId;
textOrderStatusProductId3.Text = itemStatuses[2].ProductIdentifier;
textOrderStatusQty3.Text = Convert.ToString(itemStatuses[2].QtyOrdered);
if (itemStatuses.Count < 4)
{
return;
}
textOrderStatusLineItemId4.Text = itemStatuses[3].OrderlineItemId;
textOrderStatusProductId4.Text = itemStatuses[3].ProductIdentifier;
textOrderStatusQty4.Text = Convert.ToString(itemStatuses[3].QtyOrdered);
if (itemStatuses.Count < 5)
{
return;
}
textOrderStatusLineItemId5.Text = itemStatuses[4].OrderlineItemId;
textOrderStatusProductId5.Text = itemStatuses[4].ProductIdentifier;
textOrderStatusQty5.Text = Convert.ToString(itemStatuses[4].QtyOrdered);
}
private void GetIdAndOrderDate(OrderStatusRequest request, OrderStatusResult result)
{
using (var cmd = new SqlCommand("usp_GetOrderDateAndID", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 255)
{
Value = request.OrderNumber
});
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
id = reader.GetInt32(OrderIdOrdinal);
result.OrderDate = reader.GetDateTime(OrderedDateOrdinal);
}
reader.Close();
}
}
public OrderStatusResult GetOrderStatus(OrderStatusRequest request)
{
var result = new OrderStatusResult();
try
{
GetIdAndOrderDate(request, result);
result.ItemStatuses = GetLineItemStatuses(id);
}
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 OrderStatusResult GetOrderStatus(OrderStatusRequest request)
{
var result = new OrderStatusResult();
try
{
GetIdAndOrderDate(request, result);
result.ItemStatuses = GetLineItemStatuses(id);
}
catch (SqlException ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSqlException(ex);
}
catch (Exception ex)
{
result.HasException = true;
result.Exception = ExceptionFactory.BuildSystemException(ex);
}
return result;
}
