public static CommerceLibOrderInfo GetOrder(string orderID)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CommerceLibOrderGetInfo";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@OrderID";
param.Value = orderID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// obtain the results
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
DataRow orderRow = table.Rows[0];
// save the results into an CommerceLibOrderInfo object
CommerceLibOrderInfo orderInfo =
new CommerceLibOrderInfo(orderRow);
return orderInfo;
}
protected void processButton_Click(object sender, EventArgs e)
{
try
{
OrderProcessor processor = new OrderProcessor(orderIDBox.Text);
processor.Process();
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderIDBox.Text);
processResultLabel.Text = "Поръчката е обработена, статус:"
+ orderInfo.Status.ToString();
}
catch
{
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderIDBox.Text);
processResultLabel.Text =
"Има проблем с обработката на поръчката, статус: "
+ orderInfo.Status.ToString();
}
}
protected void goButton_Click(object sender, EventArgs e)
{
try
{
CommerceLibOrderInfo orderInfo = CommerceLibAccess.GetOrder(
orderIDBox.Text);
resultLabel.Text = "Order found.";
addressLabel.Text = orderInfo.CustomerAddressAsString.Replace(
"\n", "<br />");
creditCardLabel.Text = orderInfo.CreditCard.CardNumberX;
orderLabel.Text =
orderInfo.OrderAsString.Replace("\n", "<br />");
}
catch
{
resultLabel.Text = "No order found, or order is in old format.";
addressLabel.Text = "";
creditCardLabel.Text = "";
orderLabel.Text = "";
}
}
protected void processButton_Click(object sender, EventArgs e)
{
try
{
OrderProcessor processor = new OrderProcessor(orderIDBox.Text);
processor.Process();
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderIDBox.Text);
processResultLabel.Text = "Order processed, status now: "
+ orderInfo.Status.ToString();
}
catch
{
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderIDBox.Text);
processResultLabel.Text =
"Order processing error, status now: "
+ orderInfo.Status.ToString();
}
}
public static CommerceLibOrderInfo GetOrder(string orderID)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CommerceLibOrderGetInfo";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@OrderID";
param.Value = orderID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// obtain the results
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
DataRow orderRow = table.Rows[0];
// save the results into an CommerceLibOrderInfo object
CommerceLibOrderInfo orderInfo =
new CommerceLibOrderInfo(orderRow);
return(orderInfo);
}
protected void goButton_Click(object sender, EventArgs e)
{
try
{
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderIDBox.Text);
resultLabel.Text = "Поръчката е намерена.";
addressLabel.Text =
orderInfo.CustomerAddressAsString.Replace("\n", "<br />");
creditCardLabel.Text = orderInfo.CreditCard.CardNumberX;
orderLabel.Text = orderInfo.OrderAsString.Replace("\n", "<br />");
processButton.Enabled = true;
processResultLabel.Text = "";
}
catch
{
resultLabel.Text = "Не е намерена такава поръчка или е в стар формат.";
addressLabel.Text = "";
creditCardLabel.Text = "";
orderLabel.Text = "";
processButton.Enabled = false;
}
}
public OrderProcessor(CommerceLibOrderInfo orderToProcess)
{
// get order
Order = orderToProcess;
}
public OrderProcessor(string orderID)
{
// get order
Order = CommerceLibAccess.GetOrder(orderID);
}
// populate the form with data
private void PopulateControls()
{
// obtain order ID from the session
string orderId = Session["AdminOrderID"].ToString();
// obtain order info
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderId);
// populate labels and text boxes with order info
orderIdLabel.Text = "Displaying Order #" + orderId;
totalCostLabel.Text = String.Format("{0:c} ",
orderInfo.TotalCost);
dateCreatedTextBox.Text = orderInfo.DateCreated.ToString();
dateShippedTextBox.Text = orderInfo.DateShipped.ToString();
statusDropDown.SelectedIndex = orderInfo.Status;
authCodeTextBox.Text = orderInfo.AuthCode;
referenceTextBox.Text = orderInfo.Reference;
commentsTextBox.Text = orderInfo.Comments;
customerNameTextBox.Text = orderInfo.CustomerName;
shippingAddressTextBox.Text = orderInfo.CustomerAddressAsString;
shippingTypeTextBox.Text = orderInfo.Shipping.ShippingType;
customerEmailTextBox.Text = orderInfo.Customer.Email;
// Decide which one of the buttons should
// be enabled and which should be disabled
switch (orderInfo.Status)
{
case 8:
case 9:
// if the order was canceled or completed...
processOrderButton.Text = "Process Order";
processOrderButton.Enabled = false;
cancelOrderButton.Enabled = false;
break;
case 3:
// if the order is awaiting a stock check...
processOrderButton.Text = "Confirm Stock for Order";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
case 6:
// if the order is awaiting shipment...
processOrderButton.Text = "Confirm Order Shipment";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
default:
// otherwise...
processOrderButton.Text = "Process Order";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
}
// fill the data grid with order details
grid.DataSource = orderInfo.OrderDetails;
grid.DataBind();
// fill the audit data grid with audit trail
auditGrid.DataSource = orderInfo.AuditTrail;
auditGrid.DataBind();
}
public OrderProcessor(CommerceLibOrderInfo orderToProcess)
{
// get order
Order = orderToProcess;
}
public OrderProcessor(string orderID)
{
// get order
Order = CommerceLibAccess.GetOrder(orderID);
}
// populate the form with data
private void PopulateControls(string orderId)
{
// obtain order info
CommerceLibOrderInfo orderInfo =
CommerceLibAccess.GetOrder(orderId);
// populate labels and text boxes with order info
orderIdLabel.Text = "Показване на поръчка #" + orderId;
totalAmountLabel.Text = String.Format("{0:c} ", orderInfo.TotalCost);
dateCreatedTextBox.Text = orderInfo.DateCreated.ToString();
dateShippedTextBox.Text = orderInfo.DateShipped.ToString();
statusDropDown.SelectedIndex = orderInfo.Status;
authCodeTextBox.Text = orderInfo.AuthCode;
referenceTextBox.Text = orderInfo.Reference;
commentsTextBox.Text = orderInfo.Comments;
customerNameTextBox.Text = orderInfo.CustomerName;
shippingAddressTextBox.Text = orderInfo.CustomerAddressAsString;
shippingTypeTextBox.Text = orderInfo.Shipping.ShippingType;
customerEmailTextBox.Text = orderInfo.Customer.Email;
// Decide which one of the buttons should
// be enabled and which should be disabled
switch (orderInfo.Status)
{
case 8:
case 9:
// if the order was canceled or completed...
processOrderButton.Text = "Изпращане на поръчка";
processOrderButton.Enabled = false;
cancelOrderButton.Enabled = false;
break;
case 3:
// if the order is awaiting a stock check...
processOrderButton.Text = "Потвърждение за наличност";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
case 6:
// if the order is awaiting shipment...
processOrderButton.Text = "Потвърждаване на изпращане на поръчката";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
default:
// otherwise...
processOrderButton.Text = "Изпращане на поръчка";
processOrderButton.Enabled = true;
cancelOrderButton.Enabled = true;
break;
}
// fill the data grid with order details
grid.DataSource = orderInfo.OrderDetails;
grid.DataBind();
// fill the audit data grid with audit trail
auditGrid.DataSource = orderInfo.AuditTrail;
auditGrid.DataBind();
// show status items
statusDropDown.Items.Clear();
for (int i = 0; i < CommerceLibAccess.OrderStatuses.Length; i++)
{
statusDropDown.Items.Add(
new ListItem(CommerceLibAccess.OrderStatuses[i], i.ToString()));
}
statusDropDown.SelectedIndex = orderInfo.Status;
}
