/// <summary> /// Create a new acc_ORDERS object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="orderNumber">Initial value of the OrderNumber property.</param> /// <param name="invoiceNumber">Initial value of the InvoiceNumber property.</param> /// <param name="invoiceDate">Initial value of the InvoiceDate property.</param> /// <param name="invoiceCopy">Initial value of the InvoiceCopy property.</param> /// <param name="jewelrySize">Initial value of the JewelrySize property.</param> /// <param name="clubOrder">Initial value of the ClubOrder property.</param> /// <param name="orderdate">Initial value of the orderdate property.</param> /// <param name="user_id">Initial value of the user_id property.</param> /// <param name="packaging_id">Initial value of the packaging_id property.</param> /// <param name="payment_id">Initial value of the payment_id property.</param> /// <param name="shipping_id">Initial value of the shipping_id property.</param> /// <param name="shipping_tracking_no">Initial value of the shipping_tracking_no property.</param> /// <param name="amnt_items">Initial value of the amnt_items property.</param> /// <param name="amnt_shipping">Initial value of the amnt_shipping property.</param> /// <param name="amnt_wrapping">Initial value of the amnt_wrapping property.</param> /// <param name="amnt_labor">Initial value of the amnt_labor property.</param> /// <param name="amnt_extracharges">Initial value of the amnt_extracharges property.</param> /// <param name="amnt_vat">Initial value of the amnt_vat property.</param> /// <param name="amnt_subtotal">Initial value of the amnt_subtotal property.</param> /// <param name="amnt_discount">Initial value of the amnt_discount property.</param> /// <param name="amnt_grandtotal">Initial value of the amnt_grandtotal property.</param> /// <param name="adrs_billing_firstname">Initial value of the adrs_billing_firstname property.</param> /// <param name="adrs_billing_lastname">Initial value of the adrs_billing_lastname property.</param> /// <param name="adrs_billing_street">Initial value of the adrs_billing_street property.</param> /// <param name="adrs_billing_city">Initial value of the adrs_billing_city property.</param> /// <param name="adrs_billing_zip">Initial value of the adrs_billing_zip property.</param> /// <param name="adrs_billing_state_id">Initial value of the adrs_billing_state_id property.</param> /// <param name="adrs_billing_country_id">Initial value of the adrs_billing_country_id property.</param> /// <param name="adrs_billing_phone">Initial value of the adrs_billing_phone property.</param> /// <param name="adrs_delivery_firstname">Initial value of the adrs_delivery_firstname property.</param> /// <param name="adrs_delivery_lastname">Initial value of the adrs_delivery_lastname property.</param> /// <param name="adrs_delivery_street">Initial value of the adrs_delivery_street property.</param> /// <param name="adrs_delivery_city">Initial value of the adrs_delivery_city property.</param> /// <param name="adrs_delivery_zip">Initial value of the adrs_delivery_zip property.</param> /// <param name="adrs_delivery_state_id">Initial value of the adrs_delivery_state_id property.</param> /// <param name="adrs_delivery_country_id">Initial value of the adrs_delivery_country_id property.</param> /// <param name="adrs_delivery_phone">Initial value of the adrs_delivery_phone property.</param> /// <param name="cannot_be_edited">Initial value of the cannot_be_edited property.</param> /// <param name="sts1_new_order_received">Initial value of the sts1_new_order_received property.</param> /// <param name="sts1_new_order_received_viewed">Initial value of the sts1_new_order_received_viewed property.</param> /// <param name="sts1_new_order_received_date">Initial value of the sts1_new_order_received_date property.</param> /// <param name="sts2_waiting_for_authorization">Initial value of the sts2_waiting_for_authorization property.</param> /// <param name="sts2_waiting_for_authorization_viewed">Initial value of the sts2_waiting_for_authorization_viewed property.</param> /// <param name="sts2_waiting_for_authorization_date">Initial value of the sts2_waiting_for_authorization_date property.</param> /// <param name="sts2_waiting_for_authorization_note">Initial value of the sts2_waiting_for_authorization_note property.</param> /// <param name="sts3_waiting_for_payment">Initial value of the sts3_waiting_for_payment property.</param> /// <param name="sts3_waiting_for_payment_viewed">Initial value of the sts3_waiting_for_payment_viewed property.</param> /// <param name="sts3_waiting_for_payment_date">Initial value of the sts3_waiting_for_payment_date property.</param> /// <param name="sts3_waiting_for_payment_note">Initial value of the sts3_waiting_for_payment_note property.</param> /// <param name="sts4_order_confirmed">Initial value of the sts4_order_confirmed property.</param> /// <param name="sts4_order_confirmed_viewed">Initial value of the sts4_order_confirmed_viewed property.</param> /// <param name="sts4_order_confirmed_date">Initial value of the sts4_order_confirmed_date property.</param> /// <param name="sts4_order_confirmed_note">Initial value of the sts4_order_confirmed_note property.</param> /// <param name="sts5_partial_order_confirmed">Initial value of the sts5_partial_order_confirmed property.</param> /// <param name="sts5_partial_order_confirmed_viewed">Initial value of the sts5_partial_order_confirmed_viewed property.</param> /// <param name="sts5_partial_order_confirmed_date">Initial value of the sts5_partial_order_confirmed_date property.</param> /// <param name="sts5_partial_order_confirmed_note">Initial value of the sts5_partial_order_confirmed_note property.</param> /// <param name="sts6_order_failed">Initial value of the sts6_order_failed property.</param> /// <param name="sts6_order_failed_viewed">Initial value of the sts6_order_failed_viewed property.</param> /// <param name="sts6_order_failed_date">Initial value of the sts6_order_failed_date property.</param> /// <param name="sts6_order_failed_note">Initial value of the sts6_order_failed_note property.</param> /// <param name="sts7_order_waiting_to_be_send">Initial value of the sts7_order_waiting_to_be_send property.</param> /// <param name="sts7_order_waiting_to_be_send_viewed">Initial value of the sts7_order_waiting_to_be_send_viewed property.</param> /// <param name="sts7_order_waiting_to_be_send_date">Initial value of the sts7_order_waiting_to_be_send_date property.</param> /// <param name="sts7_order_waiting_to_be_send_note">Initial value of the sts7_order_waiting_to_be_send_note property.</param> /// <param name="sts8_order_send">Initial value of the sts8_order_send property.</param> /// <param name="sts8_order_send_viewed">Initial value of the sts8_order_send_viewed property.</param> /// <param name="sts8_order_send_date">Initial value of the sts8_order_send_date property.</param> /// <param name="sts8_order_send_note">Initial value of the sts8_order_send_note property.</param> /// <param name="sts9_partial_order_send">Initial value of the sts9_partial_order_send property.</param> /// <param name="sts9_partial_order_send_viewed">Initial value of the sts9_partial_order_send_viewed property.</param> /// <param name="sts9_partial_order_send_date">Initial value of the sts9_partial_order_send_date property.</param> /// <param name="sts9_partial_order_send_note">Initial value of the sts9_partial_order_send_note property.</param> /// <param name="sts10_order_received_by_customer">Initial value of the sts10_order_received_by_customer property.</param> /// <param name="sts10_order_received_by_customer_viewed">Initial value of the sts10_order_received_by_customer_viewed property.</param> /// <param name="sts10_order_received_by_customer_date">Initial value of the sts10_order_received_by_customer_date property.</param> /// <param name="sts10_order_received_by_customer_note">Initial value of the sts10_order_received_by_customer_note property.</param> /// <param name="sts11_partial_order_received_by_customer">Initial value of the sts11_partial_order_received_by_customer property.</param> /// <param name="sts11_partial_order_received_by_customer_viewed">Initial value of the sts11_partial_order_received_by_customer_viewed property.</param> /// <param name="sts11_partial_order_received_by_customer_date">Initial value of the sts11_partial_order_received_by_customer_date property.</param> /// <param name="sts11_partial_order_received_by_customer_note">Initial value of the sts11_partial_order_received_by_customer_note property.</param> /// <param name="sts12_customer_returning_order">Initial value of the sts12_customer_returning_order property.</param> /// <param name="sts12_customer_returning_order_viewed">Initial value of the sts12_customer_returning_order_viewed property.</param> /// <param name="sts12_customer_returning_order_date">Initial value of the sts12_customer_returning_order_date property.</param> /// <param name="sts12_customer_returning_order_note">Initial value of the sts12_customer_returning_order_note property.</param> /// <param name="sts13_customer_returning_part_order">Initial value of the sts13_customer_returning_part_order property.</param> /// <param name="sts13_customer_returning_part_order_viewed">Initial value of the sts13_customer_returning_part_order_viewed property.</param> /// <param name="sts13_customer_returning_part_order_date">Initial value of the sts13_customer_returning_part_order_date property.</param> /// <param name="sts13_customer_returning_part_order_note">Initial value of the sts13_customer_returning_part_order_note property.</param> /// <param name="sts14_customer_refunded">Initial value of the sts14_customer_refunded property.</param> /// <param name="sts14_customer_refunded_viewed">Initial value of the sts14_customer_refunded_viewed property.</param> /// <param name="sts14_customer_refunded_date">Initial value of the sts14_customer_refunded_date property.</param> /// <param name="sts14_customer_refunded_note">Initial value of the sts14_customer_refunded_note property.</param> /// <param name="sts15_customer_partly_refunded">Initial value of the sts15_customer_partly_refunded property.</param> /// <param name="sts15_customer_partly_refunded_viewed">Initial value of the sts15_customer_partly_refunded_viewed property.</param> /// <param name="sts15_customer_partly_refunded_date">Initial value of the sts15_customer_partly_refunded_date property.</param> /// <param name="sts15_customer_partly_refunded_note">Initial value of the sts15_customer_partly_refunded_note property.</param> /// <param name="sts16_order_closed">Initial value of the sts16_order_closed property.</param> /// <param name="sts16_order_closed_viewed">Initial value of the sts16_order_closed_viewed property.</param> /// <param name="sts16_order_closed_date">Initial value of the sts16_order_closed_date property.</param> /// <param name="sts16_order_closed_note">Initial value of the sts16_order_closed_note property.</param> /// <param name="sts17_order_cancelled">Initial value of the sts17_order_cancelled property.</param> /// <param name="sts17_order_cancelled_viewed">Initial value of the sts17_order_cancelled_viewed property.</param> /// <param name="sts17_order_cancelled_date">Initial value of the sts17_order_cancelled_date property.</param> /// <param name="sts17_order_cancelled_note">Initial value of the sts17_order_cancelled_note property.</param> /// <param name="sts_curr_stat">Initial value of the sts_curr_stat property.</param> /// <param name="sts_curr_date">Initial value of the sts_curr_date property.</param> /// <param name="orderDeleted">Initial value of the OrderDeleted property.</param> /// <param name="interest_start_date">Initial value of the Interest_start_date property.</param> /// <param name="interest_percent">Initial value of the Interest_percent property.</param> /// <param name="merchant_Notes">Initial value of the Merchant_Notes property.</param> /// <param name="customer_Notes">Initial value of the Customer_Notes property.</param> /// <param name="lastModify_Date">Initial value of the LastModify_Date property.</param> /// <param name="lastModify_User">Initial value of the LastModify_User property.</param> /// <param name="lastModify_User_Id">Initial value of the LastModify_User_Id property.</param> /// <param name="campaign">Initial value of the campaign property.</param> /// <param name="affiliate">Initial value of the affiliate property.</param> /// <param name="referrer">Initial value of the referrer property.</param> /// <param name="remote_ip">Initial value of the remote_ip property.</param> /// <param name="order_transacted">Initial value of the order_transacted property.</param> /// <param name="order_currency">Initial value of the order_currency property.</param> /// <param name="order_currency_rate">Initial value of the order_currency_rate property.</param> /// <param name="hear_fromus">Initial value of the hear_fromus property.</param> /// <param name="include_receipt">Initial value of the include_receipt property.</param> public static acc_ORDERS Createacc_ORDERS(global::System.Int32 id, global::System.Int32 orderNumber, global::System.Int32 invoiceNumber, global::System.DateTime invoiceDate, global::System.Boolean invoiceCopy, global::System.String jewelrySize, global::System.Boolean clubOrder, global::System.DateTime orderdate, global::System.Int32 user_id, global::System.Int32 packaging_id, global::System.Int32 payment_id, global::System.Int32 shipping_id, global::System.String shipping_tracking_no, global::System.Decimal amnt_items, global::System.Decimal amnt_shipping, global::System.Decimal amnt_wrapping, global::System.Decimal amnt_labor, global::System.Decimal amnt_extracharges, global::System.Decimal amnt_vat, global::System.Decimal amnt_subtotal, global::System.Decimal amnt_discount, global::System.Decimal amnt_grandtotal, global::System.String adrs_billing_firstname, global::System.String adrs_billing_lastname, global::System.String adrs_billing_street, global::System.String adrs_billing_city, global::System.String adrs_billing_zip, global::System.Int32 adrs_billing_state_id, global::System.Int32 adrs_billing_country_id, global::System.String adrs_billing_phone, global::System.String adrs_delivery_firstname, global::System.String adrs_delivery_lastname, global::System.String adrs_delivery_street, global::System.String adrs_delivery_city, global::System.String adrs_delivery_zip, global::System.Int32 adrs_delivery_state_id, global::System.Int32 adrs_delivery_country_id, global::System.String adrs_delivery_phone, global::System.Boolean cannot_be_edited, global::System.Boolean sts1_new_order_received, global::System.Boolean sts1_new_order_received_viewed, global::System.DateTime sts1_new_order_received_date, global::System.Boolean sts2_waiting_for_authorization, global::System.Boolean sts2_waiting_for_authorization_viewed, global::System.DateTime sts2_waiting_for_authorization_date, global::System.String sts2_waiting_for_authorization_note, global::System.Boolean sts3_waiting_for_payment, global::System.Boolean sts3_waiting_for_payment_viewed, global::System.DateTime sts3_waiting_for_payment_date, global::System.String sts3_waiting_for_payment_note, global::System.Boolean sts4_order_confirmed, global::System.Boolean sts4_order_confirmed_viewed, global::System.DateTime sts4_order_confirmed_date, global::System.String sts4_order_confirmed_note, global::System.Boolean sts5_partial_order_confirmed, global::System.Boolean sts5_partial_order_confirmed_viewed, global::System.DateTime sts5_partial_order_confirmed_date, global::System.String sts5_partial_order_confirmed_note, global::System.Boolean sts6_order_failed, global::System.Boolean sts6_order_failed_viewed, global::System.DateTime sts6_order_failed_date, global::System.String sts6_order_failed_note, global::System.Boolean sts7_order_waiting_to_be_send, global::System.Boolean sts7_order_waiting_to_be_send_viewed, global::System.DateTime sts7_order_waiting_to_be_send_date, global::System.String sts7_order_waiting_to_be_send_note, global::System.Boolean sts8_order_send, global::System.Boolean sts8_order_send_viewed, global::System.DateTime sts8_order_send_date, global::System.String sts8_order_send_note, global::System.Boolean sts9_partial_order_send, global::System.Boolean sts9_partial_order_send_viewed, global::System.DateTime sts9_partial_order_send_date, global::System.String sts9_partial_order_send_note, global::System.Boolean sts10_order_received_by_customer, global::System.Boolean sts10_order_received_by_customer_viewed, global::System.DateTime sts10_order_received_by_customer_date, global::System.String sts10_order_received_by_customer_note, global::System.Boolean sts11_partial_order_received_by_customer, global::System.Boolean sts11_partial_order_received_by_customer_viewed, global::System.DateTime sts11_partial_order_received_by_customer_date, global::System.String sts11_partial_order_received_by_customer_note, global::System.Boolean sts12_customer_returning_order, global::System.Boolean sts12_customer_returning_order_viewed, global::System.DateTime sts12_customer_returning_order_date, global::System.String sts12_customer_returning_order_note, global::System.Boolean sts13_customer_returning_part_order, global::System.Boolean sts13_customer_returning_part_order_viewed, global::System.DateTime sts13_customer_returning_part_order_date, global::System.String sts13_customer_returning_part_order_note, global::System.Boolean sts14_customer_refunded, global::System.Boolean sts14_customer_refunded_viewed, global::System.DateTime sts14_customer_refunded_date, global::System.String sts14_customer_refunded_note, global::System.Boolean sts15_customer_partly_refunded, global::System.Boolean sts15_customer_partly_refunded_viewed, global::System.DateTime sts15_customer_partly_refunded_date, global::System.String sts15_customer_partly_refunded_note, global::System.Boolean sts16_order_closed, global::System.Boolean sts16_order_closed_viewed, global::System.DateTime sts16_order_closed_date, global::System.String sts16_order_closed_note, global::System.Boolean sts17_order_cancelled, global::System.Boolean sts17_order_cancelled_viewed, global::System.DateTime sts17_order_cancelled_date, global::System.String sts17_order_cancelled_note, global::System.String sts_curr_stat, global::System.DateTime sts_curr_date, global::System.Boolean orderDeleted, global::System.DateTime interest_start_date, global::System.Decimal interest_percent, global::System.String merchant_Notes, global::System.String customer_Notes, global::System.DateTime lastModify_Date, global::System.String lastModify_User, global::System.Int32 lastModify_User_Id, global::System.String campaign, global::System.String affiliate, global::System.String referrer, global::System.String remote_ip, global::System.Boolean order_transacted, global::System.String order_currency, global::System.Decimal order_currency_rate, global::System.String hear_fromus, global::System.Boolean include_receipt) { acc_ORDERS acc_ORDERS = new acc_ORDERS(); acc_ORDERS.id = id; acc_ORDERS.OrderNumber = orderNumber; acc_ORDERS.InvoiceNumber = invoiceNumber; acc_ORDERS.InvoiceDate = invoiceDate; acc_ORDERS.InvoiceCopy = invoiceCopy; acc_ORDERS.JewelrySize = jewelrySize; acc_ORDERS.ClubOrder = clubOrder; acc_ORDERS.orderdate = orderdate; acc_ORDERS.user_id = user_id; acc_ORDERS.packaging_id = packaging_id; acc_ORDERS.payment_id = payment_id; acc_ORDERS.shipping_id = shipping_id; acc_ORDERS.shipping_tracking_no = shipping_tracking_no; acc_ORDERS.amnt_items = amnt_items; acc_ORDERS.amnt_shipping = amnt_shipping; acc_ORDERS.amnt_wrapping = amnt_wrapping; acc_ORDERS.amnt_labor = amnt_labor; acc_ORDERS.amnt_extracharges = amnt_extracharges; acc_ORDERS.amnt_vat = amnt_vat; acc_ORDERS.amnt_subtotal = amnt_subtotal; acc_ORDERS.amnt_discount = amnt_discount; acc_ORDERS.amnt_grandtotal = amnt_grandtotal; acc_ORDERS.adrs_billing_firstname = adrs_billing_firstname; acc_ORDERS.adrs_billing_lastname = adrs_billing_lastname; acc_ORDERS.adrs_billing_street = adrs_billing_street; acc_ORDERS.adrs_billing_city = adrs_billing_city; acc_ORDERS.adrs_billing_zip = adrs_billing_zip; acc_ORDERS.adrs_billing_state_id = adrs_billing_state_id; acc_ORDERS.adrs_billing_country_id = adrs_billing_country_id; acc_ORDERS.adrs_billing_phone = adrs_billing_phone; acc_ORDERS.adrs_delivery_firstname = adrs_delivery_firstname; acc_ORDERS.adrs_delivery_lastname = adrs_delivery_lastname; acc_ORDERS.adrs_delivery_street = adrs_delivery_street; acc_ORDERS.adrs_delivery_city = adrs_delivery_city; acc_ORDERS.adrs_delivery_zip = adrs_delivery_zip; acc_ORDERS.adrs_delivery_state_id = adrs_delivery_state_id; acc_ORDERS.adrs_delivery_country_id = adrs_delivery_country_id; acc_ORDERS.adrs_delivery_phone = adrs_delivery_phone; acc_ORDERS.cannot_be_edited = cannot_be_edited; acc_ORDERS.sts1_new_order_received = sts1_new_order_received; acc_ORDERS.sts1_new_order_received_viewed = sts1_new_order_received_viewed; acc_ORDERS.sts1_new_order_received_date = sts1_new_order_received_date; acc_ORDERS.sts2_waiting_for_authorization = sts2_waiting_for_authorization; acc_ORDERS.sts2_waiting_for_authorization_viewed = sts2_waiting_for_authorization_viewed; acc_ORDERS.sts2_waiting_for_authorization_date = sts2_waiting_for_authorization_date; acc_ORDERS.sts2_waiting_for_authorization_note = sts2_waiting_for_authorization_note; acc_ORDERS.sts3_waiting_for_payment = sts3_waiting_for_payment; acc_ORDERS.sts3_waiting_for_payment_viewed = sts3_waiting_for_payment_viewed; acc_ORDERS.sts3_waiting_for_payment_date = sts3_waiting_for_payment_date; acc_ORDERS.sts3_waiting_for_payment_note = sts3_waiting_for_payment_note; acc_ORDERS.sts4_order_confirmed = sts4_order_confirmed; acc_ORDERS.sts4_order_confirmed_viewed = sts4_order_confirmed_viewed; acc_ORDERS.sts4_order_confirmed_date = sts4_order_confirmed_date; acc_ORDERS.sts4_order_confirmed_note = sts4_order_confirmed_note; acc_ORDERS.sts5_partial_order_confirmed = sts5_partial_order_confirmed; acc_ORDERS.sts5_partial_order_confirmed_viewed = sts5_partial_order_confirmed_viewed; acc_ORDERS.sts5_partial_order_confirmed_date = sts5_partial_order_confirmed_date; acc_ORDERS.sts5_partial_order_confirmed_note = sts5_partial_order_confirmed_note; acc_ORDERS.sts6_order_failed = sts6_order_failed; acc_ORDERS.sts6_order_failed_viewed = sts6_order_failed_viewed; acc_ORDERS.sts6_order_failed_date = sts6_order_failed_date; acc_ORDERS.sts6_order_failed_note = sts6_order_failed_note; acc_ORDERS.sts7_order_waiting_to_be_send = sts7_order_waiting_to_be_send; acc_ORDERS.sts7_order_waiting_to_be_send_viewed = sts7_order_waiting_to_be_send_viewed; acc_ORDERS.sts7_order_waiting_to_be_send_date = sts7_order_waiting_to_be_send_date; acc_ORDERS.sts7_order_waiting_to_be_send_note = sts7_order_waiting_to_be_send_note; acc_ORDERS.sts8_order_send = sts8_order_send; acc_ORDERS.sts8_order_send_viewed = sts8_order_send_viewed; acc_ORDERS.sts8_order_send_date = sts8_order_send_date; acc_ORDERS.sts8_order_send_note = sts8_order_send_note; acc_ORDERS.sts9_partial_order_send = sts9_partial_order_send; acc_ORDERS.sts9_partial_order_send_viewed = sts9_partial_order_send_viewed; acc_ORDERS.sts9_partial_order_send_date = sts9_partial_order_send_date; acc_ORDERS.sts9_partial_order_send_note = sts9_partial_order_send_note; acc_ORDERS.sts10_order_received_by_customer = sts10_order_received_by_customer; acc_ORDERS.sts10_order_received_by_customer_viewed = sts10_order_received_by_customer_viewed; acc_ORDERS.sts10_order_received_by_customer_date = sts10_order_received_by_customer_date; acc_ORDERS.sts10_order_received_by_customer_note = sts10_order_received_by_customer_note; acc_ORDERS.sts11_partial_order_received_by_customer = sts11_partial_order_received_by_customer; acc_ORDERS.sts11_partial_order_received_by_customer_viewed = sts11_partial_order_received_by_customer_viewed; acc_ORDERS.sts11_partial_order_received_by_customer_date = sts11_partial_order_received_by_customer_date; acc_ORDERS.sts11_partial_order_received_by_customer_note = sts11_partial_order_received_by_customer_note; acc_ORDERS.sts12_customer_returning_order = sts12_customer_returning_order; acc_ORDERS.sts12_customer_returning_order_viewed = sts12_customer_returning_order_viewed; acc_ORDERS.sts12_customer_returning_order_date = sts12_customer_returning_order_date; acc_ORDERS.sts12_customer_returning_order_note = sts12_customer_returning_order_note; acc_ORDERS.sts13_customer_returning_part_order = sts13_customer_returning_part_order; acc_ORDERS.sts13_customer_returning_part_order_viewed = sts13_customer_returning_part_order_viewed; acc_ORDERS.sts13_customer_returning_part_order_date = sts13_customer_returning_part_order_date; acc_ORDERS.sts13_customer_returning_part_order_note = sts13_customer_returning_part_order_note; acc_ORDERS.sts14_customer_refunded = sts14_customer_refunded; acc_ORDERS.sts14_customer_refunded_viewed = sts14_customer_refunded_viewed; acc_ORDERS.sts14_customer_refunded_date = sts14_customer_refunded_date; acc_ORDERS.sts14_customer_refunded_note = sts14_customer_refunded_note; acc_ORDERS.sts15_customer_partly_refunded = sts15_customer_partly_refunded; acc_ORDERS.sts15_customer_partly_refunded_viewed = sts15_customer_partly_refunded_viewed; acc_ORDERS.sts15_customer_partly_refunded_date = sts15_customer_partly_refunded_date; acc_ORDERS.sts15_customer_partly_refunded_note = sts15_customer_partly_refunded_note; acc_ORDERS.sts16_order_closed = sts16_order_closed; acc_ORDERS.sts16_order_closed_viewed = sts16_order_closed_viewed; acc_ORDERS.sts16_order_closed_date = sts16_order_closed_date; acc_ORDERS.sts16_order_closed_note = sts16_order_closed_note; acc_ORDERS.sts17_order_cancelled = sts17_order_cancelled; acc_ORDERS.sts17_order_cancelled_viewed = sts17_order_cancelled_viewed; acc_ORDERS.sts17_order_cancelled_date = sts17_order_cancelled_date; acc_ORDERS.sts17_order_cancelled_note = sts17_order_cancelled_note; acc_ORDERS.sts_curr_stat = sts_curr_stat; acc_ORDERS.sts_curr_date = sts_curr_date; acc_ORDERS.OrderDeleted = orderDeleted; acc_ORDERS.Interest_start_date = interest_start_date; acc_ORDERS.Interest_percent = interest_percent; acc_ORDERS.Merchant_Notes = merchant_Notes; acc_ORDERS.Customer_Notes = customer_Notes; acc_ORDERS.LastModify_Date = lastModify_Date; acc_ORDERS.LastModify_User = lastModify_User; acc_ORDERS.LastModify_User_Id = lastModify_User_Id; acc_ORDERS.campaign = campaign; acc_ORDERS.affiliate = affiliate; acc_ORDERS.referrer = referrer; acc_ORDERS.remote_ip = remote_ip; acc_ORDERS.order_transacted = order_transacted; acc_ORDERS.order_currency = order_currency; acc_ORDERS.order_currency_rate = order_currency_rate; acc_ORDERS.hear_fromus = hear_fromus; acc_ORDERS.include_receipt = include_receipt; return acc_ORDERS; }
/// <summary> /// Deprecated Method for adding a new object to the acc_ORDERS EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToacc_ORDERS(acc_ORDERS acc_ORDERS) { base.AddObject("acc_ORDERS", acc_ORDERS); }
public int Save(Order orderdto) { using (var db = new JONEntities()) { var totalPrice = orderdto.TotalPrice; var customer = mapper.Map<Order, usr_CUSTOMERS>(orderdto); if (CustomerExists(customer.email)) { var customerExists = CustomerFromEmail(orderdto.Email); customer.password = customerExists.password; customer.id = customerExists.id; db.usr_CUSTOMERS.Attach(customer); db.ObjectStateManager.ChangeObjectState(customer, EntityState.Modified); } else { customer.password = Guid.NewGuid().ToString().Substring(0, 8); db.usr_CUSTOMERS.AddObject(customer); } // ObjectSet<acc_ORDERS> orderset = new ObjectSet<acc_ORDERS>(); var nextOrderNumber = db.acc_ORDERS.Count() + 1; var order = new acc_ORDERS { user_id = customer.id, OrderNumber = nextOrderNumber+10000, orderdate = DateTime.Now, campaign = "notset", affiliate = "notset", referrer = "notset", remote_ip = "notset", order_transacted = true, InvoiceNumber = 1, InvoiceCopy = true, InvoiceDate = DateTime.Now, JewelrySize = "", ClubOrder = false, packaging_id = 1, payment_id = orderdto.PaymentID, shipping_id = 1, shipping_tracking_no = "", amnt_discount = 0, amnt_extracharges = 0, amnt_grandtotal = totalPrice, amnt_items = totalPrice, amnt_labor = 0, amnt_shipping = 0, amnt_subtotal = totalPrice, amnt_vat = 0, amnt_wrapping = 0, adrs_billing_firstname = orderdto.BillingAddress.FirstName, adrs_billing_lastname = orderdto.BillingAddress.LastName, adrs_billing_city = orderdto.BillingAddress.City, adrs_billing_phone = orderdto.BillingAddress.Phone, adrs_billing_state_id = orderdto.BillingAddress.StateID, adrs_billing_street = orderdto.BillingAddress.Address1, adrs_billing_zip = orderdto.BillingAddress.ZipCode, adrs_delivery_country_id = orderdto.ShippingAddress.CountryID, adrs_delivery_firstname = orderdto.ShippingAddress.FirstName, adrs_delivery_lastname= orderdto.ShippingAddress.LastName, adrs_delivery_city = orderdto.ShippingAddress.City, adrs_delivery_phone = orderdto.ShippingAddress.Phone, adrs_delivery_state_id = orderdto.ShippingAddress.StateID, adrs_delivery_street = orderdto.ShippingAddress.Address1, adrs_delivery_zip = orderdto.ShippingAddress.ZipCode, adrs_billing_country_id = orderdto.BillingAddress.CountryID, cannot_be_edited = false, OrderDeleted = false, Customer_Notes = orderdto.Comment ?? String.Empty, sts1_new_order_received = true, sts1_new_order_received_date = DateTime.Now, sts1_new_order_received_viewed = false, sts2_waiting_for_authorization = false, sts2_waiting_for_authorization_date = DateTime.Now, sts2_waiting_for_authorization_note = "", sts2_waiting_for_authorization_viewed = false, sts3_waiting_for_payment = false, sts3_waiting_for_payment_date = DateTime.Now, sts3_waiting_for_payment_note = "", sts3_waiting_for_payment_viewed = false, sts4_order_confirmed = false, sts4_order_confirmed_date = DateTime.Now, sts4_order_confirmed_note = "", sts4_order_confirmed_viewed = false, sts5_partial_order_confirmed = false, sts5_partial_order_confirmed_date = DateTime.Now, sts5_partial_order_confirmed_note = "", sts5_partial_order_confirmed_viewed = false, sts6_order_failed = false, sts6_order_failed_date = DateTime.Now, sts6_order_failed_note = "", sts6_order_failed_viewed = false, sts7_order_waiting_to_be_send = false, sts7_order_waiting_to_be_send_date = DateTime.Now, sts7_order_waiting_to_be_send_note = "", sts7_order_waiting_to_be_send_viewed = false, sts8_order_send = false, sts8_order_send_date = DateTime.Now, sts8_order_send_note = "", sts8_order_send_viewed = false, sts9_partial_order_send = false, sts9_partial_order_send_date = DateTime.Now, sts9_partial_order_send_note = "", sts9_partial_order_send_viewed = false, sts10_order_received_by_customer = false, sts10_order_received_by_customer_date = DateTime.Now, sts10_order_received_by_customer_note = "", sts10_order_received_by_customer_viewed = false, sts11_partial_order_received_by_customer = false, sts11_partial_order_received_by_customer_date = DateTime.Now, sts11_partial_order_received_by_customer_note = "", sts11_partial_order_received_by_customer_viewed = false, sts12_customer_returning_order = false, sts12_customer_returning_order_date = DateTime.Now, sts12_customer_returning_order_note = "", sts12_customer_returning_order_viewed = false, sts13_customer_returning_part_order = false, sts13_customer_returning_part_order_date = DateTime.Now, sts13_customer_returning_part_order_note = "", sts13_customer_returning_part_order_viewed = false, sts14_customer_refunded = false, sts14_customer_refunded_date = DateTime.Now, sts14_customer_refunded_note = "", sts14_customer_refunded_viewed = false, sts15_customer_partly_refunded = false, sts15_customer_partly_refunded_date = DateTime.Now, sts15_customer_partly_refunded_note = "", sts15_customer_partly_refunded_viewed = false, sts16_order_closed = false, sts16_order_closed_date = DateTime.Now, sts16_order_closed_note = "", sts16_order_closed_viewed = false, sts17_order_cancelled = false, sts17_order_cancelled_date = DateTime.Now, sts17_order_cancelled_note = "", sts17_order_cancelled_viewed = false, sts_curr_stat = "", sts_curr_date = DateTime.Now, Interest_start_date = DateTime.Now, Interest_percent = 0, Merchant_Notes = "", LastModify_Date = DateTime.Now, LastModify_User= "", LastModify_User_Id = customer.id, order_currency = "USD", order_currency_rate = 1, include_receipt = false, hear_fromus = "" }; db.acc_ORDERS.AddObject(order); foreach (var item in orderdto.Items) { switch (item.Type) { case CartItemType.Jewelry: { var cartItem = item as JewelCartItem; var orderItem = new acc_JEWELRY_ORDER_ITEMS() { Item_id = cartItem.ID, Item_quantity = 1, description = "", jewelsize = cartItem.Size, metal = (int) cartItem.MediaType, Item_no = "", OrderNumber = order.OrderNumber }; db.acc_JEWELRY_ORDER_ITEMS.AddObject(orderItem); } break; case CartItemType.Diamond: { var cartItem = item as DiamondCartItem; var orderItem = new acc_DIAMOND_ORDER_ITEMS() { Item_id = cartItem.ID, Item_quantity = 1, description = "", OrderNumber = order.OrderNumber }; db.acc_DIAMOND_ORDER_ITEMS.AddObject(orderItem); } break; case CartItemType.CustomJewel: { var cartItem = item as CustomJewelCartItem; var orderItem = new acc_CUSTOMJEWEL_ORDER_ITEMS() { Setting_id = cartItem.SettingID, Diamond_id = cartItem.DiamondID, Item_quantity = 1, size = cartItem.Size, metal = (int)cartItem.MediaType, diamond_description = "", setting_description = "", OrderNumber = order.OrderNumber }; db.acc_CUSTOMJEWEL_ORDER_ITEMS.AddObject(orderItem); } break; default: throw new ArgumentOutOfRangeException(); } } switch (orderdto.PaymentID) { case 1: { var payment = new acc_CASHFLOW() { user_id = customer.id, payment_type = 1, LastModify_Date = DateTime.Now, LastModify_User = customer.email, LastModify_User_Id = customer.id, amount_interest = 0, amount_actual = totalPrice, amount_costs = 0, amount_total = totalPrice, approved = false, approved_date = DateTime.Now, cc_batch = "", cc_cleared = false, cc_clubmember = false, cc_confirmation = "", cc_cvv = orderdto.CreditCard.CCV, cc_exp_month = orderdto.CreditCard.Month.ToString(), cc_exp_year = orderdto.CreditCard.Year.ToString(), cc_name = orderdto.FirstName + " " + orderdto.LastName, cc_number = orderdto.CreditCard.CreditCardsNumber, cc_type_id = orderdto.CreditCard.CreditCardID, cc_user_ssn = "", cq_account = "", cq_bank = "", cq_date = DateTime.Now, cq_name = "", master = false, mt_account = "", mt_bank = "", mt_code = "", mt_name = "", notes = "", order_id = order.id, paypal = false }; db.acc_CASHFLOW.AddObject(payment); } break; case 2: { var payment = new acc_CASHFLOW() { payment_type = 2, LastModify_Date = DateTime.Now, LastModify_User = customer.email, LastModify_User_Id = customer.id, amount_interest = 0, amount_actual = totalPrice, amount_costs = 0, amount_total = totalPrice, approved = false, approved_date = DateTime.Now, cc_batch = "", cc_cleared = false, cc_clubmember = false, cc_confirmation = "", cc_user_ssn = "", cq_account = "", cq_bank = "", cq_date = DateTime.Now, cq_name = "", master = false, mt_account = "", mt_bank = "", mt_code = "", mt_name = "", notes = "", order_id = order.id, paypal = false, user_id = customer.id }; db.acc_CASHFLOW.AddObject(payment); } break; case 3: { var payment = new acc_CASHFLOW() { payment_type = 3, LastModify_Date = DateTime.Now, LastModify_User = customer.email, LastModify_User_Id = customer.id, amount_interest = 0, amount_actual = totalPrice, amount_costs = 0, amount_total = totalPrice, approved = false, approved_date = DateTime.Now, cc_batch = "", cc_cleared = false, cc_clubmember = false, cc_confirmation = "", cc_user_ssn = "", cq_account = "", cq_bank = "", cq_date = DateTime.Now, cq_name = "", master = false, mt_account = "", mt_bank = "", mt_code = "", mt_name = "", notes = "", order_id = order.id, paypal = true, user_id = customer.id }; db.acc_CASHFLOW.AddObject(payment); } break; } db.SaveChanges(); return order.OrderNumber; } }