internal List <Order> getUserOrders(String username)
{
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
List <Order> userOrders = new List <Order>();
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT * FROM [ORDERS] INNER JOIN [USERS] ON [USERS].user_id = [ORDERS].user_id WHERE [USERS].username = @username";
cmd.CommandText = select;
cmd.Parameters.Add("username", OleDbType.VarChar, 255).Value = username;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Order userOrder = new Order();
userOrder.setOrderIdForOrderOnly((int)reader["order_id"]);
userOrder.setUserId((int)reader["Orders.user_id"]);
userOrder.setValidated((bool)reader["validated"]);
userOrder.setIsCollctOnDelivery((bool)reader["collect_on_delivery"]);
userOrder.setCompleted((bool)reader["completed"]);
userOrder.setPaymentAmount(Double.Parse(reader["payment_amount"].ToString(), NumberStyles.Currency));
userOrder.setPaymentInformation(PaymentManager.getUserCreditCard((int)reader["payment_id"]));
userOrder.setOrderItems(getOrderItems(userOrder.getOrderId()));
userOrders.Add(userOrder);
}
return(userOrders);
}
catch (OleDbException ex)
{
userOrders = null;
return(userOrders);
}
finally
{
sqlconn.Close();
}
}
}
private void loadSingleOrder(int viewOrderId)
{
OrderManager businessLayer = new OrderManager();
cisseniorproject.dataobjects.Order order = businessLayer.getOrder(viewOrderId);
lblUserId.Text = order.getUserId().ToString();
lblUsername.Text = order.getPaymentInformation().getUser().getUsername();
lblFirstName.Text = order.getPaymentInformation().getUser().getFirstName();
lblLastName.Text = order.getPaymentInformation().getUser().getLastName();
lblAddress.Text = order.getPaymentInformation().getUser().getAddress();
lblCity.Text = order.getPaymentInformation().getUser().getCity();
lblState.Text = order.getPaymentInformation().getUser().getState();
lblZipCode.Text = order.getPaymentInformation().getUser().getZipCode();
lblAccountCreationDate.Text = order.getPaymentInformation().getUser().getAccountCreationDate().ToShortDateString();
lblEmail.Text = order.getPaymentInformation().getUser().getEamil();
lblCreditCardType.Text = order.getPaymentInformation().getCreditCardType();
lblCreditCardNumber.Text = order.getPaymentInformation().getCreditCardNumber();
lblCardCity.Text = order.getPaymentInformation().getCity();
lblCardState.Text = order.getPaymentInformation().getState();
lblCardExpDate.Text = order.getPaymentInformation().getCardExpDate().ToShortDateString();
lblCardSecurityCode.Text = order.getPaymentInformation().getSecurityCode();
lblOrderId.Text = order.getOrderId().ToString();
lblOrderUserId.Text = order.getUserId().ToString();
cbIsValidated.Checked = order.isOrderValidated();
cbIsCompleted.Checked = order.isOrderCompleted();
cbIsCollectOnDelivery.Checked = order.getCollectOnDelivery();
lblPaymentAmount.Text = String.Format("{0:C}", order.getPaymentAmount());
lblTotalOrderAmount.Text = String.Format("{0:C}", businessLayer.getOrderTotal());
lblAmountDue.Text = String.Format("{0:C}", businessLayer.getAmountDue());
List <UserOrderItem> orderItems = businessLayer.getOrderItems(order);
rptOrderItems.DataSource = orderItems;
rptOrderItems.DataBind();
}
internal List<Order> getUserOrders(String username)
{
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
List<Order> userOrders = new List<Order>();
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT * FROM [ORDERS] INNER JOIN [USERS] ON [USERS].user_id = [ORDERS].user_id WHERE [USERS].username = @username";
cmd.CommandText = select;
cmd.Parameters.Add("username", OleDbType.VarChar, 255).Value = username;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Order userOrder = new Order();
userOrder.setOrderIdForOrderOnly((int)reader["order_id"]);
userOrder.setUserId((int)reader["Orders.user_id"]);
userOrder.setValidated((bool)reader["validated"]);
userOrder.setIsCollctOnDelivery((bool)reader["collect_on_delivery"]);
userOrder.setCompleted((bool)reader["completed"]);
userOrder.setPaymentAmount(Double.Parse(reader["payment_amount"].ToString(), NumberStyles.Currency));
userOrder.setPaymentInformation(PaymentManager.getUserCreditCard((int)reader["payment_id"]));
userOrder.setOrderItems(getOrderItems(userOrder.getOrderId()));
userOrders.Add(userOrder);
}
return userOrders;
}
catch (OleDbException ex)
{
userOrders = null;
return userOrders;
}
finally
{
sqlconn.Close();
}
}
}