public ActionResult DanhSachNhapHang()
{
//khai Bao
var sessionCart = (List <CartItem>)Session[NhapHangSesstion];// danh sach cart
var lathongtin = Session[CommonConstants.NhaCCSesstion];
var mand = Convert.ToInt32(lathongtin);
var Ncc = new NhaCungCapDao().ViewDentail(mand);
var donhang = new DonHangDao().DonHangMoiTao();
var dao = new ChiTiet_DonHangDao();
ChiTietDonHang BienTam = new ChiTietDonHang();
BienTam.MaNhaCungCap = Ncc.MaNhaCungCap;
BienTam.MaDonHang = donhang[0].MaDonHang;
foreach (var item in sessionCart)
{
if (item.SoLuong > 0)
{
BienTam.LoaiHangHoa = item.Hang_Hoa.LoaiHang.TenLoaiHang;
BienTam.TenHang = item.Hang_Hoa.TenHang;
BienTam.SoLuong = item.SoLuong;
BienTam.Gia = item.Hang_Hoa.DonGia;
var id = dao.Add(BienTam);
}
}
var result = ExportData(Ncc, donhang);
Session[NhapHangSesstion] = null;
return(RedirectToAction("Index", "Cart1"));
}
public ActionResult GetInforDetailOrder(string idDH)
{
var order = new DonHangDao().GetDonHang(idDH);
var listCT_DonHang = new DonHangDao().getListCTDH(idDH);
var customer = new CustomerModel();
decimal phiShip = 0;
decimal tong = 0;
foreach (var item in listCT_DonHang)
{
tong += item.SOLUONG * item.THANHTIEN;
}
if (tong < 300000)
{
phiShip = 30000;
}
if (order != null)
{
var cusdetail = new CustomerDao().ViewDetail(order.MAKHACHHANG);
var pttt = new OrdersDao().GetPhuongThucThanhToan(order.MAPHUONGTHUCTHANHTOAN);
customer.MAKH = cusdetail.MAKHACHHANG;
customer.TENKH = cusdetail.TENKHACHHANG;
customer.DIACHI = cusdetail.DIACHI;
customer.DIENTHOAI = cusdetail.DIENTHOAI;
customer.EMAIL = cusdetail.EMAIL;
customer.NgayTaoDon = order.NGAYLAP;
customer.PhuongThucThanhToan = pttt.TENPHUONGTHUCTHANHTOAN;
customer.Ship = phiShip;
}
return(Json(customer, JsonRequestBehavior.AllowGet));
}
public ActionResult ThemMoi(DonHang quyenhan)
{
if (quyenhan.TenDonHang != null)
{
if (quyenhan.NgayGiao > DateTime.Now)
{
var dao = new DonHangDao();
quyenhan.NgayTao = DateTime.Now;
var id = dao.ThemMoi(quyenhan);
if (id)
{
// SetAlert("Thêm quyền thành công", "success");
return(RedirectToAction("NhaCungcap", "Cart1"));
}
else
{
return(RedirectToAction("ThemMoi", "DonHang"));
}
}
else
{
//SetAlert("Thêm quyền thành công", "success");
return(RedirectToAction("ThemMoi", "DonHang"));
}
}
return(RedirectToAction("ThemMoi", "DonHang"));
}
public List <DonHang> Result()
{
var dao = new DonHangDao();
var list = dao.LayDS();
return(list);
}
// GET: DonHangs
public ActionResult Index(int page = 1, int pageSize = 11)
{
var dao = new DonHangDao();
var model = dao.ListAllPaging(page, pageSize);
return(View(model));
}
public ActionResult DonHang(long id)
{
var dao = new DonHangDao();
var list = dao.DonHangOfUser(id);
// Hiển thị list đơn hàng
return(View(list));
}
// GET: Admin/CTDH
public ActionResult Index(int page = 1, int pageSize = 11)
{
var dao = new DonHangDao();
var model = dao.ListAllPaging2(page, pageSize);
//var chiTietDonHang = db.ChiTietDonHang.Include(c => c.DonHang).Include(c => c.SanPham);
return(View(model));
}
public ActionResult Edit(int id)
{
var dao = new DonHangDao();
var quyenhan = dao.ViewDentail(id);
SetViewBag(quyenhan.MaKhachSan);
return(View(quyenhan));
}
// GET: Admin/DonHang
public ActionResult DanhSachDonHang(string searchString, int page = 1, int pageSize = 10)
{
var dao = new DonHangDao();
var model = dao.LayTatCaDS(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public JsonResult JsonListDHTheoTrangThai(string tt, int page = 1, int pageSize = 10)
{
var dh = new DonHangDao().ListDHTheoTrangThai(tt, page, pageSize);
return(Json(new
{
status = true
}));
}
public JsonResult CapNhat(int madh, string tt)
{
var dh = new DonHangDao().CapNhat(madh, tt);
return(Json(new
{
status = true
}));
}
public ActionResult ListDonHang(string tt, int page = 1, int pageSize = 10)
{
if (tt == null)
{
var listdh = new DonHangDao().ListDonHang(page, pageSize);
return(View(listdh));
}
else
{
var dh = new DonHangDao().ListDHTheoTrangThai(tt, page, pageSize);
return(View(dh));
}
}
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 GetListDH(string id)
{
var donhang = new DonHangDao().GetDonHang(id);
var listCT_DonHang = new DonHangDao().getListCTDH(id);
var model = new List <DonHangModel>();
decimal total = 0;
foreach (var item in listCT_DonHang)
{
var product = new SanPhamDao().getProduct(item.MASANPHAM);
var img = new SanPhamDao().getListImages(item.MASANPHAM);
model.Add(new DonHangModel()
{
idDonHang = id,
idProduct = item.MASANPHAM,
idCustomer = donhang.MAKHACHHANG,
soluong = item.SOLUONG,
thanhtien = item.THANHTIEN,
nameProduct = product.TENSANPHAM,
linkImage = img[0].LINKHINHANH,
});
total += (item.THANHTIEN * item.SOLUONG);
}
int status = 4;
var ship = 0;
if (donhang != null)
{
status = (int)donhang.TRANGTHAI;
if (total < 300000)
{
total += 30000;
ship = 30000;
}
}
var oModel = new
{
model = model,
total = total,
status = status,
ship = ship
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
// GET: User
public ActionResult Index()
{
var user = Session[OnlineShop.Common.CommonConstants.USER_SESSION];
if (user != null)
{
var dao = new DonHangDao();
var list = dao.DonHangOfUser(((UserLogin)user).UserID);
// Hiển thị list đơn hàng
ViewBag.UserId = ((UserLogin)user).UserID;
return(View(list));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public ActionResult Edit(DonHang qh)
{
if (ModelState.IsValid)
{
var dao = new DonHangDao();
var result = dao.Edit(qh);
if (result)
{
// SetAlert("Cập nhật thành công", "success");
return(RedirectToAction("DanhSachDonHang", "DonHang"));
}
else
{
ModelState.AddModelError("", "Cập nhật thất bại");
}
}
return(View("DanhSachDonHang"));
}
public void displayChart()
{
var cnv = new Bunifu.DataViz.Canvas();
var dataPoint = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuDataViz._type.Bunifu_splineArea);
DonHangDao dao = new DonHangDao();
int jan = dao.month_amount(1);
int feb = dao.month_amount(2);
int mar = dao.month_amount(3);
int apr = dao.month_amount(4);
int may = dao.month_amount(5);
int jun = dao.month_amount(6);
int jul = dao.month_amount(7);
int aug = dao.month_amount(8);
int sep = dao.month_amount(9);
int oct = dao.month_amount(10);
int nov = dao.month_amount(11);
int dec = dao.month_amount(12);
dataPoint.addLabely("Jan", jan.ToString());
dataPoint.addLabely("Feb", feb.ToString());
dataPoint.addLabely("Mar", mar.ToString());
dataPoint.addLabely("Apr", apr.ToString());
dataPoint.addLabely("May", may.ToString());
dataPoint.addLabely("Jun", jun.ToString());
dataPoint.addLabely("Jul", jul.ToString());
dataPoint.addLabely("Aug", aug.ToString());
dataPoint.addLabely("Sep", sep.ToString());
dataPoint.addLabely("Oct", oct.ToString());
dataPoint.addLabely("Nov", nov.ToString());
dataPoint.addLabely("Dec", dec.ToString());
cnv.addData(dataPoint);
bunifuDataViz1.colorSet.Add(Color.Red);
bunifuDataViz1.Render(cnv);
}
public ActionResult GetDoanhThuTheoThang()
{
var list = new List <DoanhThuViewModel>();
decimal doanhthu, tongnhap, loinhuan;
var nam = DateTime.Now.Year;
for (int j = 2019; j <= nam; j++)
{
for (int i = 1; i <= 12; i++)
{
tongnhap = new NhapHangDao().TongNhap(i, j);
doanhthu = new DonHangDao().DoanhThuTheoThang(i, j);
loinhuan = doanhthu - tongnhap;
if (doanhthu != 0)
{
list.Add(new DoanhThuViewModel {
Thang = i, Nam = j, TongNhap = tongnhap, DoanhThu = doanhthu, LoiNhuan = loinhuan
});
}
}
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
// GET: Admin/DonH
public ActionResult Index()
{
var data = new DonHangDao().donHang_TH();
return(View(data));
}
public void populateGridInfo()
{
DonHangDao dao = new DonHangDao();
dataGridViewDonHang.DataSource = dao.getInfo();
}
public ActionResult ChoTH()
{
var data = new DonHangDao().donHang_CTH();
return(View(data));
}
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"));
}
}
