/// <summary> /// Updates the Order Data with respect to the desired shipping details. /// </summary> /// <param name="orderCL">OrderCL class containing Order Description and Status</param> /// <returns>OrderCL class returning all the fields in the updated Order.</returns> public OrderCL updateShippingDetails(OrderCL orderCL) { Order query = (from x in dbcontext.Orders where x.Id == orderCL.id && x.IsDeleted == false select x).FirstOrDefault(); query.Description = orderCL.description; query.StatusId = orderCL.statusId; dbcontext.SaveChanges(); OrderCL newOrderCL = new OrderCL() { id = query.Id, addressId = query.AddressId, cartId = query.CartId, dateCreated = query.DateCreated, dateModified = query.DateModified, description = query.Description, isDeleted = query.IsDeleted, shippingCharge = query.ShippingCharge.ToString(), statusId = query.StatusId, taxAmount = query.TaxAmount, totalAmount = query.TotalAmount, orderNumber = query.OrderNumber, }; return(newOrderCL); }
//private OrderGridCL ConvertOrderToGrid(OrderCL activeOrders) //{ // string addressType = ""; // int addressTypeId = addressBLL.getAddressById(activeOrders.addressId).addressTypeId; // if(addressTypeId==0) // { // addressType = "Shipping Address"; // } // if(addressTypeId==1) // { // addressType = "Billing Address"; // } // if(addressTypeId==2) // { // addressType = "Permanent Address"; // } // OrderGridCL activeOrderDetails = new OrderGridCL() // { // addressLine1 = addressBLL.getAddressById(activeOrders.addressId).addressLine1, // addressLine2 = addressBLL.getAddressById(activeOrders.addressId).addressLine2, // addressLine3 = addressBLL.getAddressById(activeOrders.addressId).addressLine3, // address = addressBLL.getAddressById(activeOrders.addressId).addressLine1 + "," + addressBLL.getAddressById(activeOrders.addressId).addressLine2 + "," + addressBLL.getAddressById(activeOrders.addressId).addressLine3 + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).cityName + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).stateName + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).countryName + ",", // addressType = addressType, // cityId = addressBLL.getAddressById(activeOrders.addressId).cityId, // country = addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).countryName, // dateCreated = activeOrders.dateCreated, // dateModified = activeOrders.dateModified, // id = activeOrders.id, // isDeleted = activeOrders.isDeleted, // memberName = cartBLL.getMemberbyCartId(activeOrders.cartId).name, // orderStatus = addressBLL.getStatusById(activeOrders.statusId).name, // productName = cartBLL.getProductbyCartId(activeOrders.cartId).name, // productQty = cartBLL.getCartProductByCartId(activeOrders.cartId).quantity.ToString(), // shippingCharge = activeOrders.shippingCharge, // shippingDescription = activeOrders.description, // stateId = addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).stateId, // taxAmt = activeOrders.taxAmount, // totalAmt = activeOrders.totalAmount, // }; // return activeOrderDetails; //} protected void btnUpdate_Click(object sender, EventArgs e) { OrderCL orderCL = new OrderCL(); orderCL.id = id; orderCL.description = txtShippingDescription.Text; orderCL.statusId = Convert.ToInt32(ddlShippingStatus.SelectedValue); OrderBLL orderBLL = new OrderBLL(); OrderCL newOrderCL = orderBLL.updateShippingDetails(orderCL); txtShippingDescription.Text = newOrderCL.description; ddlShippingStatus.SelectedValue = newOrderCL.statusId.ToString(); }
protected void Page_Load(object sender, EventArgs e) { int orderId = Convert.ToInt32(Request.QueryString["id"]); id = orderId; if (!IsPostBack) { OrderBLL orderBLL = new OrderBLL(); OrderCL orderCL = orderBLL.getOrderById(orderId); UpdateOrderGridCL ordergridCL = ConvertOrderToGrid(orderCL); string memberIsGuest = ordergridCL.memberIsGuest ? "Is Guest" : "Member";; string memberGender = ordergridCL.memberGender ? "Is Male" : "Is Female"; string dateJoining = ordergridCL.memberJoinDate.Date.ToString("d"); string dateModified = ordergridCL.memberModifiedDate.Date.ToString("d"); lblMemberDetails.Text = ordergridCL.memberName + " , " + memberIsGuest + " , " + memberGender + " , " + ordergridCL.memberMobNo + Environment.NewLine + ordergridCL.memberAddress + "<br />" + "Member Joining Date" + " - " + dateJoining + "<br />" + "Member Update Date" + " - " + dateModified; lblPaymentDetails.Text = ""; ddlShippingStatus.SelectedValue = orderBLL.getOrderById(orderId).statusId.ToString(); txtShippingDescription.Text = orderBLL.getOrderById(orderId).description; string[] productName = ordergridCL.productName.Split(';'); string[] productDispatchTime = ordergridCL.productDispatchTime.Split(';'); string[] productQty = ordergridCL.productQty.Split(';'); string[] productPrice = ordergridCL.productPrice.Split(';'); string[] productShippingCharge = ordergridCL.productShippingCharge.Split(';'); string[] productId = ordergridCL.productId.Split(';'); int productCount = ordergridCL.productCount; Collection <UpdateProductGridCL> productUpdateInGrid = new Collection <UpdateProductGridCL>(); for (int i = 0; i < productCount; i++) { productUpdateInGrid.Add(new UpdateProductGridCL { productDispatchTime = productName[i], productId = productId[i], productName = productName[i], productPrice = productPrice[i], productQty = productQty[i], productShippingCharge = productShippingCharge[i], }); } grdUpdateOrders.DataSource = productUpdateInGrid; grdUpdateOrders.DataBind(); } }
/// <summary> /// Fetchs the all the orders containing Order CL class by Cart Id. /// </summary> /// <param name="cartId">Cart Id provided to get Order CL class for it.</param> /// <returns>Order CL class having orderId provided.</returns> public OrderCL getOrderByCartId(int cartId) { Order query = (from x in dbcontext.Orders where x.CartId == cartId select x).FirstOrDefault(); OrderCL orderCL = new OrderCL() { addressId = query.AddressId, cartId = query.CartId, dateCreated = query.DateCreated, dateModified = query.DateModified, description = query.Description, id = query.Id, isDeleted = query.IsDeleted, shippingCharge = query.ShippingCharge.ToString(), statusId = query.StatusId, taxAmount = query.TaxAmount, totalAmount = query.TotalAmount, orderNumber = query.OrderNumber, }; return(orderCL); }
private UpdateOrderGridCL ConvertOrderToGrid(OrderCL activeOrders) { Collection <ProductCL> products = cartBLL.getProductCollectionByCartId(activeOrders.cartId); Collection <CartProductCL> cartProducts = cartBLL.getCartProductCollectionByCartId(activeOrders.cartId); string addressType = ""; int addressTypeId = addressBLL.getAddressById(activeOrders.addressId).addressTypeId; if (addressTypeId == 0) { addressType = "Shipping Address"; } if (addressTypeId == 1) { addressType = "Billing Address"; } if (addressTypeId == 2) { addressType = "Permanent Address"; } StringBuilder productQty = new StringBuilder(); StringBuilder productId = new StringBuilder(); StringBuilder productName = new StringBuilder(); StringBuilder productDispatchTime = new StringBuilder(); StringBuilder productPrice = new StringBuilder(); StringBuilder productShippingCharge = new StringBuilder(); foreach (ProductCL item in products) // Loop through all strings { productName.Append(item.name).Append(";"); // Append string to StringBuilder productDispatchTime.Append(item.dispatchTime).Append(";"); productId.Append(item.Id).Append(";"); productPrice.Append(item.price).Append(";"); productShippingCharge.Append(item.shippingCharge).Append(";"); } foreach (CartProductCL item in cartProducts) { productQty.Append(item.quantity).Append(";"); } UpdateOrderGridCL updateOrderDetails = new UpdateOrderGridCL() { id = activeOrders.id, memberName = cartBLL.getMemberbyCartId(activeOrders.cartId).name, memberAddress = addressBLL.getAddressById(activeOrders.addressId).addressLine1 + "," + addressBLL.getAddressById(activeOrders.addressId).addressLine2 + "," + addressBLL.getAddressById(activeOrders.addressId).addressLine3 + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).cityName + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).stateName + "," + addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).countryName, memberAddressType = addressType, memberCityId = addressBLL.getAddressById(activeOrders.addressId).cityId, memberCountryName = addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).countryName, memberGender = cartBLL.getMemberbyCartId(activeOrders.cartId).gender, memberIsGuest = cartBLL.getMemberbyCartId(activeOrders.cartId).isGuest, memberModifiedDate = cartBLL.getMemberbyCartId(activeOrders.cartId).dateModified, memberJoinDate = cartBLL.getMemberbyCartId(activeOrders.cartId).dateCreated, memberMobNo = cartBLL.getMemberbyCartId(activeOrders.cartId).mobNo, memberStateId = addressBLL.getCityById(addressBLL.getAddressById(activeOrders.addressId).cityId).stateId, orderShippingDescription = activeOrders.description, orderStatusId = activeOrders.statusId, orderTaxAmt = activeOrders.taxAmount, orderTotalAmt = activeOrders.totalAmount, orderTotalShippingCharge = activeOrders.shippingCharge, productName = productName.ToString(), productDispatchTime = productDispatchTime.ToString(), productId = productId.ToString(), productPrice = productPrice.ToString(), productShippingCharge = productShippingCharge.ToString(), productQty = productQty.ToString(), productCount = cartProducts.Count(), }; return(updateOrderDetails); }