public ActionResult DuyetDonHang(int ma)
{
// ViewBag.MaLoaiTV = new SelectList(db.LoaiThanhViens.Where(x => x.MaLoaiTV != 1), "MaLoaiTV", "TenLoai");
// ViewBag.NVGH = db.ThanhViens.Where(x => x.MaLoaiTV == 3);
DonDatHangDAO ddh = null;
if (ma != 0)
{
var dh = db.DonDatHangs.Where(x => x.TinhTrang == 0);
// ddh = new DonDatHangDAO();
ChangeStatus(ma);
ViewBag.MaThanhVien = new SelectList(db.ThanhViens.Where(x => x.MaLoaiTV == 3), "MaThanhVien", "Hoten");
// ViewBag.NVGH = new SelectList(db.ThanhViens.Where(x => x.MaLoaiTV == 3), "Hoten", "NVGiaoHang");
// List<DonDatHangDAO> list = ddh.getlist(mathanhvien);
return(View(dh));
}
else
{
var dh = db.DonDatHangs.Where(x => x.TinhTrang == 0);
//ddh = new DonDatHangDAO();
//ChangeStatus(36);
ViewBag.MaThanhVien = new SelectList(db.ThanhViens.Where(x => x.MaLoaiTV == 3), "MaThanhVien", "Hoten");
// List<DonDatHangDAO> list = ddh.getlist(mathanhvien);
return(View(dh));
}
// var tv = db.KhachHangs.Find(mathanhvien);
// var donhang = db.DonDatHangs.Where(n=>n.MaKH==tv.MaKH);
// var list = db.KhachHangs.Where(n=>n.MaKH==n.MaKH && n.MaThanhVien==mathanhvien);
//var list = db.ThanhViens;
//var listdh = db.DonDatHangs.Where(n=>n.MaKH==list.);
//var dao = new DonDatHangDAO();
//var pg = dao.Listallpaging(donhang.MaKH);
// ViewBag.ListDH = list;
}
public ActionResult XemDonHang(int mathanhvien, int ma)
{
DonDatHangDAO ddh = null;
if (ma != 0)
{
ddh = new DonDatHangDAO();
ChangeStatus(ma);
List <DonDatHangDAO> list = ddh.getlist(mathanhvien);
return(View(list));
}
else
{
ddh = new DonDatHangDAO();
//ChangeStatus(36);
List <DonDatHangDAO> list = ddh.getlist(mathanhvien);
return(View(list));
}
// var tv = db.KhachHangs.Find(mathanhvien);
// var donhang = db.DonDatHangs.Where(n=>n.MaKH==tv.MaKH);
// var list = db.KhachHangs.Where(n=>n.MaKH==n.MaKH && n.MaThanhVien==mathanhvien);
//var list = db.ThanhViens;
//var listdh = db.DonDatHangs.Where(n=>n.MaKH==list.);
//var dao = new DonDatHangDAO();
//var pg = dao.Listallpaging(donhang.MaKH);
// ViewBag.ListDH = list;
}
public ActionResult XacNhanDatHang()
{
KhachHangModel kh = (KhachHangModel)Session["KhachHang"];
//Lay thong tin gio hang de them chi tiet don hang
List <GioHangModel> cart = (List <GioHangModel>)Session["Cart"];
//Thêm vào bảng đơn hàng
DonDatHangModel ddhModel = new DonDatHangModel();
ddhModel.idKH = kh.id;
ddhModel.ngayDat = DateTime.Now;
//ddhModel.ngayXuat = "";
ddhModel.tinhTrangDon = 0;
ddhModel.tongTien = cart.Sum(x => x.TongTien);
//Thêm đơn hàng và lấy ra id của đơn để thêm chi tiết
int idDH = DonDatHangDAO.ThemDonHang(baseAddress, $"donhang/themdonhang", ddhModel);
List <ChiTietDonHangModel> ctdh = new List <ChiTietDonHangModel>();
foreach (GioHangModel item in cart)
{
ChiTietDonHangModel ctdhItem = new ChiTietDonHangModel();
ctdhItem.idDH = idDH;
ctdhItem.idSP = item.SanPham.id;
ctdhItem.soLuong = item.SoLuong;
ctdhItem.tongTien = item.TongTien;
DonDatHangDAO.ThemChiTietDonHang(baseAddress, $"donhang/themchitietdonhang", ctdhItem);
}
return(RedirectToAction("XemDonHangNguoiDung", "DonDatHang"));
}
public string MaDDHLonNhat()
{
DonDatHangDAO Dao = new DonDatHangDAO();
string MADDH = Dao.MaDDHLonNhat();
if (string.IsNullOrEmpty(MADDH))
{
return("DDH001");
}
else
{
int ChuyenSo = int.Parse(MADDH.Replace("DDH", ""));
return("DDH" + (ChuyenSo + 1).ToString("000"));
}
}
// GET: ShoppingPage/DonDatHang
public ActionResult XemDonHangNguoiDung()
{
int idKH = 0;
if (Session["KhachHang"] != null)
{
idKH = ((KhachHangModel)Session["KhachHang"]).id;
}
else
{
return(RedirectToAction("DangNhap", "KhachHang"));
}
List <DonDatHangModel> res = DonDatHangDAO.XemDonHangNguoiDung(baseAddress, $"donhang/dsdhuser?idUser={idKH}");
return(View(res));
}
public bool ThemDDH(DonDatHangDTO DTO)
{
DonDatHangDAO Dao = new DonDatHangDAO();
return(Dao.ThemDDH(DTO));
}
public bool XoaDDH(DonDatHangDTO DTO)
{
DonDatHangDAO dao = new DonDatHangDAO();
return(dao.XoaDDH(DTO));
}
public bool SUADDH(DonDatHangDTO DTO)
{
DonDatHangDAO DAO = new DonDatHangDAO();
return(DAO.SuaDDH(DTO));
}
public List <DonDatHangDTO> Laydsdondathang()
{
DonDatHangDAO DAO = new DonDatHangDAO();
return(DAO.Laydsdondathang());
}
public static bool ThemPD(DonDatHangDTO DDH)
{
return(DonDatHangDAO.ThemPD(DDH));
}
public static DataSet XuatDonDatHang(string MaDDH)
{
return(DonDatHangDAO.XuatDonDatHang(MaDDH));
}
//huy don hang
//[HttpPost]
public bool ChangeStatus(int id)
{
var result = new DonDatHangDAO().ChangeStatus(id);
return(result);
}
public static bool UpdateTrangThai(string MaDDH, int MaTT)
{
return(DonDatHangDAO.UpdateTrangThai(MaDDH, MaTT));
}
public static DataTable TongSLHangDDH(string MaDDH)
{
return(DonDatHangDAO.TongSLHangDDH(MaDDH));
}
public static DataTable DanhSachPDCoTrangThaiDaXacNhanVaChuaNhanHangDu()
{
return(DonDatHangDAO.DanhSachPDCoTrangThaiDaXacNhanVaChuaNhanHangDu());
}
public static DataTable DanhSachDDHTheoMaPG(string MaPG)
{
return(DonDatHangDAO.DanhSachDDHTheoMaPG(MaPG));
}
public static bool XoaPD(string MaDDH)
{
return(DonDatHangDAO.XoaPD(MaDDH));
}
public List <DonDatHangDTO> TimKiem(string ten)
{
DonDatHangDAO DAO = new DonDatHangDAO();
return(DAO.TimKiem(ten));
}
public ActionResult ChiTietDDH(int id)
{
var ddhDAO = new DonDatHangDAO();
return(View(ddhDAO.getChiTietDDH(id)));
}
public static DataTable DanhSachPD()
{
return(DonDatHangDAO.DanhSachPD());
}
public static bool ThemCTPD(ChiTietDonDatHangDTO PD)
{
return(DonDatHangDAO.ThemCTPD(PD));
}
public static DataTable DanhSachCTPD(string MaPD)
{
return(DonDatHangDAO.DanhSachCTPD(MaPD));
}
public static string GetIDPhieuDat()
{
return(DonDatHangDAO.GetIDPhieuDat());
}
public ActionResult XemChiTietDonHang(int idDH)
{
List <ChiTietDonHangModel2> res = DonDatHangDAO.ChiTietDonHangTheoDon(baseAddress, $"donhang/ctdh2?idDH={idDH}");
return(Json(res));
}
public ActionResult AllDDHInDay()
{
var ddhDAO = new DonDatHangDAO();
return(View(ddhDAO.getDDHInDay()));
}
