/// <summary>
/// Lấy ra các lớp được đăng ký để sinh viên đăng ký
/// </summary>
/// <param name="lst"></param>
/// <returns></returns>
public List <LopTinChi> GetListLTCDangKy(ICollection <LopTinChi> lst)
{
NienKhoaHocKyBLL contextNKHK = new NienKhoaHocKyBLL();
MonHocBLL contextMH = new MonHocBLL();
List <LopTinChi> lstOpen = new List <LopTinChi>();
Date supportDateTime = new Date();
DateTime dt = DateTime.UtcNow;
foreach (LopTinChi ltc in lst)
{
NienKhoaHocKy nkhk = contextNKHK.GetById(ltc.NienKhoa);
if (nkhk != null && nkhk.HocKy == 1)
{
if (Int32.Parse(ltc.NienKhoa.Split('-')[0]) == dt.Year)
{
if (ltc.TrangThai == true)
{
if (nkhk.HocKy == 1)
{
if (dt.Month >= 9 && dt.Month <= 12)
{
DateTime ngayCuoiNam = new DateTime(dt.Year, 12, 31);
dt = dt.AddDays(1);
// int soTietCoTheMo = supportDateTime.SoTietHocCoTheMo(dt, ngayCuoiNam);
}
}
ltc.MonHoc = contextMH.GetById(ltc.MaMonHoc);
lstOpen.Add(ltc);
}
}
}
}
return(lstOpen);
}
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);
}
/// <summary>
/// Chỉnh sửa khoa
/// </summary>
/// <param name="khoa"></param>
/// <returns>true, false</returns>
public bool Edit(NienKhoaHocKy khoa)
{
if (khoa == null)
{
return(false);
}
try
{
context.Edit(khoa);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
/// <summary>
/// Tao moi 1 record
/// </summary>
/// <param name="nienKhoaHocKy">Niên khóa học kỳ</param>
/// <returns>true , false</returns>
public bool Create(NienKhoaHocKy nienKhoaHocKy)
{
if (nienKhoaHocKy == null)
{
return(false);
}
try
{
context.Create(nienKhoaHocKy);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
/// <summary>
/// Lay 1 record dua vao ID
/// </summary>
/// <param name="ID"></param>
/// <returns>Khoa</returns>
public NienKhoaHocKy GetById(string ID)
{
if (ID == "" || ID == null)
{
return(null);
}
try
{
NienKhoaHocKy nk = context.GetById(ID);
return(nk);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
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!" }));
}
/// <summary>
/// Xoa khoa theo ma khoa
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public bool Delete(string ID)
{
if (string.IsNullOrEmpty(ID))
{
return(false);
}
NienKhoaHocKy kh = new NienKhoaHocKy();
try
{
kh = context.GetById(ID);
if (kh != null)
{
context.Delete(ID);
return(true);
}
return(false);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
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" }));
}
