//Equates to a QuickBooks customer private long EnterBCOrderBillingAddress() { using (PreferredFloristDBDataContext pfDB = new PreferredFloristDBDataContext()) { var bcOrderAddressObj = new Site_Manager.DataModel.BC_BillingAddress(); bcOrderAddressObj.bc_order_id = bcOrder.id; bcOrderAddressObj.city = bcOrder.billing_address.city; bcOrderAddressObj.company = bcOrder.billing_address.company; bcOrderAddressObj.country = bcOrder.billing_address.country; bcOrderAddressObj.country_iso2 = bcOrder.billing_address.country_iso2; bcOrderAddressObj.email = bcOrder.billing_address.email; bcOrderAddressObj.first_name = bcOrder.billing_address.first_name; bcOrderAddressObj.last_name = bcOrder.billing_address.last_name; var validateField = new ValidateFieldLength(); bcOrderAddressObj.phone = validateField.PhoneNumber(bcOrder.billing_address.phone); bcOrderAddressObj.state = bcOrder.billing_address.state; bcOrderAddressObj.street_1 = bcOrder.billing_address.street_1; bcOrderAddressObj.street_2 = bcOrder.billing_address.street_2; bcOrderAddressObj.zip = bcOrder.billing_address.zip; if (null != bcOrder.total_tax && bcOrder.total_tax > 0) { bcOrderAddressObj.IsTaxable = true; } else { bcOrderAddressObj.IsTaxable = false; } var GetAccountNumber = new GetNextIDNumber(); bcOrderAddressObj.PF_accountNumber = GetAccountNumber.GetCustomerNumber(); pfDB.BC_BillingAddresses.InsertOnSubmit(bcOrderAddressObj); pfDB.SubmitChanges(); return (long)bcOrderAddressObj.PF_accountNumber; } }
private Boolean EnterBCOrder(string storeName) { bool orderHasCoupons = false; long result = CheckForExistingBCOrder(storeName); if (result == 0) { using (PreferredFloristDBDataContext pfDB = new PreferredFloristDBDataContext()) { var bcOrderObj = new Site_Manager.DataModel.BC_Order(); bcOrderObj.bc_store_name = storeName; bcOrderObj.base_handling_cost = bcOrder.base_handling_cost; bcOrderObj.base_shipping_cost = bcOrder.base_shipping_cost; bcOrderObj.base_wrapping_cost = bcOrder.base_wrapping_cost; bcOrderObj.coupon_discount = bcOrder.coupon_discount; if (bcOrder.coupon_discount > 0) { orderHasCoupons = true; }; bcOrderObj.currency_code = bcOrder.currency_code; bcOrderObj.currency_exchange_rate = bcOrder.currency_exchange_rate; bcOrderObj.currency_id = bcOrder.currency_id; bcOrderObj.customer_id = bcOrder.customer_id; var getPFOrderNumber = new GetNextIDNumber(); bcOrderObj.pfOrderID = getPFOrderNumber.GetPFOrderNumber(); pfOrderID = (long)bcOrderObj.pfOrderID; bcOrderObj.customer_message = bcOrder.customer_message; var joshBD = Convert.ToDateTime("02-16-1983"); bcOrderObj.Date_Created = bcOrder.Date_Created < joshBD ? joshBD : bcOrder.Date_Created; bcOrderObj.Date_Modified = bcOrder.Date_Modified < joshBD ? joshBD : bcOrder.Date_Modified; bcOrderObj.Date_Shipped = bcOrder.Date_Shipped < joshBD ? joshBD : bcOrder.Date_Shipped; bcOrderObj.requested_delivery_date = FindDeliveryDate(bcOrder.customer_message); bcOrderObj.default_currency_code = bcOrder.default_currency_code; bcOrderObj.default_currency_id = bcOrder.default_currency_id; bcOrderObj.discount_amount = bcOrder.discount_amount; bcOrderObj.geoip_country = bcOrder.geoip_country; bcOrderObj.geoip_country_iso2 = bcOrder.geoip_country_iso2; bcOrderObj.gift_certificate_amount = bcOrder.gift_certificate_amount; bcOrderObj.handling_cost_ex_tax = bcOrder.handling_cost_ex_tax; bcOrderObj.handling_cost_inc_tax = bcOrder.handling_cost_inc_tax; bcOrderObj.handling_cost_tax = bcOrder.handling_cost_tax; bcOrderObj.handling_cost_tax_class_id = bcOrder.handling_cost_tax_class_id; bcOrderObj.id = bcOrder.id; bcOrderObj.ip_address = bcOrder.ip_address; bcOrderObj.is_deleted = bcOrder.is_deleted; bcOrderObj.items_shipped = bcOrder.items_shipped; bcOrderObj.items_total = bcOrder.items_total; bcOrderObj.order_is_digital = bcOrder.order_is_digital; bcOrderObj.payment_method = bcOrder.payment_method; bcOrderObj.payment_provider_id = bcOrder.payment_provider_id; bcOrderObj.payment_status = bcOrder.payment_status; bcOrderObj.refunded_amount = bcOrder.refunded_amount; bcOrderObj.shipping_address_count = bcOrder.shipping_address_count; bcOrderObj.shipping_cost_ex_tax = bcOrder.shipping_cost_ex_tax; bcOrderObj.shipping_cost_inc_tax = bcOrder.shipping_cost_inc_tax; bcOrderObj.shipping_cost_tax = bcOrder.shipping_cost_tax; bcOrderObj.shipping_cost_tax_class_id = bcOrder.shipping_cost_tax_class_id; bcOrderObj.staff_notes = bcOrder.staff_notes; /* 0 Incomplete * 1 Pending * 2 Shipped * 3 Partially Shipped * 4 Refunded * 5 Cancelled * 6 Declined * 7 Awaiting Payment * 8 Awaiting Pickup * 9 Awaiting Shipment * 10 Completed * 11 Awaiting Fulfillment * 12 Manual Verification Required */ bcOrderObj.status = bcOrder.status; bcOrderObj.status_id = bcOrder.status_id; bcOrderObj.store_credit_amount = bcOrder.store_credit_amount; bcOrderObj.subtotal_ex_tax = bcOrder.subtotal_ex_tax; bcOrderObj.subtotal_inc_tax = bcOrder.subtotal_inc_tax; bcOrderObj.subtotal_tax = bcOrder.subtotal_tax; bcOrderObj.total_ex_tax = bcOrder.total_inc_tax - bcOrder.total_tax; bcOrderObj.total_inc_tax = bcOrder.total_inc_tax; bcOrderObj.total_tax = bcOrder.total_tax; bcOrderObj.wrapping_cost_ex_tax = bcOrder.wrapping_cost_ex_tax; bcOrderObj.wrapping_cost_inc_tax = bcOrder.wrapping_cost_inc_tax; bcOrderObj.wrapping_cost_tax = bcOrder.wrapping_cost_tax; bcOrderObj.wrapping_cost_tax_class_id = bcOrder.wrapping_cost_tax_class_id; decimal orderTotal = bcOrder.total_inc_tax; bcOrderObj.merchant_fee = orderTotal * .03M; pfDB.BC_Orders.InsertOnSubmit(bcOrderObj); pfDB.SubmitChanges(); var orderListObj = (from e1 in pfDB.BC_OrderLists where e1.bc_order_id == bcOrder.id && e1.bc_store_name == storeName select e1).SingleOrDefault(); orderListObj.requested_delivery_date = bcOrderObj.requested_delivery_date; pfDB.SubmitChanges(); } } return orderHasCoupons; }