public string GetTenLSP(CHITIETDONHANG CTDH) { SANPHAM sp = cn.GetObject <SANPHAM>("api/SANPHAM/" + CTDH.SANPHAM_ID); LOAISP lsp = cn.GetObject <LOAISP>("api/LOAISP/" + sp.LOAISP_ID); return(lsp.TEN); }
public ActionResult DatHang(FormCollection collection) { //Them Don hang DonDatHang ddh = new DonDatHang(); KhachHang kh = (KhachHang)Session["Taikhoan"]; List <Giohang> gh = Laygiohang(); ddh.MaKH = kh.MaKH; ddh.NgayMua = DateTime.Now; ddh.Dagiao = false; ddh.Dathanhtoan = false; data.DonDatHangs.InsertOnSubmit(ddh); data.SubmitChanges(); //Them chi tiet don hang foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDH = ddh.MaDH; ctdh.MaSP = item.iMaSP; ctdh.SoLuong = item.iSoluong; ctdh.Gia = (decimal)item.dGiaHienTai; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); Session["Giohang"] = null; return(RedirectToAction("Xacnhandonhang", "GioHang")); }
public ActionResult DatHang(FormCollection collection) { //thêm đơn hàng DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["TaiKhoan1"]; List <GioHangModels> gh = LayGioHang(); dh.MaKH = kh.MaKH; dh.NgayDat = DateTime.Now; var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]); dh.NgayGiao = DateTime.Parse(NgayGiao); dh.TinhTrangGiaoHang = false; dh.DaThanhToan = false; db.DONHANGs.Add(dh); db.SaveChanges(); //thêm chi tiết đơn hàng foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDonHang = dh.MaDonHang; ctdh.MASACHCT = item.iMaSach; ctdh.Soluong = item.iSoLuong; ctdh.DonGia = (float)item.dDongia; db.CHITIETDONHANGs.Add(ctdh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
public ActionResult Order(FormCollection collection) { DONDATHANG ddh = new DONDATHANG(); KHACHHANG kh = (KHACHHANG)Session["Taikhoan"]; List <GH> gh = takeGH(); ddh.MaKH = kh.MaKH; ddh.Ngaydat = DateTime.Now; var ngaygiao = string.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]); ddh.Ngaygiao = DateTime.Parse(ngaygiao); ddh.Tinhtranggiaohang = false; ddh.Dathanhtoan = false; data.DONDATHANGs.InsertOnSubmit(ddh); data.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDonHang = ddh.MaDonHang; ctdh.MaLT = item.iMaLT; ctdh.Soluong = item.iSoluong; ctdh.Dongia = (decimal)item.dDongia; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); //Session["GioHang"] = null; return(RedirectToAction("Xacnhandonhang", "GioHang")); }
public ActionResult Capnhatctdh(int id) { CHITIETDONHANG ctdh = data.CHITIETDONHANGs.Where(n => n.mactdh == id).SingleOrDefault(); ViewBag.Tinhtrang = new SelectList(data.TINHTRANGs.OrderBy(n => n.matinhtrang).ToList(), "matinhtrang", "tentinhtrang", ctdh.matinhtrang); return(View(ctdh)); }
public ActionResult DatHang(FormCollection collection) { DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["Email"]; List <Giohang> gh = LayGioHang(); dh.MaKH = kh.MaKH; dh.NgayLap = DateTime.Now; var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]); dh.NgayGiao = DateTime.Parse(NgayGiao); dh.DaThanhToan = false; dh.ThanhTien = TongTien(); data.DONHANGs.InsertOnSubmit(dh); data.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDH = dh.MaDH; ctdh.MaSP = item.sMaSP; ctdh.Soluong = item.sSoLuong; ctdh.DonGia = (int)item.sDonGia; ctdh.TongCong = ctdh.Soluong * ctdh.DonGia; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
public ActionResult Payment(DONHANG model) { //model. = DateTime.Now; try { context.DONHANGs.Add(model); context.SaveChanges(); var cart = (Cart)Session["CartSession"]; foreach (var item in cart.Lines) { CHITIETDONHANG obj = new CHITIETDONHANG(); obj.MaDH = model.MaDH; obj.MaThuoc = item.Thuoc.MaThuoc; //obj.= item.Sanpham.GiaSP; obj.SoLuong = item.Quantity; context.CHITIETDONHANGs.Add(obj); context.SaveChanges(); } cart.Clear(); Session["CartSession"] = cart; } catch (Exception ex) { //ghi log return(RedirectToAction("/Loi")); } return(View("Complete")); }
public ActionResult DatHang(FormCollection collection) { KHACHHANG kh = (KHACHHANG)Session["TAIKHOAN"]; DONHANG dh = new DONHANG(); List <GioHang> gh = LayGioHang(); dh.MAKH = kh.MAKH; dh.NGAYDAT = DateTime.Now; dh.DATHANHTOAN = Convert.ToString(0); data.DONHANGs.InsertOnSubmit(dh); data.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MADH = dh.MADH; ctdh.MATRANH = item.iMATRANH; ctdh.SOLUONG = item.iSOLUONG; ctdh.DONGIA = (decimal)item.dTHANHTIEN; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
public ActionResult Payment(string shipName, string mobile, string address, string email) { var order = new DONHANG(); order.NGAYDAT = DateTime.Now; order.DIACHI = address; order.HOTEN = shipName; order.DIENTHOAI = mobile; order.EMAIL = email; try { var id = new FHoaDon().Insert(order); var cart = (List <CartItem>)Session[CartSession]; var detailDao = new FChiTietHD(); decimal total = 0; foreach (var item in cart) { var orderDetail = new CHITIETDONHANG(); orderDetail.MASACH = item.SACH.MASACH; orderDetail.MADONHANG = id; orderDetail.DONGIA = item.SACH.GIABAN; orderDetail.SOLUONG = item.Quantity; detailDao.Insert(orderDetail); total += (item.SACH.GIABAN.GetValueOrDefault(0) * item.Quantity); } } catch (Exception ex) { //ghi log return(RedirectToAction("Failed"));; } return(RedirectToAction("Success")); }
public ActionResult DatHang(FormCollection col) { DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"]; List <GIOHANG> gh = LayGioHang(); dh.MAKH = kh.MAKH; dh.NGAYDAT = DateTime.Now; var ngaygiao = String.Format("{0:MM/dd/yyyy}", col["NgayGiao"]); dh.NGAYGIAO = DateTime.Parse(ngaygiao); dh.TINHTRANGGIAOHANG = "Chưa giao hàng"; dh.TINHTRANGTHANHTOAN = "Chưa thanh toán"; db.DONHANGs.InsertOnSubmit(dh); db.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MADH = dh.MADH; ctdh.MAHOA = item.mahoa; ctdh.SOLUONG = item.soluong; ctdh.DONGIA = (int)item.dongia; db.CHITIETDONHANGs.InsertOnSubmit(ctdh); } db.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhan", "GioHang")); }
public ActionResult OrderInformation(string MaSP) { CHITIETDONHANG ctDonHang = new CHITIETDONHANG(MaSP); Response.Cookies["MaSP"]["MaSP"] = MaSP; return(View(ctDonHang)); }
public ActionResult CheckOut(FormCollection collection) { // Thêm đơn hàng DONHANG dh = new DONHANG(); NGUOIDUNG kh = (NGUOIDUNG)Session["TaiKhoan"]; List <ShopCart> sc = GetShopCart(); dh.IDNguoiDung = kh.IDNguoiDung; dh.NgayDatHang = DateTime.Now; var ngaygiao = String.Format("{0:mm/dd/yyy}", collection["NgayGiaoHang"]); dh.NgayGiaoHang = DateTime.Parse(ngaygiao); dh.TrangThai = false; db.DONHANGs.Add(dh); db.SaveChanges(); //thêm chi tiết đơn hàng foreach (var item in sc) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDH = dh.MaDH; ctdh.MaSP = item.iMaSP; ctdh.SoLuong = item.iSoLuong; ctdh.TongTien = (decimal)item.dThanhTien; db.CHITIETDONHANGs.Add(ctdh); } db.SaveChanges(); Session["ShopCart"] = null; return(RedirectToAction("ConfirmOrder", "ShopCart")); }
private void btnXuat_Click(object sender, EventArgs e) { CHITIETDONHANG CTDH = dhDAO.GetCTDHbyId((int)grViewCTDH.GetFocusedRowCellValue("ID")); FormLayHang frmLayHang = new FormLayHang(CTDH); frmLayHang.ShowDialog(); }
internal void xoabotsodiakhachmua_GUI_QLDONHANG(int donhang_id) { // throw new NotImplementedException(); /* lấy ra một tập các đĩa đã mua trong bảng CHITIETHOADON */ IEnumerable <CHITIETDONHANG> ds_ctdh = db.CHITIETDONHANGs.Where(ctdh => ctdh.DONHANG_ID == donhang_id); #region //foreach (var cthd in ds_ctdh) //{ // //tìm thằng đĩa_id tương ứng // DIA dia = db.DIAs.Where(d => d.ID == cthd.DIA_ID).First(); // //xóa số lượng đĩa // dia.SOLUONG = dia.SOLUONG - cthd.SOLUONGDIAMUA; // //cập nhật // db.SaveChanges(); //} #endregion for (int i = 0; i < ds_ctdh.Count(); i++) { CHITIETDONHANG ctdh = ds_ctdh.ElementAt(i); //tìm thằng đĩa_id tương ứng DIA dia = db.DIAs.Where(d => d.ID == ctdh.DIA_ID).First(); //xóa số lượng đĩa dia.SOLUONG = dia.SOLUONG - ctdh.SOLUONGDIAMUA; //cập nhật db.SaveChanges(); } }
protected void btnDatHang_Click(object sender, EventArgs e) { if (Session["GioHang"] != null) { DataTable dtGioHang = (DataTable)Session["GioHang"]; if (Page.IsValid) { KHACHHANG KHACHHANG = new KHACHHANG { HOTEN = txtHoTen.Text, SDT = txtSDT.Text, EMAIL = txtEmail.Text, DIACHI = txtDiaChi.Text, }; DataTable ThongTinKH = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'"); if (ThongTinKH.Rows.Count > 0) { } else { bool result = DAO.InsertKHACHHANG(KHACHHANG); } DataTable dtKhacHang = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'"); string MaKH = dtKhacHang.Rows[0]["MAKH"].ToString(); DateTime NgayDat = DateTime.Now; int MaDH = RanDom(); DONHANG DONHANG = new DONHANG { NGAYDAT = NgayDat, MAKH = MaKH, MADONHANG = MaDH }; bool result1 = DAO.InsertDONHANG(DONHANG); //DataTable dtDonHang = DAO.getTable("SELECT * FROM dbo.DONHANG WHERE MAKH='" + MaKH + "' AND NGAYDATHANG='" + NgayDat + "'"); //string MaDonHang = dtDonHang.Rows[0]["MADONHANG"].ToString(); if (dtGioHang.Rows.Count > 0) { for (int i = 0; i < dtGioHang.Rows.Count; i++) { DataTable dtSanPham = DAO.getTable("SELECT * FROM dbo.SANPHAM WHERE MASP='" + dtGioHang.Rows[i]["MaSanPham"].ToString() + "'"); int SoLuongSP = (int)dtSanPham.Rows[0]["SOLUONG"] - (int)dtGioHang.Rows[i]["SoLuong"]; CHITIETDONHANG CHITIETDONHANG = new CHITIETDONHANG { MADONHANG = MaDH, MASP = dtGioHang.Rows[i]["MaSanPham"].ToString(), SOLUONG = (int)dtGioHang.Rows[i]["SoLuong"] }; DAO.InsertCHITIETDONHANG(CHITIETDONHANG); DAO.UpDate("UPDATE dbo.SANPHAM SET SOLUONG = " + SoLuongSP + ""); } } Session["GioHang"] = null; Response.Write("<script>alert('Đặt hàng thành công. Đơn hàng của bạn đã đực giao cho bộ phận kĩ thuật vui lòng chờ cuộc gọi từ chúng tôi. Cảm ơn!!');</script>"); //Response.Redirect("TrangBanHang.aspx?modul=SanPham&modul1=DanhSachSanPham"); } } }
public ActionResult DeleteConfirmed(string id) { CHITIETDONHANG cHITIETDONHANG = db.CHITIETDONHANGs.Find(id); db.CHITIETDONHANGs.Remove(cHITIETDONHANG); db.SaveChanges(); return(RedirectToAction("Index", "DonHang")); }
public ActionResult CreateOrderDetail() { int id = int.Parse(Url.RequestContext.RouteData.Values["id"].ToString()); CHITIETDONHANG newCT = new CHITIETDONHANG(); newCT.ID_DONHANG = id; return(PartialView(newCT)); }
public ActionResult DeleteConfirmed(int id) { CHITIETDONHANG chitietdonhang = db.CHITIETDONHANGs.Find(id); db.CHITIETDONHANGs.Remove(chitietdonhang); db.SaveChanges(); return(RedirectToAction("Index")); }
public void add(CHITIETDONHANGModel news_dh) { Mapper.CreateMap <CHITIETDONHANGModel, CHITIETDONHANG>(); CHITIETDONHANG _news_dh = Mapper.Map <CHITIETDONHANGModel, CHITIETDONHANG>(news_dh); db.CHITIETDONHANGs.Add(_news_dh); db.SaveChanges(); }
public List <CHITIETNHAPHANG> GetListCTNhapHang(CHITIETDONHANG CTDH) { SANPHAM sp = cn.GetObject <SANPHAM>("api/SANPHAM/" + CTDH.SANPHAM_ID); List <CHITIETNHAPHANG> lstNH = cn.GetObject <List <CHITIETNHAPHANG> >("api/CHITIETNHAPHANG") .Where(x => x.SANPHAM_ID == sp.ID && x.SOLUONGCONLAI > 0).ToList(); return(lstNH); }
public ActionResult XacNhanThanhToan(int maKH) { string code = Session["Code"].ToString(); PROMOCODE check = db.PROMOCODEs.SingleOrDefault(x => x.Code == code); int promoID = check.Id; KHACHHANG kh = db.KHACHHANGs.SingleOrDefault(x => x.MaKH == maKH); DONHANG dh = new DONHANG() { MaKH = int.Parse(Session["UserID"].ToString()), PromoID = promoID, NgayDatHang = DateTime.Now, NgayGiaoHang = null, DiaChiGiao = kh.DiaChi, TongTien = TongTien(), ThanhToan = "Cash", TinhTrang = "Chưa xác nhận", HoTen = kh.TenKH, Email = kh.Email, Sdt = kh.Sdt }; db.DONHANGs.Add(dh); db.SaveChanges(); List <GIOHANG> listGioHang = LayGioHang(); foreach (var item in listGioHang) { int maSP = item.MaSP; int maSize = item.MaSize; int maMau = item.MaMau; int soLuong = item.SoLuong; CHITIETSP ctsp = db.CHITIETSPs.SingleOrDefault(x => x.MaSP == maSP && x.MaMau == maMau && x.MaSize == maSize); ctsp.SoLuong -= soLuong; db.Entry(ctsp).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in listGioHang) { int maSP = item.MaSP; int maSize = item.MaSize; int maMau = item.MaMau; int soLuong = item.SoLuong; decimal donGia = item.ThanhTien; CHITIETDONHANG ctdh = new CHITIETDONHANG() { MaDH = dh.MaDH, MaSP = maSP, MaMau = maMau, MaSize = maSize, SoLuong = soLuong, DonGia = donGia }; db.CHITIETDONHANGs.Add(ctdh); db.SaveChanges(); } Session.Remove("GIOHANG"); return(RedirectToAction("ThanksYou")); }
public ActionResult CreateDH(string id1, string id2, string id3, string id4) { if (id4.Length <= 9 || string.IsNullOrEmpty(id3)) { ModelState.AddModelError("", "Vui lòng điền đầy đủ thông tin !"); } else { SANPHAMsController sANPHAM = new SANPHAMsController(); DONHANG dONHANG = new DONHANG(); if (ModelState.IsValid) { //dONHANG.NV_ID = Session["NV_ID"].ToString(); dONHANG.DN_ID = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count()); dONHANG.DN_SDT = id4; dONHANG.TTDH_ID = 4; if (Session["KH_ID"] != null) { string KH_ID = Session["KH_ID"].ToString(); dONHANG.KH_ID = KH_ID; } dONHANG.DN_NGALAPDON = DateTime.Now; dONHANG.DN_GHICHU = "Khách đặc Online"; dONHANG.HTTT_ID = Convert.ToInt16(id1); //dONHANG.DN_SL = Convert.ToInt32(id2); db.DONHANGs.Add(dONHANG); db.SaveChanges(); int DN_ID = Convert.ToInt32(dONHANG.DN_ID); CHITIETDONHANG cHITIETDONHANG = new CHITIETDONHANG(); var giohang = Session["giohang"] as List <CartItem>; foreach (var i in giohang) { string CTDH_ID = db.autottang("CHITIETDONHANG", "CTDH_ID", db.CHITIETDONHANGs.Count()).ToString(); string SP_ID = i.SanPhamID; short TT = db.Database.SqlQuery <short>("select SP_TRANGTHAI from SanPham where SP_ID ='" + SP_ID + "'").SingleOrDefault(); if (TT == 1) { db.Database.ExecuteSqlCommand("Insert into ChiTietDonHang (CTDH_ID,DN_ID,SP_ID,CTDH_DIACHIGIAO) values('" + CTDH_ID + "','" + DN_ID + "','" + SP_ID + "',N'" + id3 + "')"); db.Database.ExecuteSqlCommand("update sanpham set SP_TRANGTHAI =0 where SP_ID ='" + SP_ID + "'"); ModelState.AddModelError("", "Xạc nhận mua " + i.SanPhamID + " thành công"); } CartItem itemXoa = giohang.FirstOrDefault(m => m.SanPhamID == i.SanPhamID); giohang.Remove(itemXoa); } ModelState.AddModelError("", "Đã thêm chờ hàng vui lòng chờ duyệt đơn !"); } } return(View()); }
public void Delete(int id) { CHITIETDONHANG a = ListItem.Where(p => p.MATHANGID == id).FirstOrDefault(); if (a == null) { return; } ListItem.Remove(a); }
public async Task <IHttpActionResult> GetCHITIETDONHANG(int id) { CHITIETDONHANG cHITIETDONHANG = await db.CHITIETDONHANG.FindAsync(id); if (cHITIETDONHANG == null) { return(NotFound()); } return(Ok(cHITIETDONHANG)); }
public void InsertCHITIETDH(CHITIETDONHANG CTDH) { string query = "insertCTDH"; string[] para = new string[4] { "@idSP", "@idDH", "@soluong", "@giaban" }; object[] value = new object[4] { CTDH.SANPHAM_ID, CTDH.DONHANG_ID, CTDH.SOLUONG, CTDH.DONGIA }; cn.Excute_Sql(query, CommandType.StoredProcedure, para, value); }
public async Task <IHttpActionResult> PostCHITIETDONHANG(CHITIETDONHANG cHITIETDONHANG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CHITIETDONHANG.Add(cHITIETDONHANG); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = cHITIETDONHANG.ID }, cHITIETDONHANG)); }
public ActionResult Edit([Bind(Include = "MaCTDH,MaSP,SoLuong,DonGia,MaDH")] CHITIETDONHANG chitietdonhang) { if (ModelState.IsValid) { db.Entry(chitietdonhang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaDH = new SelectList(db.DONHANGs, "MaDH", "TenTaiKhoan", chitietdonhang.MaDH); ViewBag.MaSP = new SelectList(db.SANPHAMs, "MaSP", "TenSP", chitietdonhang.MaSP); return(View(chitietdonhang)); }
public ActionResult Edit([Bind(Include = "CTDH_ID,DN_ID,CTSP_ID,CTDH_DIACHIGIAO")] CHITIETDONHANG cHITIETDONHANG) { if (ModelState.IsValid) { db.Entry(cHITIETDONHANG).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DN_ID = new SelectList(db.DONHANGs, "DN_ID", "DN_ID", cHITIETDONHANG.DN_ID); ViewBag.CTSP_ID = new SelectList(db.CHITIETSANPHAMs, "CTSP_ID", "CTSP_TEN", cHITIETDONHANG.CTSP_ID); return(View(cHITIETDONHANG)); }
public ActionResult ThongTinKhachHang(string txtName, string txtPhone, string txtAddress, string txtEmail) { //Tạo và lấy thông tin của order var od = new DONHANG(); DonHangDAO ODAO = new DonHangDAO(); long idorder = 0; od.NgayTao = DateTime.Now; od.TenKhachHang = txtName; od.DiaChiKhachHang = txtAddress; od.DienThoaiKhachHang = txtPhone; od.EmailKhachHang = txtEmail; od.TrangThai = 0; try { idorder = ODAO.Insert(od); //Thêm order vào chi tiết var list = (List <CartItem>)Session[CartSession];; if (list != null) { foreach (var item in list) { CHITIETDONHANG od1 = new CHITIETDONHANG(); CoDAO ccc = new CoDAO(); od1.IDDonHang = idorder; od1.IDCo = ccc.LayIDCoGiayTheoIDSPVaCo(item.Product.ID, item.CoGiay); od1.SoLuong = item.Quantity; int giatien = 0; if (item.Product.GiaKhuyenMai != null && item.Product.GiaKhuyenMai > 0) { giatien = (int.Parse(item.Product.GiaKhuyenMai.Value.ToString()) * item.Quantity); } else { giatien = (int.Parse(item.Product.Gia.Value.ToString()) * item.Quantity); } od1.Gia = giatien; ChiTietDonHangDAO ODDAO = new ChiTietDonHangDAO(); ODDAO.Add(od1); } } } catch (Exception) { throw; } return(Redirect("/GioHang/XemLaiDonHang?idorder=" + idorder + "")); }
public bool Insert(CHITIETDONHANG detail) { try { db.CHITIETDONHANGs.Add(detail); db.SaveChanges(); return(true); } catch { return(false); } }