public List <DonHangViewModel> DonHangDaGiao(long userID) { List <DonHangViewModel> lst = new List <DonHangViewModel>(); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand com = new SqlCommand("SelectQuanLyDonHangThanhToan", con); com.Parameters.AddWithValue("@UserID", userID); com.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { DonHangViewModel donHangViewModel = new DonHangViewModel(); donHangViewModel.SanPhamID = rdr["SanPhamID"].ToString(); donHangViewModel.OrderID = rdr["OrderID"].ToString(); donHangViewModel.DonGia = rdr["DonGia"].ToString(); donHangViewModel.Quantity = rdr["Quantity"].ToString(); donHangViewModel.ThanhTien = rdr["ThanhTien"].ToString(); donHangViewModel.CreateDate = (DateTime)rdr["CreateDate"]; donHangViewModel.ShipName = rdr["ShipName"].ToString(); donHangViewModel.ShipMobile = rdr["ShipMobile"].ToString(); donHangViewModel.ShipAddress = rdr["ShipAddress"].ToString(); donHangViewModel.ShipEmail = rdr["ShipEmail"].ToString(); donHangViewModel.Status = (bool)rdr["Status"]; donHangViewModel.UserID = rdr["UserID"].ToString(); donHangViewModel.TongTien = rdr["TongTien"].ToString(); donHangViewModel.TenSanPham = rdr["TenSanPham"].ToString(); lst.Add(donHangViewModel); } return(lst); } }
public ActionResult ChiTietDonHang(string orderID) { var session = (UserLogin)Session[CommonConstants.USER_SESSION]; var thongTinDonHangDAO = new ThongTinDonHangDAO(); var TatCaDonHang = thongTinDonHangDAO.ToanBoDonDatHang(session.UserID); DonHangViewModel dHModel = new DonHangViewModel(); foreach (var item in TatCaDonHang) { if (item.OrderID.Trim() == orderID.Trim()) { dHModel.OrderID = item.OrderID; dHModel.SanPhamID = item.SanPhamID; dHModel.DonGia = item.OrderID; dHModel.Quantity = item.Quantity; dHModel.ThanhTien = item.ThanhTien; dHModel.CreateDate = item.CreateDate; dHModel.ShipName = item.ShipName; dHModel.ShipMobile = item.ShipMobile; dHModel.ShipAddress = item.ShipAddress; dHModel.ShipEmail = item.ShipEmail; dHModel.UserID = item.UserID; dHModel.TongTien = item.TongTien; dHModel.TenSanPham = item.TenSanPham; dHModel.Status = item.Status; } } return(View(dHModel)); }
// GET: QLHoaDon public ActionResult Index() { var model = new DonHangViewModel() { DonHangChuaDuyet = db.HoaDon.Where(x => x.TrangThai == false).ToList(), DonHangDaDuyet = db.HoaDon.Where(x => x.TrangThai == true).ToList() }; return(View(model)); }
public ActionResult DuyetHD(int id) { var hoaDon = db.HoaDon.Find(id).TrangThai = true; //Thiếu Mã tài khoản db.SaveChanges(); var model = new DonHangViewModel() { DonHangChuaDuyet = db.HoaDon.Where(x => x.TrangThai == false).ToList(), DonHangDaDuyet = db.HoaDon.Where(x => x.TrangThai == true).ToList() }; return(RedirectToAction("Index", model)); }
public IActionResult DonHang(int pageIndex = 1, int?searchMa = null, string searchTrangThai = null) { var DonHangVM = new DonHangViewModel() { ListDonHang = _db.DonHang.Where(dh => dh.MaKH == HttpContext.Session.GetObject <DangNhap>("DangNhap").MaKH).ToList() }; StringBuilder param = new StringBuilder(); param.Append("/Customer/MuaHang/DonHang?pageIndex=:"); param.Append("&searchMa="); if (searchMa != null) { param.Append(searchMa); } param.Append("&searchTrangThai="); if (searchTrangThai != null) { param.Append(searchTrangThai); } if (searchMa != null) { DonHangVM.ListDonHang = DonHangVM.ListDonHang.Where(dh => dh.MaDH.ToString().Contains(searchMa.ToString())).ToList(); } if (searchTrangThai != null) { DonHangVM.ListDonHang = DonHangVM.ListDonHang.Where(dh => dh.TrangThai == searchTrangThai).ToList(); } var count = DonHangVM.ListDonHang.Count; DonHangVM.ListDonHang = DonHangVM.ListDonHang.OrderByDescending(dh => dh.NgayLapDH).Skip((pageIndex - 1) * PageSize).Take(PageSize).ToList(); DonHangVM.PagingInfo = new PagingInfo { CurrentPage = pageIndex, ItemsPerPage = PageSize, TotalItems = count, urlParam = param.ToString() }; return(View(DonHangVM)); }
public ActionResult SuaHD(HoaDon hoaDon) { var model = db.HoaDon.Find(hoaDon.MaHoaDon); model.HovaTen = hoaDon.HovaTen; model.DiaChi = hoaDon.DiaChi; model.Phone = hoaDon.Phone; model.Email = hoaDon.Email; model.DiaChiGiaoHang = hoaDon.DiaChiGiaoHang; model.ThoiGianGiaoHang = hoaDon.ThoiGianGiaoHang; db.SaveChanges(); var model1 = new DonHangViewModel() { DonHangChuaDuyet = db.HoaDon.Where(x => x.TrangThai == false).ToList(), DonHangDaDuyet = db.HoaDon.Where(x => x.TrangThai == true).ToList() }; return(RedirectToAction("Index", model1)); }
public List <DonHangViewModel> LayDonHangTheoNgay(DateTime ngay) { try { // Func string query = "SELECT * FROM dbo.LayDonHangTheoNgay(@ngay)"; var type = CommandType.Text; var paramaters = new SqlParameter[] { new SqlParameter("@ngay", SqlDbType.DateTime) { Value = ngay } }; var dtbDonHang = ExecuteQuery(query, type, paramaters); var dsDonHang = new List <DonHangViewModel>(); foreach (DataRow row in dtbDonHang.Rows) { var donHang = new DonHangViewModel { MaDonHang = (string)row["MaDonHang"], ThoiGian = (DateTime)row["ThoiGian"], KhoiLuongGiat = (double)row["KhoiLuongGiat"], TenKhachHang = (string)row["TenKhachHang"], GiaoTanNoi = (bool)row["GiaoTanNoi"], DiaChiGiaoHang = (string)row["DiaChiGiaoHang"], GiaTien = (double)row["GiaTien"], TienThem = (double)row["TienThem"], TongTien = (double)row["TongTien"], DaThanhToan = (bool)row["ThanhToan"] }; dsDonHang.Add(donHang); } return(dsDonHang); } catch (Exception e) { throw e; } }
public ActionResult BeginEdit(int id) { using (DBNoiThat db = new DBNoiThat()) { DonHangViewModel dh = (from d in db.DonHangs.Where(p => p.ID == id) select new DonHangViewModel { ID = d.ID, HoTen = d.HoTen, SDT = d.Sdt, Email = d.Email, HinhThucThanhToan = d.HinhThucThanhToan, ThoiGian = d.ThoiGian, DiaChiGiaoHang = d.DiaChiGiaoHang, TinhTrangThanhToan = d.TinhTrangThanhToan, TinhTrangGiaoHang = d.TinhTrangGiaoHang, DaGiamGia = d.DaGiamGia }).FirstOrDefault(); return(Json(dh, JsonRequestBehavior.AllowGet)); } }
public List <DonHangViewModel> LayTatCaDonHang() { try { // View string query = "SELECT * FROM LayTatCaDonHang"; var type = CommandType.Text; var dtbDonHang = ExecuteQuery(query, type); // Ko có parameter var dsDonHang = new List <DonHangViewModel>(); foreach (DataRow row in dtbDonHang.Rows) { var donHang = new DonHangViewModel { MaDonHang = (string)row["MaDonHang"], ThoiGian = (DateTime)row["ThoiGian"], KhoiLuongGiat = (double)row["KhoiLuongGiat"], TenKhachHang = (string)row["TenKhachHang"], GiaoTanNoi = (bool)row["GiaoTanNoi"], DiaChiGiaoHang = (string)row["DiaChiGiaoHang"], GiaTien = (double)row["GiaTien"], TienThem = (double)row["TienThem"], TongTien = (double)row["TongTien"], DaThanhToan = (bool)row["ThanhToan"] }; dsDonHang.Add(donHang); } return(dsDonHang); } catch (Exception e) { throw e; } }
public async Task <IActionResult> Index(int productPage = 1, string searchName = null, string searchAddress = null, string searchPhone = null, string searchDate = null) { System.Security.Claims.ClaimsPrincipal currentUser = this.User; var claimsIndentity = (ClaimsIdentity)this.User.Identity; var claim = claimsIndentity.FindFirst(ClaimTypes.NameIdentifier); DonHangViewModel donHangVM = new DonHangViewModel() { DonHangs = new List <Models.DonHang>() }; StringBuilder param = new StringBuilder(); param.Append("/Admin/DonHang?productPage=:"); param.Append("&searchName="); if (searchName != null) { param.Append(searchName); } param.Append("&searchEmail="); if (searchAddress != null) { param.Append(searchAddress); } param.Append("&searchPhone="); if (searchPhone != null) { param.Append(searchPhone); } param.Append("&searchDate="); if (searchDate != null) { param.Append(searchDate); } donHangVM.DonHangs = _db.DonHangs.Include(a => a.NhanVien).ToList(); //donHangVM.DonHangs.OrderBy(p => p.NgayLapDH); if (User.IsInRole(SD.NhanVien)) { donHangVM.DonHangs = donHangVM.DonHangs.Where(a => a.MaNV == claim.Value).ToList(); } if (searchName != null) { donHangVM.DonHangs = donHangVM.DonHangs.Where(a => a.TenKH.ToLower().Contains(searchName.ToLower())).ToList(); } if (searchAddress != null) { donHangVM.DonHangs = donHangVM.DonHangs.Where(a => a.DiaChiKH.ToLower().Contains(searchAddress.ToLower())).ToList(); } if (searchPhone != null) { donHangVM.DonHangs = donHangVM.DonHangs.Where(a => a.SoDienThoai.ToLower().Contains(searchPhone.ToLower())).ToList(); } if (searchDate != null) { try { DateTime appDate = Convert.ToDateTime(searchDate); donHangVM.DonHangs = donHangVM.DonHangs.Where(a => a.NgayNhanHang.ToShortDateString().Equals(appDate.ToShortDateString())).ToList(); } catch (Exception ex) { } } var count = donHangVM.DonHangs.Count; donHangVM.DonHangs = donHangVM.DonHangs.OrderByDescending(p => p.NgayLapDH) .Skip((productPage - 1) * PageSize) .Take(PageSize).ToList(); donHangVM.PagingInfo = new PagingInfo { CurrentPage = productPage, ItemsPerPage = PageSize, ToTalItems = count, urlPram = param.ToString() }; return(View(donHangVM)); }