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