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