public ActionResult Register(ThiSinh entity)
{
if (ModelState.IsValid)
{
var dao = new ThiSinhData();
var user = new ThiSinh();
user.GioiTinh = entity.GioiTinh;
user.NgaySinh = entity.NgaySinh;
user.DiaChi = entity.DiaChi;
user.Image = entity.Image;
user.Password = entity.Password;
tn.SaveChanges();
if (dao.Insert(user) > 0)
{
ViewBag.Success = "Đăng ký thành công!";
entity = new ThiSinh();
}
else
{
ModelState.AddModelError("", "Đăng ký không thành công!");
}
}
return(RedirectToAction("Index", "Login"));
}
public ActionResult Delete(int id, ThiSinh collection)
{
try
{
// TODO: Add delete logic here
if (ModelState.IsValid)
{
var ts = new ThiSinhData();
var res = ts.Delete(id);
if (res)
{
return(RedirectToAction("Index", "ThiSinh"));
}
else
{
ModelState.AddModelError("", "Xóa thất bại");
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(ThiSinh collection)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
byte[] imageData = null;
HttpPostedFileBase poImgFile = Request.Files["fileim"];
if (poImgFile != null && poImgFile.ContentLength > 0)
{
using (var binary = new BinaryReader(poImgFile.InputStream))
{
imageData = binary.ReadBytes(poImgFile.ContentLength);
}
}
collection.Image = imageData;
var ts = new ThiSinhData();
int id = ts.Insert(collection);
if (id > 0)
{
return(RedirectToAction("Index", "ThiSinh"));
}
else
{
ModelState.AddModelError("", "Thêm thất bại");
}
}
return(View(collection));
}
catch
{
return(View());
}
}
public ActionResult DangNhap(FormCollection collection)
{
var tendn = collection["username"];
var matkhau = collection["password"];
if (String.IsNullOrEmpty(tendn))
{
ViewData["Loi1"] = "Phải nhập tên đăng nhập";
}
else if (String.IsNullOrEmpty(matkhau))
{
ViewData["Loi2"] = "Phải nhập mật khẩu";
}
else
{
ThiSinh ts = db.ThiSinhs.SingleOrDefault(n => n.IDLogin == tendn && n.Pass == matkhau);
if (ts != null)
{
ViewBag.Thongbao = "Chúc mừng đăng nhập thành công";
Session["Taikhoan"] = ts;
Session["TenDangNhap"] = tendn;
return(RedirectToAction("Index", "QLCTTHTH"));
}
else
{
ViewBag.Thongbao = "Tên đăng nhập hoặc mật khẩu không đúng";
}
}
return(View());
}
public ActionResult Create(ThiSinh ts, HttpPostedFileBase fileupload)
{
if (fileupload == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh đại diện";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/Images"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.Thongbao = "Hình đại diện đã tồn tại";
}
else
{
fileupload.SaveAs(path);
}
ts.HinhTS = fileName;
db.ThiSinhs.InsertOnSubmit(ts);
db.SubmitChanges();
}
return(RedirectToAction("TS"));
}
}
public async Task <ThiSinh> UpdateThiSinh(ThiSinh thiSinh)
{
_context.ThiSinhContext.Update(thiSinh);
await _context.SaveChangesAsync();
return(thiSinh);
}
public ActionResult DeleteConfirmed(int id)
{
ThiSinh thiSinh = db.ThiSinhs.Find(id);
db.ThiSinhs.Remove(thiSinh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ThiSinh> CreateThiSinh(ThiSinh thiSinh)
{
await _context.ThiSinhContext.AddAsync(thiSinh);
await _context.SaveChangesAsync();
return(thiSinh);
}
public int DeleteThiSinh(ThiSinh pThiSinh)
{
var ThiSinh = Context.ThiSinhs.FirstOrDefault(p => p.MSSV == pThiSinh.MSSV);
Context.ThiSinhs.Remove(ThiSinh);
return(Context.SaveChanges());
}
public ThamGiaCaThiResponse(CaThi caThi, ThiSinh thiSinh)
{
Id = caThi.Id;
TenCaThi = caThi.TenCaThi;
ThoiGianBatDau = caThi.ThoiGianBatDau;
ThoiGianThi = caThi.ThoiGianThi;
TrangThai = caThi.TrangThai;
TrangThaiThi = thiSinh.TrangThaiThi;
}
public ActionResult Edit([Bind(Include = "MaTS,HoTenTS,NamSinhTS,GT,DiaChiTS,QueQuanTS,HinhTS,NopPhi")] ThiSinh thiSinh)
{
if (ModelState.IsValid)
{
db.Entry(thiSinh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thiSinh));
}
public ThiSinhResponse(SinhVien sinhVien, ThiSinh thiSinh)
{
Id = sinhVien.Id;
HoTen = sinhVien.HoTen;
MSSV = sinhVien.MSSV;
TenMay = thiSinh.TenMay;
SoLanDangNhap = thiSinh.SoLanDangNhap;
DiaChiIp = thiSinh.DiaChiIp;
TrangThaiThi = thiSinh.TrangThaiThi;
}
public ActionResult Create([Bind(Include = "MaTS,HoTenTS,NamSinhTS,GT,DiaChiTS,QueQuanTS,HinhTS,NopPhi")] ThiSinh thiSinh)
{
if (ModelState.IsValid)
{
db.ThiSinhs.Add(thiSinh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thiSinh));
}
public ActionResult Edit(int id)
{
ThiSinh ts = db.ThiSinhs.SingleOrDefault(n => n.MaTS == id);
if (ts == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ts));
}
public ActionResult Edit(int id, ThiSinh collection)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
byte[] imageData = null;
HttpPostedFileBase poImgFile = Request.Files["fileim"];
if (poImgFile != null && poImgFile.ContentLength > 0)
{
using (var binary = new BinaryReader(poImgFile.InputStream))
{
imageData = binary.ReadBytes(poImgFile.ContentLength);
}
collection.Image = imageData;
var ts = new ThiSinhData();
var res = ts.Update(collection);
if (res)
{
//return RedirectToAction("Details", "Profile");
return(RedirectToAction("Details", "Profile", new { area = "Contest", id = id }));
}
else
{
ModelState.AddModelError("", "Sửa thất bại");
}
}
else
{
byte[] tana = tn.ThiSinhs.Where(x => x.MaThiSinh == id).Select(u => u.Image).SingleOrDefault();
collection.Image = tana;
var ts = new ThiSinhData();
var res = ts.Update(collection);
if (res)
{
return(RedirectToAction("Details", "Profile", new { area = "Contest", id = id }));
}
else
{
ModelState.AddModelError("", "Sửa thất bại");
}
}
}
//return RedirectToAction("Index");
return(RedirectToAction("Details", "Profile", new { area = "Contest", id = id }));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirm(int id)
{
ThiSinh ts = db.ThiSinhs.SingleOrDefault(n => n.MaTS == id);
ViewBag.MaTS = ts.MaTS;
if (ts == null)
{
Response.StatusCode = 404;
return(null);
}
db.ThiSinhs.DeleteOnSubmit(ts);
db.SubmitChanges();
return(RedirectToAction("TS"));
}
// GET: ThiSinhs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ThiSinh thiSinh = db.ThiSinhs.Find(id);
if (thiSinh == null)
{
return(HttpNotFound());
}
return(View(thiSinh));
}
public ActionResult Dangky(FormCollection collection, ThiSinh ts)
{
var hoten = collection["HoTenTS"];
var idlogin = collection["IDLogin"];
var matkhau = collection["Pass"];
string gioitinh = collection["GT"];
var diachi = collection["DiachiTS"];
var quequan = collection["QueQuanTS"];
var ngaysinh = String.Format("{0:MM/dd/yyyy}", collection["NamSinhTS"]);
if (String.IsNullOrEmpty(idlogin))
{
ViewData["Loi1"] = "Phải nhập ID";
}
else if (String.IsNullOrEmpty(gioitinh))
{
ViewData["Loi2"] = "Phải nhập giới tính ";
}
else if (String.IsNullOrEmpty(matkhau))
{
ViewData["Loi3"] = "Phải nhập mật khẩu";
}
else if (String.IsNullOrEmpty(quequan))
{
ViewData["Loi4"] = "Phải nhập quê quán";
}
else if (String.IsNullOrEmpty(hoten))
{
ViewData["Loi5"] = "Phải nhập tên ";
}
else
{
ts.HoTenTS = hoten;
ts.GT = gioitinh;
ts.DiaChiTS = diachi;
ts.QueQuanTS = quequan;
//ts.NamSinhTS = DateTime.Parse(ngaysinh);
ts.IDLogin = idlogin;
ts.Pass = matkhau;
db.ThiSinhs.InsertOnSubmit(ts);
db.SubmitChanges();
return(RedirectToAction("Dangnhap"));
}
return(this.Dangky());
}
public ActionResult Edit(ThiSinh ts, HttpPostedFileBase fileupload)
{
var t = db.ThiSinhs.SingleOrDefault(n => n.MaTS == ts.MaTS);
if (ModelState.IsValid)
{
t.HoTenTS = ts.HoTenTS;
t.NamSinhTS = ts.NamSinhTS;
t.GT = ts.GT;
t.DiaChiTS = ts.DiaChiTS;
t.QueQuanTS = ts.QueQuanTS;
t.HinhTS = ts.HinhTS;
t.NopPhi = ts.NopPhi;
db.SubmitChanges();
}
return(RedirectToAction("TS"));
}
public int SaveThiSinh(ThiSinh pThiSinh)
{
var ThiSinh = Context.ThiSinhs.FirstOrDefault(p => p.MSSV == pThiSinh.MSSV);
if (ThiSinh == null)
{
ThiSinh = new ThiSinh();
Context.ThiSinhs.Add(ThiSinh);
}
ThiSinh.MSSV = pThiSinh.MSSV;
ThiSinh.HoDem = pThiSinh.HoDem;
ThiSinh.Ten = pThiSinh.Ten;
ThiSinh.GIoiTinh = pThiSinh.GIoiTinh;
ThiSinh.NgaySinh = pThiSinh.NgaySinh;
return(Context.SaveChanges());
}
private void ProcessBaiTuLuan()
{
string idPhongCaNgay = Request["IDPhongCaNgay"]?.ToString();
string idKiThi = Request["IDKiThi"]?.ToString();
string loaiDe = Convert.ToInt32(LoaiDe.TuLuan).ToString();
#region lay thong tin phong thi, ca thi, ngay thi
string sql = $@"SELECT pc.*, convert(varchar, pc.Ngaythi, 103) as NgayThiFormatted, p.TenPhong as PhongThi, c.TenCa as CaThi
from [NuceThi_PhongThi_CaThi] pc
left join [Nuce_thi_chung_chi].[dbo].[NuceThi_PhongThi] p on pc.phongthiid = p.id
left join [Nuce_thi_chung_chi].[dbo].[NuceThi_CaThi] c on pc.cathiid = c.id
where pc.id = {idPhongCaNgay}";
DataTable dt = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(Nuce_ThiChungChi.ConnectionString, CommandType.Text, sql).Tables[0];
string NgayThi = dt.Rows[0]["NgayThiFormatted"]?.ToString();
string PhongThi = dt.Rows[0]["PhongThi"]?.ToString();
string CaThi = dt.Rows[0]["CaThi"]?.ToString();
#endregion
sql = $@"SELECT nt.ma, nt.Ho + ' ' + nt.Ten as HoTen, nt.CMT, nt.NoiSinh, convert(varchar, nt.ngaysinh, 103) as NgaySinh, nt.Mobile,
kls.made, kls.bailam, kls.KiThi_LopHoc_SinhVienID
FROM [Nuce_thi_chung_chi].[dbo].[NuceThi_KiThi_LopHoc_SinhVien] kls
left join Nuce_thichungchi_nguoithi nt on kls.sinhvienid = nt.id
left join nucethi_kithi kt on kt.KiThiID = kls.KiThi_LopHocID
left join nucethi_bode bd on kt.BoDeID = bd.BoDeID
where kls.phongthi_cathi_id = {idPhongCaNgay} and kls.[KiThi_LopHocID] = {idKiThi} and bd.LoaiDe = {loaiDe}";
dt = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(Nuce_ThiChungChi.ConnectionString, CommandType.Text, sql).Tables[0];
if (dt.Rows.Count == 0)
{
Response.ContentType = "text/plain";
Response.Write("Không có thí sinh nào.");
return;
}
string UploadsFolder = ConfigurationManager.AppSettings["UploadsFolder"];
List <string> dirs = new List <string>();
Dictionary <string, string> ThiSinhMaDe = new Dictionary <string, string>();
Dictionary <string, string> ThiSinhHash = new Dictionary <string, string>();
Dictionary <string, string> ThiSinhMaBaiLam = new Dictionary <string, string>();
Dictionary <string, ThiSinh> ThiSinhInfo = new Dictionary <string, ThiSinh>();
// Bai Lam
for (int i = 0; i < dt.Rows.Count; i++)
{
var row = dt.Rows[i];
string MaThiSinh = row["ma"]?.ToString();
string MaDe = row["made"]?.ToString();
string BaiLam = row["bailam"]?.ToString();
string MaBaiLam = row["KiThi_LopHoc_SinhVienID"]?.ToString();
string HoTen = row["HoTen"]?.ToString();
string NgaySinh = row["NgaySinh"]?.ToString();
string NoiSinh = row["NoiSinh"]?.ToString();
string Mobile = row["Mobile"]?.ToString();
string Cmt = row["CMT"]?.ToString();
var tmpThiSinh = new ThiSinh()
{
Ma = MaThiSinh,
HoTen = HoTen,
NgaySinh = NgaySinh,
NoiSinh = NoiSinh,
CMT = Cmt,
Mobile = Mobile,
};
if (!string.IsNullOrEmpty(BaiLam))
{
BaiLam = Path.Combine(UploadsFolder, BaiLam);
dirs.Add(BaiLam);
}
ThiSinhMaDe.Add(MaThiSinh, MaDe);
ThiSinhMaBaiLam.Add(MaThiSinh, MaBaiLam);
ThiSinhInfo.Add(MaThiSinh, tmpThiSinh);
}
// File Thi sinh ma de
string DanhSachMaDeThiSinhFileName = Path.Combine(UploadsFolder, $"DanhSachThiSinhMaDe-{Guid.NewGuid()}.xlsx");
string CryptKey = ConfigurationManager.AppSettings["CryptKey"];
using (XLWorkbook wb = new XLWorkbook())
{
IXLWorksheet ws = wb.Worksheets.Add("DanhSachThiSinhMaDe");
ws.Cell(1, 1).Value = "Mã";
ws.Cell(1, 2).Value = "Mã đề";
int i = 1;
foreach (var item in ThiSinhMaDe)
{
i++;
string MaBaiLam = ThiSinhMaBaiLam[item.Key];
var cryptCode = StringCipher.Encrypt(MaBaiLam, CryptKey);
ws.Cell(i, 1).Value = cryptCode;
ws.Cell(i, 2).Value = item.Value;
ThiSinhHash.Add(item.Key, cryptCode);
}
wb.SaveAs(DanhSachMaDeThiSinhFileName);
}
dirs.Add(DanhSachMaDeThiSinhFileName);
// File Thi sinh mã hoá
string DanhSachThiSinhFileName = Path.Combine(UploadsFolder, $"MaHoa-{Guid.NewGuid()}.xlsx");
using (XLWorkbook wb = new XLWorkbook())
{
IXLWorksheet ws = wb.Worksheets.Add("MaHoa");
ws.Cell(1, 1).Value = "Mã";
ws.Cell(1, 2).Value = "Mã đề";
ws.Cell(1, 3).Value = "Mã thí sinh";
ws.Cell(1, 4).Value = "Họ tên";
ws.Cell(1, 5).Value = "Ngày sinh";
ws.Cell(1, 6).Value = "Nơi sinh";
ws.Cell(1, 7).Value = "CMND";
ws.Cell(1, 8).Value = "SĐT";
ws.Cell(1, 9).Value = "Điểm";
int i = 1;
foreach (var item in ThiSinhHash)
{
i++;
string made = ThiSinhMaDe[item.Key];
ws.Cell(i, 1).Value = item.Value;
ws.Cell(i, 2).Value = made;
ws.Cell(i, 2).SetDataType(XLCellValues.Text);
ws.Cell(i, 3).Value = $"'{item.Key}";
ws.Cell(i, 4).Value = ThiSinhInfo[item.Key].HoTen;
ws.Cell(i, 5).Value = ThiSinhInfo[item.Key].NgaySinh;
ws.Cell(i, 6).Value = ThiSinhInfo[item.Key].NoiSinh;
ws.Cell(i, 7).Value = ThiSinhInfo[item.Key].CMT;
ws.Cell(i, 8).Value = ThiSinhInfo[item.Key].Mobile;
}
wb.SaveAs(DanhSachThiSinhFileName);
}
dirs.Add(DanhSachThiSinhFileName);
// zip
string zipname = Path.Combine(UploadsFolder, $"{Guid.NewGuid()}.zip");
try
{
using (ZipFile zipFile = new ZipFile())
{
zipFile.AddFiles(dirs, false, "");
zipFile.Save(zipname);
}
}
catch (Exception ex)
{
Response.ContentType = "text/plain";
Response.Write(ex.Message + "\n " + String.Join(",", dirs));
return;
}
Response.Clear();
Response.Buffer = true;
//Response.ContentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
Response.AddHeader("content-disposition", $"attachment; filename={PhongThi}-{CaThi}-{NgayThi}.zip");
Response.WriteFile(zipname);
Response.Flush();
Response.Close();
File.Delete(zipname);
File.Delete(DanhSachThiSinhFileName);
File.Delete(DanhSachMaDeThiSinhFileName);
}
public async Task <Response <CaThiResponse> > TaoCaThi(long idHocPhan, TaoCaThiRequest request)
{
var hocPhan = await _hocPhanRepo.GetHocPhanById(idHocPhan);
if (hocPhan == null)
{
return new Response <CaThiResponse>
{
StatusCode = 400,
Success = false,
Errors = new[] { "Không tìm thấy học phần" }
}
}
;
var caThi = new CaThi
{
TenCaThi = request.TenCaThi,
ThoiGianBatDau = request.ThoiGianBatDau,
ThoiGianThi = request.ThoiGianThi,
TrangThai = TrangThaiCaThi.ChuaBatDau,
IdHocPhan = idHocPhan,
IdLopHoc = request.IdLopHoc,
IdGiamThi = request.IdGiamThi,
IdDeThi = request.IdDeThi
};
var newCaThi = await _caThiRepo.CreateCaThi(caThi);
var lopHoc = await _lopHocRepo.GetLopHocById(newCaThi.IdLopHoc);
var deThi = await _deThiRepo.GetDeThiById(newCaThi.IdDeThi);
var dsIdCauHoi = _deThiRepo.GetDsIdCauHoi(deThi.Id);
var dsCauHoi = await _cauHoiRepo.GetMultipleCauHoiById(dsIdCauHoi);
var deThiResponse = new DeThiResponse(deThi, dsCauHoi);
var giamThi = await _taiKhoanRepo.GetTaiKhoanById(newCaThi.IdGiamThi);
var caThiResponse = new CaThiResponse(newCaThi, lopHoc, deThiResponse, giamThi);
var dsSinhVien = _sinhVienRepo.GetAllInLopHoc(lopHoc.Id);
foreach (var sinhVien in dsSinhVien)
{
var thiSinh = new ThiSinh
{
IdCaThi = newCaThi.Id,
IdSinhVien = sinhVien.Id,
SoLanDangNhap = 0,
TenMay = null,
DiaChiIp = null,
TrangThaiThi = TrangThaiThi.ChuaThi
};
await _thiSinhRepo.CreateThiSinh(thiSinh);
}
return(new Response <CaThiResponse>
{
StatusCode = 201,
Success = true,
Data = caThiResponse
});
}
}
public bool CheckExistThiSinh(ThiSinh pThiSinh)
{
return(Context.ThiSinhs.Any(p => p.MSSV == pThiSinh.MSSV));
}
public async Task DeleteThiSinh(ThiSinh thiSinh)
{
_context.ThiSinhContext.Remove(thiSinh);
await _context.SaveChangesAsync();
}
