public ActionResult Payment(int idkh, string tenkh, string sdt, string diachi, string email)
{
var order = new HoaDon();
order.MaKh = idkh;
order.NgayNhap = DateTime.Now;
order.TenNguoiNhan = tenkh;
order.SdtNguoiNhan = sdt;
order.DiaChiNguoiNhan = diachi;
order.EmailNguoiNhan = email;
var id = new HoaDonDao().Insert(order);
var cart = (List <Cartitem>)Session[CartSession];
var chitiet = new ChiTietHoaDonDao();
foreach (var item in cart)
{
var cthoadon = new ChiTietHoaDon();
cthoadon.MaSach = item.Sach.IDSach;
cthoadon.MaHoaDon = id;
cthoadon.SoLuongMua = item.SoLuong;
cthoadon.Gia = item.Sach.Gia * item.SoLuong;
chitiet.Insert(cthoadon);
}
return(Redirect("/hoan-thanh"));
}
// GET: Admin/HoaDon
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new HoaDonDao();
var model = dao.LayTatCaDS(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult DanhSachDichVu(int maHoaDon)
{
var dao = new HoaDonDao();
ViewBag.ThongTinHoaDon = dao.TimMaHoaDonTrongCTHD(maHoaDon);
ViewBag.ThongTinDichVu = new DichVuDao().ListAll();
return(View());
}
public ActionResult ThanhToan(int maHoaDon)
{
var dao = new HoaDonDao();
var model = dao.ViewDentail(maHoaDon);
ViewBag.ThongTinHoaDon = dao.TimMaHoaDonTrongCTHD(maHoaDon);
ViewBag.ThongTinDichVu = dao.timDichVuTheoMaHoaDon(maHoaDon);
return(View(model));
}
public ActionResult ListCTHD(int page = 1, int pagesize = 5)
{
//var iplCate = new SachModel();
//var model = iplCate.ListAll();
var dao = new HoaDonDao();
var model = dao.ListAllPagingCtHD(page, pagesize);
return(View(model));
}
public ActionResult testSearchByTotalMoney(string searchStatus, int page = 1, int pageSize = 10)
{
// Thêm view bag như Index
var _daoHoaDon = new HoaDonDao();
var _modalHoaDon = _daoHoaDon.ListAllPagingTotalMoney(searchStatus, page, pageSize);
ViewBag.SearchStatus = searchStatus;
return(View(_modalHoaDon));
}
// GET: HoaDon/Details/5
public ActionResult Details(int id)
{
var hoaDon = new HoaDonDao().ViewDetail(id);
ViewBag.TenHocVien = new HocVienDao().ViewDetails(hoaDon.MaHocVien.GetValueOrDefault(0)).TenHocVien;
ViewBag.TenLopHoc = new LopHocDao().ViewDetail(hoaDon.MaLopHoc.GetValueOrDefault(0)).TenLopHoc;
ViewBag.TenKhoaHoc = new KhoaHocDao().ViewDetail(hoaDon.MaKhoaHoc.GetValueOrDefault(0)).TenKhoaHoc;
return(View(hoaDon));
}
// GET: Admin/Sach/Details/5
public ActionResult Detail(int id)
{
HoaDonDao dao = new HoaDonDao();
var rs = dao.Detail(id);
//if (rs != null)
//{
// ViewBag.Detail = rs;
//}
return(View(rs));
}
public ActionResult Edit(int madonhang)
{
if (Session["User"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
DonHang donhang = new HoaDonDao().ViewDetails(madonhang);
return(View(donhang));
}
}
public ActionResult CreateDetails(HoaDonDetails hoaDonDetails)
{
var hoaDonDao = new HoaDonDao();
var ctHDDao = new CT_HoaDonDao();
var lopHocDao = new LopHocDao();
var hocVienDao = new HocVienDao();
var hocVien = new HocVien();
var ctHD = new CT_HoaDon();
var lopHoc = new LopHoc();
var hoaDon = new HoaDon();
return(RedirectToAction("Index"));
}
// GET: Admin/HoaDonAD
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
if (Session["User"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var dao = new HoaDonDao();
ViewBag.SearchString = searchString;
var model = dao.ListAllPaging(searchString, page, pageSize);
return(View(model));
}
}
public ActionResult Create(HoaDon model)
{
if (ModelState.IsValid)
{
var dao = new HoaDonDao();
int idnv = dao.Insert(model);
if (idnv > 0)
{
return(RedirectToAction("Index", "HoaDon"));
}
else
{
ModelState.AddModelError("", "Thêm HoaDon thành công");
}
}
return(View(model));
}
public void ThemHoaDon(HoaDonDao _hoaDonDao)
{
try
{
ConnectDB();
OpenConnect();
string sqlInsert = @"INSERT INTO HoaDon(MaTP,NgayLap,ThanhTien) VALUES(@MaTP,@NgayLap,@ThanhTien)";
cmd = new SqlCommand(sqlInsert, conn);
cmd.Parameters.AddWithValue("MaTP", _hoaDonDao.MaTP);
cmd.Parameters.AddWithValue("NgayLap", _hoaDonDao.NgayLap);
cmd.Parameters.AddWithValue("ThanhTien", _hoaDonDao.ThanhTien);
cmd.ExecuteNonQuery();
}
finally
{
CloseConnect();
}
}
public ActionResult Edit(HoaDon hoadon)
{
if (ModelState.IsValid)
{
var dao = new HoaDonDao();
if (!string.IsNullOrEmpty(hoadon.DichVu))
{
hoadon.DichVu = hoadon.DichVu;
}
var result = dao.Update(hoadon);
if (result)
{
return(RedirectToAction("Index", "HoaDon"));
}
else
{
ModelState.AddModelError("", "Cập nhật Hóa Đơn không thành công");
}
}
return(View("Index"));
}
public ActionResult DanhSachDichVu(HoaDon_DichVu thongTin)
{
if (thongTin.NguoiSuDung != null && thongTin.MaDichVu != 0)
{
var dao = new HoaDonDao().themThongTinVaoHD_DV(thongTin);
if (dao)
{
SetAlert("Thông tin đã được lưu thành công", "success");
return(RedirectToAction("Index", "HoaDon"));
}
else
{
SetAlert("Thông tin chưa đầy đủ vui lòng kiểm tra lại", "error");
return(RedirectToAction("index", "HoaDon"));
}
}
else
{
SetAlert("Thông tin chưa đầy đủ vui lòng kiểm tra lại", "error");
return(RedirectToAction("index", "HoaDon"));
}
}
// GET: HoaDon
//[HasCredential(Roles = "Xem_HoaDon")]
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
ViewBag.Current = DateTime.UtcNow;
ViewBag.DoanhThuHomNay = db.HoaDons.Where(i => i.NgayLap.Value.Day == DateTime.Now.Day &&
i.NgayLap.Value.Year == DateTime.Now.Year)
.Sum(i => i.TongTien).GetValueOrDefault(0).ToString("#,##").Replace(',', '.');
ViewBag.DoanhThuThangNay = db.HoaDons.Where(i => i.NgayLap.Value.Month == DateTime.Now.Month &&
i.NgayLap.Value.Year == DateTime.Now.Year)
.Sum(i => i.TongTien).GetValueOrDefault(0).ToString("#,##").Replace(',', '.');
ViewBag.TongHoaDonHomNay = db.HoaDons.Where(i => i.NgayLap.Value.Day == DateTime.Now.Day &&
i.NgayLap.Value.Year == DateTime.Now.Year)
.Count();
ViewBag.TongHoaDonThangNay = db.HoaDons.Where(i => i.NgayLap.Value.Month == DateTime.Now.Month &&
i.NgayLap.Value.Year == DateTime.Now.Year)
.Count();
var hoaDonDao = new HoaDonDao();
var modelHoaDon = hoaDonDao.ListAllPaging(searchString, page, pageSize);
return(View(modelHoaDon));
}
public void ThemHoaDon(HoaDonDao _hoaDonDao)
{
_hoaDonDal.ThemHoaDon(_hoaDonDao);
}
public ActionResult DonDatPhong(int page = 1, int pageSize = 10)
{
var dao = new HoaDonDao().DanhSachDatPhong(page, pageSize);
return(View(dao));
}
public ActionResult Edit(int mahd)
{
var hoadon = new HoaDonDao().ViewDetail(mahd);
return(View(hoadon));
}
public ActionResult ThanhToan(HoaDon thongtin)
{
var dao = new HoaDonDao().HoanThanhThanhToan(thongtin.MaHoaDon);
return(RedirectToAction("Index", "HoaDon"));
}
public ActionResult AddCourse(DangKy entity, int id, int maLopHoc, int maKhoaHoc)
{
var hocVienDao = new HocVienDao().ViewDetails(id);
GetViewBagIdHocVien(hocVienDao.MaHocVien);
var hoaDonDao = new HoaDonDao();
var ct_HoaDonDao = new CT_HoaDonDao();
var khoaHocDao = new KhoaHocDao();
var hoaDon = new HoaDon();
var ct_HD = new CT_HoaDon();
var khoaHoc = new KhoaHoc();
khoaHoc.GiaTien = khoaHocDao.GiaTienKhoaHoc(maKhoaHoc);
hoaDon.TongTien = (khoaHoc.GiaTien * 1);
hoaDon.TinhTrang = entity.HoaDon.TinhTrang;
hoaDon.MaHocVien = hocVienDao.MaHocVien;
hoaDon.NgayLap = DateTime.Now;
hoaDon.MaLopHoc = maLopHoc;
hoaDon.MaKhoaHoc = maKhoaHoc;
int checkHD = hoaDonDao.Insert(hoaDon);
ct_HD.MaKhoaHoc = maKhoaHoc;
ct_HD.MaHoaDon = checkHD;
ct_HD.SoLuong = /*entity.CT_HoaDon.SoLuong*/ 1;
int checkCTHD = ct_HoaDonDao.Insert(ct_HD);
var khoaHocDaoEmail = new KhoaHocDao().ViewDetail(maKhoaHoc);
var hocVienDaoEmail = new HocVienDao().ViewDetails(id);
if (checkHD > 0 && checkCTHD > 0)
{
khoaHocDao.DangKyKhoaHoc(maKhoaHoc);
SetAlert("Thêm thành công", 1);
if (hocVienDao.Email == null)
{
return(RedirectToAction("Index", "HocVien"));
}
else
{
string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Email/DangKyKhoaHoc.html"));
content = content.Replace("{{TenKH}}", khoaHocDaoEmail.TenKhoaHoc.ToString());
content = content.Replace("{{TenHV}}", hocVienDaoEmail.TenHocVien.ToString());
content = content.Replace("{{NgaySinh}}", hocVienDaoEmail.NgaySinh.ToString());
content = content.Replace("{{SDT}}", hocVienDaoEmail.SDT.ToString());
content = content.Replace("{{DiaChi}}", hocVienDaoEmail.DiaChi.ToString());
content = content.Replace("{{NgayDangKy}}", hocVienDaoEmail.NgayDangKy.ToString());
new MailHelper().SendMail(hocVienDao.Email, "Chào mừng em đã tham gia vào đại gia đình Đan Thanh!", content);
//SetAlert("")
return(RedirectToAction("Index", "HocVien"));
}
}
else
{
ModelState.AddModelError("", "Có lỗi khi thêm chi tiết học viên");
}
return(RedirectToAction("Index"));
}
