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