public ActionResult Payment(PaymentModel payment)
{
try
{
if (ModelState.IsValid)
{
order order = new order();
order.user_id = int.Parse(Session["id"].ToString());
order.display_name = payment.display_name;
order.phone_number = payment.phone_number;
order.address = payment.address;
order.email = payment.email;
order.start_time = DateTime.Now.Date;
order.form_payments = payment.form_payments;
order.form_delivery = payment.form_delivery;
order.status = false;
order.total_money = this.totalMoney();
db.orders.Add(order);
db.SaveChanges();
try
{
var carts = this.getProductInCookie();
foreach (var item in carts)
{
order_details orderDetail = new order_details();
orderDetail.order_id = order.id;
orderDetail.product_id = item.id;
orderDetail.name = Server.UrlDecode(item.name);
orderDetail.quantity = item.quantity;
if (item.price_promotion > 0)
{
var giamGia = String.Format("{0:0}", item.price * ((100 - item.price_promotion) / 100));
orderDetail.price = Decimal.Parse(giamGia.ToString());
}
else
{
orderDetail.price = item.price;
}
orderDetail.into_money = item.totalMoney;
db.order_details.Add(orderDetail);
db.SaveChanges();
}
}
catch (Exception e)
{
}
Response.Cookies["CartCookie"].Expires = DateTime.Now.AddDays(-1);
var content = db.order_details.Where(n => n.order_id == order.id).ToList();
var body = new PaymentSuccess().body(order.display_name, content);
new Utils().SendEmail(payment.email, "Chúc mừng bạn đã mua sản phẩm thành công", body, "", "");
return(Redirect("~/Trang-Chu"));
}
}catch (Exception e)
{
}
this.getFormPayment();
this.getFormDelivery();
return(View(payment));
}
public ActionResult DeleteConfirmed(int id)
{
order_details order_details = db.order_details.Find(id);
db.order_details.Remove(order_details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "order_detail_id,order_id,game_platform_id,physical_copy,qty_ordered")] order_details order_details)
{
if (ModelState.IsValid)
{
db.Entry(order_details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.game_platform_id = new SelectList(db.game_platforms, "game_platform_id", "game_platform_id", order_details.game_platform_id);
ViewBag.order_id = new SelectList(db.orders, "order_id", "order_id", order_details.order_id);
return(View(order_details));
}
public ActionResult AddOrder(String address)
{
int userid = (Session["User"] as account).id;
decimal totalprice = 0;
var cart = cos.carts;
foreach (var item in cart)
{
if (item.id_user == userid)
{
var query = from product in cos.products
where product.id == item.id_products
select product;
product prod = query.FirstOrDefault();
totalprice += prod.price * item.quantity;
ShoppingCart dto = new ShoppingCart(prod, item.quantity);
if (shopCart == null)
{
shopCart = new List <ShoppingCart>();
}
shopCart.Add(dto);
}
}
order od = new order {
id_user = userid, totalprice = totalprice, createdAt = DateTime.Now, address = address
};
cos.orders.Add(od);
cos.SaveChanges();
var query1 = from order in cos.orders
where order.id_user == userid
select order;
query1 = query1.OrderByDescending(o => o.id);
order or = query1.FirstOrDefault();
foreach (var item in shopCart)
{
order_details detail = new order_details {
id_order = or.id, id_products = item.Product.id, price = item.Product.price, quantity = item.Quantity, createdAt = or.createdAt
};
cos.order_details.Add(detail);
cos.carts.RemoveRange(cos.carts.Where(x => x.id_user == userid));
cos.SaveChanges();
}
TempData["order"] = "Order successfully";
return(RedirectToAction("Index", "Home"));
}
// GET: OrderDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_details order_details = db.order_details.Find(id);
if (order_details == null)
{
return(HttpNotFound());
}
return(View(order_details));
}
public ActionResult PaymentPayPal(order data)
{
order order = new order();
order.user_id = int.Parse(Session["id"].ToString());
order.display_name = data.display_name;
order.phone_number = data.phone_number;
order.address = data.address;
order.email = data.email;
order.start_time = DateTime.Now.Date;
order.form_payments = data.form_payments;
order.form_delivery = data.form_delivery;
order.status = false;
order.total_money = this.totalMoney();
db.orders.Add(order);
db.SaveChanges();
try
{
var carts = this.getProductInCookie();
foreach (var item in carts)
{
order_details orderDetail = new order_details();
orderDetail.order_id = order.id;
orderDetail.product_id = item.id;
orderDetail.name = Server.UrlDecode(item.name);
orderDetail.quantity = item.quantity;
if (item.price_promotion > 0)
{
var giamGia = String.Format("{0:0}", item.price * ((100 - item.price_promotion) / 100));
orderDetail.price = Decimal.Parse(giamGia.ToString());
}
else
{
orderDetail.price = item.price;
}
orderDetail.into_money = item.totalMoney;
db.order_details.Add(orderDetail);
db.SaveChanges();
}
var content = db.order_details.Where(n => n.order_id == order.id).ToList();
var body = new PaymentSuccess().body(order.display_name, content);
new Utils().SendEmail(data.email, "Chúc mừng bạn đã mua sản phẩm thành công", body, "", "");
}
catch (Exception e)
{
}
//var body = new PaymentSuccess().body();
//new Utils().SendEmail(payment.email, "Chúc mừng bạn đã mua sản phẩm thành công", body, "", "");
return(View());
}
// GET: OrderDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_details order_details = db.order_details.Find(id);
if (order_details == null)
{
return(HttpNotFound());
}
ViewBag.game_platform_id = new SelectList(db.game_platforms, "game_platform_id", "game_platform_id", order_details.game_platform_id);
ViewBag.order_id = new SelectList(db.orders, "order_id", "order_id", order_details.order_id);
return(View(order_details));
}
public ActionResult Add()
{
User user = (User)Session["user"];
int userId = user.U_Id;
var query =
(from o in context.Carts
where o.User_Id == userId
select new { o.Product_Id, o.Product.Price, o.Quantity, o.Product }).ToList();
decimal totalPrice = 0;
if (query.Count > 0)
{
foreach (var item in query)
{
totalPrice += item.Price * item.Quantity;
}
}
// add new order
Order newOrder = new Order();
newOrder.User_Id = userId;
newOrder.Total_Price = totalPrice;
newOrder.Sales_Date = DateTime.Now;
context.Orders.Add(newOrder);
context.SaveChanges();
var oId =
(from o in context.Orders
select o.O_Id).Max();
// add order details
foreach (var item in query)
{
order_details odetails = new order_details();
odetails.O_Id = oId;
odetails.p_id = item.Product_Id;
odetails.Quantity = item.Quantity;
odetails.Price = (int)item.Product.Price;
context.order_details.Add(odetails);
updateQuantity(item.Product_Id, item.Quantity);
}
context.SaveChanges();
return(RedirectToAction("Index"));
//return View();
}
/// <summary>
/// 微信下单
/// </summary>
/// <param name="order_no">系统订单号</param>
/// <param name="product">商品gid列表</param>
/// <param name="member_gid">会员gid</param>
/// <param name="openid">会员openid</param>
/// <param name="type">1=真柏 2=视频 3=课程</param>
/// <param name="remarks">备注</param>
/// <param name="address">快递地址</param>
/// <param name="consignee">收货人</param>
/// <param name="contact_number">联系电话</param>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">对象结果</para>
/// <remarks>
/// 2018-08-18 林建生
/// </remarks>
public static string wxpay(string order_no, string product, Guid member_gid, string openid, int type, string remarks, string address = "", string consignee = "", string contact_number = "")
{
using (EFDB db = new EFDB())
{
//订单的gid
Guid order_gid = Guid.NewGuid();
//产品金额
decimal total_price = 0;
//产品名称
string body = "多个商品订单";
//添加订单产品列表
JArray json = (JArray)JsonConvert.DeserializeObject(product);
Guid? product_gid = null;
int number = 0;
foreach (var j in json)
{
product_gid = Guid.Parse(j["product_gid"].ToString());
number = int.Parse(j["number"].ToString());
var p = db.product.Where(l => l.gid == product_gid).FirstOrDefault();
if (json.Count() == 1)
{
body = p.name;
}
//total_price += p.price * number;
var od = new order_details();
od.gid = Guid.NewGuid();
od.add_time = DateTime.Now;
od.order_gid = order_gid;
od.product_gid = (Guid)product_gid;
od.number = number;
od.price = p.price;
od.pay_price = p.price;
db.order_details.Add(od);
}
if (db.SaveChanges() == json.Count())
{
//备注
string attach = JsonConvert.SerializeObject(new { type = type, total_price, order_gid });
//string order_no = RandStr.CreateOrderNO();
total_price = db.order_details.Where(l => l.order_gid == order_gid).Sum(l => l.price * l.number);
//生成订单
var b = new lorder();
b.gid = order_gid;
b.add_time = DateTime.Now;
b.order_no = order_no;
b.member_gid = member_gid;
b.pay_status = 2;
b.pay_type = 2;
b.total_price = total_price;
b.price = total_price;
b.number = type != 1 ? number: json.Count();
b.coupon_price = 0;
b.express_status = 1;
b.address = address;
b.consignee = consignee;
b.contact_number = contact_number;
b.remarks = string.IsNullOrEmpty(remarks) ? attach : remarks;
if (type != 1)
{
b.product_gid = product_gid;
}
db.lorder.Add(b);
if (db.SaveChanges() == 1)
{
//开始微信统一下单
string _Pay_Package = WXPay.Get_RequestHtml(openid, order_no, total_price, body, attach);
//微信jspai支付
if (_Pay_Package.Length > 0)
{
if (!string.IsNullOrEmpty(consignee) && !string.IsNullOrEmpty(contact_number) && !string.IsNullOrEmpty(address))
{
db.member.Where(l => l.gid == member_gid).Update(l => new member {
address = address, contact_number = contact_number, real_name = consignee
});
}
return(_Pay_Package);
}
else
{
db.lorder.Where(l => l.gid == b.gid).Delete();
return("微信下单失败");
}
}
else
{
db.order_details.Where(l => l.order_gid == order_gid).Delete();
db.lorder.Where(l => l.gid == order_gid).Delete();
return("生成订单失败");
}
}
else
{
db.order_details.Where(l => l.order_gid == order_gid).Delete();
return("生成订单列表失败");
}
}
}
public ActionResult SaveOrder(string payment_type)
{
order order = new order();
order_details order_Details = new order_details();
var getid = (from a in db.orders
select a.ID).Count();
if (getid == 0)
{
getid = 1;
}
else
{
getid = (from a in db.orders
select a.ID).Max() + 1;
}
var totalsum = (from a in db.shopping_cart_details
where getid == a.order_id
select a.item_amount).Sum();
//var userid = (from a in db.users
// where a.name == Session["username"].ToString() || a.name == Session["facebookusername"].ToString()
// select a.ID).FirstOrDefault();
var payment_id = (from a in db.Payments
where a.payment_type == payment_type
select a.ID).FirstOrDefault();
order.date_created = DateTime.Now;
order.total_sum = double.Parse(TempData["totalprice"].ToString());
order.amount = totalsum;
// order.user_id = userid;
order.payment_id = payment_id;
db.orders.Add(order);
db.SaveChanges();
var products = (from a in db.shopping_cart_details
where a.order_id == getid
join b in db.products on a.item_id equals b.ID
select b).ToList();
var itemoncart = (from a in db.shopping_cart_details
where getid == a.order_id
select a).ToList();
foreach (var prods in products)
{
foreach (var item in itemoncart)
{
order_Details.order_prd_qty = item.item_amount.ToString();
}
order_Details.order_prd_name = prods.prd_name;
order_Details.order_prd_price = prods.price;
order_Details.prd_id = prods.ID;
var finalqty = prods.prd_quantity - int.Parse(TempData["amount"].ToString());
order_Details.order_date = DateTime.Now;
order_Details.order_id = getid;
db.order_details.Add(order_Details);
db.SaveChanges();
}
return(Json("Order Made Correctly", JsonRequestBehavior.AllowGet));
}
