public static object ApiCartGet(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); var cartInfoList = CartDao.GetCartInfoList(siteId, context.UserName, sessionId); var totalCount = 0; decimal totalFee = 0; foreach (var cartInfo in cartInfoList) { totalCount += cartInfo.Count; totalFee += cartInfo.Fee * cartInfo.Count; } var configInfo = Context.ConfigApi.GetConfig <ConfigInfo>(Main.PluginId, siteId) ?? new ConfigInfo(); return(new { context.IsUserLoggin, configInfo.IsForceLogin, cartInfoList, totalCount, totalFee }); }
public UnitOfWork(IDbConnection connection) { _connection = connection; StoredProcedures = new StoredProcedures(connection); Brands = new BrandDao(connection); Carts = new CartDao(connection); Categories = new CategoryDao(connection); CategoryProducts = new CategoryProductDao(connection); ContactInfo = new ContactInfoDao(connection); Characteristics = new CharacteristicDao(connection); CharacteristicProducts = new CharacteristicProductDao(connection); FavouriteProducts = new FavouriteProductDao(connection); Items = new ItemDao(connection); OptionalParameters = new OptionalParameterDao(connection); OptionalParameterProducts = new OptionalParameterProductDao(connection); Orders = new OrderDao(connection); OrderDeliveryTypes = new OrderDeliveryTypeDao(connection); OrderPaymentTypes = new OrderPaymentTypeDao(connection); OrderProducts = new OrderProductDao(connection); OrderStatuses = new OrderStatusDao(connection); Products = new ProductDao(connection); ProductImages = new ProductImageDao(connection); Roles = new RoleDao(connection); SupportMessages = new SupportMessageDao(connection); Users = new UserDao(connection); }
public static object ApiAddSuccessGet(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); var cartInfoList = CartDao.GetCartInfoList(siteId, context.UserName, sessionId); var productName = string.Empty; decimal productFee = 0; var totalCount = 0; decimal totalFee = 0; foreach (var cartInfo in cartInfoList) { if (string.IsNullOrEmpty(productName)) { productName = cartInfo.ProductName; productFee = cartInfo.Fee; } totalCount += cartInfo.Count; totalFee += cartInfo.Fee * cartInfo.Count; } return(new { productName, productFee = "¥" + productFee.ToString("N"), totalCount, totalFee = "¥" + totalFee.ToString("N") }); }
// GET: Admin/Cart public ActionResult Index(int page = 1, int pageSize = 10) { var dao = new CartDao(); var model = dao.ListAllPagding(page, pageSize); return(View(model)); }
public int SuaSL(int id, int soluong) { List <cartModel> li = Session["giohang"] as List <cartModel>; Session["giohang"] = CartDao.SuaSoLuong(id, soluong, li); return(cartModel.tongTien); }
public ActionResult Index() { var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION]; var list = new List <GioHangModel>(); if (session != null) { var cart = new CartDao().GetProductsByIdUser(session.UserId); foreach (var item in cart) { var cartitem = new GioHangModel(); var product = new ProductDao().viewDetail(item.MaSanPham); var categorydao = new CategoryDao(); if (categorydao.getSPChinh(product.Id) == 1) { cartitem.MaSanPham = item.MaSanPham; cartitem.Id = item.Id; cartitem.TenSanPham = product.TenSanPham; cartitem.Anh = product.Anh; cartitem.SoLuong = item.SoLuong; cartitem.SanPhamThu = item.SanPhamThu; cartitem.GiaBan = new CartDao().Tien1LyTraSua(session.UserId, product.Id, item.SanPhamThu); cartitem.ThanhTien = cartitem.GiaBan * cartitem.SoLuong; cartitem.MoTa = new CartDao().getMoTa(product.Id, session.UserId, item.SanPhamThu); list.Add(cartitem); } } return(View(list)); } else { return(View("/SanPham/Index")); } }
public ActionResult DeleteCart(int productid, int sanphamthu) { var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION]; if (session != null) { var userid = session.UserId; var list = new CartDao().layDSSP(productid, userid, sanphamthu); int?spthu = 0; foreach (var item in list) { new CartDao().Delete(item.Id); spthu = item.SanPhamThu; } var listconlai = new CartDao().GetProductsByIdUser(userid); foreach (var item in listconlai) { if (spthu < item.SanPhamThu) { var sanpham_giohang = db.GioHangs.Find(item.Id); sanpham_giohang.SanPhamThu = item.SanPhamThu - 1; db.SaveChanges(); } } var session_sanphamthu = (Common.Session.SanPhamThuSession)Session[Common.Constants.SANPHAMTHU_SESSION]; var sp_thu = new Common.Session.SanPhamThuSession(); sp_thu.SanPham_Thu = session_sanphamthu.SanPham_Thu - 1; Session.Add(Common.Constants.SANPHAMTHU_SESSION, sp_thu); } return(RedirectToAction("Index")); }
public static object ApiPaySaveAddress(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); var deliveryId = context.GetPostInt("deliveryId"); var addressInfo = context.GetPostObject <AddressInfo>("addressInfo"); var isEdit = context.GetPostBool("isEdit"); addressInfo.UserName = context.UserName; addressInfo.SessionId = sessionId; if (isEdit) { AddressDao.Update(addressInfo); } else { addressInfo.Id = AddressDao.Insert(addressInfo); } AddressDao.SetDefault(context.UserName, sessionId, addressInfo.Id); var cartInfoList = CartDao.GetCartInfoList(siteId, context.UserName, sessionId); var deliveryInfo = DeliveryDao.GetDeliveryInfo(deliveryId); var deliveryFee = Utils.GetDeliveryFee(cartInfoList, addressInfo, deliveryInfo); return(new { addressInfo, deliveryFee }); }
public int XoaSP(int id) { List <cartModel> li = Session["giohang"] as List <cartModel>; Session["giohang"] = CartDao.XoaSPTrongCart(id, li); return(cartModel.TongTien); }
void TestAddCartItem() { CartDao cartDao = new CartDao(); CartDaoCollection c = new CartDaoCollection(cartDao); CartDao.AddCartItem(userid, menuitemid); CartDao.GetAllCartItems(); }
public ActionResult Edit(int id) { SetUser(); var cart = new CartDao().GetById(id); return(View(cart)); }
void TestRemoveCartItem() { CartDao cartDao = new CartDao(); CartDaoCollection c = new CartDaoCollection(cartDao); CartDao.RemoveCartItem(); CartDao.GetAllCartItems(); }
public static object ApiPayGet(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); if (context.IsUserLoggin) { CartDao.UpdateUserName(siteId, sessionId, context.UserName); } var addressInfoList = AddressDao.GetAddressInfoList(context.UserName, sessionId); var cartInfoList = CartDao.GetCartInfoList(siteId, context.UserName, sessionId); AddressInfo addressInfo = null; foreach (var addInfo in addressInfoList) { if (addInfo.IsDefault) { addressInfo = addInfo; } } if (addressInfo == null && addressInfoList.Count > 0) { addressInfo = addressInfoList[0]; } var deliveryInfoList = DeliveryDao.GetDeliveryInfoList(siteId); DeliveryInfo deliveryInfo = null; if (deliveryInfoList.Count > 0) { deliveryInfo = deliveryInfoList[0]; } var totalCount = 0; decimal totalFee = 0; var deliveryFee = Utils.GetDeliveryFee(cartInfoList, addressInfo, deliveryInfo); foreach (var cartInfo in cartInfoList) { totalCount += cartInfo.Count; totalFee += cartInfo.Fee * cartInfo.Count; } return(new { addressInfoList, addressId = addressInfo?.Id ?? 0, deliveryInfoList, deliveryId = deliveryInfo?.Id ?? 0, cartInfoList, totalCount, totalFee, deliveryFee }); }
public PartialViewResult GioHang() { var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION]; if (session != null) { var cart = new CartDao().GetProductsByIdUser(session.UserId); return(PartialView(cart)); } return(PartialView()); }
public string ThemNSP(int id, int soluong) { if (Session["giohang"] == null) // Nếu giỏ hàng chưa được khởi tạo { Session["giohang"] = new List <cartModel>(); // Khởi tạo Session["giohang"] là 1 List<CartItem> } List <cartModel> giohang = Session["giohang"] as List <cartModel>; // Gán qua biến giohang dễ code Session["giohang"] = CartDao.ThemNSPVaoCart(id, giohang, soluong); return("ok"); }
public PartialViewResult GioHang() { var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION]; if (session != null) { var cart = new CartDao().GetProductsByIdUser(session.UserId); var countitem = cart.Max(x => x.SanPhamThu); ViewBag.CountItem = countitem; return(PartialView(cart)); } return(PartialView()); }
public static object ApiAdd(IRequest context) { var siteId = context.GetPostInt("siteId"); var productId = context.GetPostString("productId"); var productName = context.GetPostString("productName"); var imageUrl = context.GetPostString("imageUrl"); var linkUrl = context.GetPostString("linkUrl"); var fee = context.GetPostDecimal("fee"); var isDelivery = context.GetPostBool("isDelivery"); var count = context.GetPostInt("count", 1); var sessionId = context.GetPostString("sessionId"); var cartInfo = new CartInfo { SiteId = siteId, UserName = context.UserName, SessionId = sessionId, ProductId = productId, ProductName = productName, ImageUrl = imageUrl, LinkUrl = linkUrl, Fee = fee, IsDelivery = isDelivery, Count = count, AddDate = DateTime.Now }; var cartId = CartDao.GetCartId(siteId, sessionId, productId); if (cartId == 0) { cartId = CartDao.Insert(cartInfo); } else { cartInfo = CartDao.GetCartInfo(cartId); cartInfo.UserName = context.UserName; cartInfo.ProductName = productName; cartInfo.ImageUrl = imageUrl; cartInfo.LinkUrl = linkUrl; cartInfo.Fee = fee; cartInfo.IsDelivery = isDelivery; cartInfo.Count += count; cartInfo.AddDate = DateTime.Now; CartDao.Update(cartInfo); } return(cartId); }
public ActionResult Edit(Cart cart) { var dao = new CartDao(); bool result = dao.UpdateCart(cart); if (result) { return(RedirectToAction("Index", "Cart")); } else { ModelState.AddModelError("", "Khong them duoc"); } return(View("Index", "Home")); }
public ActionResult Create(Cart cart) { var dao = new CartDao(); int id = dao.InsertCart(cart); if (id > 0) { return(RedirectToAction("Index", "Cart")); } else { ModelState.AddModelError("", "Khong them san pham thanh cong"); } return(View("Index", "Home")); }
// hàm này để đây và không có tác dụng gì public void SaveDb() { var session = (List <CartItem>)Session[CommonConst.CartSession]; foreach (var item in session) { var _cart = new Cart(); _cart.ProductID = item.Product.ID; _cart.Quantity = item.Quantity; _cart.UserID = ((LoginModel)Session[CommonConst.UserSession]).UserID; _cart.Status = false; var result = new CartDao().Insert(_cart); } }
public static object ApiCartSave(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); var cartInfoList = context.GetPostObject <List <CartInfo> >("cartInfoList"); CartDao.Delete(siteId, context.UserName, sessionId); foreach (var cartInfo in cartInfoList) { cartInfo.UserName = context.UserName; cartInfo.Id = CartDao.Insert(cartInfo); } return(cartInfoList); }
public ActionResult DeleteCart(int productid) { var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION]; if (session != null) { var userid = session.UserId; var list = new CartDao().layDSSP(productid, userid); foreach (var item in list) { var cart = new GioHang(); new CartDao().Delete(item.Id); } } return(RedirectToAction("Index")); }
public static object ApiOrderGet(IRequest context) { var guid = context.GetPostString("guid"); var orderInfo = OrderDao.GetOrderInfo(guid); if (orderInfo != null) { orderInfo.CartInfoList = CartDao.GetCartInfoList(orderInfo.Id); } return(new { context.IsUserLoggin, orderInfo }); }
public ActionResult UpdateCart(int productid, int?soluong, int sanphamthu) { var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION]; if (session != null) { var userid = session.UserId; var list = new CartDao().layDSSP(productid, userid, sanphamthu); foreach (var item in list) { var cart = new GioHang(); new CartDao().Update(item.Id, soluong); } } return(RedirectToAction("Index")); }
public ActionResult Index() { var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION]; if (session != null) { var cart = new CartDao().GetProductsByIdUser(session.UserId); if (cart != null) { var countitem = cart.Max(x => x.SanPhamThu); var session_sanphamthu = new SanPhamThuSession(); session_sanphamthu.SanPham_Thu = Convert.ToInt32(countitem); Session.Add(DoAn.Common.Constants.SANPHAMTHU_SESSION, session_sanphamthu); } } return(View()); }
public static object ApiPaySetAddressAndDelivery(IRequest context) { var siteId = context.GetPostInt("siteId"); var sessionId = context.GetPostString("sessionId"); var addressId = context.GetPostInt("addressId"); var deliveryId = context.GetPostInt("deliveryId"); AddressDao.SetDefault(context.UserName, sessionId, addressId); var cartInfoList = CartDao.GetCartInfoList(siteId, context.UserName, sessionId); var addressInfo = AddressDao.GetAddressInfo(addressId); var deliveryInfo = DeliveryDao.GetDeliveryInfo(deliveryId); var deliveryFee = Utils.GetDeliveryFee(cartInfoList, addressInfo, deliveryInfo); return(new { deliveryFee }); }
public ActionResult Payment(string shipName, string mobile, string address, string email) { var model = new CartDao(); Order order = new Order(); order.ShipName = shipName; order.ShipMobile = mobile; order.ShipAddress = address; order.ShipEmail = email; order.CreateDate = DateTime.Now; int id = model.InsertOrder(order); var sessionCart = (List <CartItem>)Session[CommonConstant.CART_SESSION]; decimal total = 0; foreach (var item in sessionCart) { OrderDetail orderDetail = new OrderDetail(); orderDetail.ProducID = item.Product.ID; orderDetail.OrderID = id; orderDetail.Quantity = item.Quantity; orderDetail.Price = item.Product.Price; model.InsertOrderDetail(orderDetail); total += (item.Product.Price.GetValueOrDefault(0) * item.Quantity); } string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/client/template/newOrder.html")); content = content.Replace("{{CustomerName}}", shipName); content = content.Replace("{{Phone}}", mobile); content = content.Replace("{{Email}}", email); content = content.Replace("{{Address}}", address); content = content.Replace("{{Total}}", total.ToString("N0")); new MailHelper().SendMail(email, "Đơn hàng từ Online Shop", content); return(Redirect("/hoan-thanh")); }
public static object ApiOrdersGet(IRequest context) { var type = context.GetPostString("type"); var orderInfoList = new List <OrderInfo>(); if (context.IsUserLoggin) { orderInfoList = string.IsNullOrEmpty(type) ? OrderDao.GetOrderInfoList(context.UserName, string.Empty) : OrderDao.GetOrderInfoList(context.UserName, Convert.ToBoolean(type)); foreach (var orderInfo in orderInfoList) { orderInfo.CartInfoList = CartDao.GetCartInfoList(orderInfo.Id); } } return(new { context.IsUserLoggin, orderInfoList }); }
public ActionResult CreateBill(HoaDonBanModel model) { var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION]; if (session != null) { new KhachHangDao().Update(session.UserId, model.HoTen, model.DiaChi, model.SDT, model.Email); // tạo idbill DateTime now = DateTime.Now; var idbill = session.UserId.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString(); //insert order var dao = new CartDao(); var cart = dao.GetProductsByIdUser(session.UserId); var item = new HoaDonBan(); item.Id = idbill.ToString(); item.MaKhach = session.UserId; item.MaNhanVien = 1; item.DaThanhToan = 0; item.Duyet = 0; item.TongTien = model.TongTien; item.NgayBan = now; var result = new BillDao().Insert(item); foreach (var item_hdb in cart) { //insert orderdetail var ct_hdb = new ChiTietHDB(); ct_hdb.MaHDB = idbill.ToString(); var product = new ProductDao().viewDetail(item_hdb.MaSanPham); ct_hdb.MaSanPham = item_hdb.MaSanPham; ct_hdb.SoLuong = item_hdb.SoLuong; ct_hdb.GiamGia = 0; ct_hdb.ThanhTien = product.KhuyenMai * item_hdb.SoLuong; ct_hdb.ThuocSanPham = item_hdb.ThuocSanPham; ct_hdb.ChiTietThu = item_hdb.SanPhamThu; new BillDao().Insert_Bill_Detail(ct_hdb); //delete cart dao.Delete(item_hdb.Id); } var khachhang = new KhachHangDao().getById(session.UserId); string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/neworder.html")); content = content.Replace("{{CustomerName}}", khachhang.HoTen); content = content.Replace("{{Phone}}", khachhang.SDT); content = content.Replace("{{Email}}", khachhang.Email); content = content.Replace("{{Address}}", khachhang.DiaChi); content = content.Replace("{{Total}}", String.Format("{0:0,0}", model.TongTien)); var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString(); new MailHelper().SendMail(khachhang.Email, "Đơn hàng mới từ Estore", content); new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Estore", content); ViewBag.Success1 = "Bạn vừa đặt hàng thành công, kiếm tra email của bạn"; return(RedirectToAction("Index", "SanPham")); } else { return(Redirect("/Login/Login")); } }
public void Page_Load(object sender, EventArgs e) { var request = SiteServer.Plugin.Context.GetCurrentRequest(); _siteId = request.GetQueryInt("siteId"); _isPaied = request.GetQueryBool("isPaied"); _state = request.GetQueryString("state"); _keyword = request.GetQueryString("keyword"); if (!request.AdminPermissions.HasSitePermissions(_siteId, Main.PluginId)) { Response.Write("<h1>未授权访问</h1>"); Response.End(); return; } if (!string.IsNullOrEmpty(Request.QueryString["delete"]) && !string.IsNullOrEmpty(Request.QueryString["idCollection"])) { var array = Request.QueryString["idCollection"].Split(','); var list = array.Select(s => Utils.ParseInt(s)).ToList(); OrderDao.Delete(list); LtlMessage.Text = Utils.GetMessageHtml("删除成功!", true); } SpContents.ControlToPaginate = RptContents; SpContents.ItemsPerPage = 30; SpContents.SelectCommand = OrderDao.GetSelectStringBySearch(_siteId, _isPaied, _state, _keyword); SpContents.SortField = nameof(OrderInfo.Id); SpContents.SortMode = "DESC"; RptContents.ItemDataBound += RptContents_ItemDataBound; if (IsPostBack) { return; } LtlPageTitle.Text = Utils.GetStateText(_isPaied, _state) + "订单管理"; DdlSearchState.Items.Add(new ListItem(Utils.GetStateText(false, string.Empty), $"{false}_")); DdlSearchState.Items.Add(new ListItem(Utils.GetStateText(true, string.Empty), $"{true}_")); DdlSearchState.Items.Add(new ListItem(Utils.GetStateText(true, nameof(OrderState.Done)), $"{true}_{nameof(OrderState.Done)}")); Utils.SelectListItems(DdlSearchState, $"{_isPaied}_{_state}"); TbSearchKeyword.Text = _keyword; SpContents.DataBind(); BtnDelete.Attributes.Add("onclick", Utils.ReplaceNewline($@" var ids = []; $(""input[name='idCollection']:checked"").each(function () {{ ids.push($(this).val());}} ); if (ids.length > 0){{ {Utils.SwalWarning("删除订单", "此操作将删除所选订单,确定吗?", "取 消", "删 除", $"location.href='{GetRedirectUrl(_siteId, _isPaied, _state, _keyword)}&delete={true}&idCollection=' + ids.join(',')")} }} else {{ {Utils.SwalError("请选择需要删除的订单!", string.Empty)} }} ;return false;", string.Empty)); BtnStateAll.Attributes.Add("onclick", Utils.ReplaceNewline($@" var ids = []; $(""input[name='idCollection']:checked"").each(function () {{ ids.push($(this).val());}} ); if (ids.length > 0){{ location.href = '{GetRedirectUrl(_siteId, _isPaied, _state, _keyword)}&state={true}&idCollection=' + ids.join(',') }} else {{ {Utils.SwalError("请选择需要更改状态的订单!", string.Empty)} }} ;return false;", string.Empty)); if (!string.IsNullOrEmpty(Request.QueryString["view"])) { PhModalView.Visible = true; var id = Utils.ParseInt(Request.QueryString["id"]); var orderInfo = OrderDao.GetOrderInfo(id); if (!string.IsNullOrEmpty(orderInfo.Message)) { LtlModalViewMessage.Text = Utils.GetMessageHtml(orderInfo.Message); } LtlGuid.Text = orderInfo.Guid; LtlRealName.Text = orderInfo.RealName; LtlMobile.Text = orderInfo.Mobile; LtlTel.Text = orderInfo.Tel; LtlLocation.Text = orderInfo.Location; LtlAddress.Text = orderInfo.Address; LtlZipCode.Text = orderInfo.ZipCode; LtlChannel.Text = Utils.GetChannelText(orderInfo.Channel); LtlAmount.Text = $@"商品金额:¥{orderInfo.TotalFee:N2}元 运费:¥{orderInfo.ExpressCost:N2}元 合计:¥{orderInfo.TotalFee + orderInfo.ExpressCost:N2}元" ; LtlAddDate.Text = orderInfo.AddDate.ToString("yyyy-MM-dd HH:mm:ss"); LtlState.Text = Utils.GetStateText(orderInfo.IsPaied, orderInfo.State); RptCarts.DataSource = CartDao.GetCartInfoList(orderInfo.Id); RptCarts.ItemDataBound += RptCarts_ItemDataBound; RptCarts.DataBind(); BtnState.Attributes.Add("onclick", Utils.ReplaceNewline($@" location.href = '{GetRedirectUrl(_siteId, _isPaied, _state, _keyword)}&setState={true}&idCollection={id}'; return false;", string.Empty)); } else if (!string.IsNullOrEmpty(Request.QueryString["setState"]) && !string.IsNullOrEmpty(Request.QueryString["idCollection"])) { PhModalState.Visible = true; DdlState.Items.Add(new ListItem(Utils.GetStateText(false, string.Empty), $"{false}_")); DdlState.Items.Add(new ListItem(Utils.GetStateText(true, string.Empty), $"{true}_")); DdlState.Items.Add(new ListItem(Utils.GetStateText(true, nameof(OrderState.Done)), $"{true}_{nameof(OrderState.Done)}")); } }