protected void Page_Load(object sender, EventArgs e)
{
try
{
string currentPageFileName = new FileInfo(this.Request.Url.AbsolutePath).Name;
var PermMgr = new PermissionManager(Session);
if (PermMgr.IsAdmin || PermMgr.CanManageTestBatches)
{
string alink = Request["z"];
if (!string.IsNullOrEmpty(alink))
{
var candBatch = _db.T_Batch.FirstOrDefault(s => s.Id == long.Parse(alink));
var bs = _db.T_BatchSet.Where(s => s.BatchId == candBatch.Id);
var candNo = bs.Count();
var res = bs.Select(a => new ViewBatchResultsGridModel
{
ID = (long)a.CandidateId,
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString(),
FirstName = ErecruitHelper.getCandidateFirstName((long)a.CandidateId).ToString(),
LastName = ErecruitHelper.getCandidateLastName((long)a.CandidateId).ToString(),
Score = a.TestScore == null ? "Not Attempted" : a.TestScore + "%",
DateOfBirth = ErecruitHelper.getCandidateDOB((long)a.CandidateId).ToString(),
Sex = ErecruitHelper.getCandidateSex((long)a.CandidateId).ToString(),
Passport = ErecruitHelper.getCandidateImgUrl((long)a.CandidateId).ToString(),
Alt = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString()
});
bname.InnerHtml = candBatch.Name;
NoCands.InnerHtml = candNo.ToString();
dateTaken.InnerHtml = ErecruitHelper.GetDateStringFromDate((DateTime)candBatch.StartDate);
BatchScoreList.DataSource = res.ToList();
BatchScoreList.DataBind();
}
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
public List<TestReportModel> TestReport(string dateFrom, string dateTo)
{
var TR = new List<TestReportModel>();
QuizBookDbEntities1 _db = new QuizBookDbEntities1();
if (!string.IsNullOrEmpty(dateFrom) && !string.IsNullOrEmpty(dateTo))
{
var f = ErecruitHelper.GetCurrentDateFromDateString(dateFrom);
var t = ErecruitHelper.GetCurrentDateFromDateString(dateTo);
var tr = _db.T_CTestTracker.Where(s => s.CurrentStartTime.Value.Date >= f.Date && s.CurrentStartTime.Value.Date <= t.Date).OrderByDescending(s => s.CurrentStartTime).Select(s => s.BatchId).Distinct();
var bs = _db.T_BatchSet.Where(s => tr.Contains(s.BatchId)).ToList();
TR = bs.Select(a => new TestReportModel
{
ID = (long)a.CandidateId,
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString(),
FirstName = ErecruitHelper.getCandidateFirstName((long)a.CandidateId).ToString(),
LastName = ErecruitHelper.getCandidateLastName((long)a.CandidateId).ToString(),
Qualification = ErecruitHelper.getCandidate((long)a.CandidateId).Degree,
Grade = ErecruitHelper.getCandidate((long)a.CandidateId).ClassOfDegree,
Contact = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
Refferal = ErecruitHelper.getCandidate((long)a.CandidateId).Referer,
from =ErecruitHelper.GetDateStringFromDateX(f),
to = ErecruitHelper.GetDateStringFromDateX(t),
Email = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
TestDate = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getTracker(a.CandidateId.Value,a.BatchId.Value).CurrentStartTime.Value),
Score = a.TestScore == null ? "Not Attempted" : a.TestScore + "%",
Age = (DateTime.Now.Year - (ErecruitHelper.getCandidateDobx((long)a.CandidateId) != null ? ErecruitHelper.getCandidateDobx((long)a.CandidateId).Value.Year: 0)).ToString(),
DateOfBirth = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getCandidate((long)a.CandidateId).DateOfBirth.Value),
Sex = ErecruitHelper.getCandidateSex((long)a.CandidateId).ToString(),
Passport = ErecruitHelper.getCandidateImgUrl((long)a.CandidateId).ToString(),
Alt = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString()
}).ToList();
}
else if (string.IsNullOrEmpty(dateFrom) && !string.IsNullOrEmpty(dateTo))
{
var f = DateTime.Now;
var t = ErecruitHelper.GetCurrentDateFromDateString(dateTo);
var tr = _db.T_CTestTracker.Where(s => s.CurrentStartTime.Value.Date >= f.Date && s.CurrentStartTime.Value.Date <= t.Date).OrderByDescending(s => s.CurrentStartTime).Select(s => s.BatchId).Distinct();
var bs = _db.T_BatchSet.Where(s => tr.Contains(s.BatchId)).ToList();
TR = bs.Select(a => new TestReportModel
{
ID = (long)a.CandidateId,
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString(),
FirstName = ErecruitHelper.getCandidateFirstName((long)a.CandidateId).ToString(),
LastName = ErecruitHelper.getCandidateLastName((long)a.CandidateId).ToString(),
Qualification = ErecruitHelper.getCandidate((long)a.CandidateId).Degree,
Grade = ErecruitHelper.getCandidate((long)a.CandidateId).ClassOfDegree,
Contact = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
Refferal = ErecruitHelper.getCandidate((long)a.CandidateId).Referer,
Email = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
from = ErecruitHelper.GetDateStringFromDateX(f),
to = ErecruitHelper.GetDateStringFromDateX(t),
TestDate = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getTracker(a.CandidateId.Value, a.BatchId.Value).CurrentStartTime.Value),
Score = a.TestScore == null ? "Not Attempted" : a.TestScore + "%",
Age = (DateTime.Now.Year - (ErecruitHelper.getCandidateDobx((long)a.CandidateId) != null ? ErecruitHelper.getCandidateDobx((long)a.CandidateId).Value.Year : 0)).ToString(),
DateOfBirth = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getCandidate((long)a.CandidateId).DateOfBirth.Value),
Sex = ErecruitHelper.getCandidateSex((long)a.CandidateId).ToString(),
Passport = ErecruitHelper.getCandidateImgUrl((long)a.CandidateId).ToString(),
Alt = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString()
}).ToList();
}
else if (!string.IsNullOrEmpty(dateFrom) && string.IsNullOrEmpty(dateTo))
{
var f = ErecruitHelper.GetCurrentDateFromDateString(dateFrom);
var t = DateTime.Now;
var tr = _db.T_CTestTracker.Where(s => s.CurrentStartTime.Value.Date >= f.Date && s.CurrentStartTime.Value.Date <= t.Date).OrderByDescending(s => s.CurrentStartTime).Select(s => s.BatchId).Distinct();
var bs = _db.T_BatchSet.Where(s => tr.Contains(s.BatchId)).ToList();
TR = bs.Select(a => new TestReportModel
{
ID = (long)a.CandidateId,
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString(),
FirstName = ErecruitHelper.getCandidateFirstName((long)a.CandidateId).ToString(),
LastName = ErecruitHelper.getCandidateLastName((long)a.CandidateId).ToString(),
Qualification = ErecruitHelper.getCandidate((long)a.CandidateId).Degree,
Grade = ErecruitHelper.getCandidate((long)a.CandidateId).ClassOfDegree,
Contact = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
Refferal = ErecruitHelper.getCandidate((long)a.CandidateId).Referer,
Email = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
from = ErecruitHelper.GetDateStringFromDateX(f),
to = ErecruitHelper.GetDateStringFromDateX(t),
TestDate = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getTracker(a.CandidateId.Value, a.BatchId.Value).CurrentStartTime.Value),
Score = a.TestScore == null ? "Not Attempted" : a.TestScore + "%",
Age = (DateTime.Now.Year - (ErecruitHelper.getCandidateDobx((long)a.CandidateId) != null ? ErecruitHelper.getCandidateDobx((long)a.CandidateId).Value.Year : 0)).ToString(),
DateOfBirth = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getCandidate((long)a.CandidateId).DateOfBirth.Value),
Sex = ErecruitHelper.getCandidateSex((long)a.CandidateId).ToString(),
Passport = ErecruitHelper.getCandidateImgUrl((long)a.CandidateId).ToString(),
Alt = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString()
}).ToList();
}
else
{
var f = DateTime.Now;
var tr = _db.T_CTestTracker.Where(s => s.CurrentStartTime.Value.Date == f.Date).OrderByDescending(s=>s.CurrentStartTime).Select(s => s.BatchId).Distinct();
var bs = _db.T_BatchSet.Where(s => tr.Contains(s.BatchId)).ToList();
TR = bs.Select(a => new TestReportModel
{
ID = (long)a.CandidateId,
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString(),
FirstName = ErecruitHelper.getCandidateFirstName((long)a.CandidateId).ToString(),
LastName = ErecruitHelper.getCandidateLastName((long)a.CandidateId).ToString(),
Qualification = ErecruitHelper.getCandidate((long)a.CandidateId).Degree,
Grade = ErecruitHelper.getCandidate((long)a.CandidateId).ClassOfDegree,
Contact = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
Refferal = ErecruitHelper.getCandidate((long)a.CandidateId).Referer,
Email = ErecruitHelper.getCandidate((long)a.CandidateId).Email,
from = ErecruitHelper.GetDateStringFromDateX(f),
TestDate = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getTracker(a.CandidateId.Value, a.BatchId.Value).CurrentStartTime.Value),
Score = a.TestScore == null ? "Not Attempted" : a.TestScore + "%",
Age = (DateTime.Now.Year - (ErecruitHelper.getCandidateDobx((long)a.CandidateId) != null ? ErecruitHelper.getCandidateDobx((long)a.CandidateId).Value.Year : 0)).ToString(),
DateOfBirth = ErecruitHelper.GetDateStringFromDateX(ErecruitHelper.getCandidate((long)a.CandidateId).DateOfBirth.Value),
Sex = ErecruitHelper.getCandidateSex((long)a.CandidateId).ToString(),
Passport = ErecruitHelper.getCandidateImgUrl((long)a.CandidateId).ToString(),
Alt = ErecruitHelper.getCandidateCode((long)a.CandidateId).ToString()
}).ToList();
}
return TR;
}