/// <summary>
/// Search phiếu đăng ký dự thi
/// </summary>
/// <param name="name">tên thí sinh dự thi</param>
/// <param name="issuccess">trạng thái phiếu dự thi</param>
/// <returns>List phiếu dự thi</returns>
public List <ThongTinDangKy> SearchPhieuDuThiTheoDK(string name, bool issuccess = false)
{
var result = from pdt in _db.ThongTinDangKies
where pdt.TrangThai == issuccess
select pdt;
if (!string.IsNullOrWhiteSpace(name))
{
var resultHoTen = result.Where(x => x.HoTen.Contains(name));
var t1 = resultHoTen.ToList().Count();
var hotenTemp = RemoveUnicodes.RemoveUnicode(name).ToLower();
var resultGoiY = result.Where(x => x.GoiY.Contains(hotenTemp));
var t2 = resultGoiY.ToList().Count();
//union all
result = resultHoTen.Union(resultGoiY);
//remove dupplicate
result = result.Distinct();
}
return(result.ToList());
}
public JsonResult UploadFile(HttpPostedFileBase file, string name)
{
string fileUpload = "";
try
{
fileUpload = Path.GetFileName(file.FileName);
var temps = fileUpload.Split('.');
var t = RemoveUnicodes.RemoveBlankString(name);
t = RemoveUnicodes.RemoveUnicode(t).ToLower();
temps[0] = t;
//Ten file + DateTime.Now.Ticks.ToString() + duoi file
fileUpload = temps[0] + "_" + DateTime.Now.Ticks.ToString() + "." + temps[1];
string virPath = string.Concat("~", ConfigurationManager.AppSettings["imgFile"]);
var dirPath = System.Web.Hosting.HostingEnvironment.MapPath(virPath);
var pathString = Path.Combine(dirPath, fileUpload);
//check file ton tai
file.SaveAs(pathString);
fileUpload = string.Concat("/img/imagefile/", fileUpload);
}
catch (Exception ex)
{
bs_EventLog.EventLog("up file", "APP - UploadFile", "NghiaBui", ex.Message, ex.StackTrace);
return(null);
}
return(Json(fileUpload, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Cập nhật số báo danh cho phiếu dự thi
/// </summary>
/// <param name="mapdt"></param>
/// <returns></returns>
public bool UpdatePhieuDuThi(int mapdt)
{
try
{
var pdk = GetPhieuDuThiTheoDK(mapdt);
if (string.IsNullOrWhiteSpace(pdk.SBD) && !(bool)pdk.TrangThai)
{
var countPDT = CountPhieuDuThiDuDK();
if (countPDT == -1)
{
return(false);
}
var header = (countPDT + 1).ToString().PadLeft(4, '0');
var payload = RemoveUnicodes.RemoveUnicode(pdk.HoTen);
payload = RemoveUnicodes.SplitUpperString(payload);
var sign = pdk.SoCMND;
pdk.SBD = header + payload + sign;
pdk.TrangThai = true;
}
_db.SaveChanges();
}
catch (Exception e)
{
bs_EventLog.EventLog("Connection", "UpdatePhieuDuThi", "NghiaBui", e.Message, e.StackTrace);
return(false);
}
return(true);
}
public bool TaoDangKiDuThi(crudThongTinDangKi info)
{
info.TrangThai = false;
info.NgayTao = DateTime.Now;
var thongTinDangKy = crudThongTinDangKiMapper.MapcrudThongTinDKThongTinDK(info);
thongTinDangKy.GoiY = RemoveUnicodes.RemoveUnicode(thongTinDangKy.HoTen).ToLower();
bs_DangKiThi action = new bs_DangKiThi();
var result = action.CreatePhieuDuThi(thongTinDangKy);
if (result)
{
return(true);
}
return(false);
}
