protected void Page_Load(object sender, EventArgs e)
{
try
{
var candId = SessionHelper.FetchCandidateId(Session);
var tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == long.Parse(candId));
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == tracker.CandidateCode);
var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
var candBatch = _db.T_Batch.FirstOrDefault(s => b_id.Contains(s.Id) && s.IsActive.Value);
//string path = Path.Combine("~/Passports/", "no-pic-avatar.jpg");
//Image1.ImageUrl = !(string.IsNullOrEmpty(cand.Passport)) ? cand.Passport : path;
//string st = cand.Code + " - " + cand.FirstName + " " + cand.LastName;
//CandName.Text = st;
var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
if (cand != null && candBatch != null)
{
var bs = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
ccode.InnerHtml = cand.Code;
CGender.InnerHtml = cand.Sex;
Surname.InnerHtml = cand.LastName;
COthernames.InnerHtml = cand.FirstName + " " + cand.MiddleName + " " + cand.MaidenName;
CDob.InnerHtml = ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Day) + "/" + ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Month) + "/" + cand.DateOfBirth.Value.Year;
cgrade.InnerHtml = bs.TestScore + "%";
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
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.CanWorkWithCandidates || PermMgr.CanApprove)
{
if (!IsPostBack)
{
string code = Request["z"];
if (!string.IsNullOrEmpty(code))
{
var cand = _db.T_Candidate.FirstOrDefault(s => s.Id.ToString() == code);
if (cand != null)
{
candId.Value = cand.Id.ToString();
Label1.Text = cand.Code;
Label2.Text = cand.LastName;
Label3.Text = cand.FirstName + " " + cand.MiddleName + " " + cand.MaidenName;
Label4.Text = cand.Sex;
Label5.Text = ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Day) + "/" + ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Month) + "/" + cand.DateOfBirth.Value.Year;
Label6.Text = cand.Degree;
Label10.Text = cand.ClassOfDegree;
Label11.Text = cand.Course;
Label12.Text = cand.Referer;
Label13.Text = cand.Email;
Label14.Text = cand.ApprovalStatus;
Comment.Text = cand.Comment;
string path = Path.Combine("~/Passports/", "no-pic-avatar.jpg");
Image1.ImageUrl = !(string.IsNullOrEmpty(cand.Passport)) ? cand.Passport : path;
Image1.DataBind();
var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
var candBatch = _db.T_Batch.FirstOrDefault(s => b_id.Contains(s.Id) && s.IsActive.Value);
if (candBatch != null)
{
var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
if (cbSet != null)
{
Label7.Text = string.IsNullOrEmpty(cbSet.TestScore)?"Not Taken":cbSet.TestScore + "%";
Label8.Text = cbSet.Essay == true ? "Taken" : "Not Taken";
Label9.Text = cbSet.Psychometric == true ? "Taken" : "Not Taken";
}
}
}
else
{
ErecruitHelper.SetErrorData(new NullReferenceException(), Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
else
{
ErecruitHelper.SetErrorData(new NullReferenceException(), Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
}
else
{
Response.Redirect("NoPermission.aspx", false);
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void check_Click(object sender, EventArgs e)
{
try
{
var code = Code.Text;
if (!string.IsNullOrEmpty(code))
{
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
if (cand != null)
{
var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
var candBatch = _db.T_Batch.FirstOrDefault(s => b_id.Contains(s.Id) && s.IsActive.Value);
if (candBatch != null)
{
var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
var tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
if (tracker != null)
{
if (cbSet.Finished == false && cbSet.IsLive == true)
{
cbSet.IsLive = false;
_db.SaveChanges();
var duration = candBatch.Duration.ToString();
string[] ds = duration.Split(':');
int min = 0;
int sec = 0;
int hour = 0;
int TestdurationSum = 0;
if (ds.Length == 1)
{
min = int.Parse(ds[0]);
sec = 0;
hour = 0;
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
else if (ds.Length == 2)
{
min = int.Parse(ds[0]);
sec = int.Parse(ds[1]);
hour = 0;
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
else
{
min = int.Parse(ds[1]);
sec = int.Parse(ds[2]);
hour = int.Parse(ds[0]);
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
var timeEnding = DateTime.Now;
var ending = timeEnding.AddSeconds(TestdurationSum);
var st = DateTime.Now;
var initialTime = tracker.InitialStartTime == null
? st
: tracker.InitialStartTime.Value;
DateTime lastActiveTime = tracker.CurrentStartTime == null
? initialTime
: tracker.CurrentStartTime.Value;
//TimeSpan spent = (lastActiveTime - initialTime);
//int hours = spent.Hours;
//int mins = spent.Minutes;
//int secs = spent.Seconds;
if (initialTime != null)
{
var span = (lastActiveTime - initialTime);
//var sumSpent = ((span.Hours * 3600) + (span.Minutes * 60) + span.Seconds);
var spentTime = new TimeSpan(span.Hours, span.Minutes, span.Seconds);
ending = ending.Subtract(spentTime);
}
TimeSpan remaining = (ending - timeEnding);
//var timeString = String.Format("{0}:{1}:{2}", ErecruitHelper.AppendZero(remaining.Hours),
// ErecruitHelper.AppendZero(remaining.Minutes),
// ErecruitHelper.AppendZero(remaining.Seconds));
resultLbl.Text = "Session for the Candidate: " + cand.Code + " has been reset.<br />Time Remaining: " + ErecruitHelper.AppendZero(remaining.Hours) + " hours, " + ErecruitHelper.AppendZero(remaining.Minutes) + " minutes and " + ErecruitHelper.AppendZero(remaining.Seconds) + " seconds";
//int sumSpent = ((hours ) + (mins * 60) + secs);
//string[] ds = duration.Split(',');
//int min = 0;
//int sec = 0;
//if (ds.Length == 1)
//{
// min = int.Parse(ds[0]);
// sec = 0;
// duration = min + "," + sec;
// resultLbl.Text = "Session for the Candidate: " + cand.Code + " has been reset.<br />Time Remaining: " + min + " minutes and " + sec + " seconds";
//}
//else
//{
// min = int.Parse(ds[0]);
// sec = int.Parse(ds[1]);
// duration = min + "," + sec;
// resultLbl.Text = "Session for the Candidate: " + cand.Code + " has been reset.<br />Time Remaining: " + min + " minutes and " + sec + " seconds";
//}
//SessionHelper.SetCandidateCode(code, Session);
//Response.Redirect("ActivateCandidateSession.aspx", false);
}
else if (cbSet.Finished == false && cbSet.IsLive == false)
{
resultLbl.Text = "The candidate Session currently valid.";
}
else
{
var rsltTxt = "The candidate must have finished the test.";
resultLbl.Text = rsltTxt;
}
}
else
{
resultLbl.Text = "The candidate is yet to start the test.";
}
}
else
{
resultLbl.Text = "The candidate has not been assigned to a test batch.";
}
}
else
{
resultLbl.Text = "This is not a valid candidate code";
}
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void AudiTrailGrid_Sorting(object sender, GridViewSortEventArgs e)
{
try{
var auditLogs = _db.AuditRecords.OrderByDescending(s => s.AuditDate).ToList();
TotalRecCount.Text = auditLogs.Count() + " Log(s)";
if ((string)Session["EXP"] == e.SortExpression && (string)Session["DIRECTION"] == SortDirection.Ascending.ToString())
{
e.SortDirection = SortDirection.Descending;
}
else
{
e.SortDirection = SortDirection.Ascending;
}
Session["EXP"] = e.SortExpression;
Session["DIRECTION"] = e.SortDirection.ToString();
switch (e.SortExpression)
{
case "UserName":
if (e.SortDirection == SortDirection.Ascending)
{
auditLogs = auditLogs.OrderBy(s => s.UserName).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
else
{
auditLogs = auditLogs.OrderByDescending(s => s.UserName).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
break;
case "Action":
if (e.SortDirection == SortDirection.Ascending)
{
auditLogs = auditLogs.OrderBy(s => s.Action).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
else
{
auditLogs = auditLogs.OrderByDescending(s => s.Action).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
break;
case "TableName":
if (e.SortDirection == SortDirection.Ascending)
{
auditLogs = auditLogs.OrderBy(s => s.TableName).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
else
{
auditLogs = auditLogs.OrderByDescending(s => s.TableName).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
break;
//case "MemberName":
// if (e.SortDirection == SortDirection.Ascending)
// {
// auditLogs = auditLogs.OrderBy(s => s.MemberName).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// else
// {
// auditLogs = auditLogs.OrderByDescending(s => s.MemberName).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// break;
//case "OldValue":
// if (e.SortDirection == SortDirection.Ascending)
// {
// auditLogs = auditLogs.OrderBy(s => s.OldValue).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// else
// {
// auditLogs = auditLogs.OrderByDescending(s => s.OldValue).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// break;
//case "NewValue":
// if (e.SortDirection == SortDirection.Ascending)
// {
// auditLogs = auditLogs.OrderBy(s => s.NewValue).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// else
// {
// auditLogs = auditLogs.OrderByDescending(s => s.NewValue).ToList();
// AudiTrailGrid.DataSource = auditLogs;
// AudiTrailGrid.DataBind();
// }
// break;
case "AuditDate":
if (e.SortDirection == SortDirection.Ascending)
{
auditLogs = auditLogs.OrderBy(s => s.AuditDate).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
else
{
auditLogs = auditLogs.OrderByDescending(s => s.AuditDate).ToList();
AudiTrailGrid.DataSource = auditLogs;
AudiTrailGrid.DataBind();
}
break;
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void C_TestStart_Click(object sender, EventArgs e)
{
try
{
var code = Code.Text;
if (!string.IsNullOrEmpty(code))
{
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
if (cand.ApprovalStatus == QuizBook.Helpers.ErecruitHelper.ApprovalStatus.APPROVED.ToString())
{
if (cand != null)
{
SessionHelper.SetCandidateCode(cand.Code.ToString(CultureInfo.InvariantCulture), Session);
var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
if (!b_id.Any())
{
Info.Text = "You have not been assigned to a batch.\n Please contact the Administrator.";
//Response.Redirect("CandidateLogin.aspx");
}
else
{
var candBatch = _db.T_Batch.FirstOrDefault(s => b_id.Contains(s.Id) && s.IsActive.Value);
if (candBatch != null)
{
if (candBatch.StartDate <= DateTime.Now)
{
var bSets = _db.T_BatchSet.Where(s => s.BatchId == candBatch.Id).ToList();
//int membersCount = bSets.Count();
//int finishedMembersCount = bSets.Where(s => s.Finished.Value).Count();
var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
if (cbSet != null && cbSet.Finished == true)
{
SessionHelper.SetCandidateId(cand.Id.ToString(CultureInfo.InvariantCulture), Session);
if (cbSet.Essay == true)
{
if (cbSet.Psychometric == true)
{
ErecruitHelper.CheckBatches(_db, candBatch);
Info.Text = "You have already finished this process";
}
else
{
var exitingPsyc1 = _db.T_MultiintelligencQuizBookDb.FirstOrDefault(s => s.CandidateId == cand.Id);
if (exitingPsyc1 != null)
{
Response.Redirect("BackGroundQuestionaire.aspx", false);
}
else
{
Response.Redirect("MultiIntelligenceTest.aspx", false);
}
}
}
else
{
//Info.Text = "You have not done the Essay part";
Response.Redirect("CandidateTestResult.aspx", false);
}
//if (cbSet.Psychometric == false)
//{
// Info.Text = "You have not done the Psychometric part";
//}
//else if (cbSet.Finished == true&& cbSet.Psychometric == true && cbSet.Essay == true)
//{
//}
//if (cbSet.Essay == true)
//{
//}
// Info.Text = "You Have Done this test.";
}
else
{
var batchSet = bSets.FirstOrDefault(s => s.CandidateId == cand.Id);
if (batchSet.IsLive.Value)
{
Info.Text = "You Currently have a Session on.\n Please contact the Administrator.";
// Response.Redirect("CandidateLogin.aspx");
}
else
{
if (candBatch != null)
{
var tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
if (tracker != null)
{
//var duration = tracker.RemainingDuration.ToString();
//string[] ds = duration.Split(':');
//int hour = 0;
//int min = 0;
//int sec = 0;
//if (ds.Length == 1)
//{
// min = int.Parse(ds[0]);
// sec = 0;
// hour = 0;
// duration = hour+":"+min + ":" + sec;
//}
//else if (ds.Length == 2)
//{
// min = int.Parse(ds[0]);
// sec = int.Parse(ds[1]);
// hour = 0;
// duration = hour + ":" + min + ":" + sec;
//}
//else
//{
// min = int.Parse(ds[1]);
// sec = int.Parse(ds[2]);
// hour = int.Parse(ds[0]);
// duration = hour + ":" + min + ":" + sec;
//}
var st = DateTime.Now;
var initialTime = tracker.InitialStartTime == null
? st
: tracker.InitialStartTime.Value;
DateTime lastActiveTime = tracker.CurrentStartTime == null
? initialTime
: tracker.CurrentStartTime.Value;
TimeSpan spent = (lastActiveTime - initialTime);
int hours = spent.Hours;
int mins = spent.Minutes;
int secs = spent.Seconds;
int sumSpent = ((hours * 3600) + (mins * 60) + secs);
var TestDuration = tracker.TestDuration.ToString();
string[] ds = TestDuration.Split(':');
int hour = 0;
int min = 0;
int sec = 0;
int TestdurationSum = 0;
if (ds.Length == 1)
{
min = int.Parse(ds[0]);
sec = 0;
hour = 0;
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
else if (ds.Length == 2)
{
min = int.Parse(ds[0]);
sec = int.Parse(ds[1]);
hour = 0;
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
else
{
min = int.Parse(ds[1]);
sec = int.Parse(ds[2]);
hour = int.Parse(ds[0]);
TestdurationSum = ((hour * 3600) + (min * 60) + sec);
}
if (sumSpent >= TestdurationSum)
{
Response.Redirect("CandidateTestResult.aspx?z=elapsed", false);
}
else
{
//var endtime = st.AddSeconds(TestdurationSum - sumSpent);
//tracker.CurrentStartTime = st;
//tracker.EndTime = endtime;
batchSet.IsLive = true;
candBatch.SessionOn = true;
_db.SaveChanges();
tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
var remaining = tracker.RemainingDuration;
var d = tracker.TestDuration;
if (d != "00:00:00" && remaining != "00:00:00")
{
var existingQCount = _db.T_CandidateTemp.Count(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
if (existingQCount < 1)
{
List <long?> Q = _db.T_BatchQuestions.Where(s => s.BatchId == candBatch.Id).Select(x => x.QuestionId).ToList();
var questions = _db.T_Question.Where(s => Q.Contains(s.Id)).ToList();
var typ = questions.Select(s => s.PreambleId).Distinct().OrderBy(s => s).ToList();
//Randomize the questions
// Q.Shuffle();
int count = 0;
foreach (var t in typ)
{
var qs = questions.Where(s => s.PreambleId == t).ToList();
//Randomize the questions
RandomHelper.Shuffle(qs);
RandomHelper.Shuffle(qs);
foreach (var q in qs)
{
_db.T_CandidateTemp.Add(new T_CandidateTemp
{
CandidateId = cand.Id,
BatchId = candBatch.Id,
PreambleId = q.PreambleId,
Q_Id = q.Id,
Q_Index = (count + 1),
Answered = false
});
count++;
}
_db.SaveChanges();
}
}
//List<T_Question> questions = _db.T_Question.Where(s => Q.Contains(s.Id) && s.IsActive.Value).ToList();
SessionHelper.SetCandidateId(cand.Id.ToString(CultureInfo.InvariantCulture), Session);
Response.Redirect("CandidateTestPage.aspx", false);
}
}
}
else
{
var st = DateTime.Now;
var duration = candBatch.Duration.ToString();
//string[] ds = duration.Split(':');
//int min = 0;
//int sec = 0;
//int hour = 0;
//int TestdurationSum = 0;
//if (ds.Length == 1)
//{
// min = int.Parse(ds[0]);
// sec = 0;
// hour = 0;
// TestdurationSum = ((hour * 3600) + (min * 60) + sec);
//}
//else if (ds.Length == 2)
//{
// min = int.Parse(ds[0]);
// sec = int.Parse(ds[1]);
// hour = 0;
// TestdurationSum = ((hour * 3600) + (min * 60) + sec);
//}
//else
//{
// min = int.Parse(ds[1]);
// sec = int.Parse(ds[2]);
// hour = int.Parse(ds[0]);
// TestdurationSum = ((hour * 3600) + (min * 60) + sec);
//}
//var endtime = st.AddSeconds(TestdurationSum);
_db.T_CTestTracker.Add(new T_CTestTracker
{
CandidateId = cand.Id,
BatchId = candBatch.Id,
CandidateCode = cand.Code,
// InitialStartTime = st,
// CurrentStartTime = st,
TestDuration = ErecruitHelper.AppendZero(0) + ":" + ErecruitHelper.AppendZero(int.Parse(duration)) + ":" + ErecruitHelper.AppendZero(0),
RemainingDuration = duration,
//EndTime = endtime
}
);
//var batchSets = _db.T_BatchSet.Where(s => s.BatchId == candBatch.Id).ToList();
// var batchSet = bSets.Where(s => s.CandidateId == cand.Id).FirstOrDefault();
batchSet.IsLive = true;
batchSet.TimeStarted = DateTime.Now;
candBatch.SessionOn = true;
_db.SaveChanges();
tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
var remaining = tracker.RemainingDuration;
var d = tracker.TestDuration;
if (d != "0:0:0" && remaining != "0:0:0")
{
var existingQCount = _db.T_CandidateTemp.Count(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
if (existingQCount < 1)
{
List <long?> Q = _db.T_BatchQuestions.Where(s => s.BatchId == candBatch.Id).Select(x => x.QuestionId).ToList();
var questions = _db.T_Question.Where(s => Q.Contains(s.Id)).ToList();
var typ = questions.Select(s => s.PreambleId).Distinct().OrderBy(s => s).ToList();
//Randomize the questions
// Q.Shuffle();
int count = 0;
foreach (var t in typ)
{
var qs = questions.Where(s => s.PreambleId == t).ToList();
//Randomize the questions
RandomHelper.Shuffle(qs);
RandomHelper.Shuffle(qs);
foreach (var q in qs)
{
_db.T_CandidateTemp.Add(new T_CandidateTemp
{
CandidateId = cand.Id,
BatchId = candBatch.Id,
PreambleId = q.PreambleId,
Q_Id = q.Id,
Q_Index = (count + 1),
Answered = false
});
count++;
}
_db.SaveChanges();
}
}
//List<T_Question> questions = _db.T_Question.Where(s => Q.Contains(s.Id) && s.IsActive.Value).ToList();
SessionHelper.SetCandidateId(cand.Id.ToString(CultureInfo.InvariantCulture), Session);
Response.Redirect("CandidateTestPage.aspx", false);
}
}
}
}
}
}
else
{
Info.Text = "It is not yet time to take this test.\n Please contact the Administrator.";
}
}
else
{
Info.Text = "You are not assigned to any active batch.\n Please contact the Administrator.";
}
}
}
else
{
Info.Text = "This is not a valid candidate ID.\n Please contact the Administrator.";
// Response.Redirect("CandidateLogin.aspx");
}
}
else
{
Info.Text = "You have not been approved.\n Please contact the Administrator.";
}
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
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.CanManageTestResults)
{
var code = SessionHelper.FetchCandidateCode(Session);
var bid = Session["Batchid"].ToString();
if (!string.IsNullOrEmpty(code))
{
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
if (cand != null)
{
//var tracker = _db.T_CTestTracker.FirstOrDefault(s => s.CandidateId == cand.Id);
//var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
var candBatch = _db.T_Batch.FirstOrDefault(s => s.Id == long.Parse(bid));
if (candBatch != null)
{
if (cand != null && candBatch != null)
{
var bs = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
ccode.InnerHtml = cand.Code;
CGender.InnerHtml = cand.Sex;
Surname.InnerHtml = cand.LastName;
COthernames.InnerHtml = cand.FirstName + " " + cand.MiddleName + " " + cand.MaidenName;
CDob.InnerHtml = ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Day) + "/" + ErecruitHelper.AppendZero(cand.DateOfBirth.Value.Month) + "/" + cand.DateOfBirth.Value.Year;
cgrade.InnerHtml = bs.TestScore + "%";
}
var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
if (cbSet.Finished == true)
{
GetTextBoxes(this);
if (TextBoxes.Count > 0)
{
var psychTestResult = _db.T_MultiintelligencQuizBookDb.FirstOrDefault(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id);
var intel = TextBoxes.FirstOrDefault(s => s.CssClass == "intel");
var analysis = TextBoxes.Where(s => s.CssClass == "analysis").OrderBy(x => x.ID).ToList();
var summation = TextBoxes.Where(s => s.CssClass == "summation").OrderBy(x => x.ID).ToList();
var D1 = TextBoxes.Where(s => s.CssClass == "D1").OrderBy(x => x.ID).ToList();
var D2 = TextBoxes.Where(s => s.CssClass == "D2").OrderBy(x => x.ID).ToList();
var D3 = TextBoxes.Where(s => s.CssClass == "D3").OrderBy(x => x.ID).ToList();
var D4 = TextBoxes.Where(s => s.CssClass == "D4").OrderBy(x => x.ID).ToList();
var D5 = TextBoxes.Where(s => s.CssClass == "D5").OrderBy(x => x.ID).ToList();
var D6 = TextBoxes.Where(s => s.CssClass == "D6").OrderBy(x => x.ID).ToList();
var D7 = TextBoxes.Where(s => s.CssClass == "D7").OrderBy(x => x.ID).ToList();
intel.Text = psychTestResult.Intelligence;
//D1
var d1 = psychTestResult.Options1.Split(',');
for (var s = 0; s < d1.Length; s++)
{
if (s < D1.Count)
{
D1[s].Text = d1[s];
}
}
//D2
var d2 = psychTestResult.Options2.Split(',');
for (var s = 0; s < d1.Length; s++)
{
if (s < D2.Count)
{
D2[s].Text = d2[s];
}
}
//D3
var d3 = psychTestResult.Options3.Split(',');
for (var s = 0; s < d3.Length; s++)
{
if (s < D3.Count)
{
D3[s].Text = d3[s];
}
}
//D4
var d4 = psychTestResult.Options4.Split(',');
for (var s = 0; s < d4.Length; s++)
{
if (s < D4.Count)
{
D4[s].Text = d4[s];
}
}
//D5
var d5 = psychTestResult.Options5.Split(',');
for (var s = 0; s < d5.Length; s++)
{
if (s < D5.Count)
{
D5[s].Text = d5[s];
}
}
//D6
var d6 = psychTestResult.Options6.Split(',');
for (var s = 0; s < d6.Length; s++)
{
if (s < D6.Count)
{
D6[s].Text = d6[s];
}
}
//D7
var d7 = psychTestResult.Options7.Split(',');
for (var s = 0; s < d7.Length; s++)
{
if (s < D7.Count)
{
D7[s].Text = d7[s];
}
}
//summation
var dsummation = psychTestResult.Summations.Split(',');
for (var s = 0; s < dsummation.Length; s++)
{
if (s < summation.Count)
{
summation[s].Text = dsummation[s];
}
}
//analysis
var danalysis = psychTestResult.Summations.Split(',');
for (var s = 0; s < danalysis.Length; s++)
{
if (s < analysis.Count)
{
analysis[s].Text = danalysis[s];
}
}
}
}
}
}
}
}
else
{
Response.Redirect("NoPermission.aspx", false);
}
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void SearchAuditTrail_Click(object sender, EventArgs e)
{
try{
var user = username.Text;
var action = Action.Text;
var c = cond.Value;
var table = tablename.Text;
// var col = column.Text;
var dateLogged = AuditDate.Text;
IQueryable <AuditRecord> logs;
if (!string.IsNullOrEmpty(user))
{
logs = _db.AuditRecords.Where(s => (s.UserName.Contains(user)));
}
else
{
logs = _db.AuditRecords.AsQueryable();
}
if (!string.IsNullOrEmpty(table))
{
logs = logs.Where(s => s.TableName.Contains(table)).AsQueryable();
}
if (!string.IsNullOrEmpty(action))
{
logs = logs.Where(s => s.Action.Contains(action)).AsQueryable();
}
//if (!string.IsNullOrEmpty(col) )
//{
// logs = logs.Where(s => s.MemberName.Contains(col)).AsQueryable();
//}
if (!string.IsNullOrEmpty(dateLogged))
{
var logdate = ErecruitHelper.GetCurrentDateFromDateStringWithHM(dateLogged);
if ((logdate) != null)
{
if (c == "=")
{
logs = logs.Where(s => s.AuditDate == (logdate)).AsQueryable();
}
else if (c == "<")
{
logs = logs.Where(s => s.AuditDate < (logdate)).AsQueryable();
}
else if (c == ">")
{
logs = logs.Where(s => s.AuditDate > (logdate)).AsQueryable();
}
}
}
TotalRecCount.Text = logs.Count() + " Log(s)";
AudiTrailGrid.DataSource = logs;
AudiTrailGrid.DataBind();
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void check_Click(object sender, EventArgs e)
{
var code = Code.Text;
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
if (!(cand == null))
{
var b_set = _db.T_BackGroundQuestAnswers.Where(s => s.CandidateId == cand.Id).ToList();
int count = b_set.Count();
if (count > 1)
{
var quests = b_set.Select(a => new PrevBatchGridModel
{
ID = a.Id,
BatchName = ErecruitHelper.getBatchName((long)a.BatchId),
Code = ErecruitHelper.getCandidateCode((long)a.CandidateId) + "," + a.BatchId,
DateTaken = ErecruitHelper.GetDateStringFromDate((DateTime)a.Dateadded)
}).Distinct().ToList();
batchHistory.DataSource = quests;
batchHistory.DataBind();
batchHistoryPanel.Visible = true;
SessionHelper.NullCandidateCode(Session);
Session["Batchid"] = null;
}
else if (count == 1)
{
batchHistoryPanel.Visible = false;
SessionHelper.SetCandidateCode(code, Session);
Session["Batchid"] = b_set[0].BatchId;
Response.Redirect("BackgroundView.aspx", false);
}
else
{
resultLbl.Text = "No History";
batchHistoryPanel.Visible = false;
}
}
else
{
resultLbl.Text = "This is not a valid candidate code";
batchHistoryPanel.Visible = false;
}
//if (!string.IsNullOrEmpty(code))
//{
// var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
// if (cand != null)
// {
// var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId);
// var candBatch = _db.T_Batch.FirstOrDefault(s => b_id.Contains(s.Id) && s.IsActive.Value);
// if (candBatch != null)
// {
// var cbSet = _db.T_BatchSet.FirstOrDefault(s => s.BatchId == candBatch.Id && s.CandidateId == cand.Id);
// var c_off = _db.T_Settings.FirstOrDefault(s => s.SettingsName == ErecruitHelper.Settings.CUT_OFF_MARK.ToString()).SettingsValue;
// if (cbSet != null && cbSet.Finished == true)
// {
// if (double.Parse(cbSet.TestScore) > double.Parse(c_off))
// {
// SessionHelper.SetCandidateCode(code, Session);
// Response.Redirect("BackgroundView.aspx", false);
// }
// else
// {
// resultLbl.Text = "The candidate did not pass the test.";
// }
// }
// else
// {
// var rsltTxt = "The candidate has not concluded the test.";
// resultLbl.Text = rsltTxt;
// }
// }
// else
// {
// resultLbl.Text = "The candidate has not been assigned to a test batch.";
// }
// }
// else
// {
// resultLbl.Text = "This is not a valid candidate code";
// }
//}
}
protected void saveRole_Click(object sender, EventArgs e)
{
var tenantID = long.Parse(SessionHelper.GetTenantID(Session));
var userId = SessionHelper.FetchUserId(Session);
var fn = firstname.Text;
var ln = lname.Text;
var role = RoleList.SelectedValue;
var emailvar = email.Text;
var sx = sex.SelectedItem.Value;
var dateOb = dob.Text;
var un = username.Text;
var address = Address.Text;
var super = supervisor.Checked;
var adId = adminId.Value;
//var cpw = cPass.Text;
if (string.IsNullOrEmpty(role) || role == "-1")
{
messageBox.Text = "Kindly Select a Role.";
}
else
{
using (QuizBookDbEntities1 _db = new QuizBookDbEntities1())
{
var pw = Guid.NewGuid().ToString();
var phrase = pw.Split('-')[0];
if (string.IsNullOrEmpty(adId))
{
var newAdmin = new AdminUser
{
FirstName = fn,
LastName = ln,
Username = un,
Sex = sx,
DOB = ErecruitHelper.GetCurrentDateFromDateString(dateOb),
Address = address,
State = Request[state.UniqueID].ToString(),
Country = Request[country.UniqueID].ToString(),
Location = Request[Location.UniqueID].ToString(),
TenantId = tenantID,
Email = emailvar,
Supervisor = super,
Role = long.Parse(role),
Status = ErecruitHelper.CStatus.Active.ToString(),
DateCreated = DateTime.Now,
CreatedBy = userId.ToString(),
Captcha = Page.IsValid,
DefaultLoginKeyChanged = true,
LogInKey = ErecruitHelper.getHash(phrase.Trim(), keySalt.Trim()),
IpAddress = ErecruitHelper.GetIP(HttpContext.Current)
};
_db.AdminUsers.Add(newAdmin);
_db.SaveChanges();
ErecruitHelper.sendProfile(newAdmin, "", phrase);
}
else
{
long idcr = long.Parse(adId);
var admin = _db.AdminUsers.FirstOrDefault(x => x.Id == idcr);
if (admin != null)
{
admin.FirstName = fn;
admin.LastName = ln;
admin.Username = un;
admin.Sex = sx;
admin.DOB = ErecruitHelper.GetCurrentDateFromDateString(dateOb);
admin.Address = address;
admin.State = Request[state.UniqueID].ToString();
admin.Country = Request[country.UniqueID].ToString();
admin.Location = Request[Location.UniqueID].ToString();
admin.TenantId = tenantID;
admin.Email = emailvar;
admin.Supervisor = super;
admin.Role = long.Parse(role);
admin.DateModified = DateTime.Now;
admin.Status = ErecruitHelper.CStatus.Active.ToString();
admin.IpAddress = ErecruitHelper.GetIP(HttpContext.Current);
_db.SaveChanges();
messageBox.Text = "Changes Saved";
}
}
Response.Redirect("Admins.aspx", false);
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
try{
var selectedQtype = long.Parse(DropDownList1.SelectedValue);
var t = _db.T_QuestionType.FirstOrDefault(s => s.Id == selectedQtype);
var tenantId = long.Parse(SessionHelper.GetTenantID(Session));
//if (selectedQtype == 1 || selectedQtype == 3 || selectedQtype == 4)
//{
// //PreambleName.Text = "";
// //preambleNameRow.Visible = true;
// //PreambleName.Text = "";
// //preambleNameRow.Visible = true;
// PreambleName.Text = "";
// preambleText.Text = "";
// PreamblePreview.Text = "";
// PreambleNamePreview.Text = "";
// preview.Visible = false;
// preambleNameRow.Visible = false;
// preambleRow.Visible = false;
// //Populates the preambles DropDownList
// var p = _db.T_Question.Where(s => s.TypeId == selectedQtype).Select(s => s.PreambleId).Distinct();
// var preamblesList = _db.T_QuestionPreamble.Where(s => p.Contains(s.Id));
// var preamb = preamblesList.Select(a => new
// {
// Id = a.Id,
// Name = a.Name
// }).Distinct().ToList();
// preamb.Insert(0, new
// {
// Id = long.Parse("-1"),
// Name = "Select..."
// });
// preamb.Insert(1, new
// {
// Id = long.Parse("0"),
// Name = "New Question Preamble"
// });
// preambleLists.DataSource = preamb;
// preambleLists.DataBind();
// preambles.Visible = true;
//}
//else
//{
// preambles.Visible = false;
//preambleLists.SelectedIndex = 0;
PreambleName.Text = "";
preambleText.Text = "";
PreamblePreview.Text = "";
PreambleNamePreview.Text = "";
preview.Visible = false;
preambleNameRow.Visible = false;
preambleRow.Visible = false;
// }
//Populates the Question Type DropDownList
var typ = _db.T_QuestionType.Where(x => x.TenantId == tenantId && x.Status == true).Select(a => new
{
Id = a.Id,
Name = a.Name
}).OrderBy(s => s.Name).ToList();
DropDownList1.SelectedValue = selectedQtype.ToString();
DropDownList1.DataSource = typ;
DropDownList1.DataBind();
//var quests = _db.T_Question.Where(x => x.TypeId == selectedQtype).OrderBy(x =>x.DateAdded).Select(a => new QuestionModel
//{
// ID = a.Id,
// Detail = string.IsNullOrEmpty(a.Details) ? "Empty" : a.Details.Trim(),
// Type = ErecruitHelper.getTypeName(_db, a.TypeId),
// Preamble = ErecruitHelper.GetPreambleName(_db, a.PreambleId),
// OptionType = ErecruitHelper.getOptionTypeName(_db, a.OptionType),
// OptionsCount = ErecruitHelper.getOptionNum(_db, a.Id).ToString(),
// IsActive = a.IsActive.Value ? "Yes" : "No",
// // D = "<a id='" + a.Id.ToString() + "' onclick='deleteQuest(this)' href='#' >Delete</a>"
// D = a.IsActive.Value ? "Deactivate" : "Activate"
//}).Distinct().ToList();
// QuestionIndex.Text = quests.Count + " "+t.Name+" Question(s)";
// GridView1.DataSource = quests;
// GridView1.DataBind();
var quests = _db.ActiveQuestions_vw.Where(x => x.TypeId == selectedQtype && x.TenantId == tenantId).OrderBy(x => x.Id).Select(a => new
{
ID = a.Id,
Detail = a.Details,
Type = a.Type,
Preamble = a.Preamble,
Section = a.Section,
OptionType = a.OptionType,
OptionsCount = a.OptionsCount,
IsActive = a.IsActive,
// D = "<a id='" + a.Id.ToString() + "' onclick='deleteQuest(this)' href='#' >Delete</a>"
D = a.D
}).ToList();
QuestionIndex.Text = quests.Count + " Question(s)";
GridView1.DataSource = quests;
GridView1.DataBind();
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string currentPageFileName = new FileInfo(this.Request.Url.AbsolutePath).Name;
var PermMgr = new PermissionManager(Session);
if (PermMgr.IsAdmin || PermMgr.CanManageTestResults)
{
var c = SessionHelper.FetchCandidateCode(Session);
if (!string.IsNullOrEmpty(c))
{
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == c);
if (!(cand == null))
{
var b_id = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).Select(x => x.BatchId).ToList();
if (b_id.Count() != 0)
{
var bs = new T_BatchSet();
var candBatch = new T_Batch();
if (Session["BatchSetId"] != null)
{
bs = _db.T_BatchSet.FirstOrDefault(s => s.Id == long.Parse(Session["BatchSetId"].ToString()));
candBatch = _db.T_Batch.FirstOrDefault(s => s.Id == bs.BatchId);
var b_set = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).ToList();
var quests = b_set.Select(a => new PrevBatchGridModel
{
ID = a.Id,
BatchName = ErecruitHelper.getBatchName((long)a.BatchId),
Code = a.Finished == true ? ErecruitHelper.getCandidateCode((long)a.CandidateId) + "," + a.Id : ErecruitHelper.getCandidateCode((long)a.CandidateId),
DateTaken = a.Finished == true ? a.TimeStarted.ToString() : "Not Finished."
}).Distinct().ToList();
batchHistory.DataSource = quests;
batchHistory.DataBind();
batchHistoryPanel.Visible = true;
}
else
{
bs = _db.T_BatchSet.FirstOrDefault(s => s.CandidateId == cand.Id);
candBatch = _db.T_Batch.FirstOrDefault(s => s.Id == bs.BatchId);
}
if (bs.Finished == true)
{
int totalQuestions = _db.T_BatchQuestions.Count(s => s.BatchId == candBatch.Id);
int correct = _db.T_CandidateAnswers.Count(s => s.CandidateId == cand.Id && s.BatchId == candBatch.Id && s.Correct == true);
double percentage = (double)correct / totalQuestions;
percentage = Math.Round((percentage * 100), 2);
var rsltTxt = "Candidate Name: " + cand.FirstName + " " + cand.LastName + "<br /><br />Got " + correct + " question(s) out of " + totalQuestions + " questions.<br /><br />Percentage Score: " + percentage + " %";
name.Text = rsltTxt;
CID.Value = cand.Code;
BID.Value = candBatch.Id.ToString();
BindScoreGrid(cand.Id, candBatch);
}
else
{
var rsltTxt = "The candidate has not concluded the test.";
name.Text = rsltTxt;
batchHistoryPanel.Visible = false;
ScoreListPanel.Visible = false;
}
}
else
{
resultLbl.Text = "The candidate has not been assigned to a test batch.";
batchHistoryPanel.Visible = false;
ScoreListPanel.Visible = false;
}
}
else
{
resultLbl.Text = "This is not a valid candidate code";
batchHistoryPanel.Visible = false;
ScoreListPanel.Visible = false;
}
}
}
else
{
batchHistoryPanel.Visible = false;
ScoreListPanel.Visible = false;
Response.Redirect("NoPermission.aspx", false);
}
}
protected void check_Click(object sender, EventArgs e)
{
var code = Code.Text;
var cand = _db.T_Candidate.FirstOrDefault(s => s.Code == code);
if (!(cand == null))
{
var b_set = _db.T_BatchSet.Where(s => s.CandidateId == cand.Id).ToList();
int count = b_set.Count();
if (count > 1)
{
var quests = b_set.Select(a => new PrevBatchGridModel
{
ID = a.Id,
BatchName = ErecruitHelper.getBatchName((long)a.BatchId),
Code = a.Finished == true ? ErecruitHelper.getCandidateCode((long)a.CandidateId) + "," + a.Id : ErecruitHelper.getCandidateCode((long)a.CandidateId),
DateTaken = a.Finished == true ? ErecruitHelper.GetDateStringFromDate((DateTime)a.TimeStarted) : "Not Finished."
}).Distinct().ToList();
batchHistory.DataSource = quests;
batchHistory.DataBind();
batchHistoryPanel.Visible = true;
ScoreListPanel.Visible = false;
SessionHelper.NullCandidateCode(Session);
Session["BatchSetId"] = null;
}
else if (count == 1)
{
batchHistoryPanel.Visible = false;
SessionHelper.SetCandidateCode(code, Session);
Session["BatchSetId"] = null;
Response.Redirect("ViewTestScore.aspx", false);
}
else
{
resultLbl.Text = String.Empty;
batchHistoryPanel.Visible = false;
}
}
else
{
resultLbl.Text = "This is not a valid candidate code";
batchHistoryPanel.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
var tenant = SessionHelper.GetTenantID(Session);
using (QuizBookDbEntities1 _db = new QuizBookDbEntities1())
{
if (string.IsNullOrEmpty(tenant))
{
ErecruitHelper.SetErrorData(new NullReferenceException("There must be a valid Organisation"), Session);
Response.Redirect("ErrorPage.aspx", false);
}
else
{
var selectedBatch = Session["GrpList"] == null?0: long.Parse(Session["GrpList"].ToString());
DateTime?fromDate = DateTime.Now;
if ((bool)Session["From"])
{
fromDate = null;
}
else
{
fromDate = (DateTime)Session["dateFrom"];
}
DateTime?toDate = DateTime.Now;
if ((bool)Session["To"])
{
toDate = null;
}
else
{
toDate = (DateTime)Session["dateTo"];
}
//var toDate = (bool)Session["To"] ? null : (DateTime)Session["dateTo"];
//logoCtrl.ImageUrl = HostingEnvironment.MapPath("~/Images/book.png");
//logoCtrl.ImageUrl = GetUrl("book.png");
logoCt.Src = GetUrl("book.png");
//Session["imageURL"] = GetUrl("Images/book.png");
var details = new ERecruitReportFactory().BatchReport(selectedBatch, fromDate, toDate, long.Parse(tenant)).ToList();
var oneInstance = details.FirstOrDefault();
var count = details.Count();
candCount.Text = count.ToString();
batchName.Text = oneInstance == null? "":oneInstance.BatchName;
ppassed.Text = count > 0?((details.Count(x => x.Passed == 1) / count) * 100) + " %":"0 %";
pfailed.Text = count > 0 ? ((details.Count(x => x.Failed == 1) / count) * 100) + " %" : "0 %";
ResultList.DataSource = details;
ResultList.DataBind();
}
}
}
catch (Exception ex)
{
WSProfile filter = new WSProfile(System.Reflection.Assembly.GetExecutingAssembly().FullName.Split(',')[0], Path.GetFileName(Request.Url.AbsolutePath) + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name, ApplicationType.WebApplication);
filter.LogError(ex);
//ErecruitHelper.SetErrorData(ex, Session);
//Response.Redirect("ErrorPage.aspx", false);
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
try
{
//var selectedGroup = bgrp.SelectedValue;
var GroupItem = GroupContentList.SelectedValue;
// Session["Grp"] = string.IsNullOrEmpty(selectedGroup) ? "ALL" : selectedGroup.Trim();
Session["GrpList"] = string.IsNullOrEmpty(GroupItem) ? "ALL" : GroupItem.Trim();
//ErecruitHelper.GetCurrentDateFromDateStringWithHM(Stdate);
Session["dateFrom"] = string.IsNullOrEmpty(from.Text)?DateTime.Now.Date:ErecruitHelper.GetCurrentDateFromDateStringWithHM(from.Text);
Session["dateTo"] = string.IsNullOrEmpty(to.Text) ? DateTime.Now.Date : ErecruitHelper.GetCurrentDateFromDateStringWithHM(to.Text);
Session["From"] = string.IsNullOrEmpty(from.Text) ? true : false;
Session["To"] = string.IsNullOrEmpty(to.Text) ? true : false;
Response.Redirect("BatchReport.aspx", false);
// Response.Redirect("~/Reports/ResultView.aspx", false);
}
catch (Exception ex)
{
ErecruitHelper.SetErrorData(ex, Session);
Response.Redirect("ErrorPage.aspx", false);
}
}
