public ActionResult Index() { var lopTinChis = contextLopTC.GetAll(); foreach (LopTinChi item in lopTinChis) { item.NienKhoaHocKy = contextNKHK.GetById(item.NienKhoa); } return(View(lopTinChis)); }
public int GetMaNhom(string maMonHoc, string idNienKhoa, string maGiangVien, int hocKy) { LopTinChiBLL contectLopTC = new LopTinChiBLL(); NienKhoaHocKyBLL contextNKHK = new NienKhoaHocKyBLL(); List <LopTinChi> lstLopTinChiTrung = new List <LopTinChi>(); List <LopTinChi> lstLopTinChi = contectLopTC.GetAll(); int dem = 1; foreach (LopTinChi ltc in lstLopTinChi) { if (ltc.MaGV.Equals(maGiangVien) && ltc.NienKhoa.Equals(idNienKhoa) && ltc.MaMonHoc.Equals(maMonHoc)) { lstLopTinChiTrung.Add(ltc); } } if (lstLopTinChiTrung.Count > 0) { foreach (LopTinChi ltc in lstLopTinChiTrung) { NienKhoaHocKy nkhk = contextNKHK.GetById(ltc.NienKhoa); if (nkhk.HocKy == hocKy) { dem++; } } } return(dem); }
public ActionResult Create(string nienKhoa) { if (string.IsNullOrEmpty(nienKhoa)) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int temp = Int32.Parse(nienKhoa) + 1; string idNK = "K" + nienKhoa.Substring(2, 2) + "-1"; NienKhoaHocKy nkhk = contexNKHK.GetById(idNK.Trim()); if (nkhk == null) { nkhk = new NienKhoaHocKy(); for (int i = 1; i < 4; i++) { nkhk.ID = "K" + nienKhoa.Substring(2, 2) + "-" + i.ToString(); nkhk.NienKhoa = nienKhoa + "-" + temp.ToString().Trim(); nkhk.HocKy = i; contexNKHK.Create(nkhk); } } return(RedirectToAction("Index")); }
public JsonResult GetListLopTheoGiangVienMonHoc(string maGiangVien, string maMonHoc, string nienKhoa, int hocKy) { if (string.IsNullOrEmpty(maGiangVien) || string.IsNullOrEmpty(maMonHoc)) { return(Json(new { msg = "Lỗi !" })); } NienKhoaHocKyBLL contextNKHK = new NienKhoaHocKyBLL(); ThoiKhoaBieuBLL contextTKB = new ThoiKhoaBieuBLL(); List <ThoiKhoaBieu> lstTKB = contextTKB.GetAll(); LopTinChiBLL contextLTC = new LopTinChiBLL(); List <LopTinChi> lstLTCResult = new List <LopTinChi>(); var listLopTC = contextLTC.GetByMaGVVaMaMH(maGiangVien, maMonHoc); List <LopTinChi> lstLTCNew = new List <LopTinChi>(); foreach (LopTinChi item in listLopTC) { var query = lstTKB.Where(x => x.MaLopTC == item.MaLopTC).FirstOrDefault(); if (query == null) { lstLTCNew.Add(item); } } if (lstLTCNew.Count > 0) { foreach (var item in lstLTCNew) { NienKhoaHocKy nkhk = contextNKHK.GetById(item.NienKhoa); if (nkhk.NienKhoa == nienKhoa && nkhk.HocKy == hocKy) { lstLTCResult.Add(item); } } List <int> listMaLopTC = lstLTCResult.Select(x => x.MaLopTC).ToList(); return(Json(new { msg = listMaLopTC })); } return(Json(new { msg = "Không có lớp tín chỉ nào!" })); }
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" })); }