public HttpResponseMessage GetOrderByID(HttpRequestMessage request, int ID)
{
Context ctx = new Context();
OrderRepository orderRepo = new OrderRepository(ctx);
tbOrder result = orderRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ID == ID).FirstOrDefault();
return(request.CreateResponse <tbOrder>(HttpStatusCode.OK, result));
}
//UpSertOrder
public async Task <ActionResult> UpSertOrder(tbOrder tbOrder)
{
var url = "api/Order/UpsertOrder";
tbOrder result = await APIRequest <tbOrder> .Post(url, tbOrder);
if (result != null)
{
return(Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
public HttpResponseMessage UpsertOrder(HttpRequestMessage request, tbOrder tbOrder)
{
OrderRepository orderRepo = new OrderRepository();
tbOrder UpdatedEntity = null;
if (tbOrder.ID > 0)
{
UpdatedEntity = orderRepo.update(tbOrder);
}
else
{
UpdatedEntity = orderRepo.Add(tbOrder);
}
return(request.CreateResponse <tbOrder>(HttpStatusCode.OK, UpdatedEntity));
}
//_OrderForm
public async Task <ActionResult> _OrderForm(string FormType, int ID)
{
tbOrder tbOrder = new tbOrder();
if (FormType == "Add")
{
return(PartialView("_OrderForm", tbOrder));
}
else
{
string url = string.Format("api/Order/GetOrderByID?ID={0}", ID);
tbOrder result = await APIRequest <tbOrder> .Get(url);
return(PartialView("_OrderForm", result));
}
}
public ActionResult CheckOut()
{
//string AgentID; //mitt konto/integration
//string Key; //md5, mitt konto/integration
//string Description = "SWEProtein";
//string SellerEmail = "*****@*****.**";
//int payson_totalsumma = ((List<tbProduct>) Session["cartList"]).Sum(c => c.iPrice);
//string BuyerEmail = ((tbUser) Session["activeUser"]).sEmail;
//int Cost = payson_totalsumma;
//int ExtraCost; //t.ex. frakten
//string OkUrl; //betalningen lyckas
//string CancelUrl;
//int RefNr = ((tbUser) Session["activeUser"]).iID;
//string GuaranteeOffered = "1";
//string MD5string = SellerEmail + ":" + Cost + ":" + ExtraCost + ":" + OkUrl + ":" + GuaranteeOffered
//string MD5Hash = MD5(MD5string);
var order = new tbOrder()
{
iUserID = 2, //Byt till Session["login"].ID
iStatus = 1,
iSum = ((List<tbProduct>)Session["cartList"]).Sum(prod => prod.iPrice * prod.iCount),
dtOrderDate = DateTime.Now
};
db.tbOrders.InsertOnSubmit(order);
db.SubmitChanges();
foreach (tbProduct prod in ((List<tbProduct>) Session["cartList"]))
{
var prodOrder = new tbProductOrder()
{
iOrderID = order.iID,
iProductID = prod.iID,
iQuantity = prod.iCount,
iPrice = prod.iPrice
};
db.tbProductOrders.InsertOnSubmit(prodOrder);
}
db.SubmitChanges();
return View(); //Gå till för "färdig" betalning
}
public ActionResult CheckOut()
{
//string AgentID; //mitt konto/integration
//string Key; //md5, mitt konto/integration
//string Description = "SWEProtein";
//string SellerEmail = "*****@*****.**";
//int payson_totalsumma = ((List<tbProduct>) Session["cartList"]).Sum(c => c.iPrice);
//string BuyerEmail = ((tbUser) Session["activeUser"]).sEmail;
//int Cost = payson_totalsumma;
//int ExtraCost; //t.ex. frakten
//string OkUrl; //betalningen lyckas
//string CancelUrl;
//int RefNr = ((tbUser) Session["activeUser"]).iID;
//string GuaranteeOffered = "1";
//string MD5string = SellerEmail + ":" + Cost + ":" + ExtraCost + ":" + OkUrl + ":" + GuaranteeOffered
//string MD5Hash = MD5(MD5string);
var order = new tbOrder()
{
iUserID = 2, //Byt till Session["login"].ID
iStatus = 1,
iSum = ((List <tbProduct>)Session["cartList"]).Sum(prod => prod.iPrice * prod.iCount),
dtOrderDate = DateTime.Now
};
db.tbOrders.InsertOnSubmit(order);
db.SubmitChanges();
foreach (tbProduct prod in ((List <tbProduct>)Session["cartList"]))
{
var prodOrder = new tbProductOrder()
{
iOrderID = order.iID,
iProductID = prod.iID,
iQuantity = prod.iCount,
iPrice = prod.iPrice
};
db.tbProductOrders.InsertOnSubmit(prodOrder);
}
db.SubmitChanges();
return(View()); //Gå till för "färdig" betalning
}
public bool Linq_Them(string maGD, string loaiGia, string giaShow, string nameCTKM, int building, string priceRoom, DateTime checkin, DateTime checkout, string nameGuest, string IdGuest, string nationality, string Kenh, DateTime dateBook, string soPhong, string passPort, string listingName, string OAT, int roomPrepaid, int totalPrice, string matutang, string matutangGuest)
{
tbOrder ins = new tbOrder();
ins.order_codeTrading = maGD;
ins.order_loaiGia = loaiGia;
ins.order_priceShow = giaShow;
ins.order_nameCTKM = nameCTKM;
ins.building_id = building;
ins.order_priceRoom = priceRoom;
ins.order_checkin = checkin;
ins.order_checkout = checkout;
ins.order_nameGuest = nameGuest;
ins.order_IdGuest = IdGuest;
ins.order_country = nationality;
ins.order_kenhBook = Kenh;
ins.order_dateBook = dateBook;
ins.order_amount = soPhong;
ins.order_hidden = true;
ins.order_Show = true;
ins.order_status = "Unverified";
ins.order_passport = passPort;
ins.listring_name = listingName;
ins.order_OTATABookingID = OAT;
ins.order_RoomPrepaid = roomPrepaid;
ins.order_totalprice = Convert.ToString(totalPrice);
ins.order_matutangbook = "Book-" + matutang;
ins.order_matutangGuest = matutangGuest;
db.tbOrders.InsertOnSubmit(ins);
try
{
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.Compare(base.Request.RequestType, "post", true) != 0)
{
btnSubmit.Enabled = false;
}
else if (base.IsPostBack)
{
tbOrders = (IList<tbOrder>)Session["tbOrders"];
}
else
{
XmlDocument document = new XmlDocument();
if (string.IsNullOrEmpty(base.Request.Form["data"]))
{
ShowMsg("数据丢失，请关闭此页重新操作", false);
}
else
{
document.LoadXml(base.Request.Form["data"]);
tbOrders = new List<tbOrder>();
XmlNodeList list = document.FirstChild.SelectNodes("order");
string innerText = null;
string str2 = null;
for (int i = 0; i < list.Count; i++)
{
string str3;
tbOrder order = new tbOrder();
XmlNode node = list.Item(i);
if (innerText == null)
{
innerText = node.SelectSingleNode("ship_addr").InnerText;
str2 = node.SelectSingleNode("ship_name").InnerText;
}
else
{
str3 = node.SelectSingleNode("ship_addr").InnerText;
string str4 = node.SelectSingleNode("ship_name").InnerText;
if ((innerText != str3) || (str2 != str4))
{
ShowMsg("收货人地址/姓名不一致不能合并下单！", false);
break;
}
str2 = str4;
innerText = str3;
}
string[] strArray = innerText.Split(new char[] { ' ' });
txtShipTo.Text = str2;
if (strArray.Length >= 4)
{
str3 = strArray[0] + "," + strArray[1] + "," + strArray[2];
rsddlRegion.SelectedRegions = str3;
txtAddress.Text = strArray[3];
}
txtZipcode.Text = node.SelectSingleNode("ship_zipcode").InnerText;
txtTel.Text = node.SelectSingleNode("ship_tel").InnerText;
txtMobile.Text = node.SelectSingleNode("ship_mobile").InnerText;
radioShippingMode.DataBind();
if (radioShippingMode.Items.Count > 0)
{
radioShippingMode.Items[0].Selected = true;
}
order.orderId = node.SelectSingleNode("order_id").InnerText;
order.buyer = node.SelectSingleNode("buyer").InnerText;
order.createTime = node.SelectSingleNode("createtime").InnerText;
order.orderMemo = node.SelectSingleNode("order_memo").InnerText;
XmlNode node2 = node.SelectSingleNode("items");
double num2 = 0.0;
for (int j = 0; j < node2.ChildNodes.Count; j++)
{
tbOrderItem item2 = new tbOrderItem();
item2.id = string.Format("{0}_{1}", order.orderId, j);
item2.title = node2.ChildNodes[j].SelectSingleNode("title").InnerText;
item2.spec = node2.ChildNodes[j].SelectSingleNode("spec").InnerText;
item2.price = node2.ChildNodes[j].SelectSingleNode("price").InnerText;
item2.number = node2.ChildNodes[j].SelectSingleNode("number").InnerText;
item2.url = node2.ChildNodes[j].SelectSingleNode("url").InnerText;
tbOrderItem item = item2;
HttpRequest request = HttpContext.Current.Request;
if (request.Cookies[Globals.UrlEncode(item.title + item.spec)] != null)
{
ProductQuery query2 = new ProductQuery();
query2.PageSize = 1;
query2.PageIndex = 1;
query2.ProductCode = Globals.UrlDecode(request.Cookies[Globals.UrlEncode(item.title + item.spec)].Value);
ProductQuery query = query2;
int count = 0;
DataTable puchaseProducts = SubSiteProducthelper.GetPuchaseProducts(query, out count);
if (puchaseProducts.Rows.Count > 0)
{
item.localSkuId = puchaseProducts.Rows[0]["SkuId"].ToString();
item.localSKU = puchaseProducts.Rows[0]["SKU"].ToString();
item.localProductId = puchaseProducts.Rows[0]["ProductId"].ToString().Trim();
item.localProductName = puchaseProducts.Rows[0]["ProductName"].ToString();
item.thumbnailUrl100 = puchaseProducts.Rows[0]["ThumbnailUrl100"].ToString();
item.localPrice = puchaseProducts.Rows[0]["PurchasePrice"].ToString();
item.localStock = puchaseProducts.Rows[0]["Stock"].ToString();
num2 += Convert.ToDouble(puchaseProducts.Rows[0]["PurchasePrice"]) * Convert.ToInt32(item.number);
}
}
else
{
ProductQuery query4 = new ProductQuery();
query4.PageSize = 1;
query4.PageIndex = 1;
query4.Keywords = item.title;
ProductQuery query3 = query4;
int num5 = 0;
DataTable table2 = SubSiteProducthelper.GetPuchaseProducts(query3, out num5);
if (num5 == 1)
{
item.localSkuId = table2.Rows[0]["SkuId"].ToString();
item.localSKU = table2.Rows[0]["SKU"].ToString();
item.localProductId = table2.Rows[0]["ProductId"].ToString().Trim();
item.localProductName = table2.Rows[0]["ProductName"].ToString();
item.thumbnailUrl100 = table2.Rows[0]["ThumbnailUrl100"].ToString();
item.localPrice = table2.Rows[0]["PurchasePrice"].ToString();
item.localStock = table2.Rows[0]["Stock"].ToString();
num2 += Convert.ToDouble(table2.Rows[0]["PurchasePrice"]) * Convert.ToInt32(item.number);
}
}
order.items.Add(item);
order.orderCost = num2;
}
tbOrders.Add(order);
}
Session["tbOrders"] = tbOrders;
pageDataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.Compare(base.Request.RequestType, "post", true) != 0)
{
this.btnSubmit.Enabled = false;
}
else if (base.IsPostBack)
{
this.tbOrders = (IList <tbOrder>) this.Session["tbOrders"];
}
else
{
XmlDocument document = new XmlDocument();
if (string.IsNullOrEmpty(base.Request.Form["data"]))
{
this.ShowMsg("数据丢失，请关闭此页重新操作", false);
}
else
{
document.LoadXml(base.Request.Form["data"]);
this.tbOrders = new List <tbOrder>();
XmlNodeList list = document.FirstChild.SelectNodes("order");
string innerText = null;
string str2 = null;
for (int i = 0; i < list.Count; i++)
{
string str3;
tbOrder order = new tbOrder();
XmlNode node = list.Item(i);
if (innerText == null)
{
innerText = node.SelectSingleNode("ship_addr").InnerText;
str2 = node.SelectSingleNode("ship_name").InnerText;
}
else
{
str3 = node.SelectSingleNode("ship_addr").InnerText;
string str4 = node.SelectSingleNode("ship_name").InnerText;
if ((innerText != str3) || (str2 != str4))
{
this.ShowMsg("收货人地址/姓名不一致不能合并下单！", false);
break;
}
str2 = str4;
innerText = str3;
}
string[] strArray = innerText.Split(new char[] { ' ' });
this.txtShipTo.Text = str2;
if (strArray.Length >= 4)
{
str3 = strArray[0] + "," + strArray[1] + "," + strArray[2];
this.rsddlRegion.SelectedRegions = str3;
this.txtAddress.Text = strArray[3];
}
this.txtZipcode.Text = node.SelectSingleNode("ship_zipcode").InnerText;
this.txtTel.Text = node.SelectSingleNode("ship_tel").InnerText;
this.txtMobile.Text = node.SelectSingleNode("ship_mobile").InnerText;
this.radioShippingMode.DataBind();
if (this.radioShippingMode.Items.Count > 0)
{
this.radioShippingMode.Items[0].Selected = true;
}
order.orderId = node.SelectSingleNode("order_id").InnerText;
order.buyer = node.SelectSingleNode("buyer").InnerText;
order.createTime = node.SelectSingleNode("createtime").InnerText;
order.orderMemo = node.SelectSingleNode("order_memo").InnerText;
XmlNode node2 = node.SelectSingleNode("items");
double num2 = 0.0;
for (int j = 0; j < node2.ChildNodes.Count; j++)
{
tbOrderItem item = new tbOrderItem();
item.id = string.Format("{0}_{1}", order.orderId, j);
item.title = node2.ChildNodes[j].SelectSingleNode("title").InnerText;
item.spec = node2.ChildNodes[j].SelectSingleNode("spec").InnerText;
item.price = node2.ChildNodes[j].SelectSingleNode("price").InnerText;
item.number = node2.ChildNodes[j].SelectSingleNode("number").InnerText;
if (string.IsNullOrEmpty(item.number))
{
item.number = "1";
}
item.url = node2.ChildNodes[j].SelectSingleNode("url").InnerText;
HttpRequest request = HttpContext.Current.Request;
if (request.Cookies[Globals.UrlEncode(item.title + item.spec)] != null)
{
ProductQuery query = new ProductQuery();
query.PageSize = 1;
query.PageIndex = 1;
query.ProductCode = Globals.UrlDecode(request.Cookies[Globals.UrlEncode(item.title + item.spec)].Value);
int count = 0;
DataTable puchaseProducts = SubSiteProducthelper.GetPuchaseProducts(query, out count);
if (puchaseProducts.Rows.Count > 0)
{
item.localSkuId = puchaseProducts.Rows[0]["SkuId"].ToString();
item.localSKU = puchaseProducts.Rows[0]["SKU"].ToString();
item.localProductId = puchaseProducts.Rows[0]["ProductId"].ToString().Trim();
item.localProductName = puchaseProducts.Rows[0]["ProductName"].ToString();
item.thumbnailUrl100 = puchaseProducts.Rows[0]["ThumbnailUrl100"].ToString();
item.localPrice = puchaseProducts.Rows[0]["PurchasePrice"].ToString();
item.localStock = puchaseProducts.Rows[0]["Stock"].ToString();
num2 += Convert.ToDouble(puchaseProducts.Rows[0]["PurchasePrice"]) * Convert.ToInt32(item.number);
}
}
else
{
ProductQuery query2 = new ProductQuery();
query2.PageSize = 1;
query2.PageIndex = 1;
query2.Keywords = item.title;
int num5 = 0;
DataTable table2 = SubSiteProducthelper.GetPuchaseProducts(query2, out num5);
if (num5 == 1)
{
item.localSkuId = table2.Rows[0]["SkuId"].ToString();
item.localSKU = table2.Rows[0]["SKU"].ToString();
item.localProductId = table2.Rows[0]["ProductId"].ToString().Trim();
item.localProductName = table2.Rows[0]["ProductName"].ToString();
item.thumbnailUrl100 = table2.Rows[0]["ThumbnailUrl100"].ToString();
item.localPrice = table2.Rows[0]["PurchasePrice"].ToString();
item.localStock = table2.Rows[0]["Stock"].ToString();
num2 += Convert.ToDouble(table2.Rows[0]["PurchasePrice"]) * Convert.ToInt32(item.number);
}
}
order.items.Add(item);
order.orderCost = num2;
}
this.tbOrders.Add(order);
}
this.Session["tbOrders"] = this.tbOrders;
this.pageDataBind();
}
}
}
public HttpResponseMessage UpsertOrderDetail(HttpRequestMessage request, string items)
{
#region Instances
Context ctx = new Context();
ItemRepository itemRepo = new ItemRepository(ctx);
StockRepository stockRepo = new StockRepository(ctx);
OrderRepository orderRepo = new OrderRepository(ctx);
OrderDetailRepository orderDetailRepo = new OrderDetailRepository(ctx);
InventoryRepository inventoryRepo = new InventoryRepository(ctx);
tbItem tbItem = new tbItem();
tbStock tbStock = new tbStock();
tbInventory tbInventory = new tbInventory();
tbOrder tbOrder = new tbOrder();
tbOrderDetail tbOrderDetail = new tbOrderDetail();
tbOrder UpdatedOrder = null;
tbOrderDetail UpdatedEntity = null;
decimal totalPrice = 0;
string voucherCode = Guid.NewGuid().ToString();
#endregion
#region insert order table
tbOrder.StaffGUID = "Default";
tbOrder.StaffName = "Default";
tbOrder.CinemaId = 1;
tbOrder.CinemaName = "";
tbOrder.VoucherCode = voucherCode;
tbOrder.Accesstime = DateTime.UtcNow.ToLocalTime();
tbOrder.IsDeleted = false;
tbOrder.TotalPrice = totalPrice;
tbOrder.CreatedAt = DateTime.UtcNow.ToLocalTime();
tbOrder.Status = "Default";
tbOrder.ServiceFees = 0;
tbOrder.SubTotalPrice = tbOrder.TotalPrice;
tbOrder.TotalTax = 0;
tbOrder.TaxIncluded = false;
tbOrder.Currency = "";
tbOrder.TotalDiscounts = 0;
tbOrder.TotalItemPrice = tbOrder.TotalPrice;
tbOrder.DiscountCode = "";
tbOrder.Remark = "";
UpdatedOrder = orderRepo.Add(tbOrder);
#endregion
List <string> itemList = items.Split(',').ToList();
foreach (string item in itemList)
{
string[] idVal = item.Split('|').ToArray();
string itemGUID = idVal[0];
int qty = Convert.ToInt32(idVal[1]);
tbItem = itemRepo.GetDataSet().Where(a => a.IsDeleted != true && a.UniqueID.ToString() == itemGUID).FirstOrDefault();
//if(tbStock.StockQty>=qty)
//{ }
#region Add order detail.
tbOrderDetail.ItemID = tbItem.ID;
tbOrderDetail.ItemName = tbItem.Item;
tbOrderDetail.ItemPrice = tbItem.SellingPrice;
tbOrderDetail.ItemQty = qty;
tbOrderDetail.TotalPrice = tbOrderDetail.ItemPrice * qty;
totalPrice += Convert.ToDecimal(tbOrderDetail.TotalPrice);
tbOrderDetail.VoucherCode = voucherCode;
tbOrderDetail.OrderID = UpdatedOrder.ID;
tbOrderDetail.CinemaID = tbOrder.CinemaId;
tbOrderDetail.CinemaName = tbOrder.CinemaName;
tbOrderDetail.IsDeleted = false;
UpdatedEntity = orderDetailRepo.Add(tbOrderDetail);
#endregion
#region update stock table.
tbStock = stockRepo.GetDataSet().Where(s => s.IsDeleted != true && s.ItemGUID.ToString() == itemGUID && s.CinemaID == tbOrder.CinemaId).FirstOrDefault();
tbStock.StockQty = tbStock.StockQty - qty;
tbStock.Accesstime = DateTime.UtcNow.ToLocalTime();
stockRepo.update(tbStock);
#endregion
#region update inventory table.
tbInventory.FlowType = "StockOut";
tbInventory.ItemPrice = tbItem.SellingPrice;
tbInventory.TotalItemPrice = totalPrice;
tbInventory.IsDeleted = false;
tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime();
tbInventory.UniqueID = Guid.NewGuid();
tbInventory.ItemGUID = tbItem.UniqueID;
tbInventory.ItemName = tbItem.Item;
tbInventory.TransactionType = "3"; //TransactionType:3 (StockOut)
tbInventory.CinemaID = tbOrder.CinemaId;
tbInventory.Qty = qty;
inventoryRepo.Add(tbInventory);
#endregion
}
#region update total price to order table
tbOrder = orderRepo.GetDataSet().Where(x => x.IsDeleted != true && x.VoucherCode == voucherCode).FirstOrDefault();
tbOrder.TotalPrice = totalPrice;
tbOrder.TotalItemPrice = totalPrice;
orderRepo.update(tbOrder);
#endregion
return(request.CreateResponse <tbOrderDetail>(HttpStatusCode.OK, UpdatedEntity));
}
