private int Insert_Order(decimal Total_All, string Name, string OrderCode, string Email, string Address, int PaymentID, Guid News_guid, string Desc, DateTime Date, string Phone, decimal ship)
        {
            int _orderID = -1;
            ESHOP_ORDER _order = new ESHOP_ORDER();
            _order.ORDER_TOTAL_ALL = Total_All;
            _order.ORDER_TOTAL_AMOUNT = ship > 0 ? Total_All + ship : Total_All;
            _order.ORDER_SHIPPING_FEE = ship;
            _order.ORDER_NAME = Name;
            _order.ORDER_CODE = OrderCode;
            _order.ORDER_EMAIL = Email;
            _order.ORDER_ADDRESS = Address;
            _order.ORDER_PAYMENT = PaymentID;
            _order.CUSTOMER_OID = News_guid;
            _order.ORDER_PUBLISHDATE = DateTime.Now;
            _order.ORDER_STATUS = 0;
            _order.ORDER_FIELD1 = Desc;
            _order.ORDER_UPDATE = Date;
            _order.ORDER_PHONE = Phone;
            db.ESHOP_ORDERs.InsertOnSubmit(_order);
            db.SubmitChanges();

            var _getOrderID = db.GetTable<ESHOP_ORDER>().Where(a => a.CUSTOMER_OID == News_guid);
            _orderID = _getOrderID.ToList()[0].ORDER_ID;
            return _orderID;
        }
Exemplo n.º 2
0
 partial void DeleteESHOP_ORDER(ESHOP_ORDER instance);
Exemplo n.º 3
0
 partial void InsertESHOP_ORDER(ESHOP_ORDER instance);
Exemplo n.º 4
0
 partial void UpdateESHOP_ORDER(ESHOP_ORDER instance);
        //Inser order
        private int Insert_Order(decimal Total_All, string Name, string OrderCode, string Email, string Address, int PaymentID, Guid News_guid, string Desc, DateTime Date, string Phone, decimal ship)
        {
            int _orderID = -1;
            ESHOP_ORDER _order = new ESHOP_ORDER();
            _order.ORDER_TOTAL_ALL = Total_All;
            _order.ORDER_TOTAL_AMOUNT = ship > 0 ? Total_All + ship : Total_All;
            _order.ORDER_SHIPPING_FEE = ship;
            _order.ORDER_NAME = Name;
            _order.ORDER_CODE = OrderCode;
            _order.ORDER_EMAIL = Email;
            _order.ORDER_ADDRESS = Address;
            _order.ORDER_PAYMENT = PaymentID;
            _order.CUSTOMER_OID = News_guid;
            int _iUserID = Utils.CIntDef(HttpContext.Current.Session["USER_ID"]);
            if (_iUserID != 0)
                _order.CUSTOMER_ID = _iUserID;
            else {
                string _code = Utils.CStrDef(HttpContext.Current.Session["User_Code"]);
                string _codecookie =fun.getCookiePartner();
                if (String.IsNullOrEmpty(_code))
                    _code = _codecookie;
                if (!String.IsNullOrEmpty(_code))
                {
                    int _userid =acc.getUserid(_code);
                    _order.CUSTOMER_ID = _userid;
                }
            }
            _order.ORDER_PUBLISHDATE = DateTime.Now;

            _order.ORDER_STATUS = 0;
            _order.ORDER_FIELD1 = Desc;
            _order.ORDER_UPDATE = Date;
            _order.ORDER_PHONE = Phone;
            db.ESHOP_ORDERs.InsertOnSubmit(_order);
            db.SubmitChanges();

            var _getOrderID = db.GetTable<ESHOP_ORDER>().Where(a => a.CUSTOMER_OID == News_guid);
            _orderID = _getOrderID.ToList()[0].ORDER_ID;
            return _orderID;
        }