public JsonResult XoaSpGioHang(string Id) { Guid IDGioHang = Guid.Parse(Id); bool kq = new GioHangController().XoaSPGioHang(IDGioHang); if (kq == true) { return(Json(true, JsonRequestBehavior.AllowGet)); } return(Json(false, JsonRequestBehavior.AllowGet)); }
public ActionResult SPSach() { taikhoan tk = (taikhoan)Session[CommonConstants.SESSION_ACCOUNT]; DonHangValue Dh = new GioHangController().KiemTraTkTrongDonHang(tk.id); List <ThongTinGioHang> DanhsachSP = new GioHangController().DanhSachSpTrongGio(Dh.IdDonHang); decimal?TongTien = new GioHangController().TongTien(Dh.IdDonHang); ViewBag.TongTien = TongTien; return(View(DanhsachSP)); }
public void testTC1_ThemGioHangDong() { GioHangController gc = new GioHangController(); List <GioHang> ds = new List <GioHang>(); for (int i = 0; i < 5; i++) { Random r = new Random(); int a = r.Next(1, 10); GioHang g = new GioHang("SP" + a); gc.ThemGioHang("SP" + a, "http://localhost:12742/"); ds.Add(g); } Assert.AreEqual(5, ds.Count); Assert.AreEqual(ds.Count, gc.TongSl()); }
public ActionResult ThayDoiSoL(string SL, string IDGioHang, string GiaTam, string IDDonHang) { Guid IDGioHangs = Guid.Parse(IDGioHang); Guid IDDonHangs = Guid.Parse(IDDonHang); int soluong = int.Parse(SL); decimal giatam = decimal.Parse(GiaTam); GioHangValue Gh = new GioHangValue() { IdGioHang = IDGioHangs, Soluong = soluong, Tamtinh = giatam }; bool kq = new GioHangController().UpdateGiohang(Gh); decimal?TongGia = new GioHangController().TongTien(IDDonHangs); DonHangValue Donh = new DonHangValue() { IdDonHang = IDDonHangs, TongTien = TongGia }; bool updae = new GioHangController().CapNhatDonHang(Donh); if (kq == false) { return(Json(false, JsonRequestBehavior.AllowGet)); } return(Json(true, JsonRequestBehavior.AllowGet)); }
protected void btn_muahang_Click(object sender, EventArgs e) { string idgio = ""; int slg = 0; string ngaylap = System.DateTime.Now.Day.ToString() + "/" + System.DateTime.Now.Month.ToString() + "/" + System.DateTime.Now.Year.ToString(); //int idg = 4; gh = new GioHangController(); DataTable tb; if (Session["GioHang"] == null) { tb = gh.SetTable(); idgio = DateTime.Now.Day.ToString() + "" + System.DateTime.Now.Month.ToString() + "" + System.DateTime.Now.Year.ToString() + "" + DateTime.Now.Hour.ToString() + "" + DateTime.Now.Minute.ToString() + "" + DateTime.Now.Second.ToString(); } else { tb = (DataTable)Session["GioHang"]; foreach (DataRow gr in tb.Rows) { idgio = gr["idgio"].ToString(); slg = int.Parse(gr["SoLuong"].ToString()); } } // int idsp = int.Parse(Request.QueryString.Get("idsp")); bool kt = gh.Check_SPTrongGio(idsp, idgio); if (kt) { int sl = int.Parse(Session["sl"].ToString()); Validate va = new Validate(); string sql1 = "SELECT SUM(SoLuong) AS Tong FROM dbo.GioHang WHERE IDSanPham=" + idsp + " AND IDGioHang='" + idgio + "'"; va.dr = va.getData(sql1); if (va.dr.Read()) { int soLuong = int.Parse(va.dr["Tong"].ToString()); if ((sl - soLuong) <= 0) { Lbtb.Text = "<script>alert('Bạn đã thêm sản phẩm tối đa.!')</script>"; va.dr.Close(); } else { va.dr.Close(); string sql = "SELECT * FROM dbo.tbSANPHAM WHERE IDSanPham='" + Request.QueryString.Get("idsp") + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, SqlDataConnect.connet); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow dr in dt.Rows) { tb = gh.dienVaoBang(tb, dr["HinhAnh1"].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), Convert.ToInt16(dr["IDSanPham"]), Convert.ToInt16(dr["SoLuong"]), idgio.ToString()); gh.GioHang_UpDateSl(slg + 1, idsp, idgio); Session["GioHang"] = tb; Response.Redirect("GioHang.aspx"); } } } } else { string sql = "SELECT * FROM dbo.tbSANPHAM WHERE IDSanPham='" + Request.QueryString.Get("idsp") + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, SqlDataConnect.connet); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow dr in dt.Rows) { tb = gh.dienVaoBang(tb, dr["HinhAnh1"].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), Convert.ToInt16(dr["IDSanPham"]), Convert.ToInt16(dr["SoLuong"]), idgio.ToString()); Session["GioHang"] = tb; GioHangInfo info = new GioHangInfo { IDDonHang = idgio, IDDienThoai = int.Parse(dr["IDSanPham"].ToString()), SoLuongMua = 1, Gia = int.Parse(dr["Gia"].ToString()), NgayLap = ngaylap }; GioHangController giohang = new GioHangController(); giohang.GioHang_Insert(info); Response.Redirect("GioHang.aspx"); } } }
public JsonResult MuaSach(string ID, string Gia) { taikhoan tk = (taikhoan)Session[CommonConstants.SESSION_ACCOUNT]; if (tk == null) { return(Json(false, JsonRequestBehavior.AllowGet)); } DonHangValue DonHang = new GioHangController().KiemTraTkTrongDonHang(tk.id); if (DonHang != null) { GioHangValue GioHang = new GioHangValue() { IdDonHang = DonHang.IdDonHang, IdGioHang = Guid.NewGuid(), IdSach = Guid.Parse(ID), Soluong = 1, Tamtinh = decimal.Parse(Gia) }; bool ThemGh = new GioHangController().ThemGioHang(GioHang); decimal?tongiten = new GioHangController().TongTien(DonHang.IdDonHang); DonHang.TongTien = tongiten; new GioHangController().CapNhatDonHang(DonHang); if (ThemGh == true) { return(Json(true, JsonRequestBehavior.AllowGet)); } } else { DonHangValue DHMoi = new DonHangValue() { IdDonHang = Guid.NewGuid(), IdNguoiMua = tk.id, NgayDatHang = DateTime.Now.Date, TongTien = 0 }; bool ThemDonHang = new GioHangController().ThemDonHang(DHMoi); if (ThemDonHang == true) { GioHangValue Ghmoi = new GioHangValue() { IdDonHang = DHMoi.IdDonHang, IdGioHang = Guid.NewGuid(), IdSach = Guid.Parse(ID), Soluong = 1, Tamtinh = Decimal.Parse(Gia) }; bool ThemGioHangM = new GioHangController().ThemGioHang(Ghmoi); decimal?tongtien = new GioHangController().TongTien(DHMoi.IdDonHang); DHMoi.TongTien = tongtien; bool CapNhatDonH = new GioHangController().CapNhatDonHang(DHMoi); if (ThemDonHang == true) { return(Json(true, JsonRequestBehavior.DenyGet)); } } } return(Json(true, JsonRequestBehavior.DenyGet)); }
public void TC_CapNhatGioHangDong() { Random r = new Random(); int a = r.Next(1, 10); GioHangController g = new GioHangController(); }