public async Task <IHttpActionResult> CreateDiemDanh(string MaUser) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DateTime date = new DateTime(); date = DateTime.Now; string buoi = date.Hour < 12 ? "sa" : "ch"; var dk = db.DuKienTTs.FirstOrDefault(x => x.Ngay == date.Day.ToString() && x.Thang == date.Month.ToString() && x.MaUser == MaUser); string ma = "DD_" + dk.MaDuKien + "_" + date.Day.ToString() + date.Month.ToString() + "_" + buoi.ToUpper(); if (db.DiemDanhs.FirstOrDefault(x => x.MaDD == ma) == null) { DiemDanh dd = new DiemDanh(); dd.MaDD = ma; dd.MaDuKien = dk.MaDuKien; dd.Ngay = date; dd.Buoi = buoi; db.DiemDanhs.Add(dd); await db.SaveChangesAsync(); return(Ok(new { Code = 200 })); } else { return(Ok(new { Code = 201 })); } }
public async Task <IActionResult> Edit(int id, [Bind("MaDD,Thang,Tuan,TenNV,T2,T3,T4,T5,T6")] DiemDanh diemDanh) { if (id != diemDanh.MaDD) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(diemDanh); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DiemDanhExists(diemDanh.MaDD)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(diemDanh)); }
public ActionResult DeleteConfirmed(int id) { DiemDanh diemdanh = db.DiemDanhs.Find(id); db.DiemDanhs.Remove(diemdanh); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /DiemDanh/Details/5 public ActionResult Details(int id = 0) { DiemDanh diemdanh = db.DiemDanhs.Find(id); if (diemdanh == null) { return(HttpNotFound()); } return(View(diemdanh)); }
public IActionResult DiemDanhNhanVien(LayDiemDanhNhanVienId model) { var url = $"{Common.Common.ApiUrl}/quanly/LayDiemDanhNhanVienId"; var responseData = GetMethod(url, model); var diemDanh = new DiemDanh(); diemDanh = JsonConvert.DeserializeObject <DiemDanh>(responseData); return(View(diemDanh)); }
public DiemDanh getTableDIEMDANHByIdMaHocPhan(String id, String mahp) { DiemDanh result = new DiemDanh(); DataTable dt = new DataTable(); String strSqlDuLieuChuan = string.Format(@"EXEC getListDIEMDANHByMASINHVIENMaHocPhan '{0}', '{1}'", id, mahp); dt = DataProvider.Instance.LoadAllTable(strSqlDuLieuChuan); result = new DiemDanh(dt.Rows[0]); return(result); }
public ActionResult Edit([Bind(Include = "MaPhieuDD,Ngay,Buoi,MaSV,MaLopTC")] DiemDanh diemDanh) { if (ModelState.IsValid) { contextDiemDanh.Edit(diemDanh); return(RedirectToAction("Index")); } ViewBag.MaLopTC = new SelectList(contextLopTC.GetAll(), "MaLopTC", "NienKhoa", diemDanh.MaLopTC); ViewBag.MaSV = new SelectList(contextSinhVien.GetAll(), "MaSV", "HoVaTenLot", diemDanh.MaSV); return(View(diemDanh)); }
/// <summary> /// Tạo mới 1 record /// </summary> /// <param name="dd">Điểm danh</param> public void Create(DiemDanh dd) { try { context.Create(dd); } catch (Exception ex) { Console.WriteLine(ex); } }
public async Task <IActionResult> Create([Bind("MaDD,Thang,Tuan,TenNV,T2,T3,T4,T5,T6")] DiemDanh diemDanh) { if (ModelState.IsValid) { _context.Add(diemDanh); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(diemDanh)); }
public IActionResult DiemDanhNhanVienAjax([FromBody] LayDiemDanhNhanVienId model) { var url = $"{Common.Common.ApiUrl}/quanly/LayDiemDanhNhanVienId"; var responseData = GetMethod(url, model); var diemDanh = new DiemDanh(); diemDanh = JsonConvert.DeserializeObject <DiemDanh>(responseData); return(Json(new { response = diemDanh, code = 1 })); }
public ActionResult Ed(string bhoc) { string maGV = Session["MaGV"] as string; string maKh = Session["MaKH"] as string; // Tao buoi hoc int bh = taobuoi(maKh); //--------------------------- var Fch = Request.Form.AllKeys.Where(k => k != "bhoc"); //string day = DateTime.Now.DayOfWeek.ToString(); //var query = (from pro in db.BangBuoiHocs where pro.maKH == maKh && pro.day == day select pro.maBH).FirstOrDefault(); string date = DateTime.Now.ToString("yyyy/MM/dd"); string time = DateTime.Now.ToString("HH:mm:ss"); //CreateSessionID create = new CreateSessionID(); //int getID = (create.GetLastID("DiemDanh", "sessionID", maKh) + 1); foreach (var fea in Fch) { try { if (fea.Trim().Length == 7) { DiemDanh dd = new DiemDanh(); bool stt = Request.Form[fea.Trim()] != "false"; dd.ID_BuoiHoc = bh; dd.MSSV = fea.Trim(); dd.status = stt; db.DiemDanhs.Add(dd); db.SaveChanges(); } } catch (Exception) { } } //var monhoc = connect.TestCourse(maGV); var idbt = db.BuoiHocs.Where(x => x.ID_BH == bh).FirstOrDefault(); string ids = idbt.Buoi_thu.ToString(); //ViewBag.Subject = monhoc; return(RedirectToAction("ListDiemDanh", new RouteValueDictionary( new { controller = "Course", action = "ListDiemDanh", id = ids }))); //return View(); }
public ActionResult Attendance(string id) { Session["maKH"] = id; var bhoc = db.BangBuoiHocs.Where(b => b.maKH == id).ToList(); var svien = db.SinhViens.Where(v => v.maKH == id).ToList(); var max = db.DiemDanhs.Where(m => m.MaKH == id).Max(x => x.sessionID) + 1; Session["ss"] = max; // xử lí lưu vào bang điểm danh foreach (var bh in bhoc) { foreach (var sv in svien) { DiemDanh atten = new DiemDanh(); atten.maBH = bh.maBH; atten.MaKH = id; atten.MSSV = sv.MSSV; if (max == 0 || max == null) { atten.sessionID = 1; } else { atten.sessionID = max; } atten.Date = DateTime.Now.Date; atten.Time = TimeSpan.Parse(DateTime.Now.ToString("HH:mm:ss")); atten.diemDanh1 = false; db.DiemDanhs.Add(atten); db.SaveChanges(); } } string maGV = Session["MaGV"] as string; var monhoc = db.MonHocs.Where(mh => mh.GiangViens.Count(gv => gv.maGV == maGV) > 0).ToList(); var sinhvien = db.SinhViens.Where(sv => sv.maKH == id).ToList(); var buoihoc = db.BangBuoiHocs.Where(bh => bh.maKH == id).ToList(); var mabuoihoc = buoihoc.Select(mh => mh.maBH).ToArray(); string mbh = mabuoihoc[0]; var diemdanh = db.DiemDanhs.Where(dd => dd.maBH == mbh); ViewBag.Student = sinhvien; ViewBag.Diemdanh = diemdanh.ToList(); ViewBag.CountStudent = sinhvien.Count(); ViewBag.Buoihoc = buoihoc; ViewBag.Subject = monhoc; ViewBag.MaKH = id; return(View()); }
public ActionResult Edit(DiemDanh diemdanh) { if (ModelState.IsValid) { db.Entry(diemdanh).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("EditDiemDanh", new { id = diemdanh.IdBuoiHoc })); } ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc); ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung); ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc); return(RedirectToAction("EditDiemDanh", new { id = diemdanh.IdBuoiHoc })); }
/// <summary> /// Lấy 1 record dựa vào mã phiếu điểm danh /// </summary> /// <param name="maPDD"></param> /// <returns>Khoa</returns> public DiemDanh GetById(string maPDD) { try { DiemDanh dd = context.GetById(maPDD); return(dd); } catch (Exception ex) { Console.WriteLine(ex); return(null); } }
public ActionResult Create(DiemDanh diemdanh) { if (ModelState.IsValid) { db.DiemDanhs.Add(diemdanh); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc); ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung); ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc); return(View(diemdanh)); }
public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DiemDanh diemDanh = contextDiemDanh.GetById(id); if (diemDanh == null) { return(HttpNotFound()); } return(View(diemDanh)); }
/// <summary> /// Chỉnh sửa 1 record /// </summary> /// <param name="dd">Điểm danh</param> public void Edit(DiemDanh dd) { if (dd == null) { return; } try { context.Edit(dd); } catch (Exception ex) { Console.WriteLine(ex); } }
// // GET: /DiemDanh/Edit/5 public ActionResult Edit(int idbuoihoc = 0, int idnguoidung = 0) { DiemDanh diemdanh = (DiemDanh)(from d in db.DiemDanhs where d.IdBuoiHoc == idbuoihoc && d.IdNguoiDung == idnguoidung select d).First(); if (diemdanh == null) { return(HttpNotFound()); } ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc); ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung); ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc); return(View(diemdanh)); }
public void _Vang(object parameter) { using (var db = new QuanLyPhanBonEntities()) { DiemDanh diemDanh = new DiemDanh(); diemDanh.isCoMat = false; diemDanh.isVang = true; diemDanh.NgayLam = DateTime.Now; diemDanh.NhanVien = _SelectedNhanVien.IDNhanVien; db.DiemDanhs.Add(diemDanh); _ListNhanVien.Remove(_SelectedNhanVien); OnPropertyChanged("ListNhanVien"); db.SaveChanges(); } }
public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DiemDanh diemDanh = contextDiemDanh.GetById(id); if (diemDanh == null) { return(HttpNotFound()); } ViewBag.MaLopTC = new SelectList(contextLopTC.GetAll(), "MaLopTC", "NienKhoa", diemDanh.MaLopTC); ViewBag.MaSV = new SelectList(contextSinhVien.GetAll(), "MaSV", "HoVaTenLot", diemDanh.MaSV); return(View(diemDanh)); }
public ActionResult DanhSachDiemDanh(int idsv, int idlhp) { DiemDanhService a = new DiemDanhService(); SinhVienService b = new SinhVienService(); LopHocPhanService c = new LopHocPhanService(); List <DiemDanh> lst = new List <DiemDanh>(); foreach (var item in a.GetbyIDSV(idsv, idlhp)) { DiemDanh m = new DiemDanh(); m = item; lst.Add(m); } ViewBag.ten = b.getById(idsv).tenSinhVien; ViewBag.mon = c.getById(idlhp).tenLopHocPhan; return(View(lst)); }
public ActionResult DiemDanhCf(int idsv, int idlhp, int tt) { DiemDanhService a = new DiemDanhService(); KetQuaHocTapService aa = new KetQuaHocTapService(); DiemDanh dd = new DiemDanh(); dd.kqhtID = aa.getIDkqht(idsv, idlhp); if (tt == 0) { dd.tragthai = ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat; } else { dd.tragthai = ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang; } dd.ngayDD = DateTime.Now; var temp = a.GetbyIDSV(idsv, idlhp).Where(x => x.ngayDD.Day == dd.ngayDD.Day && x.ngayDD.Month == dd.ngayDD.Month && x.ngayDD.Year == dd.ngayDD.Year).FirstOrDefault(); if (temp != null) { if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat) { TempData["tb"] = "Hom nay da diem danh"; } else if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang) { TempData["tb"] = "Hom nay da bi vang"; } } else { a.Add(dd); if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat) { TempData["tb"] = "Diem danh thanh cong"; } else if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang) { TempData["tb"] = "Sinh vien da duoc danh vang"; } } return(RedirectToAction("DiemDanh", new { id = idlhp })); }
public ActionResult DiemDanhthucong(string makh) // id truyen ma khoa hoc dang chon { int ids = taobuoi(makh); var list = db.ThamDus.Where(x => x.MaKH == makh).ToList(); foreach (var dd in list) { // var makh DiemDanh ddanh = new DiemDanh(); ddanh.MSSV = dd.MSSV; ddanh.status = false; ddanh.ID_BuoiHoc = ids; db.DiemDanhs.Add(ddanh); db.SaveChanges(); // db.Dispose(); } return(View(list)); }
// // GET: /DanhSach/DiemDanhMoi public ActionResult DiemDanhMoi() { int IdDiHoc = 1; // idtinhtrangdihoc = đi học List <SelectListItem> ListTrangThai = new List <SelectListItem>(); List <DiemDanh> ListDiemDanh = new List <DiemDanh>(); if (Session["LopMonHocCurrent"] != null) { int IdLopMonHoc = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc; LopMonHoc LopMonHocCurrent = (LopMonHoc)((from t in db.LopMonHocs where t.IdLopMonHoc == IdLopMonHoc select t).ToList().First()); List <NguoiDung> ListSinhVienTrongLop = (List <NguoiDung>)((from t in db.DanhSaches where t.IdLopMonHoc == IdLopMonHoc select t.NguoiDung).ToList()); foreach (NguoiDung n in ListSinhVienTrongLop) { DiemDanh NewDiemDanh = new DiemDanh(); NewDiemDanh.NguoiDung = n; NewDiemDanh.IdNguoiDung = n.IdNguoiDung; TinhTrangDiHoc TinhTrangDiHoc = (TinhTrangDiHoc)(from t in db.TinhTrangDiHocs where IdDiHoc == t.IdTinhTrangDiHoc select t).ToList().First(); NewDiemDanh.TinhTrangDiHoc = TinhTrangDiHoc; NewDiemDanh.IdTinhTrangDiHoc = IdDiHoc; ListDiemDanh.Add(NewDiemDanh); } } else { // chưa chọn lớp môn học } ViewBag.DanhSach = ListDiemDanh; ViewBag.ListTrangThai = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", IdDiHoc); return(View(ListDiemDanh)); }
protected void btnCaphat_Click(object sender, EventArgs e) { Dangkyhoc dkh = new Dangkyhoc(); dkh.MaMon = DrMaHP.SelectedValue.ToString(); dkh.Mssv = txtMasv.Text; db.Dangkyhocs.InsertOnSubmit(dkh); db.SubmitChanges(); DrMaHP_SelectedIndexChanged(sender, e); mymodal.Visible = false; int rowclass = GridView1.Rows.Count - 1; string mdk = GridView1.Rows[rowclass].Cells[7].Text; DiemDanh dd = new DiemDanh(); dd.MaDK = Convert.ToInt32(mdk); dd.Buoi = 1; db.DiemDanhs.InsertOnSubmit(dd); db.SubmitChanges(); }
public ActionResult Edit(string bhocc) { string maGV = Session["MaGV"] as string; string maKh = Session["MaKH"] as string; var Fch = Request.Form.AllKeys.Where(k => k != "bhocc"); string day = DateTime.Now.DayOfWeek.ToString(); var query = (from pro in db.DiemDanhs where pro.MaKH == maKh select pro).ToList(); ViewBag.Date = query; //var query = (from pro in db.BangBuoiHocs where pro.maKH == maKh select pro.maBH).FirstOrDefault(); string date = DateTime.Now.ToString("yyyy/MM/dd"); string time = DateTime.Now.ToString("HH:mm:ss"); CreateSessionID create = new CreateSessionID(); int getID = int.Parse(Session["SessionID"].ToString()); DiemDanh push = null; foreach (var fea in Fch) { { string x = Request.Form[fea.Trim()]; var diemDanh1 = Request.Form[fea.Trim()] != "false"; conn = ut.OpenDb(); conn.Open(); cmd = new SqlCommand("select *from DiemDanh", conn); cmd.CommandType = CommandType.Text; cmd.CommandText = "update DiemDanh set diemDanh = '" + diemDanh1 + "' Where MSSV = '" + fea.Trim() + "' and MaKH = '" + maKh + "' and sessionID = '" + getID + "'"; //values('" + query + "',N'" + maKh + "',N'" + fea.Trim().ToString() + "','" + date + "','" + time + "','" + diemDanh1 + "','" + getID + "')"; cmd.ExecuteNonQuery(); cmd.Dispose(); } } return(RedirectToAction("Course", "Home", new { id = Session["MaKH"].ToString() })); }
public ArrayList addArray(DiemDanh dd) { ArrayList arl = new ArrayList(); arl.Add((dd.Tuan_1) != null ? dd.Tuan_1 : ""); arl.Add((dd.Tuan_2) != null ? dd.Tuan_2 : ""); arl.Add((dd.Tuan_3) != null ? dd.Tuan_3 : ""); arl.Add((dd.Tuan_4) != null ? dd.Tuan_4 : ""); arl.Add((dd.Tuan_5) != null ? dd.Tuan_5 : ""); arl.Add((dd.Tuan_6) != null ? dd.Tuan_6 : ""); arl.Add((dd.Tuan_7) != null ? dd.Tuan_7 : ""); arl.Add((dd.Tuan_8) != null ? dd.Tuan_8 : ""); arl.Add((dd.Tuan_9) != null ? dd.Tuan_9 : ""); arl.Add((dd.Tuan_10) != null ? dd.Tuan_10 : ""); arl.Add((dd.Tuan_11) != null ? dd.Tuan_11 : ""); arl.Add((dd.Tuan_12) != null ? dd.Tuan_12 : ""); arl.Add((dd.Tuan_13) != null ? dd.Tuan_13 : ""); arl.Add((dd.Tuan_14) != null ? dd.Tuan_14 : ""); arl.Add((dd.Tuan_15) != null ? dd.Tuan_15 : ""); arl.Add((dd.Tuan_16) != null ? dd.Tuan_16 : ""); arl.Add((dd.Tuan_17) != null ? dd.Tuan_17 : ""); return(arl); }
public DiemDanh Add(DiemDanh dd) { return(diemdanhrepository.Add(dd)); }
public ActionResult BrowseDanhSach(FormCollection formCollection) { if (Request != null) { HttpPostedFileBase file = Request.Files["UploadedDanhSach"]; if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); // Khai báo biến if (Session["LopMonHocCurrent"] != null) { int IdLopMonHocCurrent = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc; List <DanhSach> ListDanhSachThanhCong = new List <DanhSach>(); List <DanhSachThemThatBai> ListDanhSachThatBai = new List <DanhSachThemThatBai>(); string MaSinhVienFromFile = ""; using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { DanhSach DanhSach = new DanhSach(); DanhSach.IdLopMonHoc = IdLopMonHocCurrent; MaSinhVienFromFile = workSheet.Cells[rowIterator, 2].Value.ToString(); if (KiemTraTonTaiNguoiDung(MaSinhVienFromFile)) { DanhSach.IdNguoiDung = (from t in db.NguoiDungs where t.UserName == MaSinhVienFromFile select t.IdNguoiDung).ToList().First(); if (KiemTraLaSinhVien(DanhSach.IdNguoiDung)) { if (false == KiemTraDanhSachTrung(DanhSach.IdLopMonHoc, DanhSach.IdNguoiDung)) { db.DanhSaches.Add(DanhSach); db.SaveChanges(); ListDanhSachThanhCong.Add(DanhSach); // Nếu lớp này đã bắt đầu và có buổi điểm danh var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc); if (LopCurrent.BuoiHocs.Count() > 0) { // Thì với mỗi buổi học đã điểm danh, // Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn foreach (var buoihoc in LopCurrent.BuoiHocs) { DiemDanh newDiemDanh = new DiemDanh(); newDiemDanh.IdBuoiHoc = buoihoc.IdBuoiHoc; newDiemDanh.IdNguoiDung = DanhSach.IdNguoiDung; newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép newDiemDanh.NhanXet = "Đăng ký vào lớp muộn"; db.DiemDanhs.Add(newDiemDanh); db.SaveChanges(); } } } else { // sinh viên đã có trong lớp học DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString(); BanGhiThatBai.MoTa = "đã có trong lớp học"; ListDanhSachThatBai.Add(BanGhiThatBai); } } else { // nếu không phải là sinh viên DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString(); BanGhiThatBai.MoTa = "không phải là sinh viên"; ListDanhSachThatBai.Add(BanGhiThatBai); } } else { // nếu người dùng k tồn tại DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString(); BanGhiThatBai.MoTa = "không tồn tại"; ListDanhSachThatBai.Add(BanGhiThatBai); } } } Session["ListDanhSachThanhCong"] = ListDanhSachThanhCong; Session["ListDanhSachThatBai"] = ListDanhSachThatBai; return(RedirectToAction("KetQuaThemVaoDanhSach", new { ListDanhSachThanhCong = ListDanhSachThanhCong, ListDanhSachThatBai = ListDanhSachThatBai })); } else { // Chưa chọn lớp môn học } } } return(View("BrowseDanhSach")); }
// // GET: /YeuCauThamGia/Accept public ActionResult Accept(int id = 0) { LopMonHoc LopMonHocCurrent = (LopMonHoc)Session["LopMonHocCurrent"]; DanhSachController DanhSachCon = new DanhSachController(); YeuCauThamGia yeucauthamgia = db.YeuCauThamGias.Find(id); DanhSach newDanhSach = new DanhSach(); // dummydata newDanhSach.IdLopMonHoc = LopMonHocCurrent.IdLopMonHoc; if (DanhSachCon.KiemTraTonTaiNguoiDung(yeucauthamgia.NguoiDung.UserName)) { newDanhSach.IdNguoiDung = yeucauthamgia.IdNguoiDung; if (DanhSachCon.KiemTraLaSinhVien(yeucauthamgia.IdNguoiDung)) { if (false == DanhSachCon.KiemTraDanhSachTrung(newDanhSach.IdLopMonHoc, newDanhSach.IdNguoiDung)) { db.DanhSaches.Add(newDanhSach); db.SaveChanges(); TempData["Message"] = "Sinh viên '" + yeucauthamgia.NguoiDung.HoTen + "-" + yeucauthamgia.NguoiDung.UserName + "' đã được thêm vào lớp thành công"; // Nếu lớp này đã bắt đầu và có buổi điểm danh var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc); if (LopCurrent.BuoiHocs.Count() > 0) { // Thì với mỗi buổi học đã điểm danh, // Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn foreach (var buoihoc in LopCurrent.BuoiHocs) { DiemDanh newDiemDanh = new DiemDanh(); newDiemDanh.IdBuoiHoc = buoihoc.IdBuoiHoc; newDiemDanh.IdNguoiDung = newDanhSach.IdNguoiDung; newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép newDiemDanh.NhanXet = "Đăng ký vào lớp muộn"; db.DiemDanhs.Add(newDiemDanh); db.SaveChanges(); } } } else { // sinh viên đã có trong lớp học DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName; TempData["Message"] = "Sinh viên " + yeucauthamgia.NguoiDung.HoTen + "-" + yeucauthamgia.NguoiDung.UserName + " đã có trong lớp học"; } } else { // nếu không phải là sinh viên DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName; TempData["Message"] = "Sinh viên " + yeucauthamgia.NguoiDung.HoTen + "-" + yeucauthamgia.NguoiDung.UserName + " không phải là sinh viên"; } } else { // nếu người dùng k tồn tại DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai(); BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName; TempData["Message"] = "Sinh viên " + yeucauthamgia.NguoiDung.HoTen + "-" + yeucauthamgia.NguoiDung.UserName + " không tồn tại"; } db.YeuCauThamGias.Remove(yeucauthamgia); db.SaveChanges(); int YeuCauCount = (from y in db.YeuCauThamGias where y.IdLopMonHoc == LopMonHocCurrent.IdLopMonHoc select y).Count(); Session["YeuCauCount"] = YeuCauCount; return(RedirectToAction("Index")); }