//sua phong tho internal void UpDatePhongThi(Phong_Thi classRoom) { // classRoom.ThoiGianDong = classRoom.ThoiGianMo.AddMinutes(double.Parse(classRoom.Bo_De.ThoiGianThi)); var Room = db.Phong_Thi.Find(classRoom.MaPhong); Room.MaBoDe = classRoom.MaBoDe; Room.TrangThai = classRoom.TrangThai; Room.Xoa = classRoom.Xoa; Room.ThoiGianMo = classRoom.ThoiGianMo; Room.ThoiGianDong = classRoom.ThoiGianDong; db.SaveChanges(); db = new TracNghiemOnlineDB(); var ds = db.DS_SVThi.Where(x => x.MaPhong == classRoom.MaPhong).ToList(); foreach (var item in ds) { if (item.MaDeThi == null) { var list = new BoDeDao().ChapterStudy(long.Parse(classRoom.MaBoDe.ToString())); var dethi = new BoDeDao().MixExemQuestion(list, item.Ma_SV); new BoDeDao().UpdateDsThi(classRoom, dethi, item.Ma_SV, "Chưa Làm"); } } }
internal void CreateExamitionRoom(string malop, string id, List <DS_SVThi> dSSV, string nd) { try { Phong_Thi phong_Thi = new Phong_Thi(); phong_Thi.TrangThai = "Chưa Thi"; phong_Thi.MaLopHP = malop; phong_Thi.NguoiTao = id; phong_Thi.TenPhong = nd; phong_Thi.Xoa = true; while (true) { phong_Thi.MaPhong = RandomString(10); if (!db.Phong_Thi.ToList().Exists(x => x.MaPhong.Equals(phong_Thi.MaPhong))) { break; } } db.Phong_Thi.Add(phong_Thi); db.SaveChanges(); CreateSinhVienRoom(phong_Thi.MaPhong, dSSV); } catch (Exception e) { } }
internal void UpdateDsThi(Phong_Thi phong, De_Thi deThi, string Masv, string trangthai) { var dSSV = db.DS_SVThi.SingleOrDefault(x => x.MaPhong == phong.MaPhong && x.Ma_SV.Equals(Masv)); dSSV.MaDeThi = deThi.MaDeThi; dSSV.TrangThai = trangthai; db.SaveChanges(); }
internal void UpDatePhongThi1(Phong_Thi classRoom) { var Room = db.Phong_Thi.Find(classRoom.MaPhong); Room.MaBoDe = classRoom.MaBoDe; Room.TrangThai = classRoom.TrangThai; Room.Xoa = classRoom.Xoa; db.SaveChanges(); }
//them hoi phong hoc internal void CreateExamitionRoom(string malop, string id, List <DS_SVThi> dSSV, string nd, string GV, string GV1, DateTime date) { try { db = new TracNghiemOnlineDB(); Phong_Thi phong_Thi = new Phong_Thi(); phong_Thi.TrangThai = "Chưa Thi"; phong_Thi.MaLopHP = malop; phong_Thi.NguoiTao = id; phong_Thi.TenPhong = nd; phong_Thi.MaCanBo1 = GV; phong_Thi.MaCanBo2 = GV1; phong_Thi.ThoiGianMo = date; phong_Thi.Xoa = true; while (true) { phong_Thi.MaPhong = RandomString(10); if (!db.Phong_Thi.ToList().Exists(x => x.MaPhong.Equals(phong_Thi.MaPhong))) { break; } } db.Phong_Thi.Add(phong_Thi); db.SaveChanges(); CreateSinhVienRoom(phong_Thi.MaPhong, dSSV); phong_Thi.LopHocPhan = new TracNghiemOnlineDB().LopHocPhans.Find(phong_Thi.MaLopHP); try { string content = "<p> Tên phòng thi: " + phong_Thi.TenPhong + "</p><p>Lớp học phần" + phong_Thi.LopHocPhan.TenLop + "</p><p> Thời gian mở: " + phong_Thi.ThoiGianMo + "</p> </br> <a class='btn btn-success' href =http://truongutc2.tk/ >Truy Cập Vào WebSite</a>"; var mail1 = new TracNghiemOnlineDB().GiaoViens.Where(x => x.MaGV.Equals(phong_Thi.MaCanBo1)).FirstOrDefault(); var mail2 = new TracNghiemOnlineDB().GiaoViens.Where(x => x.MaGV.Equals(phong_Thi.MaCanBo2)).FirstOrDefault(); if (mail1.Email != null) { SendEmail(mail1.Email, "Phân công coi thi kỳ thi " + phong_Thi.LopHocPhan.KiThi.TenKi, content); } if (mail2.Email != null) { SendEmail(mail2.Email, "Phân công coi thi kỳ thi " + phong_Thi.LopHocPhan.KiThi.TenKi, content); } } catch { } } catch (Exception e) { } }
//tim kiem bai thi sv internal De_Thi SeachForTheExam(Phong_Thi phong, string Masv) { var DSSV = db.DS_SVThi.SingleOrDefault(x => x.MaPhong == phong.MaPhong && x.Ma_SV == Masv); return(SearDethi(DSSV.MaDeThi)); }