public static List <OrderedBook> GetListOfBooksInSavedShoppingCart(shopContext shopContext, string userAuthId)
{
List <OrderedBook> orderedBooks = new List <OrderedBook>();
// check if there is a draft in user's orders
int userId = GetUserIdById(shopContext, userAuthId);
int orderId = FindDraftId(shopContext, userId);
if (orderId != 0)
{
List <int> bookIds = shopContext.BooksOrdered
.Where(b => b.OrderId == orderId)
.Select(b => b.BookId)
.ToList();
var hash = new HashSet <int>();
foreach (var id in bookIds)
{
int quantity = 0;
if (hash.Add(id))
{
quantity = bookIds
.Where(i => i == id)
.Count();
orderedBooks.Add(new OrderedBook {
BookId = id, Quantity = quantity
});
}
}
}
return(orderedBooks);
}
public IActionResult XemDanhSachKhuyenMai()
{
var dbContext = new shopContext();
var khuyenmai = (from km in dbContext.Khuyenmai
select new{
khuyenmaiId = km.KhuyenMaiId,
Tenkhuyenmai = km.TenKhuyenMai,
mota = km.MoTa,
ngBD = km.NgayBatDau,
ngKT = km.NgayKetThuc,
PhanTramGiam = km.PhanTramGiam,
TrangThai = km.TrangThai
});
List <Khuyenmai> ListKM = new List <Khuyenmai>();
foreach (var item in khuyenmai)
{
Khuyenmai km = new Khuyenmai();
km.TenKhuyenMai = item.Tenkhuyenmai;
km.KhuyenMaiId = item.khuyenmaiId;
km.MoTa = item.mota;
km.NgayBatDau = item.ngBD;
km.NgayKetThuc = item.ngKT;
km.TrangThai = item.TrangThai;
km.PhanTramGiam = item.PhanTramGiam * 100;
ListKM.Add(km);
}
ViewBag.khuyenmai = ListKM;
return(View());
}
public IActionResult ThongTinDonHangCuaKhachHang(string id)
{
var dbContext = new shopContext();
var hoadon = (from tk in dbContext.Taikhoan
join kh in dbContext.Khachhang
on tk.TaiKhoanId equals kh.TaiKhoanId
join hd in dbContext.Hoadon
on kh.KhachHangId equals hd.KhachHangId
where tk.Username == id
orderby hd.HoaDonId descending
select new{
hdId = hd.HoaDonId,
tienGiamGia = hd.TienGiamGia,
ngayMua = hd.NgayTao,
tongntien = hd.TongTienThanhToan,
trangThai = hd.TrangThai
});
List <Hoadon> DSHoaDon = new List <Hoadon>();
foreach (var item in hoadon)
{
Hoadon hd = new Hoadon();
hd.HoaDonId = item.hdId;
hd.TienGiamGia = item.tienGiamGia;
hd.NgayTao = item.ngayMua;
hd.TongTienThanhToan = item.tongntien;
hd.TrangThai = item.trangThai;
DSHoaDon.Add(hd);
}
ViewBag.hoadon = DSHoaDon;
return(View());
}
public HomeController(ILogger <HomeController> logger, shopContext dbContext, IEmailSender emailSender, IMyLogger myLogger)
{
_logger = logger;
_dbContext = dbContext;
_emailSender = emailSender;
_myLogger = myLogger;
}
public List <Kichthuoc> LayKichThuoc(int maspp)
{
var dbContext = new shopContext();
var kichthuoc = (from kt in dbContext.Kichthuoc
join sp in dbContext.Sanpham
on kt.SanPhamId equals sp.SanPhamId
where kt.SanPhamId == maspp
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
KichThuocId = kt.KichThuocid,
TenKichThuoc = kt.TenKichThuoc,
GiaBanLe = sp.GiaBanLe,
GiaThem = kt.GiaThem,
});
List <Kichthuoc> ListKT = new List <Kichthuoc>();
foreach (var item in kichthuoc)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.GiaBanLe = item.GiaBanLe;
sp.TenSanPham = item.TenSanPham;
Kichthuoc kt = new Kichthuoc();
kt.TenKichThuoc = item.TenKichThuoc;
kt.KichThuocid = item.KichThuocId;
kt.GiaThem = item.GiaThem;
kt.SanPham = sp;
ListKT.Add(kt);
}
return(ListKT);
}
public static (int, bool) AddOrderToDbOrGetId(shopContext shopContext, Order order)
{
int draftId = FindDraftId(shopContext, order.UserId);
order.User = null;
order.BillingAddress = null;
order.ShippingAddress = null;
order.Date = DateTime.Now;
if (draftId == 0)
{
shopContext.Orders.Add(order);
shopContext.SaveChanges();
shopContext.Entry(order).GetDatabaseValues();
return(order.OrderId, false);
}
else
{
order.OrderId = (int)draftId;
order.Draft = false;
shopContext.Orders.Update(order);
shopContext.SaveChanges();
return((int)draftId, true);
}
}
public List <Sanpham> ThemGioHang(int maspp)
{
var dbContext = new shopContext();
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
where sp.SanPhamId == maspp
select new
{
SanPhamId = sp.SanPhamId,
TenSp = sp.TenSanPham,
HinhAnh = h.TenFile,
GiaBanLe = sp.GiaBanLe,
});
List <Sanpham> ListSP = new List <Sanpham>();
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSp;
sp.GiaBanLe = item.GiaBanLe;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
ListSP.Add(sp);
}
return(ListSP);
}
public List<Phanhoi> ThemPhanHoi(int BinhLuanId,string NoiDung){
var dbContext = new shopContext();
var userName = HttpContext.Session.GetString("username");
var taiKhoan = (from tk in dbContext.Taikhoan where tk.Username == userName select tk).ToList();
var phanHoi = new Phanhoi(){
BinhLuanId = BinhLuanId,
TaiKhoanId = taiKhoan[0].TaiKhoanId,
NoiDung = NoiDung
};
dbContext.Phanhoi.Add(phanHoi);
dbContext.SaveChanges();
var DSPhanHoi = (from ph in dbContext.Phanhoi
join tk in dbContext.Taikhoan
on ph.TaiKhoanId equals tk.TaiKhoanId
where ph.BinhLuanId == BinhLuanId
orderby ph.PhanHoiId descending
select new {
NoiDung = ph.NoiDung,
userName = tk.Username
}).ToList();
List<Phanhoi> ListPhanHoi = new List<Phanhoi>();
foreach (var item in DSPhanHoi)
{
Phanhoi ph = new Phanhoi();
ph.BinhLuanId = BinhLuanId;
ph.NoiDung = item.NoiDung;
Taikhoan tk = new Taikhoan();
tk.Username = item.userName;
ph.TaiKhoan = tk;
ListPhanHoi.Add(ph);
}
dbContext.SaveChanges();
return ListPhanHoi;
}
public static IEnumerable <OrderedBook> GetRandomMoqOrderedBooksList()
{
shopContext context = MoqShopContext();
Random random = new Random();
List <int> tmp = new List <int>();
List <OrderedBook> mockOrderedBooks = new List <OrderedBook>();
int i = 0;
while (i < 4)
{
int randomBookId = random.Next(1, 12);
int randomQuantity = random.Next(1, 8);
if (!tmp.Contains(randomBookId))
{
OrderedBook orderedBook = new OrderedBook
{
BookId = randomBookId,
Quantity = randomQuantity,
Title = context.Books.First(x => x.BookId == randomBookId).Title,
Price = context.Books.First(x => x.BookId == randomBookId).Price
};
tmp.Add(randomBookId);
mockOrderedBooks.Add(orderedBook);
i++;
}
}
return(mockOrderedBooks);
}
public List <Thongke> ThongKe(DateTime tungay, DateTime denngay)
{
var dbContext = new shopContext();
var doanhthu = dbContext.Hoadon
.Where(x => x.NgayTao >= tungay && x.NgayTao <= denngay)
.GroupBy(x => new {
x.NgayTao.Month,
x.NgayTao.Year
})
.OrderBy(x => x.Key.Year)
.OrderBy(x => x.Key.Month)
.Select(g => new {
thang = g.Key.Month,
nam = g.Key.Year,
tong = g.Sum(x => x.TongTienThanhToan).ToString()
}).ToList();
List <Thongke> DSThongKe = new List <Thongke>();
foreach (var item in doanhthu)
{
Thongke tk = new Thongke();
tk.Nam = item.nam;
tk.Thang = item.thang;
tk.DoanhThu = item.tong;
DSThongKe.Add(tk);
}
return(DSThongKe);
}
public List <Sanpham> TimKiemSanPham(string key)
{
List <Sanpham> List = new List <Sanpham>();
var dbContext = new shopContext();
if (key == "xxx")
{
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
PhanLoaiId = sp.PhanLoaiId
});
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
sp.PhanLoaiId = item.PhanLoaiId;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
List.Add(sp);
}
}
else
{
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
where sp.TenSanPham.StartsWith(key)
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
PhanLoaiId = sp.PhanLoaiId
});
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
sp.PhanLoaiId = item.PhanLoaiId;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
List.Add(sp);
}
}
return(List);
}
public void XacNhanHuyDonHang(int mahd)
{
var dbContext = new shopContext();
var hoadon = (from hd in dbContext.Hoadon
where hd.HoaDonId == mahd
select hd).ToList();
//lay chi tiet hoa don cua hoa don xac nhan huy
var cthd = (from ct in dbContext.Chitiethoadon
where ct.HoaDonId == mahd
select ct).ToList();
//xoa chi tiet hoa don
foreach (var item in cthd)
{
var ct = dbContext.Chitiethoadon.First(a => a.ChiTietHoaDonId == item.ChiTietHoaDonId);
dbContext.Chitiethoadon.Remove(ct);
dbContext.SaveChanges();
}
//xoa hoa don
var hdon = dbContext.Hoadon.First(a => a.HoaDonId == hoadon[0].HoaDonId);
dbContext.Hoadon.Remove(hdon);
dbContext.SaveChanges();
dbContext.Dispose();
}
public IActionResult XemDanhSachHoaDonYeuCauHuy()
{
var dbContext = new shopContext();
// lấy thông tin trong bảng hóa đơn
var hoadon = (from hd in dbContext.Hoadon
join ps in dbContext.Phiship
on hd.PhiShipId equals ps.PhiShipId
join kh in dbContext.Khachhang
on hd.KhachHangId equals kh.KhachHangId
join nv in dbContext.Nhanvien
on hd.NhanVienId equals nv.NhanVienId into x
from subnv in x.DefaultIfEmpty()
where hd.TrangThai == "Yêu cầu hủy"
select new{
hoadonid = hd.HoaDonId,
ngaytao = hd.NgayTao,
ngaygiao = hd.NgayGiao,
sonha = hd.SoNha,
quan = hd.Quan,
phiship = ps.ChiPhi,
thanhtoan = hd.TongTienThanhToan,
trangthai = hd.TrangThai,
nhanvien = subnv.HoTen,
khachhang = kh.HoTen,
tennguoinhan = hd.TenNguoiNhan,
sdt = hd.Sdt,
tienchuaship = hd.TongTienChuaShip,
tiengiamgia = hd.TienGiamGia
});
List <Hoadon> ListHD = new List <Hoadon>();
foreach (var item in hoadon)
{
Hoadon hd = new Hoadon();
Nhanvien nv = new Nhanvien();
Khachhang kh = new Khachhang();
Phiship ps = new Phiship();
hd.HoaDonId = item.hoadonid;
hd.NgayTao = item.ngaytao;
hd.NgayGiao = item.ngaygiao;
hd.SoNha = item.sonha;
hd.Quan = item.quan;
ps.ChiPhi = item.phiship;
hd.TongTienThanhToan = item.thanhtoan;
hd.TrangThai = item.trangthai;
nv.HoTen = item.nhanvien;
kh.HoTen = item.khachhang;
hd.TenNguoiNhan = item.tennguoinhan;
hd.Sdt = item.sdt;
hd.TongTienChuaShip = item.tienchuaship;
hd.TienGiamGia = item.tiengiamgia;
hd.NhanVien = nv;
hd.KhachHang = kh;
hd.PhiShip = ps;
ListHD.Add(hd);
}
ViewBag.dsYeuCauHuy = ListHD;
return(View());
}
public static int FindDraftId(shopContext shopContext, int userId)
{
return(shopContext.Orders
.Where(o => o.User.UserId == userId && o.Draft == true)
.OrderByDescending(o => o.Date)
.Select(o => o.OrderId)
.FirstOrDefault());
}
public IActionResult XemDanhSachNhanVien()
{
var dbContext = new shopContext();
var nhanvien = (from nv in dbContext.Nhanvien
select nv).ToList();
ViewBag.nhanvien = nhanvien;
return(View());
}
public float CapNhatTongTienHoaDon(float phiship, float tong)
{
var dbContext = new shopContext();
var ps = (from x in dbContext.Phiship
where x.PhiShipId == phiship
select x).ToList();
return((float)ps[0].ChiPhi);
}
public IActionResult DanhSachKhachHang()
{
var dbContext = new shopContext();
var khachhang = (from kh in dbContext.Khachhang
select kh).ToList();
ViewBag.khachhang = khachhang;
return(View());
}
public void YeuCauHuyDonHang(int mahd)
{
var dbContext = new shopContext();
var hoadon = dbContext.Hoadon.First(a => a.HoaDonId == mahd);
hoadon.TrangThai = "Yêu cầu hủy";
dbContext.SaveChanges();
dbContext.Dispose();
}
public LoginModel(SignInManager <IdentityUser> signInManager,
ILogger <LoginModel> logger,
UserManager <IdentityUser> userManager,
shopContext shopContext)
{
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
_ctx = shopContext;
}
public void XacNhanNhanHang(int mahd)
{
var dbContext = new shopContext();
var hoadon = dbContext.Hoadon.First(a => a.HoaDonId == mahd);
hoadon.TrangThai = "Đã nhận hàng";
hoadon.NgayGiao = DateTime.Now;
dbContext.SaveChanges();
dbContext.Dispose();
}
public IActionResult SuaSanPham(Sanpham model, string TenAnh, string[] tenKichThuoc, float[] giaThem)
{
var dbContext = new shopContext();
if (ModelState.IsValid)
{
// kiểm tra hình ảnh đã có trong database chưa
var dsHinhAnh = (from dsha in dbContext.Hinhanh
where dsha.TenFile == TenAnh
select dsha).ToList();
// thêm ảnh vào table hinhanh
if (dsHinhAnh.Count != 0)
{
var hinhanh = new Hinhanh()
{
TenFile = TenAnh
};
dbContext.Hinhanh.Add(hinhanh);
dbContext.SaveChanges();
}
//lấy id của ảnh
var anh = (from ha in dbContext.Hinhanh
where ha.TenFile == TenAnh
select ha).ToList();
//sua sản phẩm
var sanpham = dbContext.Sanpham.First(a => a.SanPhamId == model.SanPhamId);
sanpham.TenSanPham = model.TenSanPham;
sanpham.Mota = model.Mota;
sanpham.GiaBanLe = model.GiaBanLe;
sanpham.TrangThai = model.TrangThai;
sanpham.PhanLoaiId = model.PhanLoaiId;
sanpham.KhuyenMaiId = model.KhuyenMaiId;
sanpham.HinhAnhId = anh[0].HinhAnhId;
dbContext.SaveChanges();
//thêm kích thước vào bảng kichthuoc
var x = (from sp in dbContext.Sanpham
where sp.TenSanPham == model.TenSanPham
select sp).ToList();
for (int i = 0; i < tenKichThuoc.Length; i++)
{
//lấy id của kích thước tương ứng với tên kích thước
var kichthuoc1 = (from kt in dbContext.Kichthuoc
where kt.TenKichThuoc == tenKichThuoc[i] && kt.SanPhamId == model.SanPhamId
select kt).ToList();
var kichthuoc = dbContext.Kichthuoc.First(a => a.KichThuocid == kichthuoc1[0].KichThuocid);
kichthuoc.GiaThem = giaThem[i];
dbContext.SaveChanges();
}
return(RedirectToAction("Suasanpham", "sanpham", new { id = model.SanPhamId, success = "Sửa sản phẩm thành công" }));
}
return(RedirectToAction("Suasanpham", "sanpham", new { id = model.SanPhamId, error = "Sửa sản phẩm không thành công" }));
}
public IActionResult ThemNhanVien(Nhanvien model, string Username, string Password)
{
var dbContext = new shopContext();
var taikhoan1 = (from tk in dbContext.Taikhoan where tk.Username == Username select tk).ToList();
if (taikhoan1.Count > 0)
{
ModelState.AddModelError("Username", "Username da ton tai");
ViewBag.errUsername = "******";
}
if (ModelState.IsValid)
{
// chuyển mật khẩu nhập vào thành mã băm
MD5 mh = MD5.Create();
byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(Password);
byte[] hash = mh.ComputeHash(inputBytes);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < hash.Length; i++)
{
sb.Append(hash[i].ToString("x2"));
}
string newPassword = sb.ToString();
var taikhoan = new Taikhoan()
{
Username = Username,
Password = newPassword,
NgayTao = DateTime.Now,
KichHoat = 0,
LoaiTaiKhoanId = 1
};
//cập nhật mật khẩu mới
dbContext.Taikhoan.Add(taikhoan);
dbContext.SaveChanges();
var tk = (from x in dbContext.Taikhoan
where x.Username == Username
select x).ToList();
var nhanvien = new Nhanvien()
{
HoTen = model.HoTen,
NgaySinh = model.NgaySinh,
Email = model.Email,
Sdt = model.Sdt,
DiaChi = model.DiaChi,
TaiKhoanId = tk[0].TaiKhoanId
};
dbContext.Nhanvien.Add(nhanvien);
dbContext.SaveChanges();
string success = "Thêm nhân viên thành công";
return(RedirectToAction("ThemNhanVien", "NhanVien", new{ success = success }));
}
string alert = "Thêm nhân viên không thành công";
return(RedirectToAction("ThemNhanVien", "NhanVien", new{ alert = alert }));
}
public IActionResult SuaKhachHang(int id, string err, string success)
{
var dbContext = new shopContext();
var khachhang = (from kh in dbContext.Khachhang
where kh.KhachHangId == id
select kh).ToList();
string newDate = khachhang[0].NgaySinh.ToString("yyyy-MM-dd");
ViewBag.newDate = newDate;
ViewBag.kh = khachhang;
ViewBag.err = err;
ViewBag.success = success;
return(View());
}
public IActionResult ThemSanPham(Sanpham model, string TenAnh, string[] tenKichThuoc, float[] giaThem)
{
var dbContext = new shopContext();
if (ModelState.IsValid)
{
// thêm ảnh vào table hinhanh
var hinhanh = new Hinhanh()
{
TenFile = TenAnh
};
dbContext.Hinhanh.Add(hinhanh);
dbContext.SaveChanges();
//lấy id của ảnh
var anh = (from ha in dbContext.Hinhanh
where ha.TenFile == TenAnh
select ha).ToList();
//thêm sản phẩm
var sanpham = new Sanpham()
{
TenSanPham = model.TenSanPham,
Mota = model.Mota,
GiaBanLe = model.GiaBanLe,
TrangThai = model.TrangThai,
PhanLoaiId = model.PhanLoaiId,
KhuyenMaiId = model.KhuyenMaiId,
HinhAnhId = anh[0].HinhAnhId
};
dbContext.Sanpham.Add(sanpham);
dbContext.SaveChanges();
//thêm kích thước vào bảng kichthuoc
var x = (from sp in dbContext.Sanpham
where sp.TenSanPham == model.TenSanPham
select sp).ToList();
for (int i = 0; i < tenKichThuoc.Length; i++)
{
var kichthuoc = new Kichthuoc()
{
SanPhamId = x[0].SanPhamId,
TenKichThuoc = tenKichThuoc[i],
GiaThem = giaThem[i]
};
dbContext.Kichthuoc.Add(kichthuoc);
dbContext.SaveChanges();
}
return(RedirectToAction("Themsanpham", "sanpham", new { success = "Thêm sản phẩm thành công" }));
}
return(RedirectToAction("Themsanpham", "sanpham", new { error = "Thêm sản phẩm không thành công" }));
}
public IActionResult XemThongTinKhachHang(string id, string err, string success)
{
var dbContext = new shopContext();
var taikhoan = (from tk in dbContext.Taikhoan
where tk.Username == id
select tk).ToList();
var khachhang = (from kh in dbContext.Khachhang
where kh.TaiKhoanId == taikhoan[0].TaiKhoanId
select kh).ToList();
ViewBag.kh = khachhang;
ViewBag.err = err;
ViewBag.success = success;
return(View());
}
public RegisterModel(
UserManager <IdentityUser> userManager,
SignInManager <IdentityUser> signInManager,
ILogger <RegisterModel> logger,
IEmailSender emailSender,
shopContext shopContext,
ApplicationDbContext applicationDb)
{
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
_emailSender = emailSender;
_shopContext = shopContext;
_applicationDb = applicationDb;
}
public IActionResult ThemSanPham(string success, string error)
{
var dbContext = new shopContext();
var khuyenmai = (from km in dbContext.Khuyenmai
where km.TrangThai == 1
select km).ToList();
var phanloai = (from pl in dbContext.Phanloai
select pl).ToList();
ViewBag.khuyenmai = khuyenmai;
ViewBag.phanloai = phanloai;
ViewBag.success = success;
ViewBag.error = error;
return(View());
}
public IActionResult XemThongTinNhanVien(string id, string err, string success)
{
var dbContext = new shopContext();
var taikhoan = (from tk in dbContext.Taikhoan
where tk.Username == id
select tk).ToList();
var nhanvien = (from nv in dbContext.Nhanvien
where nv.TaiKhoanId == taikhoan[0].TaiKhoanId
select nv).ToList();
ViewBag.nv = nhanvien;
ViewBag.err = err;
ViewBag.success = success;
return(View());
}
public static void AddNewUser(shopContext shopContext, ApplicationDbContext applicationDbContext, string email)
{
var userAuth = applicationDbContext.Users.FirstOrDefault(u => u.Email.Equals(email));
if (userAuth != null)
{
User user = new User()
{
Email = email,
UserAuthId = userAuth.Id
};
shopContext.Users.Add(user);
shopContext.SaveChanges();
}
}
public static void AddOrderedBooksToDb(shopContext shopContext, int orderId, List <OrderedBook> basket)
{
foreach (var item in basket)
{
IList <BooksOrdered> booksOrdereds = new List <BooksOrdered>();
for (var i = 0; i < item.Quantity; i++)
{
var book = new BooksOrdered();
book.BookId = item.BookId;
book.OrderId = orderId;
booksOrdereds.Add(book);
}
shopContext.BooksOrdered.AddRange(booksOrdereds);
shopContext.SaveChanges();
}
}
