//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) { int _orderID = -1; ESHOP_ORDER _order = new ESHOP_ORDER(); _order.ORDER_TOTAL_ALL = Total_All; _order.ORDER_TOTAL_AMOUNT = Total_All; _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); }
//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); }
public void Add_booking2(int projectId, string fullname, string phone, string email, string CONTENT, string company, string address) { ESHOP_ORDER _contact = new ESHOP_ORDER(); _contact.NEWS_ID = projectId; _contact.ORDER_FULLNAME = fullname; _contact.ORDER_PHONE = phone; _contact.ORDER_EMAIL = email; _contact.ORDER_CONTENT = CONTENT; _contact.ORDER_COMPANY = company; _contact.ORDER_ADDRESS = address; _contact.ORDER_STATUS = 0; _contact.ORDER_PUBLISHDATE = DateTime.Now; db.ESHOP_ORDERs.InsertOnSubmit(_contact); db.SubmitChanges(); }
//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) { int _orderID = -1; ESHOP_ORDER _order = new ESHOP_ORDER(); _order.ORDER_TOTAL_ALL = Total_All; _order.ORDER_TOTAL_AMOUNT = Total_All; _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; }