public ActionResult DangKyMonHoc() { string maSV = Session["MaSV"].ToString().Trim(); KhoaBLL contextK = new KhoaBLL(); LopTinChiBLL contextLTC = new LopTinChiBLL(); List <LopTinChi> lstLTC = contextLTC.GetAll(); MonHocBLL contextMH = new MonHocBLL(); GiangVienBLL contextGV = new GiangVienBLL(); // chỉ cho sinh viên đăng ký lớp đang mở List <LopTinChiModel> listLTCModel = new List <LopTinChiModel>(); foreach (LopTinChi ltc in lstLTC) { var query = ltc.SinhViens.Where(x => x.MaSV == maSV).FirstOrDefault(); if (query == null) { if (ltc.TrangThai == true && ltc.SinhViens.Count < 50) { GiangVien giangVien = contextGV.GetById(ltc.MaGV); MonHoc monHoc = contextMH.GetById(ltc.MaMonHoc); LopTinChiModel ltcModel = new LopTinChiModel() { MaLopTC = ltc.MaLopTC, TrangThai = ltc.TrangThai, MaGV = ltc.MaGV, MaMonHoc = ltc.MaMonHoc, Nhom = ltc.Nhom, NienKhoa = ltc.NienKhoa, GiangVienModel = new GiangVienModel() { MaGV = giangVien.MaGV, Email = giangVien.Email, GioiTinh = giangVien.GioiTinh, HoVaTenLot = giangVien.HoVaTenLot, MaKhoa = giangVien.MaKhoa, MatKhau = giangVien.MatKhau, NgaySinh = giangVien.NgaySinh, SDT = giangVien.SDT, TenGV = giangVien.TenGV, TrinhDo = giangVien.TrinhDo }, MonHoc = new MonHocModel { MaMH = monHoc.MaMH, SoTinChiLyThuyet = monHoc.SoTinChiLyThuyet, SoTinChiThucHanh = monHoc.SoTinChiThucHanh, TenMH = monHoc.TenMH } }; listLTCModel.Add(ltcModel); } } } ViewBag.Khoa = new SelectList(contextK.GetAll(), "MaKhoa", "TenKhoa"); return(View(listLTCModel)); }
public JsonResult GetMaNhom(string maMonHoc, string nienKhoa, string maGiangVien, int hocKy) { string idNK = "K" + nienKhoa.Substring(2, 2) + "-" + hocKy.ToString(); if (string.IsNullOrEmpty(maMonHoc) || string.IsNullOrEmpty(nienKhoa) || string.IsNullOrEmpty(maGiangVien)) { return(Json(new { maNhom = "NULL" })); } LopTinChiModel ltcModel = new LopTinChiModel(); return(Json(new { maNhom = ltcModel.GetMaNhom(maMonHoc, idNK.Trim(), maGiangVien, hocKy) })); }
public JsonResult GetLopTC(int maLopTC) { LopTinChiModel ltcModel; LopTinChiBLL contextLTC = new LopTinChiBLL(); LopTinChi ltc = contextLTC.GetById(maLopTC); GiangVienBLL contextGV = new GiangVienBLL(); MonHocBLL contextMH = new MonHocBLL(); if (ltc != null) { ltcModel = new LopTinChiModel { MaGV = ltc.MaGV, MaLopTC = ltc.MaLopTC, MaMonHoc = ltc.MaMonHoc, Nhom = ltc.Nhom, NienKhoa = ltc.NienKhoa, TrangThai = ltc.TrangThai }; GiangVien gv = contextGV.GetById(ltc.MaGV); MonHoc mh = contextMH.GetById(ltc.MaMonHoc); ltcModel.MonHoc = new MonHocModel { MaMH = mh.MaMH, SoTinChiThucHanh = mh.SoTinChiThucHanh, SoTinChiLyThuyet = mh.SoTinChiLyThuyet, TenMH = mh.TenMH }; ltcModel.GiangVien = new GiangVienModel { MaGV = gv.MaGV, Email = gv.Email, GioiTinh = gv.GioiTinh, HoVaTenLot = gv.HoVaTenLot, MaKhoa = gv.MaKhoa, MatKhau = gv.MatKhau, NgaySinh = gv.NgaySinh, SDT = gv.SDT, TenGV = gv.TenGV, TrinhDo = gv.TrinhDo }; return(Json(new { LTC = ltcModel })); } return(Json(new { LTC = "NULL" })); }
public JsonResult LocTheoNieKhoaHocKy(string nienKhoa, int hocky) { string maSV = Session["MaSV"].ToString().Trim(); if (string.IsNullOrEmpty(nienKhoa) || hocky < 0 || hocky > 3) { return(Json(new { msg = "FALSE" })); } KhoaBLL contextK = new KhoaBLL(); LopTinChiBLL contextLTC = new LopTinChiBLL(); List <LopTinChi> lstLTC = contextLTC.GetAll(); NienKhoaHocKyBLL contextNKHK = new NienKhoaHocKyBLL(); MonHocBLL contextMH = new MonHocBLL(); GiangVienBLL contextGV = new GiangVienBLL(); List <LopTinChiModel> listLTCModel = new List <LopTinChiModel>(); foreach (LopTinChi ltc in lstLTC) { NienKhoaHocKy nkhk = contextNKHK.GetById(ltc.NienKhoa); var query = ltc.SinhViens.Where(x => x.MaSV == maSV).FirstOrDefault(); if (query == null) { if (ltc.TrangThai == true && ltc.NienKhoa == nienKhoa && nkhk.HocKy == hocky && ltc.SinhViens.Count < 50) { GiangVien giangVien = contextGV.GetById(ltc.MaGV); MonHoc monHoc = contextMH.GetById(ltc.MaMonHoc); LopTinChiModel ltcModel = new LopTinChiModel() { MaLopTC = ltc.MaLopTC, TrangThai = ltc.TrangThai, MaGV = ltc.MaGV, MaMonHoc = ltc.MaMonHoc, Nhom = ltc.Nhom, NienKhoa = ltc.NienKhoa, GiangVienModel = new GiangVienModel() { MaGV = giangVien.MaGV, Email = giangVien.Email, GioiTinh = giangVien.GioiTinh, HoVaTenLot = giangVien.HoVaTenLot, MaKhoa = giangVien.MaKhoa, MatKhau = giangVien.MatKhau, NgaySinh = giangVien.NgaySinh, SDT = giangVien.SDT, TenGV = giangVien.TenGV, TrinhDo = giangVien.TrinhDo }, MonHoc = new MonHocModel { MaMH = monHoc.MaMH, SoTinChiLyThuyet = monHoc.SoTinChiLyThuyet, SoTinChiThucHanh = monHoc.SoTinChiThucHanh, TenMH = monHoc.TenMH } }; listLTCModel.Add(ltcModel); } } } ViewBag.Khoa = new SelectList(contextK.GetAll(), "MaKhoa", "TenKhoa"); if (listLTCModel.Count > 0) { return(Json(new { msg = listLTCModel })); } return(Json(new { msg = "FALSE" })); }
public JsonResult LuuDangKy() { string maSV = Session["MaSV"].ToString().Trim(); LopTinChiBLL contextLTC = new LopTinChiBLL(); List <LopTinChi> lstLTC = contextLTC.GetAll(); MonHocBLL contextMH = new MonHocBLL(); GiangVienBLL contextGV = new GiangVienBLL(); List <LopTinChiModel> listLTCModel = new List <LopTinChiModel>(); foreach (LopTinChi ltc in lstLTC) { var query = ltc.SinhViens.Where(x => x.MaSV == maSV).FirstOrDefault(); if (query == null) { if (ltc.TrangThai == true && ltc.SinhViens.Count < 50) { GiangVien giangVien = contextGV.GetById(ltc.MaGV); MonHoc monHoc = contextMH.GetById(ltc.MaMonHoc); LopTinChiModel ltcModel = new LopTinChiModel() { MaLopTC = ltc.MaLopTC, TrangThai = ltc.TrangThai, MaGV = ltc.MaMonHoc, MaMonHoc = ltc.MaMonHoc, Nhom = ltc.Nhom, NienKhoa = ltc.NienKhoa, GiangVienModel = new GiangVienModel() { MaGV = giangVien.MaGV, Email = giangVien.Email, GioiTinh = giangVien.GioiTinh, HoVaTenLot = giangVien.HoVaTenLot, MaKhoa = giangVien.MaKhoa, MatKhau = giangVien.MatKhau, NgaySinh = giangVien.NgaySinh, SDT = giangVien.SDT, TenGV = giangVien.TenGV, TrinhDo = giangVien.TrinhDo }, MonHoc = new MonHocModel { MaMH = monHoc.MaMH, SoTinChiLyThuyet = monHoc.SoTinChiLyThuyet, SoTinChiThucHanh = monHoc.SoTinChiThucHanh, TenMH = monHoc.TenMH } }; listLTCModel.Add(ltcModel); } } } DangKyModel dk = new DangKyModel(); List <int> listMaLopDK = (List <int>)TempData["ListLopTCDK"]; if (listMaLopDK.Count > 0) { foreach (int a in listMaLopDK) { LopTinChiModel ltcModel = listLTCModel.Where(x => x.MaLopTC == a).FirstOrDefault(); if (ltcModel != null) { if (Session["MaSV"] != null) { contextLTC.DangKy(ltcModel.MaLopTC, maSV); } } } TempData.Clear(); return(Json(new { msg = "Lưu đăng ký thành công!" })); } return(Json(new { msg = "Lỗi!" })); }
public JsonResult DeleteSelectMonHoc(int maLopTC) { string maSV = Session["MaSV"].ToString().Trim(); LopTinChiBLL contextLTC = new LopTinChiBLL(); List <LopTinChi> lstLTC = contextLTC.GetAll(); MonHocBLL contextMH = new MonHocBLL(); GiangVienBLL contextGV = new GiangVienBLL(); List <LopTinChiModel> listLTCModel = new List <LopTinChiModel>(); foreach (LopTinChi ltc in lstLTC) { var query = ltc.SinhViens.Where(x => x.MaSV == maSV).FirstOrDefault(); if (query == null) { if (ltc.TrangThai == true && ltc.SinhViens.Count < 50) { GiangVien giangVien = contextGV.GetById(ltc.MaGV); MonHoc monHoc = contextMH.GetById(ltc.MaMonHoc); LopTinChiModel ltcModel = new LopTinChiModel() { MaLopTC = ltc.MaLopTC, TrangThai = ltc.TrangThai, MaGV = ltc.MaMonHoc, MaMonHoc = ltc.MaMonHoc, Nhom = ltc.Nhom, NienKhoa = ltc.NienKhoa, GiangVienModel = new GiangVienModel() { MaGV = giangVien.MaGV, Email = giangVien.Email, GioiTinh = giangVien.GioiTinh, HoVaTenLot = giangVien.HoVaTenLot, MaKhoa = giangVien.MaKhoa, MatKhau = giangVien.MatKhau, NgaySinh = giangVien.NgaySinh, SDT = giangVien.SDT, TenGV = giangVien.TenGV, TrinhDo = giangVien.TrinhDo }, MonHoc = new MonHocModel { MaMH = monHoc.MaMH, SoTinChiLyThuyet = monHoc.SoTinChiLyThuyet, SoTinChiThucHanh = monHoc.SoTinChiThucHanh, TenMH = monHoc.TenMH } }; listLTCModel.Add(ltcModel); } } } if (listLTCModel.Count > 0) { LopTinChiModel ltc = listLTCModel.Where(x => x.MaLopTC == maLopTC).FirstOrDefault(); if (ltc != null) { if (TempData["SoTinChiDK"] != null) { List <int> listMaLopDK = (List <int>)TempData["ListLopTCDK"]; var itemToRemove = listMaLopDK.Single(r => r == maLopTC); listMaLopDK.Remove(itemToRemove); TempData["ListLopTCDK"] = listMaLopDK; int tong = Int32.Parse(TempData["SoTinChiDK"].ToString()) - ltc.TongSoTinChi; TempData["SoTinChiDK"] = tong; return(Json(new { msg = "OK" })); } } } return(Json(new { msg = "FALSE" })); }