private void LoadTestsForCandidate(QuizBookDbEntities1 _db) { //var ab = _db.T_Batch.Where(s => s.IsActive == true); //var abid = ab.Select(s => s.Id).ToList(); var tenant = long.Parse(SessionHelper.GetTenantID(Session)); var scopes = _db.T_CTestTracker.Where(s => s.Candidate.TenantId == tenant && s.InSession.Value == true && s.Finished.Value == false).ToList(); var myScopes = new List <BatchScopeContent>(); var quests = scopes.Where(x => x.T_Batch.EndDate != null && !(x.T_Batch.EndDate.Value < DateTime.Now)).OrderByDescending(s => s.BatchId).Select(a => new { ID = a.BatchId, trackerId = a.Id, CandidateName = a.Candidate.FirstName + " " + a.Candidate.LastName, CandidateStaffId = a.Candidate.Username ?? "-", Test = a.T_Batch.Name, Duration = a.T_Batch.Duration.Value, Rem = TimeSpan.FromSeconds(int.Parse(a.RemainingDuration)).ToString(@"hh\:mm\:ss"), st = a.CurrentStartTime, la = a.CurrentStartTime, Time = a.T_Batch.StartDate.Value.ToString("dd/MM/yyyy hh:mm:ss tt"), ETime = a.T_Batch.EndDate.Value.ToString("dd/MM/yyyy hh:mm:ss tt") }).Distinct().ToList(); GridView1.DataSource = quests; GridView1.DataBind(); }
public void SwitchActivityAction(QuizBookDbEntities1 _db, HttpContext context, string id) { var opt = _db.T_Candidate.FirstOrDefault(s => s.Id == long.Parse(id)); if (opt != null) { if (opt.IsActive != null && opt.IsActive.Value) { opt.IsActive = false; } else { opt.IsActive = true; } _db.SaveChanges(); context.Response.ContentType = "text/plain"; context.Response.Write("Successful"); } else { context.Response.ContentType = "text/plain"; context.Response.Write("Failed"); } }
public static string SwitchEssayActivity(string id) { QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var opt = _db.T_EssayQuestions.FirstOrDefault(s => s.Id == long.Parse(id)); if (opt != null) { if (opt.IsActive.Value) { opt.IsActive = false; opt.DateModified = DateTime.Now; } else { opt.IsActive = true; opt.DateModified = DateTime.Now; } _db.SaveChanges(); return("success"); } return("failed"); } catch (Exception ex) { return(ex.Message); } }
protected void tsname_TextChanged(object sender, EventArgs e) { var tsn = tsname.Text; using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var tn = _db.Tenants.FirstOrDefault(s => tsn.Trim().Equals(s.TenantCode)); if (tn != null) { var roles = _db.Roles.AsEnumerable().Where(x => x.Active && x.TenantId.HasValue && x.TenantId == tn.Id); if (roles.Count() > 0) { var rls = roles.OrderBy(s => s.Description).Select(a => new { Id = a.Id, Name = a.Description }).ToList(); rls.Insert(0, new { Id = long.Parse("-1"), Name = "--Class--" }); RoleList.DataSource = rls; RoleList.DataBind(); RoleList.Visible = true; } } } }
protected void lnkeditC_Click(object sender, EventArgs e) { LinkButton lnkeditC = ((LinkButton)sender); var p = lnkeditC.Parent; HiddenField hdfIDC = (HiddenField)p.FindControl("hdfIDC"); var idcr = long.Parse(hdfIDC.Value); using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var admin = _db.AdminUsers.FirstOrDefault(x => x.Id == idcr); if (admin != null) { adminId.Value = admin.Id.ToString(); firstname.Text = admin.FirstName; lname.Text = admin.LastName; dob.Text = admin.DOB == null ? string.Empty : admin.DOB.Value.ToString("dd/MM/yyyy"); Address.Text = admin.Address; username.Text = admin.Username; email.Text = admin.Email; sex.SelectedValue = admin.Sex; RoleList.SelectedValue = admin.Role.HasValue ? admin.Role.Value.ToString() : "-1"; supervisor.Checked = admin.Supervisor.HasValue ? admin.Supervisor.Value : false; country.Attributes.Add("data-default-value", admin.Country); state.Attributes.Add("data-default-value", admin.State); } } }
protected void regBtn_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(tnCode.Text)) { if (tnCode.Text.Length == 6) { QuizBookDbEntities1 _db = new QuizBookDbEntities1(); var tn = _db.Tenants.FirstOrDefault(s => s.TenantCode == tnCode.Text); if (tn != null) { SessionHelper.SetTenantID(tn.Id.ToString(), Session); SessionHelper.SetTenantName(tn.TenantName, Session); SessionHelper.SetTenantImage(tn.Image, Session); Response.Redirect("CandidateReg.aspx", false); } else { lblAlert.Text = "There is no tenant registered as '" + tnCode.Text + "'. Kindly verify and re-enter tenant code above."; } } else { lblAlert.Text = "Tenant code should be 6 characters. You have " + tnCode.Text.Length + ". Kindly verify."; } } else { lblAlert.Text = "Kindly fill in your tenant code above"; } }
public static string ResetMth(string name) { string keySalt = "QuizBook"; QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var pw = Guid.NewGuid().ToString(); var phrase = pw.Split('-')[0]; var qg = _db.Candidates.AsEnumerable().FirstOrDefault(s => s.Username.Trim() == name.Trim() || s.Email.Trim() == name.Trim()); //var qg = _db.T_QuestionType.FirstOrDefault(s => s.Id == long.Parse(id)); if (qg != null) { qg.LogInKey = ErecruitHelper.getHash(phrase.Trim(), keySalt.Trim()); qg.ModifiedBy = qg.Username; qg.DefaultLoginKeyChanged = false; qg.DateModified = DateTime.Now; _db.SaveChanges(); ErecruitHelper.sendPwReser(qg, " ", phrase); return("success"); } else { return("notexist"); } } catch (Exception ex) { return(ex.Message); } }
public static string DisableRole(string id) { var tenantId = long.Parse(SessionHelper.GetTenantID(HttpContext.Current.Session)); var userId = SessionHelper.FetchUserId(HttpContext.Current.Session); QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var rId = long.Parse(id); //var user = _db.AdminUsers.FirstOrDefault(x => x.Id == userId); var qg = _db.Roles.FirstOrDefault(s => s.TenantId == tenantId && s.Id == rId); if (qg != null) { qg.Active = false; qg.ModifiedBy = userId.ToString(); qg.DateModified = DateTime.Now; _db.SaveChanges(); HttpContext.Current.Session["NewSelRole"] = null; return("success"); } else { return("exist"); } } catch (Exception ex) { return(ex.Message); } }
public static string SwitchCandidateActivity(string id) { QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var opt = _db.Candidates.Where(s => s.Id == long.Parse(id)).FirstOrDefault(); if (opt != null) { if (opt.Status == ErecruitHelper.CStatus.Active.ToString()) { opt.Status = ErecruitHelper.CStatus.Inactive.ToString(); } else { opt.Status = ErecruitHelper.CStatus.Active.ToString(); } _db.SaveChanges(); return("success"); } return("failed"); } catch (Exception ex) { return(ex.Message); } }
public static string NewQuestionGroup(string id, string name) { var tenantId = long.Parse(SessionHelper.GetTenantID(HttpContext.Current.Session)); QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var qg = _db.T_QuestionType.FirstOrDefault(s => s.TenantId == tenantId && s.Name.ToLower().Trim() == id.ToLower().Trim()); if (qg == null) { _db.T_QuestionType.Add(new T_QuestionType { TenantId = tenantId, Name = id.Trim().ToUpper(), Description = id.Trim().ToUpper(), Status = true, AddedBy = name, DateAdded = DateTime.Now }); _db.SaveChanges(); return("success"); } else { return("exist"); } } catch (Exception ex) { return(ex.Message); } }
public static string DeleteQuestionGroup(string id, string name) { var tenantId = long.Parse(SessionHelper.GetTenantID(HttpContext.Current.Session)); QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var qg = _db.T_QuestionType.FirstOrDefault(s => s.Id == long.Parse(id)); if (qg != null) { var qs = _db.T_Question.Where(s => s.TypeId == qg.Id); qg.Status = false; foreach (var x in qs) { x.IsActive = false; } _db.SaveChanges(); return("success"); } else { return("notexist"); } } catch (Exception ex) { return(ex.Message); } }
protected void Button1_Click(object sender, EventArgs e) { using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var stid = staffId.Text; var tent = long.Parse(SessionHelper.GetTenantID(Session)); var cand = _db.Candidates.FirstOrDefault(s => s.Username == stid.Trim() && s.TenantId == tent); if (cand != null) { var actTest = _db.T_CTestTracker.AsEnumerable().Where(s => s.CandidateId == cand.Id && s.Finished == true).OrderByDescending(x => x.CurrentStartTime).Select(x => new { Name = x.T_Batch.Name, Candidate = x.CandidateId, Batch = x.BatchId, TimeFinished = ErecruitHelper.GetDateStringFromDate(x.CurrentStartTime.Value) }); CandidateTestList.DataSource = actTest.ToList(); CandidateTestList.DataBind(); DAlert.Visible = false; DMain.Visible = true; } else { var actTest = new List <object>(); CandidateTestList.DataSource = actTest.ToList(); CandidateTestList.DataBind(); //alert.InnerText = "This Candidate does not exist on the portal."; DAlert.Visible = false; DMain.Visible = true; } } }
protected void loginBtn_Click(object sender, EventArgs e) { var usName = username.Text; var psWord = password.Text; using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var user = _db.AdminUsers.FirstOrDefault(s => s.Username == usName); if (user != null) { string key = user.LogInKey; if (!string.IsNullOrEmpty(key) && !string.IsNullOrWhiteSpace(key)) { byte[] pw = ErecruitHelper.getByte(psWord, keySalt); byte[] pwFromDB = Convert.FromBase64String(key); if (ErecruitHelper.CompareByteArrays(pw, pwFromDB)) { if (user.Status.Trim() == ErecruitHelper.CStatus.Active.ToString()) { SessionHelper.SetEmail(user.Email, Session); SessionHelper.SetUserId((int)user.Id, Session); SessionHelper.SetUserName(user.Username, Session); if (user.TenantId == null) { SessionHelper.NullifyTenantID(Session); } else { SessionHelper.SetTenantID(user.TenantId.Value.ToString(), Session); SessionHelper.SetTenantName(user.Tenant.TenantName.ToString(), Session); } SessionHelper.SetLocation(user.Location, Session); SessionHelper.SetFirstName(user.FirstName, Session); SessionHelper.SetLastName(user.LastName, Session); var permissions = ErecruitHelper.GetAdminPermissions(_db, user); SessionHelper.SetUserPermissions(permissions, System.Web.HttpContext.Current.Session); //var adminObj = _db.Roles.FirstOrDefault(s => s.Description == "Admin"); var adminObj = _db.Roles.Select(s => s.Id).ToArray(); MB.FileBrowser.MagicSession.Current.FileBrowserAccessMode = IZ.WebFileManager.AccessMode.Write; if (user.Role.HasValue && adminObj.Contains(user.Role.Value)) { Response.Redirect("index.aspx", false); } else { Response.Redirect("TestLanding.aspx"); } } else { lblAlert.Text = string.Format("Your status is {0}. Kindly contact the Administartor", user.Status); } } } } } }
protected void loginBtn_Click(object sender, EventArgs e) { var usName = username.Text; var psWord = password.Text; QuizBookDbEntities1 _db = new QuizBookDbEntities1(); var user = _db.Candidates.FirstOrDefault(s => s.Username == usName); if (user != null) { string key = user.LogInKey; if (!string.IsNullOrEmpty(key) && !string.IsNullOrWhiteSpace(key)) { byte[] pw = ErecruitHelper.getByte(psWord, keySalt); byte[] pwFromDB = Convert.FromBase64String(key); if (ErecruitHelper.CompareByteArrays(pw, pwFromDB)) { if (user.Status.Trim() == ErecruitHelper.CStatus.Active.ToString()) { SessionHelper.SetEmail(user.Email, Session); SessionHelper.SetUserId((int)user.Id, Session); SessionHelper.SetUserName(user.Username, Session); if (user.TenantId == null) { SessionHelper.NullifyTenantID(Session); } else { SessionHelper.SetTenantID(user.TenantId.Value.ToString(), Session); } SessionHelper.SetLocation(user.Location, Session); SessionHelper.SetFirstName(user.FirstName, Session); SessionHelper.SetLastName(user.LastName, Session); var permissions = ErecruitHelper.GetuserPermissions(_db, user); SessionHelper.SetUserPermissions(permissions, System.Web.HttpContext.Current.Session); Response.Redirect("TestLanding.aspx"); } else { lblAlert.Text = string.Format("Your status is {0}. Kindly contact the Administartor", user.Status); } } else { lblAlert.Text = string.Format("Your password seems incorrect. Kindly check."); } } else { lblAlert.Text = string.Format("No password set."); } } else { lblAlert.Text = string.Format("Cannot find user in the System."); } }
//protected void preambleLists_SelectedIndexChanged(object sender, EventArgs e) //{ // try{ // var selectedQtype = long.Parse(DropDownList1.SelectedValue); // var t = _db.T_QuestionTypes.FirstOrDefault(s => s.Id == selectedQtype); // var QType = _db.T_Question.Select(s => s.PreambleId).Distinct(); // var Qt = _db.T_QuestionTypes.FirstOrDefault(s => s.Id == selectedQtype); // var QTypeCount = QType.Count(); // var QTC = QTypeCount++; // var selectedpreamble = long.Parse(preambleLists.SelectedValue); // if (selectedpreamble == 0) // { // PreambleName.Text = Qt.Name + " " + QTC; // preambleText.Text = ""; // PreamblePreview.Text = ""; // preview.Visible = false; // preambleRow.Visible = true; // preambleNameRow.Visible = true; // 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(); // } // else if (selectedpreamble != -1 && selectedpreamble != 0) // { // var id = QPid.Value; // //var Id = long.Parse(id); // //var cur = _db.T_Question.Where(s => s.Id == Id).FirstOrDefault(); // //var Qt = _db.T_QuestionTypes.FirstOrDefault(s => s.Id == cur.TypeId); // if (!(string.IsNullOrEmpty(id))) // { // var preamble = _db.T_QuestionPreamble.FirstOrDefault(s => s.Id == selectedpreamble); // PreamblePreview.Text =""; // PreambleNamePreview.Text = ""; // preview.Visible = false; // QPid.Value = preamble.Id.ToString(); // PreambleName.Text = preamble.Name; // preambleText.Text = preamble.Body; // preambleNameRow.Visible = true; // preambleRow.Visible = true; // } // else // { // var preamble = _db.T_QuestionPreamble.FirstOrDefault(s => s.Id == selectedpreamble); // PreambleName.Text = ""; // preambleText.Text = ""; // preambleNameRow.Visible = false; // preambleRow.Visible = false; // PreambleNamePreview.Text = preamble.Name; // PreamblePreview.Text = preamble.Body; // preview.Visible = true; // } // var quests = _db.T_Question.Where(x => x.PreambleId == selectedpreamble).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(); // } // else // { // PreambleName.Text = ""; // preambleText.Text = ""; // PreamblePreview.Text = ""; // PreambleNamePreview.Text = ""; // preview.Visible = false; // preambleNameRow.Visible = false; // // } // } // catch (Exception ex) // { // ErecruitHelper.SetErrorData(ex, Session); // Response.Redirect("ErrorPage.aspx", false); // } //} protected void lnkeditQ_Click(object sender, EventArgs e) { try { using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()){ LinkButton lnkedit = ((LinkButton)sender); var p = lnkedit.Parent; HiddenField hdfID = (HiddenField)p.FindControl("hdfIDQ"); var idcr = long.Parse(hdfID.Value); if (!(idcr == null)) { var opt = _db.T_Question.FirstOrDefault(s => s.Id == (idcr)); if (opt != null) { if (opt.IsActive.Value) { opt.IsActive = false; opt.DateModified = DateTime.Now; } else { opt.IsActive = true; opt.DateModified = DateTime.Now; } _db.SaveChanges(); var selectedQtype = long.Parse(DropDownList1.SelectedValue); var quests = _db.ActiveQuestions_vw.AsEnumerable().Where(x => x.TypeId == selectedQtype && x.TenantId == long.Parse(SessionHelper.GetTenantID(Session))).Select(a => new QuestionModel { ID = a.Id, Detail = a.Details, Type = a.Type, Preamble = a.Preamble, Section = a.Section, OptionType = a.OptionType, OptionsCount = a.OptionsCount.ToString(), 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) { try { // string currentPageFileName = new FileInfo(this.Request.Url.AbsolutePath).Name; var PermMgr = new PermissionManager(Session); if (PermMgr.IsAdmin || PermMgr.CanManageTestBatches) { //from.Text = ErecruitHelper.GetDateStringFromDateX(DateTime.Now); //to.Text = ErecruitHelper.GetDateStringFromDateX(DateTime.Now); if (!IsPostBack) { //var l = Enum.GetValues(typeof(ErecruitHelper.BatchGroupsR)).Cast<ErecruitHelper.BatchGroupsR>().ToList(); //var bg = l.Select(a => new //{ // Id = a.ToString(), // Name = a.ToString() //}).Distinct().OrderBy(s => s.Name).ToList(); //bgrp.DataSource = bg; // bgrp.DataBind(); var tn = long.Parse(SessionHelper.GetTenantID(Session)); var cands = new List <object> { new { ID = "ALL", Name = "ALL" } }; using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var batches = _db.T_Batch.Where(x => x.TenantId == tn && x.IsActive.Value).Select(x => new { ID = x.Id, Name = x.Name }).OrderByDescending(x => x.ID); GroupContentList.DataSource = batches.ToList(); GroupContentList.DataBind(); } } } else { Response.Redirect("NoPermission.aspx", false); } } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }
public static string PassCheck(string op, string xx) { string keySalt = "QuizBook"; QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var usName = SessionHelper.FetchUserName(HttpContext.Current.Session); var psWord = op; string key = ""; if (xx == "index") { var qg = _db.AdminUsers.AsEnumerable().FirstOrDefault(s => s.Username.Trim() == usName.Trim()); key = qg == null?"":qg.LogInKey; } else { var qg = _db.Candidates.AsEnumerable().FirstOrDefault(s => s.Username.Trim() == usName.Trim()); key = qg == null ? "" : qg.LogInKey; } if (!string.IsNullOrEmpty(key) && !string.IsNullOrWhiteSpace(key)) { byte[] pw = ErecruitHelper.getByte(psWord, keySalt); byte[] pwFromDB = Convert.FromBase64String(key); if (ErecruitHelper.CompareByteArrays(pw, pwFromDB)) { return("success"); } else { return("failed"); } } else { return("failed"); } } catch (Exception ex) { return(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { var permissions = ErecruitHelper.GetUserPermissions(Page.Session); var sid = SessionHelper.FetchStaffId(Page.Session); using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var user = _db.T_Candidate.FirstOrDefault(s => s.Code.Trim() == sid.Trim()); LoadTestsForCandidate(_db); // testPanel.Visible = true; } }
protected void lnkeditD_Click(object sender, EventArgs e) { LinkButton lnkeditD = ((LinkButton)sender); var p = lnkeditD.Parent; HiddenField hdfIDD = (HiddenField)p.FindControl("hdfIDD"); var idcr = long.Parse(hdfIDD.Value); var userId = SessionHelper.FetchUserId(Session); using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var admin = _db.AdminUsers.FirstOrDefault(x => x.Id == idcr); admin.Status = string.IsNullOrEmpty(admin.Status)?"Inactive":admin.Status.Trim() == "Active"?"Inactive": "Active"; admin.DateModified = DateTime.Now; _db.SaveChanges(); } Response.Redirect("Admins.aspx", false); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var tenantID = long.Parse(SessionHelper.GetTenantID(Session)); var roles = _db.Roles.AsEnumerable().Where(x => x.Active && x.TenantId.HasValue && x.TenantId == tenantID).ToList(); var rls = roles.OrderBy(s => s.Description).Select(a => new { Id = a.Id, Name = a.Description }).ToList(); rls.Insert(0, new { Id = long.Parse("-1"), Name = "--Select Role--" }); rl.DataSource = rls; rl.DataBind(); roleModel obj = new roleModel(); var rs = new List <roleModel>(); var rCount = 0; foreach (var a in roles) { obj = new roleModel(); obj.ID = a.Id; obj.Role = a.Description; obj.CreatedBy = string.IsNullOrEmpty(a.CreatedBy) ? "" : a.CreatedBy; obj.DateCreated = a.DateCreated.HasValue ? a.DateCreated.Value.ToString("dd-MM-yyyy") : ""; obj.ModifiedBy = string.IsNullOrEmpty(a.ModifiedBy) ? "" : a.ModifiedBy; obj.DateModified = a.DateModified.HasValue ? a.DateModified.Value.ToString("dd-MM-yyyy") : ""; rs.Add(obj); rCount++; } TotalRecCount.Text = rCount + " Role(s)"; RoleList.DataSource = rs; RoleList.DataBind(); } } }
public static string deleteQuestOption(string id) { QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var optId = long.Parse(id); var opt = _db.T_Option.FirstOrDefault(s => s.Id == optId); if (opt != null) { _db.T_Option.Remove(opt); _db.SaveChanges(); return("success"); } return("failed"); } catch (Exception ex) { return(ex.Message); } }
protected void lnkeditCa_Click(object sender, EventArgs e) { LinkButton lnkedit = ((LinkButton)sender); var p = lnkedit.Parent; HiddenField hdfID = (HiddenField)p.FindControl("hdfIDCa"); var idcr = long.Parse(hdfID.Value); using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var tracker = _db.T_CTestTracker.FirstOrDefault(s => s.Id == idcr); if (tracker != null) { tracker.LastQIndex = 0; tracker.CurrentStartTime = DateTime.Now; tracker.InSession = false; tracker.Finished = true; _db.SaveChanges(); } } Response.Redirect("ActiveCandidates.aspx", false); }
public void ProcessRequest(HttpContext context) { // Those parameters are sent by the plugin QuizBookDbEntities1 _db = new QuizBookDbEntities1(); var action = context.Request["action"]; var qtS = context.Request["qtypeSort"]; var alink = context.Request["z"]; //var alink = context.Session["thelink"]!=null?context.Session["thelink"].ToString():""; var iDisplayLength = context.Request["iDisplayLength"]; var iDisplayStart = context.Request["iDisplayStart"]; var iSortCol = context.Request["iSortCol_0"]; var iSortDir = context.Request["sSortDir_0"]; var iSearch = context.Request["sSearch"]; var isEcho = context.Request["sEcho"]; switch (action) { case "SwitchActivity": var id = context.Request["id"]; SwitchActivityAction(_db, context, id); break; case "CandidateList": CandidatesGridDataLoad(_db, context, iSearch, iSortCol, iSortDir, iDisplayStart, iDisplayLength, isEcho); break; case "QuestList": QuestionGridDataLoad(_db, context, iSearch, iSortCol, iSortDir, iDisplayStart, iDisplayLength, isEcho, qtS); break; case "QuestOptList": OptionGridDataLoad(_db, context, iSearch, iSortCol, iSortDir, iDisplayStart, iDisplayLength, isEcho, alink); break; case "QuestTypeList": QtypeGridDataLoad(_db, context, iSearch, iSortCol, iSortDir, iDisplayStart, iDisplayLength, isEcho); break; } }
public void QuestionGridDataLoad(QuizBookDbEntities1 _db, HttpContext context, string iSearch, string iSortCol2, string iSortDir, string iDisplayStart2, string iDisplayLength2, string isEcho, string qtS) { var iDisplayLength = int.Parse(iDisplayLength2); var iDisplayStart = int.Parse(iDisplayStart2); var iSortCol = int.Parse(iSortCol2); var quests = new List <QuestionModel>(); if (qtS == "null") { quests = _db.T_Question.OrderByDescending(x => x.DateAdded).Select(a => new QuestionModel { ID = a.Id, Detail = string.IsNullOrEmpty(a.Details) ? "Empty" : "<div class='box'>" + a.Details.Trim() + "</div>", Type = ErecruitHelper.getTypeName(_db, a.TypeId), OptionType = ErecruitHelper.getOptionTypeName(_db, a.OptionType), OptionsCount = ErecruitHelper.getOptionNumLink(_db, a.Id, a.Id), IsActive = a.IsActive.Value ? "Yes" : "No", Edit = "<a href='QuestionsList.aspx?z=" + a.Id + "' >Edit</a>", D = a.IsActive.Value ? "<a href='#' >Deactivate</a>" : "<a href='#' >Activate</a>" }).ToList(); } else { quests = _db.T_Question.Where(s => s.TypeId == long.Parse(qtS)).OrderByDescending(x => x.DateAdded).Select(a => new QuestionModel { ID = a.Id, Detail = string.IsNullOrEmpty(a.Details) ? "Empty" : "<div class='box'>" + a.Details.Trim() + "</div>", Type = ErecruitHelper.getTypeName(_db, a.TypeId), OptionType = ErecruitHelper.getOptionTypeName(_db, a.OptionType), OptionsCount = ErecruitHelper.getOptionNumLink(_db, a.Id, a.Id), IsActive = a.IsActive.Value ? "Yes" : "No", Edit = "<a href='QuestionsList.aspx?z=" + a.Id + "' >Edit</a>", D = a.IsActive.Value ? "<a href='#' >Deactivate</a>" : "<a href='#' >Activate</a>" }).Distinct().ToList(); } //Searching IEnumerable <QuestionModel> f; if (!string.IsNullOrEmpty(iSearch)) { f = quests .Where(c => c.ID.ToString().ToLower().Contains(iSearch.ToLower()) || c.Detail.ToLower().Contains(iSearch.ToLower()) || c.Type.ToLower().Contains(iSearch.ToLower()) || c.OptionType.ToLower().Contains(iSearch.ToLower()) || c.OptionsCount.ToLower().Contains(iSearch.ToLower()) || c.IsActive.ToLower().Contains(iSearch.ToLower()) || c.Edit.ToLower().Contains(iSearch.ToLower()) || c.D.ToLower().Contains(iSearch.ToLower()) ); } else { f = quests; } // Sorting var its = f; var sortCIndex = Convert.ToInt32(iSortCol); // Func<BDCCustomerGridModel, string> orderingFunction = (c => c.id.ToString()); Func <QuestionModel, string> orderingFunct = (c => sortCIndex == 0 ? c.ID.ToString() : sortCIndex == 1 ? c.Detail : sortCIndex == 2 ? c.Type : sortCIndex == 3 ? c.OptionType : sortCIndex == 4 ? c.OptionsCount : sortCIndex == 5 ? c.IsActive : sortCIndex == 6 ? c.Edit : sortCIndex == 7 ? c.D : "" ); //? sortColumnIndex == 2 ? c.Title :c.StartDate var sortDirect = iSortDir; // asc or desc f = sortDirect == "asc" ? f.OrderBy(orderingFunct) : f.OrderByDescending(orderingFunct); //Paging var displ = f .Skip(iDisplayStart) .Take(iDisplayLength); //Table Construction var thelst = from s in displ select new[] { s.ID.ToString(), s.Detail, s.Type, s.OptionType, s.IsActive, s.OptionsCount, s.Edit, s.D }; var r = new { sEcho = isEcho, iTotalRecords = quests.Count(), iTotalDisplayRecords = thelst.Count(), aaData = thelst.ToList() }; var srlizer = new JavaScriptSerializer(); var jsonObj = srlizer.Serialize(r); context.Response.ContentType = "application/json"; context.Response.Write(jsonObj); }
public static string ChangePass(string op, string xx) { string keySalt = "QuizBook"; QuizBookDbEntities1 _db = new QuizBookDbEntities1(); try { var usName = SessionHelper.FetchUserName(HttpContext.Current.Session); var psWord = op; string key = ""; if (xx == "index") { var qg = _db.AdminUsers.AsEnumerable().FirstOrDefault(s => s.Username.Trim() == usName.Trim()); if (qg == null) { return("failed"); } else { qg.LogInKey = ErecruitHelper.getHash(psWord.Trim(), keySalt.Trim()); qg.DefaultLoginKeyChanged = true; qg.DateModified = DateTime.Now; _db.SaveChanges(); return("success"); } } else { var qg = _db.Candidates.AsEnumerable().FirstOrDefault(s => s.Username.Trim() == usName.Trim()); if (qg == null) { return("failed"); } else { qg.LogInKey = ErecruitHelper.getHash(psWord.Trim(), keySalt.Trim()); qg.ModifiedBy = qg.Username; qg.DateModified = DateTime.Now; _db.SaveChanges(); return("success"); } } //if (!string.IsNullOrEmpty(key) && !string.IsNullOrWhiteSpace(key)) //{ // byte[] pw = ErecruitHelper.getByte(psWord, keySalt); // byte[] pwFromDB = Convert.FromBase64String(key); //if (ErecruitHelper.CompareByteArrays(pw, pwFromDB)) //{ // return "success"; //} //else //{ // return "failed"; //} //} //else //{ // return "failed"; //} } catch (Exception ex) { return(ex.Message); } }
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 regBtn_Click(object sender, EventArgs e) { try { var page = Page.IsValid; var tsn = tsname.Text; var fn = fname.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; //var ste = Request[state.UniqueID].ToString(); //var ctry = Request[country.UniqueID].ToString(); var pw = Request["userPw"].ToString(); var cpw = Request["userPw2"].ToString(); var lctn = Request[Location.UniqueID].ToString(); var role = RoleList.Visible ? RoleList.SelectedValue : null; using (QuizBookDbEntities1 _db = new QuizBookDbEntities1()) { var tn = _db.Tenants.FirstOrDefault(s => tsn.Trim().Equals(s.TenantCode)); if (tn != null) { if (pw.Trim() == cpw.Trim()) { long?n = null; var rl = _db.Roles.FirstOrDefault(s => s.Description == "Candidate"); _db.Candidates.Add(new QuizBook.Candidate { 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(), Email = emailvar, TenantId = tn.Id, Role = rl.Id, Status = ErecruitHelper.CStatus.Active.ToString(), DateCreated = DateTime.Now, CreatedBy = "QuizBook", Captcha = Page.IsValid, Class = role == null?n:long.Parse(role), DefaultLoginKeyChanged = true, LogInKey = ErecruitHelper.getHash(pw, keySalt), IpAddress = ErecruitHelper.GetIP(HttpContext.Current) }); _db.SaveChanges(); Session["InfoValue"] = "Your Profile has been successfully saved. Kindly <a href='CandLogin.aspx'>click here</a> to proceed."; Response.Redirect("Info.aspx", false); } else { lblAlert.Text = "Registration Failed. Your passwords did not match"; } } else { lblAlert.Text = "Registration Failed. Kindly ensure you have the correct Tenant Code."; } } } catch (Exception ex) { SessionHelper.SetExMessage(ex.Message, Session); SessionHelper.SetExStacktrace(ex.StackTrace, Session); Response.Redirect("ExceptionPage.aspx", false); } }
public void CandidatesGridDataLoad(QuizBookDbEntities1 _db, HttpContext context, string iSearch, string iSortCol1, string iSortDir, string iDisplayStart1, string iDisplayLength1, string isEcho) { var iDisplayLength = int.Parse(iDisplayLength1); var iDisplayStart = int.Parse(iDisplayStart1); var iSortCol = int.Parse(iSortCol1); var data = _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") }).ToList(); //Searching IEnumerable <CandidateGridModel> filtered; if (!string.IsNullOrEmpty(iSearch)) { filtered = data .Where(c => c.Username.ToLower().Contains(iSearch.ToLower()) || c.FirstName.ToLower().Contains(iSearch.ToLower()) || c.LastName.ToLower().Contains(iSearch.ToLower()) || c.D.ToLower().Contains(iSearch.ToLower()) ); } else { filtered = data; } // Sorting var items = filtered; var sortColumnIndex = Convert.ToInt32(iSortCol); // Func<BDCCustomerGridModel, string> orderingFunction = (c => c.id.ToString()); Func <CandidateGridModel, string> orderingFunction = (c => sortColumnIndex == 0 ? c.Username : sortColumnIndex == 1 ? c.FirstName : sortColumnIndex == 2 ? c.LastName : sortColumnIndex == 8 ? c.D : "" ); //? sortColumnIndex == 2 ? c.Title :c.StartDate var sortDirection = iSortDir; // asc or desc filtered = sortDirection == "asc" ? filtered.OrderBy(orderingFunction) : filtered.OrderByDescending(orderingFunction); //Paging var displayed = filtered .Skip(iDisplayStart) .Take(iDisplayLength); //Table Construction var thelist = from s in displayed select new[] { s.Username, s.FirstName, s.LastName, s.D, s.DateRegistered.ToString() }; var result = new { sEcho = isEcho, iTotalRecords = data.Count(), iTotalDisplayRecords = thelist.Count(), aaData = thelist.ToList() }; var serializer = new JavaScriptSerializer(); var json = serializer.Serialize(result); context.Response.ContentType = "application/json"; context.Response.Write(json); }
public void QtypeGridDataLoad(QuizBookDbEntities1 _db, HttpContext context, string iSearch, string iSortCol3, string iSortDir, string iDisplayStart3, string iDisplayLength3, string isEcho) { var iDisplayLength = int.Parse(iDisplayLength3); var iDisplayStart = int.Parse(iDisplayStart3); var iSortCol = int.Parse(iSortCol3); //var options = _db.T_QuestionTypes.Select(a => new QuestionTypeModel //{ // Id = a.Id.ToString(), // Name = string.IsNullOrEmpty(a.Name) ? "Empty" : a.Name.Trim(), // Status = a.Status.Value ? "Yes" : "No", // Action = a.Status.Value ? "<a href='#'>Activate</a>" : "<a href='#'>Deactivate</a>" //}).ToList(); var options = _db.T_QuestionType.Select(a => new QuestionTypeModel { Id = "-", Name = "3", Status = "No", Action = "YES" }).ToList(); //Searching IEnumerable <QuestionTypeModel> fopt; if (!string.IsNullOrEmpty(iSearch)) { fopt = options .Where(c => c.Id.ToLower().Contains(iSearch.ToLower()) || c.Name.ToLower().Contains(iSearch.ToLower()) || c.Status.ToLower().Contains(iSearch.ToLower()) || c.Action.ToLower().Contains(iSearch.ToLower()) ); } else { fopt = options; } // Sorting var itOpt = fopt; var sortOptIndex = Convert.ToInt32(iSortCol); Func <QuestionTypeModel, string> orderingOptFunct = (c => sortOptIndex == 0 ? c.Id.ToString() : sortOptIndex == 1 ? c.Name : sortOptIndex == 5 ? c.Status : sortOptIndex == 7 ? c.Action: "" ); //? sortColumnIndex == 2 ? c.Title :c.StartDate var sortOptDirect = iSortDir; // asc or desc fopt = sortOptDirect == "asc" ? fopt.OrderBy(orderingOptFunct) : fopt.OrderByDescending(orderingOptFunct); //Paging var displOpt = fopt .Skip(iDisplayStart) .Take(iDisplayLength); //Table Construction var thelstOpt = from s in displOpt select new[] { s.Id.ToString(), s.Name, s.Status, s.Action }; var rOpt = new { sEcho = isEcho, iTotalRecords = options.Count(), iTotalDisplayRecords = thelstOpt.Count(), aaData = thelstOpt.ToList() }; var srlizerOpt = new JavaScriptSerializer(); var jsonObjOpt = srlizerOpt.Serialize(rOpt); context.Response.ContentType = "application/json"; context.Response.Write(jsonObjOpt); }
public void OptionGridDataLoad(QuizBookDbEntities1 _db, HttpContext context, string iSearch, string iSortCol3, string iSortDir, string iDisplayStart3, string iDisplayLength3, string isEcho, string alink) { var iDisplayLength = int.Parse(iDisplayLength3); var iDisplayStart = int.Parse(iDisplayStart3); var iSortCol = int.Parse(iSortCol3); var options = _db.T_Option.AsEnumerable().Where(s => s.Q_Id == long.Parse(alink)).Select(a => new QuestionOptionModel { ID = a.Id.ToString(), Detail = string.IsNullOrEmpty(a.Details) ? "Empty" : a.Details.Trim(), Answer = (a.Answer.Value.ToString()), E = "<a href='QuestionOptions.aspx?z=" + a.Id + "' >Edit</a>", D = "<a href='#'>Delete</a>" }).ToList(); //Searching IEnumerable <QuestionOptionModel> fopt; if (!string.IsNullOrEmpty(iSearch)) { fopt = options .Where(c => c.ID.ToLower().Contains(iSearch.ToLower()) || c.Detail.ToLower().Contains(iSearch.ToLower()) || c.Answer.ToLower().Contains(iSearch.ToLower()) || c.E.ToLower().Contains(iSearch.ToLower()) || c.D.ToLower().Contains(iSearch.ToLower()) ); } else { fopt = options; } // Sorting var itOpt = fopt; var sortOptIndex = Convert.ToInt32(iSortCol); Func <QuestionOptionModel, string> orderingOptFunct = (c => sortOptIndex == 0 ? c.ID.ToString() : sortOptIndex == 1 ? c.Detail : sortOptIndex == 5 ? c.Answer : sortOptIndex == 6 ? c.E : sortOptIndex == 7 ? c.D : "" ); //? sortColumnIndex == 2 ? c.Title :c.StartDate var sortOptDirect = iSortDir; // asc or desc fopt = sortOptDirect == "asc" ? fopt.OrderBy(orderingOptFunct) : fopt.OrderByDescending(orderingOptFunct); //Paging var displOpt = fopt .Skip(iDisplayStart) .Take(iDisplayLength); //Table Construction var thelstOpt = from s in displOpt select new[] { s.ID.ToString(), s.Detail, s.Answer, s.E, s.D }; var rOpt = new { sEcho = isEcho, iTotalRecords = options.Count(), iTotalDisplayRecords = thelstOpt.Count(), aaData = thelstOpt.ToList() }; var srlizerOpt = new JavaScriptSerializer(); var jsonObjOpt = srlizerOpt.Serialize(rOpt); context.Response.ContentType = "application/json"; context.Response.Write(jsonObjOpt); }