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); } } }