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