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