public ActionResult OrderlistDetail(int num) { if (Session["Account"] != null) { var datacount = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).Count(); var data = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); if (datacount > 0) { var model = new OrderViewModel() { Order = orderCompleteData.Get().ToList().Where(a => a.num == num && a.memberId == data.num && a.isdel == 0), productsize = psd.Get().ToList(), productcolor = pcd.Get().ToList() }; return View(model); } else { return RedirectToAction("Index", "Home"); } } else { return RedirectToAction("Index", "Home"); } }
public ActionResult Orderlist() { if (Session["Account"] != null) { var datacount = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).Count(); var data = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); if (datacount > 0) { var model = new OrderViewModel() { Order = orderCompleteData.Get().ToList().Where(a => a.memberId == data.num && a.isdel == 0).OrderByDescending(a=>a.num).ThenByDescending(a=>a.wdate) }; return View(model); } else { return RedirectToAction("Index", "Home"); } } else { return RedirectToAction("Index", "Home"); } }
public ActionResult Read(int page = 1, string find1 = "") { if (!CheckMemberlogin) { return RedirectToAction("login", "admin"); } else { leftModel(); ViewBag.searchResult = 0; ViewBag.search = 1; ViewBag.gowhere = Url.Action("Read", "adminOrder"); if (find1 != "") { ViewBag.searchResult = 1; ViewBag.searchText = find1; } var currentpage = page < 1 ? 1 : page; var pagesize = 10; var order = orderCompleteData.Get().ToList().Where(a => a.isdel == 0 && a.orderId.Contains(find1)).OrderByDescending(a => a.wdate); var model = new OrderViewModel() { Order_pagelist = order.ToPagedList(currentpage, pagesize) }; return View(model); } }
public ActionResult Edit(int num) { if (!CheckMemberlogin) { return RedirectToAction("login", "admin"); } else { leftModel(); var model = new OrderViewModel() { Order = orderCompleteData.Get().ToList().Where(a => a.num == num), productsize = psd.Get().ToList(), productcolor = pcd.Get().ToList() }; return View(model); } }
public ActionResult Index(string coupons = "") { TempData["ordercheckempty"] = false; TempData["ordercheckmsg"] = false; TempData["cuponsError"] = false; Session["couponcoin"] = ""; bool isUseCoupon = false; if (Session["Account"] != null) { int total = Convert.ToInt32(Session["CartTotal"] != null ? Session["CartTotal"] : "0"); if (!String.IsNullOrEmpty(coupons)) { //使用優惠券 var datacount = cood.Get().ToList().Where(a => a.CooponCode == coupons && a.isusing == 0 && a.isdel == 0).Count(); var data = cood.Get().ToList().Where(a => a.CooponCode == coupons && a.isusing == 0 && a.isdel == 0).SingleOrDefault(); if (datacount > 0) { isUseCoupon = true; TempData["cuponsError"] = false; TempData["isUseCoupon"] = isUseCoupon; TempData["Couponcoin"] = data.coin; Session["couponcoin"] = data.coin; Session["couponID"] = coupons; var allttotal = total - data.coin; if (allttotal < 0) { allttotal = 0; } Session["CartTotal"] = allttotal; Session["CartDesCoupon"] = allttotal; var model = new OrderViewModel() { prodcut = pd.Get().ToList().Where(a => a.isdel == 0), productsize = psd.Get().ToList().Where(a => a.isdel == 0), productcolor = pcd.Get().ToList().Where(a => a.isdel == 0), Member = md.Get().ToList().Where(a => a.isdel == 0) }; return View(model); } else { return RedirectToAction("Index", "Cart"); } } else { //不使用優惠券 isUseCoupon = false; TempData["isUseCoupon"] = isUseCoupon; TempData["Couponcoin"] = 0; Session["couponcoin"] = 0; Session["couponID"] = null; var allttotal = total - 0; if (allttotal < 0) { allttotal = 0; } Session["CartTotal"] = allttotal; Session["CartDesCoupon"] = allttotal; var model = new OrderViewModel() { prodcut = pd.Get().ToList().Where(a => a.isdel == 0), productsize = psd.Get().ToList().Where(a => a.isdel == 0), productcolor = pcd.Get().ToList().Where(a => a.isdel == 0), Member = md.Get().ToList().Where(a => a.isdel == 0) }; return View(model); } } else { TempData["loginmsg"] = "請先登入會員"; return RedirectToAction("Index", "login"); } }
public ActionResult Complete(OrderComplete orderlist, string keyin = "") { //try //{ if (Session["Account"] != null) { if (keyin == "") { TempData["ordercheckempty"] = true; return RedirectToAction("Index", "Order"); } if (keyin != Session["ordercheck"].ToString()) { TempData["ordercheckmsg"] = true; return RedirectToAction("Index", "Order"); } //------會員------ var memberdata = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); orderlist.memberId = memberdata.num; orderlist.memberAccount = memberdata.uAccount; orderlist.memberName = memberdata.uName; //------地址------ var cd = citydata.Get().ToList().Where(a => a.num == Convert.ToInt32(orderlist.city)).SingleOrDefault(); var ad = areadata.Get().ToList().Where(a => a.num == Convert.ToInt32(orderlist.area)).SingleOrDefault(); orderlist.city = cd.cityName; orderlist.area = ad.AreaName; orderlist.Status = 0; orderlist.isRead = 0; orderlist.isdel = 0; if (Convert.ToInt32(orderlist.pay_mode) == 3) { orderlist.Status = 5; } //-------產生訂單---------- //發票格式 orderlist.pay_invoice = ((Enum_pay_invoice)Convert.ToInt32(orderlist.pay_invoice)).ToString(); //付款方式 orderlist.pay_mode = ((Enum_pay_mode)Convert.ToInt32(orderlist.pay_mode)).ToString(); //運送方式 orderlist.transport = ((Enum_transport)Convert.ToInt32(orderlist.transport)).ToString(); orderlist.wdate = DateTime.Now; orderlist.udate = DateTime.Now; var dataCount = ocd.Get().ToList().Count(); orderlist.orderId = "FUN" + DateTime.Now.ToString("yyyyMMdd") + (dataCount + 1).ToString().PadLeft(3, '0'); //var id = ""; //將購物車內容轉json orderlist.productJson = JsonConvert.SerializeObject(GetCartProduct()); if (Session["CartDesCoupon"] != null) { orderlist.Total = Convert.ToInt32(Session["CartDesCoupon"]); } else { TempData["totalerror"] = "Error"; return RedirectToAction("Index", "Order"); } if (Session["couponcoin"] != null) { orderlist.coupon = Convert.ToInt32(Session["couponcoin"]); } else { orderlist.coupon = 0; } if (Session["couponID"] != null) { orderlist.couponID = Session["couponID"].ToString(); } else { orderlist.couponID = ""; } //************************************************************************************************************************** //將優惠券變成已使用 DeleCoupon(); //刪除購物車內容物 DeleCart(); ocd.Create(orderlist); if (orderlist.pay_mode == "線上刷卡") { return RedirectToAction("AllpayWebsite", orderlist); } var model = new OrderViewModel() { Order = ocd.Get().ToList().Where(a => a.memberId == memberdata.num && a.orderId == orderlist.orderId), prodcut = pd.Get().ToList().Where(a => a.isdel == 0), productsize = psd.Get().ToList().Where(a => a.isdel == 0), productcolor = pcd.Get().ToList().Where(a => a.isdel == 0) }; return View(model); } else { TempData["loginmsg"] = "請先登入會員"; return RedirectToAction("Index", "login"); } //} //catch (Exception ex) //{ // return RedirectToAction("Index", "Home"); //} }
//歐富寶系列導向頁 public ActionResult Complete_AllPay(AllPay_RedirectVal allpay) { try { if ((allpay.RtnCode == 2 && allpay.PaymentType.Contains("ATM")) || (allpay.RtnCode == 10100073 && allpay.PaymentType.Contains("CVS")) || (allpay.RtnCode == 1 && allpay.PaymentType.Contains("Credit"))) { if (Session["Account"] != null) { var memberdata = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()); if (memberdata != null) { var memberdatas = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); var orderlist = ocd.Get().ToList().Where(a => a.memberId == memberdatas.num && a.orderId == allpay.MerchantTradeNo); if (orderlist != null) { SendEmailToGuest(orderlist.SingleOrDefault(), allpay); } var model = new OrderViewModel() { Order = orderlist, prodcut = pd.Get().ToList().Where(a => a.isdel == 0), productsize = psd.Get().ToList().Where(a => a.isdel == 0), productcolor = pcd.Get().ToList().Where(a => a.isdel == 0), AllPay_RedirectVal = allpay }; return View(model); } else { TempData["msg"] = "會員取得失敗"; return RedirectToAction("Index", "Home"); } } else { TempData["msg"] = "會員取得失敗"; return RedirectToAction("Index", "Home"); } } else { var memberdata = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()); if (memberdata != null) { var memberdatas = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); var orderlist = ocd.Get().ToList().Where(a => a.memberId == memberdatas.num && a.orderId == allpay.MerchantTradeNo); if (orderlist != null) { var orderlists = ocd.Get().ToList().Where(a => a.memberId == memberdatas.num && a.orderId == allpay.MerchantTradeNo).SingleOrDefault(); OrderComplete od = new OrderComplete(); od.udate = DateTime.Now; od.isdel = 1; od.num = orderlists.num; ocd.Delete(od); } } TempData["msg"] = "交易失敗,導回首頁"; return RedirectToAction("Index", "Home"); } } catch (Exception ex) { TempData["msg"] = "交易失敗,導回首頁"; return RedirectToAction("Index", "Home"); } }
public ActionResult Complete(OrderComplete orderlist, string keyin = "") { //判斷session, 會員是否有登入 if (Session["Account"] != null) { //再次判斷前端驗證碼是否符合session值 if (keyin != Session["ordercheck"].ToString()) { TempData["msg"] = "驗證碼錯誤"; return RedirectToAction("Index", "OrderNoAllpay"); } //------會員------ //取得會員 var memberdata = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); //會員自動編號 orderlist.memberId = memberdata.num; //會員帳號 orderlist.memberAccount = memberdata.uAccount; //會員姓名 orderlist.memberName = memberdata.uName; //------地址------ //取得城市 var cityd = citydata.Get().ToList().Where(a => a.num == Convert.ToInt32(orderlist.city)).SingleOrDefault(); //取得地區 var aread = areadata.Get().ToList().Where(a => a.num == Convert.ToInt32(orderlist.area)).SingleOrDefault(); //城市 orderlist.city = cityd.cityName; //地區 orderlist.area = aread.AreaName; //訂單狀態 orderlist.Status = 0; orderlist.isRead = 0; //是否刪除 orderlist.isdel = 0; //發票格式 orderlist.pay_invoice = ((Enum_pay_invoice)Convert.ToInt32(orderlist.pay_invoice)).ToString(); //付款方式 orderlist.pay_mode = ((Enum_pay_mode)Convert.ToInt32(orderlist.pay_mode)).ToString(); //運送方式 //orderlist.transport = ((Enum_transport)Convert.ToInt32(orderlist.transport)).ToString(); orderlist.transport = ""; //建檔日期 orderlist.wdate = DateTime.Now; //更新日期 orderlist.udate = DateTime.Now; //訂單筆數 var dataCount = ocd.Get().ToList().Count(); //訂單編號 orderlist.orderId = "SUN" + DateTime.Now.ToString("yyyyMMdd") + (dataCount + 1).ToString().PadLeft(3, '0'); //優惠券金額 orderlist.coupon = 0; //優惠券序號 orderlist.couponID = ""; //將購物車內容轉json orderlist.productJson = JsonConvert.SerializeObject(GetCartProduct()); //每筆商品總額相加 int total = 0; foreach (var i in cd.Get().ToList().Where(a => a.isdel == 0 && a.memberID == memberdata.num)) { total += i.total; } //****************需要運費不須註解******************* //運費已城市為主 //int pay = 0, paydesc = 0; //bool isPaytf = false; //int totalAddPay = 0; //pay = PayFn.GetPay(cityd.num); //paydesc = PayFn.GetDescPay(cityd.num); //if (total < paydesc) //{ // isPaytf = true; // totalAddPay = total + pay; //} //else //{ // isPaytf = false; // totalAddPay = total; //} //****************//需要運費不須註解******************* //總金額 orderlist.Total = total; //刪除購物車內容物 DeleCart(); //新增訂單 ocd.Create(orderlist); //******寄信*********** string toEmail = orderlist.buyemail; string fromEmail = "*****@*****.**"; string Title = "杉魁-訂單通知"; string Subject = "杉魁-訂單通知"; string Content = ""; bool isSSL = false; Content = "<table align='center' border='1' cellpadding='2' cellspacing='0' width='700'>" + "<tbody>" + "<tr><td align='right' width='15%'>訂單編號</td><td align='left' width='85%'>" + orderlist.orderId + "</td></tr>" + "<tr><td align='right'>訂購人</td><td align='left'>" + orderlist.buyers + "</td></tr>" + "<tr><td align='right'>聯絡電話</td><td align='left'>" + orderlist.buyers_tel + "</td></tr>" + "<tr><td align='right'>取貨人</td><td align='left'>" + orderlist.consignee + "</td></tr>" + "<tr><td align='right'>取貨人電話</td><td align='left'>" + orderlist.consignee_tel + "</td></tr>" + "<tr><td align='right'>取貨人手機</td><td align='left'>" + orderlist.consignee_phone + "</td></tr>" + "<tr><td align='right'>取貨人地址</td><td align='left'>" + orderlist.city + orderlist.area + orderlist.address + "</td></tr>" + "<tr><td align='right'>發票格式</td><td align='left'>" + orderlist.pay_invoice + "</td></tr>" + "<tr><td align='right'>統一編號</td><td align='left'>" + orderlist.number + "</td></tr>" + "<tr><td align='right'>抬頭</td><td align='left'>" + orderlist.invoice_title + "</td></tr>" + "<tr><td align='right'>下單時間</td><td align='left'>" + orderlist.wdate + "</td></tr>" + "<tr><td align='right'>付款方式</td><td align='left'>" + orderlist.pay_mode + "</td></tr>" + "<tr><td align='right'>總金額</td><td align='left'>" + orderlist.Total + "元</td></tr>" + "<tr><td align='right'>運費</td><td align='left'>" + orderlist.thispay + "元(出貨時會另行通知)</td></tr>" + "<tr><td align='right'>備 註</td><td align='left'>" + orderlist.demo + "</td></tr>" + "<tr><td align='right'>產品清單</td><td align='left'>" + "<table border='1'>" + "<thead>" + //"<th align='center'>圖片</th>" + "<th align='center'>產品名稱</th>" + "<th align='center'>形式</th>" + "<th align='center' width='5%'>價錢</th>" + "<th align='center' width='5%'>數量</th>" + "</thead>" + "<tbody>"; var alltotal = 0; if (!String.IsNullOrEmpty(orderlist.productJson)) { var jsonstr = JsonConvert.DeserializeObject<List<productlistforCart>>(orderlist.productJson); foreach (var i in jsonstr) { Content += "<tr>"; //Content += "<td align='center'><img src='" + AppDomain.CurrentDomain.BaseDirectory +"/upload/product/" + i.pic1 + "' width='50' height='50'/></td>"; Content += "<td align='center'>" + i.pname + "</td>"; Content += "<td align='center'>" + i.pro_type_name + "</td>"; Content += "<td align='center'>" + i.price + "</td>"; Content += "<td align='center'>" + i.qty + "</td>"; Content += " </tr>"; alltotal += (i.qty * i.price); } } Content += "<tr>"; Content += "<td align='center' colspan='5'>"; Content += "<span>總計(原金額):" + alltotal + "</span>"; Content += "</td>"; Content += "</tr>"; Content += "<tr>"; Content += "<td align='center' colspan='5'>"; Content += "<span>運費:" + orderlist.thispay + "</span>"; Content += "</td>"; Content += "</tr>"; Content += "<tr>"; Content += "<td align='center' colspan='5'>"; Content += "<span>(總金額+運費):" + (orderlist.Total + orderlist.thispay) + "</span>"; Content += "</td>"; Content += "</tr>"; Content += "</tbody></table></td></tr></tbody></table>"; SendMailToEveryOne.SendMail(toEmail, fromEmail, Title, Subject, Content, isSSL); SendMailToEveryOne.SendMail(fromEmail, toEmail, Title, Subject, Content, isSSL); //*********//寄信*********** //製作成ViewModel供訂單完成頁面使用 var model = new OrderViewModel() { Order = ocd.Get().ToList().Where(a => a.memberId == memberdata.num && a.orderId == orderlist.orderId), prodcut = pd.Get().ToList().Where(a => a.isdel == 0), total = total, //pay = pay, //ispay = isPaytf }; return View(model); } else { TempData["msg"] = "請先登入會員"; return RedirectToAction("Index", "login"); } }
public ActionResult Index() { if (Session["Account"] != null) { var mdata = md.Get().ToList().Where(a => a.uAccount == Session["Account"].ToString()).SingleOrDefault(); int total = 0; var cartdata = cd.Get().ToList().Where(a => a.isdel == 0 && a.memberID == mdata.num); if (cartdata != null && cartdata.Count() > 0) { foreach (var i in cd.Get().ToList().Where(a => a.isdel == 0 && a.memberID == mdata.num)) { total += i.total; } var model = new OrderViewModel() { cart = cd.Get().ToList().Where(a => a.isdel == 0 && a.memberID == mdata.num), prodcut = pd.Get().ToList().Where(a => a.isdel == 0), Member = md.Get().ToList().Where(a => a.isdel == 0 && a.num == mdata.num), pro_type_item = ptid.Get().ToList().Where(a => a.isdel == 0), total = total }; return View(model); } else { TempData["msg"] = "您尚未購物,系統將自動導向"; return RedirectToAction("Index", "product"); } } else { TempData["msg"] = "無登入會員,系統將自動導向"; return RedirectToAction("Index", "login"); } }