public ActionResult ChiTietDonHang(int madh)
{
var ctdh = new ChiTietDonHangDao().ChiTietDonHang(madh);
ViewBag.ttDonHang = new DonHangDao().oneDonHang(madh);
return(View(ctdh));
}
public ActionResult ChiTiet(long id)
{
var dao = new ChiTietDonHangDao();
var list = dao.ListChiTiet(id);
return(View(list));
}
public ActionResult ChiTietAdmin(long id)
{
var dao = new ChiTietDonHangDao();
var list = dao.ListChiTiet(id);
// Hiển thị list đơn hàng
return(View(list));
}
public void populateGridDetails(int idDonHang = 1)
{
if (idDonHang == 0)
{
dataGridViewChiTietDH.DataSource = null;
}
else
{
ChiTietDonHangDao dao = new ChiTietDonHangDao();
dataGridViewChiTietDH.DataSource = dao.getDetails(idDonHang);
}
}
private void UC_Home_Admin_Load(object sender, EventArgs e)
{
ChiTietDonHangDao dao = new ChiTietDonHangDao();
labelSoldBooks.Text = dao.allBookSold().ToString();
ChiTietPhieuNhapDao cDao = new ChiTietPhieuNhapDao();
labelPurchasedBook.Text = cDao.purchasedBook().ToString();
KhachHangDao khDao = new KhachHangDao();
labelCustomer.Text = khDao.countCustomer().ToString();
}
// GET: Admin/ChiTietDonHangAD
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
if (Session["User"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var dao = new ChiTietDonHangDao();
ViewBag.SearchString = searchString;
var model = dao.ListAllPaging(searchString, page, pageSize);
return(View(model));
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBoxCustomerID.Text == "" || textBoxCustomerID.Text == null)
{
MessageBox.Show("Hãy nhập thông tin khách hàng !");
}
else
{
GioHangDao dao = new GioHangDao();
// thêm id khách hàng vào trong bảng GioHang
dao.addIdCustomerToAllRecord(int.Parse(textBoxCustomerID.Text));
// Tạo Record trong bảng DonHang
DonHang d = new DonHang();
d.MaKH = int.Parse(dao.getIdCustomer());
d.TongTien = dao.netAmount();
DonHangDao donhangDao = new DonHangDao();
var idDonHang = donhangDao.insertDonHang(d);
// Tạo Record trong bảng ChiTietDonHang
foreach (var item in dao.listGioHang())
{
var tensach = item.BookTitle;
var soluong = item.Qty;
var dongia = item.Price;
SachDao sachDao = new SachDao();
// Tạo 1 ChiTietDonHang và thêm các thuộc tính vào
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.MaDH = int.Parse(idDonHang);
ctdh.MaSach = sachDao.getIdBookByName(tensach);
ctdh.SoLuong = soluong;
ctdh.DonGia = dongia;
// Insert record vào ChiTietDonHang
ChiTietDonHangDao ctdhDao = new ChiTietDonHangDao();
ctdhDao.insertChiTietDonHang(ctdh);
// Update lại số lượng tồn của Sach
sachDao.updateStock(ctdh.MaSach, (int)ctdh.SoLuong);
}
// Clear all
clearAll();
// Xóa hết bảng GioHang
dao.deleteAllCartRecord();
MessageBox.Show("Thành công !");
}
}
public ActionResult Create(string TenNguoiNhan, string SDTNguoiNhan, string Email, string DiaChiNhan, string GhiChu)
{
var dao = new DonHangDao();
var productDao = new ProductDao();
var chitietDao = new ChiTietDonHangDao();
DonHang don = new DonHang();
var user = (UserLogin)Session[Common.CommonConstants.USER_SESSION];
don.IdUser = user.UserID;
don.NgayDat = DateTime.Now;
don.TrangThai = 0;
don.TenNguoiNhan = TenNguoiNhan;
don.SDTNguoiNhan = SDTNguoiNhan;
don.Email = Email;
don.DiaChiNhan = DiaChiNhan;
don.GhiChu = GhiChu;
don.TongTien = 0;
var list = (List <CartItem>)Session[Common.CommonConstants.CartSession];
var maDonHang = dao.insert(don);
if (maDonHang >= 0)
{
long tongtien = 0;
foreach (var item in list)
{
ChiTietDonHang entity = new ChiTietDonHang();
entity.MaDonHang = maDonHang;
entity.MaSach = item.SanPham.MaSach;
entity.SoLuong = item.SoLuong;
entity.DonGia = (int)item.SanPham.DonGia;
entity.ThanhTien = entity.SoLuong * entity.DonGia;
chitietDao.insert(entity);
productDao.UpdateSoLuong(item.SoLuong, entity.MaSach);
tongtien += (long)entity.ThanhTien;
}
dao.UpdateTongTien(tongtien, maDonHang);
Session[Common.CommonConstants.CartSession] = null;
string s = "Bạn đã đặt hàng thành công. Vui lòng xem chi tiết trong tài khoản cá nhân ";
List <string> overList = new List <string>();
overList.Add(s);
Session[Common.CommonConstants.OverSoLuong] = overList;
}
return(RedirectToAction("Index", "Cart"));
}
public ActionResult XuatHang()
{
//khai Bao
var sessionCart = (List <CartItem>)Session[CartSesstion];// danh sach cart
var dao = new ChiTietDonHangDao();
var dao1 = new ChiTiet_HangHoaDao();
DS_XuatKho BienTam = new DS_XuatKho(); //khai bao bien tam
//ma nguoi dung
var lathongtin = Session[CommonConstants.MaND_SESSTION]; //lay ma quan ly tu session
var mand = Convert.ToString(lathongtin); //chuyen ma thanh string
var dao2 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(mand); //tim ma nguoi dung trong bang quan ly kho hang
int Stt = dao2.STT; //gan gia tri cho stt
int maKho = dao2.MaKho;
var result = ExportData(dao2);
foreach (var item in sessionCart)
{
if (item.SoLuong > 0)
{
BienTam.MaHang = item.Hang_Hoa.MaHang;
BienTam.NgayXuat = DateTime.Now;
BienTam.SoLuong = item.SoLuong;
BienTam.DonGia = item.Hang_Hoa.DonGia;
BienTam.STT = Stt;
var id = dao.ThemMoi(BienTam);
if (id > 0)
{
dao1.ChinhSua(BienTam, maKho);
}
}
}
Session[CartSesstion] = null;
SetAlert("Đã tạo xong Hàng Xuất Kho", "success");
return(RedirectToAction("Index", "Home"));
}
public ActionResult ThanhToan(string HoTen, string SDT, string Email, string DiaChiNhan)
{
decimal tongtien = 0;
decimal thanhtien = 0;
ViewBag.userSession = Session[CommonConstant.USER_SESSION];
var listSP = new SanPhamDao().ListSP();
var gioHang = (List <GioHang>)Session[CartSession];
var ctdhDAO = new ChiTietDonHangDao();
var donHang = new DonHang();
int dem = 0;
donHang.NgayBan = DateTime.Now;
donHang.HoTen = HoTen;
donHang.SDT = SDT;
donHang.Email = Email;
donHang.DiaChiNhan = DiaChiNhan;
donHang.TongTien = tongtien;
donHang.TrangThai = "Chờ duyệt";
if (ViewBag.userSession != null)
{
donHang.MaKH = ViewBag.userSession.ID;
}
else
{
}
var addDH = new DonHangDao().Insert(donHang);
foreach (var sp in listSP)
{
foreach (var item in gioHang)
{
if (item.SoLuong <= sp.SoLuongCon && item.MauSanPham.MaSP == sp.MaSP && item.MauSanPham.MaMau == sp.MaMau && item.MauSanPham.MaDL == sp.MaDL && item.MauSanPham.MaTT == sp.MaTT)
{
dem += 1;
tongtien = thanhtien + item.MauSanPham.Gia * item.SoLuong;
var ctdh = new ChiTietDonHang();
ctdh.MaDH = donHang.MaDH;
ctdh.MaSP = item.MauSanPham.MaSP;
ctdh.MaMau = item.MauSanPham.MaMau;
ctdh.MaTT = item.MauSanPham.MaTT;
ctdh.MaDL = item.MauSanPham.MaDL;
ctdh.SoLuong = item.SoLuong;
ctdhDAO.Insert(ctdh);
}
else
{
}
}
}
if (dem > 0)
{
// Gửi mail
string mail = System.IO.File.ReadAllText(Server.MapPath("~/Asset/client/template/DonHangMoi.html"));
mail = mail.Replace("{{MaDH}}", donHang.MaDH.ToString());
mail = mail.Replace("{{HoTen}}", HoTen);
mail = mail.Replace("{{SDT}}", SDT);
mail = mail.Replace("{{Email}}", Email);
mail = mail.Replace("{{DiaChiNhan}}", DiaChiNhan);
mail = mail.Replace("{{TongTien}}", string.Format("{0:#,##}", tongtien));
var emailAdmin = ConfigurationManager.AppSettings["EmailAdmin"].ToString();
new Mail().GuiMail(Email, "Đơn hàng của bạn", mail);
new Mail().GuiMail(emailAdmin, "Khách vừa đặt hàng", mail);
gioHang = null;
return(Redirect("/hoan-thanh"));
}
else
{
Session[CartSession] = null;
var del = db.DonHangs.Where(x => x.MaDH == addDH).FirstOrDefault();
db.DonHangs.Remove(del);
db.SaveChanges();
return(View("Error"));
}
}
