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;
}
protected void regBtn_Click(object sender, EventArgs e)
{
// QuizBookDbEntities1 _db = new QuizBookDbEntities1();
var page = Page.IsValid;
if (page)
{
var fn = firstname.Text;
var ln = lname.Text;
var address = Address.Text;
var emailvar = email.Text;
var sx = sex.SelectedItem.Value;
var dateOb = dob.Text;
var un = username.Text;
var pw = password.Text;
var cpw = cPass.Text;
if (pw.Trim() == cpw.Trim())
{
HttpPostedFile file = tLogo.PostedFile;
if (file != null && file.ContentLength > 0)
{
string fname = Path.GetFileName(file.FileName);
string ext = System.IO.Path.GetExtension(file.FileName);
string fileID = Guid.NewGuid().ToString();
string path = "";
if (shortName.Text.Length >= 6)
{
var tenant = new Tenant
{
TenantName = name.Text,
TenantCode = string.IsNullOrEmpty(shortName.Text) ? name.Text.Substring(0, 6) : shortName.Text,
Address = Address.Text,
State = Request[state.UniqueID].ToString(),
Country = Request[country.UniqueID].ToString(),
TenantStatus = true,
DateCreated = DateTime.Now,
CreatedBy = "QuizBook",
TenantLimit = 0,
Image = Path.Combine("~/TenantLogo/", fileID + ext)
};
using (QuizBookDbEntities1 _db = new QuizBookDbEntities1())
{
_db.Tenants.Add(tenant);
_db.SaveChanges();
var rl = _db.Roles.FirstOrDefault(s => s.Description == "Admin");
_db.AdminUsers.Add(new AdminUser
{
FirstName = fn,
LastName = ln,
Username = un,
Sex = sx,
DOB = ErecruitHelper.GetCurrentDateFromDateString(dateOb),
Address = Address.Text,
State = Request[state.UniqueID].ToString(),
Country = Request[country.UniqueID].ToString(),
Location = Request[Location.UniqueID].ToString(),
TenantId = tenant.Id,
Email = emailvar,
Role = rl.Id,
Status = ErecruitHelper.CStatus.Active.ToString(),
DateCreated = DateTime.Now,
CreatedBy = "QuizBook",
Captcha = Page.IsValid,
DefaultLoginKeyChanged = true,
LogInKey = ErecruitHelper.getHash(pw, keySalt),
IpAddress = ErecruitHelper.GetIP(HttpContext.Current)
});
_db.SaveChanges();
}
// var all = new List<string[]>();
if (Directory.Exists(Server.MapPath("~/TenantLogo/")))
{
path = Server.MapPath(Path.Combine("~/TenantLogo/", fileID + ext));
// PPath = Path.Combine("~/Passports/", cand.Code + ext);
file.SaveAs(path);
}
else
{
Directory.CreateDirectory(Server.MapPath("~/TenantLogo/"));
path = Server.MapPath(Path.Combine("~/TenantLogo/", fileID + ext));
// PPath = Path.Combine("~/Passports/", cand.Code + ext);
file.SaveAs(path);
}
var data = File.ReadAllBytes(path);
SessionHelper.SetInfoValue("Your Profile has been successfully saved. Kindly <a href='Welcome.aspx'>click here</a> to proceed.", Session);
Response.Redirect("Info.aspx", false);
}
else
{
lblAlert.Text = "Short Name should be at least 6 characters";
}
}
}
else
{
lblAlert.Text = "Administrator's Password did not match";
}
}
else
{
lblAlert.Text = "Kindly fill the recaptcha";
}
}
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);
}
}
}