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));
}
