Пример #1
0
        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);
        }
Пример #2
0
        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"));
        }
Пример #5
0
        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));
        }
Пример #6
0
        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"));
        }
Пример #7
0
        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"));
        }
Пример #8
0
        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"));
        }
Пример #9
0
        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"));
        }
Пример #11
0
        public ActionResult OrderInformation(string MaSP)
        {
            CHITIETDONHANG ctDonHang = new CHITIETDONHANG(MaSP);

            Response.Cookies["MaSP"]["MaSP"] = MaSP;
            return(View(ctDonHang));
        }
Пример #12
0
        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"));
        }
Пример #13
0
        private void btnXuat_Click(object sender, EventArgs e)
        {
            CHITIETDONHANG CTDH       = dhDAO.GetCTDHbyId((int)grViewCTDH.GetFocusedRowCellValue("ID"));
            FormLayHang    frmLayHang = new FormLayHang(CTDH);

            frmLayHang.ShowDialog();
        }
Пример #14
0
        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();
            }
        }
Пример #15
0
        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");
                }
            }
        }
Пример #16
0
        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"));
        }
Пример #19
0
        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();
        }
Пример #20
0
        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);
        }
Пример #21
0
        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"));
        }
Пример #22
0
        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());
        }
Пример #23
0
        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));
        }
Пример #25
0
        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));
 }
Пример #28
0
 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));
 }
Пример #29
0
        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 + ""));
        }
Пример #30
0
 public bool Insert(CHITIETDONHANG detail)
 {
     try
     {
         db.CHITIETDONHANGs.Add(detail);
         db.SaveChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }