/// <summary>
/// Tao moi 1 record
/// </summary>
/// <param name="lop"></param>
/// <returns>-1 : Input rỗng</returns>
/// <returns> 0 : Trùng</returns>
/// <returns> 1 : Thành công</returns>
/// <returns>2 : Exception</returns>
public int Create(LopTinChi lop)
{
if (lop == null)
{
return(-1);
}
if (lop.NienKhoa.Length == 4)
{
int nk = Int32.Parse(lop.NienKhoa) + 1;
lop.NienKhoa = lop.NienKhoa + "-" + nk.ToString().Trim();
}
try
{
LopTinChi lpTest = context.GetById(lop.MaLopTC);
if (lpTest != null)
{
return(0);
}
context.Create(lop);
return(1);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(2);
}
}
public void Create(ThoiKhoaBieu tkb)
{
LopTinChiBLL contextLTC = new LopTinChiBLL();
MonHocBLL contextMH = new MonHocBLL();
// lấy thông tin lớp tín chỉ của thời khóa biểu.
LopTinChi ltc = contextLTC.GetById(tkb.MaLopTC);
//Lasays thông tin môn học
MonHoc mh = contextMH.GetById(ltc.MaMonHoc);
int soBuoi = 0;
int sotc = mh.SoTinChiLyThuyet + mh.SoTinChiThucHanh;
if (sotc * 15 % 4 != 0)
{
soBuoi = (int)(sotc * 15 / 4) + 1;
}
else
{
soBuoi = sotc * 15 / 4;
}
try
{
for (int i = 0; i < soBuoi; i++)
{
context.Create(tkb);
tkb.Ngay = tkb.Ngay.AddDays(7);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
// GET: LopTinChis/Create
public ActionResult ThemSinhVienVaoLop(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LopTinChi lopTinChi = db.LopTinChis.Find(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID;
KichHoatLopTinChi ltc = new KichHoatLopTinChi();
ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat);
ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID);
ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID);
ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID);
ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID);
var data = db.SinhViens.Where(x => x.KhoaID == khoaID && x.TinhTrang == 1).ToList();
ViewData["dataSinhVien"] = data;
return(View(lopTinChi));
}
public ActionResult DeleteConfirmed(int id)
{
LopTinChi lopTinChi = db.LopTinChis.Find(id);
db.LopTinChis.Remove(lopTinChi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaLopTC,HocKy,Nhom,NienKhoa,MaMonHoc,MaGV,TrangThai")] LopTinChi lopTinChi)
{
if (ModelState.IsValid)
{
contextLopTC.Edit(lopTinChi);
return(RedirectToAction("Index"));
}
ViewBag.MaGV = new SelectList(contextGV.GetALL(), "MaGV", "TenDayDu", lopTinChi.MaGV);
ViewBag.MaMonHoc = new SelectList(contextMH.GetAll(), "MaMH", "TenMH", lopTinChi.MaMonHoc);
return(View(lopTinChi));
}
public ActionResult Edit(int id)
{
LopTinChi lopTinChi = contextLopTC.GetById(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
ViewBag.MaGV = new SelectList(contextGV.GetALL(), "MaGV", "TenDayDu", lopTinChi.MaGV);
return(View(lopTinChi));
}
public ActionResult Create([Bind(Include = "LopTinChiID,MaLopTinChi,TenLopTinChi,SoLuongToiDa,NgayBatDau,NgayKetThuc,GiangVienID,MonHocID,NganhDaoTaoID,KichHoat")] LopTinChi lopTinChi)
{
if (ModelState.IsValid)
{
db.LopTinChis.Add(lopTinChi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "MaMonHoc", lopTinChi.MonHocID);
ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID);
return(View(lopTinChi));
}
public ActionResult Delete(int id)
{
GiangVienBLL ctGV = new GiangVienBLL();
LopTinChiBLL contextLTC = new LopTinChiBLL();
LopTinChi lopTinChi = contextLTC.GetById(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
return(View(lopTinChi));
}
// GET: LopTinChis/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LopTinChi lopTinChi = db.LopTinChis.Find(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID;
KichHoatLopTinChi ltc = new KichHoatLopTinChi();
ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat);
ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID);
ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID);
ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID);
ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID);
var data = db.BangDiems
.Join(db.SinhViens, o1 => o1.SinhVienID, o2 => o2.SinhVienID, (o1, o2) =>
new DanhSachLopViewModels()
{
BangDiemID = o1.BangDiemID,
LopTinChiID = o1.LopTinChiID
,
SinhVienID = o1.SinhVienID
,
MaSinhVien = o2.MaSinhVien
,
HoTen = o2.HoTen
,
NgaySinh = o2.NgaySinh
,
DiemThanhPhan = o1.DiemThanhPhan
,
DiemThi = o1.DiemThi
,
DiemTrungBinh = (o1.DiemThanhPhan * 0.3) + (o1.DiemThi * 0.7) //so1.DiemTrungBinh
,
DiemChu = o1.DiemChu
})
.Where(X => X.LopTinChiID == lopTinChi.LopTinChiID).ToList();
ViewData["dataSinhVien"] = data;
return(View(lopTinChi));
}
public ActionResult Create([Bind(Include = "MaLopTC,HocKy,Nhom,NienKhoa,MaMonHoc,MaGV,TrangThai")] LopTinChi lopTinChi, int HocKy)
{
ViewBag.NienKhoa = new SelectList(contextNKHK.GetNienKhoa(), "NienKhoa", "NienKhoa");
if (ModelState.IsValid)
{
string idNienKhoa = "K" + lopTinChi.NienKhoa.Substring(2, 2) + "-" + HocKy.ToString();
lopTinChi.NienKhoa = idNienKhoa.Trim();
contextLopTC.Create(lopTinChi);
return(RedirectToAction("Index"));
}
ViewBag.MaGV = new SelectList(contextGV.GetALL(), "MaGV", "TenDayDu", lopTinChi.MaGV);
ViewBag.MaMonHoc = new SelectList(contextMH.GetAll(), "MaMH", "TenMH", lopTinChi.MaMonHoc);
return(View(lopTinChi));
}
public ActionResult Details(int id)
{
LopTinChi lopTinChi = contextLopTC.GetById(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
GiangVienBLL ctGV = new GiangVienBLL();
MonHocBLL ctMH = new MonHocBLL();
lopTinChi.GiangVien = ctGV.GetById(lopTinChi.MaGV);
lopTinChi.MonHoc = ctMH.GetById(lopTinChi.MaMonHoc);
lopTinChi.NienKhoaHocKy = contextNKHK.GetById(lopTinChi.NienKhoa);
return(View(lopTinChi));
}
public void DangKy(int maLopTC, string maSV)
{
try
{
SinhVienDAO contextSV = new SinhVienDAO();
LopTinChi lpTest = context.GetById(maLopTC);
SinhVien sv = contextSV.GetById(maSV);
if (lpTest != null && sv != null)
{
context.DangKy(maLopTC, maSV);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
/// <summary>
/// Chỉnh sửa lớp tín chỉ
/// </summary>
/// <param name="lop"></param>
/// <returns>true, false</returns>
public bool Edit(LopTinChi lop)
{
if (lop == null)
{
return(false);
}
try
{
context.Edit(lop);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
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 ActionResult Edit([Bind(Include = "LopTinChiID,MaLopTinChi,TenLopTinChi,SoLuongToiDa,NgayBatDau,NgayKetThuc,GiangVienID,MonHocID,NganhDaoTaoID,KichHoat")] LopTinChi lopTinChi)
{
if (ModelState.IsValid)
{
db.Entry(lopTinChi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID;
KichHoatLopTinChi ltc = new KichHoatLopTinChi();
ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat);
ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID);
ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID);
ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID);
ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID);
return(View(lopTinChi));
}
/// <summary>
/// Xoa khoa theo ma khoa
/// </summary>
/// <param name="maLop"></param>
/// <returns>true, false</returns>
public bool Delete(int maLop)
{
LopTinChi lp = new LopTinChi();
try
{
lp = context.GetById(maLop);
if (lp != null)
{
context.Delete(maLop);
return(true);
}
return(false);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
/// <summary>
/// Lay 1 record dua vao ma lop
/// </summary>
/// <param name="maLop"></param>
/// <returns>Lop</returns>
public LopTinChi GetById(int maLop)
{
GiangVienBLL ctGV = new GiangVienBLL();
LopTinChiBLL contextLTC = new LopTinChiBLL();
MonHocBLL contextMH = new MonHocBLL();
NienKhoaHocKyBLL contextNKHK = new NienKhoaHocKyBLL();
try
{
LopTinChi lopTinChi = context.GetById(maLop);
lopTinChi.NienKhoaHocKy = contextNKHK.GetById(lopTinChi.NienKhoa);
lopTinChi.MonHoc = contextMH.GetById(lopTinChi.MaMonHoc);
lopTinChi.GiangVien = ctGV.GetById(lopTinChi.MaGV);
return(lopTinChi);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
// GET: LopTinChis/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LopTinChi lopTinChi = db.LopTinChis.Find(id);
if (lopTinChi == null)
{
return(HttpNotFound());
}
var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID;
KichHoatLopTinChi ltc = new KichHoatLopTinChi();
ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat);
ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID);
ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID);
ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID);
ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID);
return(View(lopTinChi));
}
