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.CanWorkWithCandidates || PermMgr.CanApprove) { if (!IsPostBack) { var quests = _db.Candidates.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }); TotalRecCount.Text = quests.Count() + " Candidate(s)"; CandidateList.DataSource = quests.OrderByDescending(x => x.ID).ToList(); CandidateList.DataBind(); } } else { Response.Redirect("NoPermission.aspx", false); } }
protected void lnkeditCS_Click(object sender, EventArgs e) { LinkButton lnkedit = ((LinkButton)sender); var p = lnkedit.Parent; HiddenField hdfID = (HiddenField)p.FindControl("hdfIDCS"); var idcr = long.Parse(hdfID.Value); if (!(idcr == null)) { var opt = _db.T_Candidate.Where(s => s.Id == idcr).FirstOrDefault(); if (opt.ApprovalStatus == ErecruitHelper.ApprovalStatus.APPROVED.ToString()) { if (opt != null) { if (opt.IsActive.Value) { opt.IsActive = false; } else { opt.IsActive = true; } _db.SaveChanges(); var quests = _db.Candidates.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }).Distinct().ToList(); TotalRecCount.Text = quests.Count() + " Candidate(s)"; CandidateList.DataSource = quests.OrderByDescending(x => x.ID).ToList(); CandidateList.DataBind(); } resultLbl.Text = ""; } else { resultLbl.Text = "The candidate has to be approved first"; } } }
protected void lnkeditApp_Click(object sender, EventArgs e) { LinkButton lnkedit = ((LinkButton)sender); var p = lnkedit.Parent; HiddenField hdfID = (HiddenField)p.FindControl("hdfIDApp"); var idcr = long.Parse(hdfID.Value); if (!(idcr == null)) { var opt = _db.Candidates.FirstOrDefault(s => s.Id == idcr); if (opt != null) { //if (opt.ApprovalStatus == ErecruitHelper.ApprovalStatus.APPROVED.ToString()) //{ // opt.ApprovalStatus = ErecruitHelper.ApprovalStatus.NOT_APPROVED.ToString(); // opt.IsActive = false; // opt.ApprovedBy = SessionHelper.FetchEmail(Session); //} //else //{ // opt.ApprovalStatus = ErecruitHelper.ApprovalStatus.APPROVED.ToString(); // opt.IsActive = true; // opt.ApprovedBy = SessionHelper.FetchEmail(Session); //} //_db.SaveChanges(); var quests = _db.Candidates.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }); CandidateList.DataSource = quests.OrderByDescending(x => x.DateRegistered).ToList(); CandidateList.DataBind(); resultLbl.Text = ""; } } }
protected void SearchCandidate_Click(object sender, EventArgs e) { try{ var name = Name.Text; var degree = Degree.Value; var c = cond.Value; var course = Course.Text; var DegreeClass = ClassOfDegree.Value; var referal = Referal.Text; var age = Age.Text; IQueryable <QuizBook.Candidate> cands; if (!string.IsNullOrEmpty(name)) { cands = _db.Candidates.Where(s => (s.FirstName.Contains(name) || s.LastName.Contains(name))); } else { cands = _db.Candidates.AsQueryable(); } var quests = cands.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }).Distinct().ToList(); TotalRecCount.Text = quests.Count() + " Candidate(s)"; CandidateList.DataSource = quests.OrderByDescending(x => x.ID).ToList(); CandidateList.DataBind(); } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }
protected void CandidateList_PageIndexChanging(object sender, GridViewPageEventArgs e) { var name = Name.Text; var degree = Degree.Value; var c = cond.Value; var course = Course.Text; var DegreeClass = ClassOfDegree.Value; var referal = Referal.Text; var age = Age.Text; IQueryable <QuizBook.Candidate> cands; if (!string.IsNullOrEmpty(name)) { cands = _db.Candidates.Where(s => (s.FirstName.Contains(name) || s.LastName.Contains(name))); } else { cands = _db.Candidates.AsQueryable(); } var quests = cands.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }); CandidateList.DataSource = quests.OrderByDescending(x => x.ID).ToList(); CandidateList.PageIndex = e.NewPageIndex; CandidateList.DataBind(); }
protected void CandidateList_Sorting(object sender, GridViewSortEventArgs e) { var name = Name.Text; var degree = Degree.Value; var c = cond.Value; var course = Course.Text; var DegreeClass = ClassOfDegree.Value; var referal = Referal.Text; var age = Age.Text; var cCode = code.Text; IQueryable <QuizBook.Candidate> cands; if (!string.IsNullOrEmpty(name)) { cands = _db.Candidates.Where(s => (s.FirstName.Contains(name) || s.LastName.Contains(name))); } else { cands = _db.Candidates.AsQueryable(); } var quests = cands.Select(a => new CandidateGridModel { ID = a.Id, TenantId = a.TenantId ?? 0, Username = a.Username, FirstName = a.FirstName, LastName = a.LastName, Sex = a.Sex, DOB = a.DOB == null ? "-" : a.DOB.Value.ToString("dd-MM-yyyy"), Status = a.Status ?? "-", Email = a.Email, D = a.Status == ErecruitHelper.CStatus.Active.ToString() ? "Deactivate" : "Activate", DateRegistered = a.DateCreated == null ? "-" : a.DateCreated.Value.ToString("dd-MM-yyyy") }).Distinct().ToList(); quests = quests.OrderByDescending(x => x.ID).ToList(); 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 "Code": if (e.SortDirection == SortDirection.Ascending) { quests = quests.OrderBy(s => s.Username).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } else { quests = quests.OrderByDescending(s => s.Username).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } break; case "FirstName": if (e.SortDirection == SortDirection.Ascending) { quests = quests.OrderBy(s => s.FirstName).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } else { quests = quests.OrderByDescending(s => s.FirstName).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } break; case "LastName": if (e.SortDirection == SortDirection.Ascending) { quests = quests.OrderBy(s => s.LastName).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } else { quests = quests.OrderByDescending(s => s.LastName).ToList(); CandidateList.DataSource = quests; CandidateList.DataBind(); } break; } }