public bool Insert(tbl_ChiTietHoaDon detail) { try { db.tbl_ChiTietHoaDon.Add(detail); db.SaveChanges(); return(true); }catch { return(false); } }
public JsonResult JSPayCheck(FormCollection form) { JsonResult js = new JsonResult(); bool isNumeric = true; string finame = form["finame"]; string miname = form["miname"]; string laname = form["laname"]; string add1 = form["add1"]; string add2 = form["add2"]; string country = form["country"]; string state = form["state"]; string city = form["city"]; string phone = form["phone"]; if (string.IsNullOrEmpty(finame) || string.IsNullOrEmpty(laname) || string.IsNullOrEmpty(add1) || string.IsNullOrEmpty(country) || string.IsNullOrEmpty(state) || string.IsNullOrEmpty(city) || string.IsNullOrEmpty(phone)) { js.Data = new { status = "EMPTY" }; } else { foreach (char c in phone) { if (!Char.IsNumber(c)) { isNumeric = false; break; } } if (isNumeric == false) { js.Data = new { status = "ERRPHONE" }; } else { if (phone.Length != 10) { js.Data = new { status = "ERRPHONE" }; } else { string address = add1 + " " + add2 + " " + state + " " + city + " " + country; string name = finame + " " + miname + " " + laname; if (Session["Cart"] == null) { Response.Redirect("/Product/Product/1"); } Code code = new Code(); List <CartItem> giohang = Session["Cart"] as List <CartItem>; if (giohang.Count() == 0) { Response.Redirect("/Product/Product/1"); } bool status = true; foreach (CartItem item in giohang) { if (item.SoLuong > code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong) { status = false; item.SoLuong = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong; } } if (status == true) { if (Session["User"] == null) { Response.Redirect("/Login/Login"); } else { tbl_KhachHang u = (tbl_KhachHang)Session["User"]; tbl_HoaDon hd = new tbl_HoaDon(); hd.MaKhachHang = u.MaKhachHang; hd.NgayLap = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; hd.MaTrangThaiDonHang = 2; hd.DiaChiNhan = address; hd.NguoiNhan = name; hd.SDT = int.Parse(phone); hd.TongTien = giohang.Sum(m => m.ThanhTien); hd.TrangThaiThanhToan = 2; code.AddObject(hd); foreach (CartItem item in giohang) { tbl_ChiTietHoaDon cthd = new tbl_ChiTietHoaDon(); cthd.MaHoaDon = hd.MaHoaDon; cthd.MaThietBi = item.SanPhamID; cthd.SoLuong = item.SoLuong; cthd.ThanhTien = item.ThanhTien; cthd.DonGia = item.DonGia; code.AddObject(cthd); code.Save(); tbl_ThietBi tb = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID); tb.SoLuong = tb.SoLuong - item.SoLuong; code.Save(); } code.Save(); Session.Remove("Cart"); js.Data = new { status = "OK" }; } } else { js.Data = new { status = "ER" }; } } } } return(Json(js, JsonRequestBehavior.AllowGet)); }
public ActionResult Payment(string sTenNguoiNhan, string sEmail, string sSoDienThoai, string sDiaChi, string FormOfPayment, string sBankCode, FormCollection formcollection) { var order = new tbl_HoaDon(); var userSession = (UserLogin)Session[Common.CommonConstants.USER_SESSION]; var TenTinhThanh = formcollection["hdnTenTinhThanh"]; var TenQuanHuyen = formcollection["hdnTenQuanHuyen"]; string diachi = TenQuanHuyen + ", " + TenTinhThanh; if (userSession != null) { order.IDKhachHang = userSession.UserID; } order.dNgayTao = DateTime.Now; order.sTenNguoiNhan = sTenNguoiNhan; order.sEmailNguoiNhan = sEmail; order.sSDTnguoiNhan = sSoDienThoai; order.sDiaChi = sDiaChi + ", " + TenQuanHuyen + ", " + TenTinhThanh; order.sFormOfPayment = FormOfPayment; order.iMaTrangThai = 1; try { var id = new HoaDonDAO().Insert(order); var cart = (List <GioHangItems>)Session[CartSession]; var detailDao = new Model.DAO.ChiTietHoaDonDAO(); decimal total = 0; foreach (var item in cart) { var divsp = new SanPhamDAO(); var orderDetail = new tbl_ChiTietHoaDon(); orderDetail.IDSanPham = item.SanPham.ID; orderDetail.IDHoaDon = id; orderDetail.sGhiChu = item.sGhiChu; orderDetail.iSoLuong = item.SoLuong; if (item.SanPham.dGiaKhuyenMai != null && item.SanPham.dGiaKhuyenMai != 0) { orderDetail.dDonGia = item.SanPham.dGiaKhuyenMai; } else { orderDetail.dDonGia = item.SanPham.dGiaBan; } detailDao.Insert(orderDetail); if (item.SanPham.dGiaKhuyenMai != null && item.SanPham.dGiaKhuyenMai != 0) { total += (item.SanPham.dGiaKhuyenMai.GetValueOrDefault(0) * item.SoLuong); } else { total += (item.SanPham.dGiaBan.GetValueOrDefault(0) * item.SoLuong); } divsp.divSanPham(item.SanPham.ID, item.SoLuong); //ViewBag.Total = total; } if (!FormOfPayment.Equals("COD")) { RequestInfo info = new RequestInfo(); info.Merchant_id = MerchantID; info.Merchant_password = MerchantPassword; info.Receiver_email = MerchantEmail; info.cur_code = "vnd"; info.bank_code = sBankCode; info.Order_code = id.ToString(); info.Total_amount = total.ToString(); info.fee_shipping = "0"; info.Discount_amount = "0"; info.order_description = "Thanh toán đơn hàng Myhands Store"; info.return_url = currentLink + "/hoan-thanh"; info.cancel_url = currentLink + "/loi-thanh-toan"; info.Buyer_fullname = sTenNguoiNhan; info.Buyer_email = sEmail; info.Buyer_mobile = sSoDienThoai; APICheckoutV3 objNLChecout = new APICheckoutV3(); ResponseInfo result = objNLChecout.GetUrlCheckout(info, FormOfPayment); if (result.Error_code == "00") { Response.Redirect(result.Checkout_url); //return Redirect("/hoan-thanh"); } else { return(Redirect("/loi-thanh-toan")); } } string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Client/Templates/MailForm.html")); content = content.Replace("{{sTenNguoiNhan}}", sTenNguoiNhan); content = content.Replace("{{sSoDienThoai}}", sSoDienThoai); content = content.Replace("{{sEmail}}", sEmail); content = content.Replace("{{sDiaChi}}", sDiaChi + diachi); content = content.Replace("{{Total}}", total.ToString("N0")); var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString(); new Mail().SendMail(sEmail, "Đơn hàng mới từ MyHandsStore", content); new Mail().SendMail(toEmail, "Đơn hàng mới từ MyHandsStore", content); } catch (Exception ex) { string script = "<script>alert('" + ex.Message + "');</script>"; return(Redirect("/loi-thanh-toan")); } Session[CartSession] = null; return(Redirect("/hoan-thanh")); }