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;
 }
        void BuildInvoiceAddRq(IMsgSetRequest requestMsgSet, Site_Manager.DataModel.BC_BillingAddress customer, QBRequest wqObject)
        {
            IInvoiceAdd InvoiceAddRq = requestMsgSet.AppendInvoiceAddRq();
            var invoice = new Site_Manager.DataModel.BC_Order();
            using (PreferredFloristDBDataContext pfDB = new PreferredFloristDBDataContext())
            {
                invoice = pfDB.BC_Orders.FirstOrDefault(p => p.pfOrderID == wqObject.InvoiceNumber);
            }
            InvoiceAddRq.defMacro.SetValue("1234");
            //Set field value for ListID
            InvoiceAddRq.CustomerRef.ListID.SetValue(wqObject.QBListID);
            //Set field value for FullName
            InvoiceAddRq.ARAccountRef.FullName.SetValue("Accounts Receivable");
            InvoiceAddRq.ClassRef.FullName.SetValue(String.Format("{0}:Orders",wqObject.QBClass));
            //Set field value for FullName
            InvoiceAddRq.TemplateRef.FullName.SetValue("PF Invoice Template");
            //Set field value for TxnDate   DateTime.Parse("12/15/2007")
            if ((invoice.Date_Created == null))
                InvoiceAddRq.TxnDate.SetValue(Convert.ToDateTime(System.DateTime.Now.ToShortDateString()));
            else
                InvoiceAddRq.TxnDate.SetValue(Convert.ToDateTime(invoice.Date_Created.ToString()));
               //Set field value for RefNumber
            InvoiceAddRq.RefNumber.SetValue(wqObject.InvoiceNumber.ToString());
            InvoiceAddRq.RefNumber.SetValue(String.Format("{0}-{1}", wqObject.SiteID, wqObject.BC_OrderID));
            //Set field value for Addr1
            InvoiceAddRq.BillAddress.Addr1.SetValue(String.Format("{0} {1}", customer.first_name, customer.last_name));
            //Set field value for Addr2
            InvoiceAddRq.BillAddress.Addr2.SetValue(customer.street_1);
            //Set field value for City
            InvoiceAddRq.BillAddress.City.SetValue(customer.city);
            //Set field value for State
            InvoiceAddRq.BillAddress.State.SetValue(customer.state);
            //Set field value for PostalCode
            InvoiceAddRq.BillAddress.PostalCode.SetValue(customer.zip);
            //Set field value for Country
            InvoiceAddRq.BillAddress.Country.SetValue(customer.country);
            InvoiceAddRq.IsPending.SetValue(false);
            //Set field value for PONumber
            InvoiceAddRq.PONumber.SetValue(String.Empty);
            //Set field value for FullName
            InvoiceAddRq.TermsRef.FullName.SetValue("Due on receipt");
             //Set field value for ShipDate DateTime.Parse("12/15/2007")
            InvoiceAddRq.ShipDate.SetValue((invoice.Date_Created == null) ? Convert.ToDateTime(System.DateTime.Now.ToShortDateString()) : Convert.ToDateTime(invoice.Date_Created.ToString()));
            ////Set field value for ListID
            //InvoiceAddRq.ShipMethodRef.ListID.SetValue("200000-1011023419");
            //Set field value for FullName
            //InvoiceAddRq.ShipMethodRef.FullName.SetValue("ab");
            //Set field value for FullName
            InvoiceAddRq.ItemSalesTaxRef.FullName.SetValue("In State");
            //Set field value for FullName
            InvoiceAddRq.CustomerMsgRef.FullName.SetValue("Thank you for shopping at preferredflorist.com");
            //Set field value for IsToBePrinted
            InvoiceAddRq.IsToBePrinted.SetValue(false);
            //Set field value for IsToBeEmailed
            //InvoiceAddRq.IsToBeEmailed.SetValue(isValid);
            InvoiceAddRq.IsToBeEmailed.SetValue(false);
            //InvoiceAddRq.FOB.SetValue(invoice.CustomerJobNumber);
            //InvoiceAddRq.Other.SetValue(invoice.WorkOrderNumber.ToString());

            using (var db = new PreferredFloristDBDataContext())
            {
                int countOfInvolis = 0;
                var bagOfInvolis = from pi in db.BC_OrderLineItems
                                   where pi.PFOrderID == wqObject.InvoiceNumber
                                   select pi;
                countOfInvolis = bagOfInvolis.Count();
                if (countOfInvolis > 0)
                {
                    foreach (Site_Manager.DataModel.BC_OrderLineItem involi in bagOfInvolis)
                    {
                        IORInvoiceLineAdd ORInvoiceLineAddListElement1 = InvoiceAddRq.ORInvoiceLineAddList.Append();
                        string ORInvoiceLineAddListElementType2 = "InvoiceLineAdd";
                        if (ORInvoiceLineAddListElementType2 == "InvoiceLineAdd")
                        {
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.ItemRef.FullName.SetValue("Product");

                            //Get the value of the card sentiment, card signature, verse, ribbon etc.
                            var bagOfProductOptions = from pi in db.BC_OrderProductOptions
                                                      where pi.PF_Line_Item_ID == involi.pf_line_item_id
                                                      orderby pi.option_id ascending
                                                      select pi;
                            var prodOptsText = new StringBuilder();
                            foreach (Site_Manager.DataModel.BC_OrderProductOption oPo in bagOfProductOptions)
                            {
                                prodOptsText.Append(String.Format("{0}:\r\n", oPo.display_name));
                                prodOptsText.Append(String.Format("{0}:\r\n\r\n", oPo.value));
                            }
                            //Set field value for Desc
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Desc.SetValue(String.Format("{0}   {1}\r\n\r\n{2}\r\n\r\n", involi.sku, involi.name, prodOptsText));
                            //Set field value for Quantity
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Quantity.SetValue(Convert.ToInt32(involi.quantity));

                            ORInvoiceLineAddListElement1.InvoiceLineAdd.ORRatePriceLevel.Rate.SetValue(Convert.ToDouble(involi.price_ex_tax));
                            if (null == customer.IsTaxable || customer.IsTaxable == false)
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Non");
                            }
                            else
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Tax");
                            }
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Other1.SetValue(involi.sku);

                        }
                    }

                    //Add order coupons if there are any
                    if (invoice.coupon_discount > 0)
                    {
                        int countOfCoupons = 0;
                        var bagOfCoupons = from pi in db.BC_OrderCoupons
                                           where pi.pf_Order_ID == wqObject.InvoiceNumber
                                           select pi;
                        countOfCoupons = bagOfCoupons.Count();
                        if (countOfCoupons > 0)
                        {
                            foreach (Site_Manager.DataModel.BC_OrderCoupon couponLi in bagOfCoupons)
                            {
                                IORInvoiceLineAdd ORInvoiceLineAddListElement1 = InvoiceAddRq.ORInvoiceLineAddList.Append();
                                string ORInvoiceLineAddListElementType2 = "InvoiceLineAdd";
                                if (ORInvoiceLineAddListElementType2 == "InvoiceLineAdd")
                                {
                                    ORInvoiceLineAddListElement1.InvoiceLineAdd.ItemRef.FullName.SetValue("Coupon");
                                    //Set field value for Desc
                                    ORInvoiceLineAddListElement1.InvoiceLineAdd.Desc.SetValue(couponLi.code);
                                    //Set field value for Quantity
                                    //ORInvoiceLineAddListElement1.InvoiceLineAdd.Quantity.SetValue(1); //Cannot set quantity for item of this type

                                    ORInvoiceLineAddListElement1.InvoiceLineAdd.ORRatePriceLevel.Rate.SetValue(Convert.ToDouble(invoice.coupon_discount));
                                    if (null == customer.IsTaxable || customer.IsTaxable == false)
                                    {
                                        ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Non");
                                    }
                                    else
                                    {
                                        ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Tax");
                                    }
                                    ORInvoiceLineAddListElement1.InvoiceLineAdd.Other1.SetValue(couponLi.code);
                                }
                            }
                        }
                    }

                        //Add Service Fee. Note: in some of the earlier stores, the handling fee was billed as shipping

                        if (invoice.handling_cost_ex_tax > 0)
                        {
                            IORInvoiceLineAdd ORInvoiceLineAddListElement1 = InvoiceAddRq.ORInvoiceLineAddList.Append();
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.ItemRef.FullName.SetValue("Service Fee");
                            //Set field value for Desc
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Desc.SetValue("Service Fee");
                            //Set field value for Quantity
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Quantity.SetValue(1);
                            //ORInvoiceLineAddListElement1.InvoiceLineAdd.Other1.SetValue(dr["PartNumber"].ToString());

                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Amount.SetValue(Convert.ToDouble(invoice.handling_cost_ex_tax));
                            if (invoice.handling_cost_tax > 0)
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Tax");
                            }
                            else
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Non");                            }
                        }

                        if (invoice.shipping_cost_ex_tax > 0) // Note: in some of the earlier stores, the handling fee was billed as shipping
                        {
                            IORInvoiceLineAdd ORInvoiceLineAddListElement1 = InvoiceAddRq.ORInvoiceLineAddList.Append();
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.ItemRef.FullName.SetValue("Shipping");
                            //Set field value for Desc
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Desc.SetValue("Shipping");
                            //Set field value for Quantity
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Quantity.SetValue(1);

                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Amount.SetValue(Convert.ToDouble(invoice.shipping_cost_ex_tax));
                            if (invoice.shipping_cost_tax > 0)
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Tax");
                            }
                            else
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Non"); //////////////////HEEEEEEEEEEEEEEY??????????????????
                            }
                        }

                        //Add Order Discounts
                        if (!(String.IsNullOrEmpty(invoice.discount_amount.ToString())) && invoice.discount_amount > 0)
                        {
                            Decimal aCredit = invoice.discount_amount > 0 ? (decimal)invoice.discount_amount : 0;
                            IORInvoiceLineAdd ORInvoiceLineAddListElement1 = InvoiceAddRq.ORInvoiceLineAddList.Append();
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.ItemRef.FullName.SetValue("Discount");
                            //Set field value for Desc
                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Desc.SetValue("Discount");

                            ORInvoiceLineAddListElement1.InvoiceLineAdd.Amount.SetValue(Convert.ToDouble(aCredit));
                            if (null == customer.IsTaxable || customer.IsTaxable == false)
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Non");
                            }
                            else
                            {
                                ORInvoiceLineAddListElement1.InvoiceLineAdd.SalesTaxCodeRef.FullName.SetValue("Tax");
                            }
                        }
                }
            }
        }