//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;
}
