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