public ActionResult Edit(HocVien hocVien) { try { // TODO: Add insert logic here if (ModelState.IsValid) { var _daoGiaoVien = new HocVienDao(); var res = _daoGiaoVien.Update(hocVien); if (res) { return(RedirectToAction("Index", "HocVien")); } else { ModelState.AddModelError("", "Cập nhật thất bại"); } } return(View(hocVien)); } catch { return(RedirectToAction("Index", "Home")); } }
public ActionResult GetBillByStudent(int id) { var list = new HocVienDao().getListBillByStudent(id); ViewBag.TenHocVien = new HocVienDao().ViewDetails(id).TenHocVien; ViewBag.TongTien = new HocVienDao().TotalMoney(id); return(View(list)); }
public ActionResult Create(HocVien hocVien, HttpPostedFileBase hinhAnh) { try { if (ModelState.IsValid) { string path = ""; if (hinhAnh != null && hinhAnh.ContentLength > 0) { string extension = Path.GetExtension(hinhAnh.FileName); if (extension.Equals(".jpg") || extension.Equals(".png") || extension.Equals(".jpeg")) { path = Path.Combine(Server.MapPath("~/Img/HocVien/"), hinhAnh.FileName); hinhAnh.SaveAs(path); } hocVien.HinhAnh = hinhAnh.FileName; var _daoHocVien = new HocVienDao(); hocVien.NgayDangKy = DateTime.Now; int _maGiaoVien = _daoHocVien.Insert(hocVien); if (_maGiaoVien > 0) { if (hocVien.Email == null) { return(RedirectToAction("Index", "HocVien")); } else { string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Email/HocVien.html")); content = content.Replace("{{TenHV}}", hocVien.TenHocVien.ToString()); content = content.Replace("{{NgaySinh}}", hocVien.NgaySinh.ToString()); content = content.Replace("{{SDT}}", hocVien.SDT.ToString()); content = content.Replace("{{DiaChi}}", hocVien.DiaChi.ToString()); content = content.Replace("{{NgayDangKy}}", hocVien.NgayDangKy.ToString()); new MailHelper().SendMail(hocVien.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 học viên"); } } } return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: HocVien public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { ViewBag.HocVienMoi = _context.HocViens.Where(x => x.NgayDangKy.Value.Month == DateTime.Now.Month).Count(); ViewBag.TongHocVien = _context.HocViens.Where(x => x.TrangThai == true).Count(); ViewBag.HocVienNam = _context.HocViens.Where(x => x.GioiTinh == "Nam" || x.GioiTinh == "nam").Count(); ViewBag.HocVienNu = _context.HocViens.Where(x => x.GioiTinh == "Nữ" || x.GioiTinh == "nữ").Count(); var _daoHocVien = new HocVienDao(); var _modelHocVien = _daoHocVien.ListAllPaging(searchString, page, pageSize); return(View(_modelHocVien)); }
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")); }
public ActionResult ChiTietHocVien(int id) { var hocVienDao = new HocVienDao().ViewDetails(id); var details = new HocVienDetailsViewModels(); details.MaHocVien = hocVienDao.MaHocVien; details.TenHocVien = hocVienDao.TenHocVien; details.NgayDangKy = hocVienDao.NgaySinh; details.NgayDangKy = hocVienDao.NgayDangKy; details.SDT = hocVienDao.SDT; details.Nguon = hocVienDao.Nguon; details.HinhAnh = hocVienDao.HinhAnh; details.GioiTinh = hocVienDao.GioiTinh; details.GhiChu = hocVienDao.GhiChu; ViewBag.MaHocVien = details.MaHocVien; return(View(details)); }
public void SetViewBagHV(int?maHocVien = null) { var daoHocVien = new HocVienDao(); ViewBag.MaHocVien = new SelectList(daoHocVien.ListAll(), "MaHocVien", "TenHocVien", maHocVien); }
public void GetViewBagIdHocVien(int maHocVien) { var dao = new HocVienDao(); ViewBag.MaHocVien = dao.GetHocVienById(maHocVien); }
public ActionResult Edit(int id) { var _hocVien = new HocVienDao().ViewDetails(id); return(View(_hocVien)); }
// GET: HocVien/Details/5 public ActionResult Details(int id) { var hocVienDao = new HocVienDao().ViewDetails(id); return(View(hocVienDao)); }
public ActionResult CreateDetails(HocVienDetails hocVienDetails, HttpPostedFileBase hinhAnhDetail) { try { if (ModelState.IsValid) { string path = ""; if (hinhAnhDetail != null && hinhAnhDetail.ContentLength > 0) { string extension = Path.GetExtension(hinhAnhDetail.FileName); if (extension.Equals(".jpg") || extension.Equals(".png") || extension.Equals(".jpeg")) { path = Path.Combine(Server.MapPath("~/Img/HocVien/"), hinhAnhDetail.FileName); hinhAnhDetail.SaveAs(path); } var _daoHocVien = new HocVienDao(); var _daoPhuHuynh = new PhuHuynhDao(); var hocVien = new HocVien(); hocVien.TenHocVien = hocVienDetails.HocVien.TenHocVien; hocVien.TaiKhoan = hocVienDetails.HocVien.TaiKhoan; hocVien.MatKhau = hocVienDetails.HocVien.MatKhau; hocVien.HinhAnh = hinhAnhDetail.FileName; hocVien.GioiTinh = hocVienDetails.HocVien.GioiTinh; hocVien.SDT = hocVienDetails.HocVien.SDT; hocVien.Email = hocVienDetails.HocVien.Email; hocVien.DiaChi = hocVienDetails.HocVien.DiaChi; hocVien.NgaySinh = hocVienDetails.HocVien.NgaySinh; hocVien.GhiChu = hocVienDetails.HocVien.GhiChu; hocVien.TrangThai = hocVienDetails.HocVien.TrangThai; hocVien.Nguon = hocVienDetails.HocVien.Nguon; // Thêm học viên int _maHocVien = _daoHocVien.Insert(hocVien); for (int i = 0; i < 2; i++) { var _phuHuynh = new PhuHuynh(); _phuHuynh.TenPhuHuynh = hocVienDetails.LstPhuHuynh[i].TenPhuHuynh; _phuHuynh.TenPhuHuynh = hocVienDetails.LstPhuHuynh[i].TenPhuHuynh; _phuHuynh.SDT = hocVienDetails.LstPhuHuynh[i].SDT; _phuHuynh.GioiTinh = hocVienDetails.LstPhuHuynh[i].GioiTinh; _phuHuynh.DiaChi = hocVienDetails.LstPhuHuynh[i].DiaChi; _phuHuynh.Email = hocVienDetails.LstPhuHuynh[i].Email; _phuHuynh.MaHocVien = _maHocVien; int _maPhuHuynh = _daoPhuHuynh.Insert(_phuHuynh); } if (_maHocVien > 0 && _maHocVien > 0) { if (hocVien.Email == null) { return(RedirectToAction("Index", "HocVien")); } else { string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Email/HocVien.html")); content = content.Replace("{{TenHV}}", hocVien.TenHocVien.ToString()); content = content.Replace("{{NgaySinh}}", hocVien.NgaySinh.ToString()); content = content.Replace("{{SDT}}", hocVien.SDT.ToString()); content = content.Replace("{{DiaChi}}", hocVien.DiaChi.ToString()); content = content.Replace("{{NgayDangKy}}", hocVien.NgayDangKy.ToString()); new MailHelper().SendMail(hocVien.Email, "Chào mừng em đã tham gia vào đại gia đình Đan Thanh!", content); SetAlert("Thêm thành công", 1); return(RedirectToAction("Index", "HocVien")); } } else { ModelState.AddModelError("", "Có lỗi khi thêm chi tiết học viên"); } } } return(RedirectToAction("Index")); } catch { return(View()); } }
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")); }