protected void Page_Load(object sender, EventArgs e) { this.CurrentMentor = (Models.Mentor)Session["Account"]; if (!Page.IsPostBack) { using (var context = new DatabaseContext()) { context.Student .Include(s => s.Mentor) .ToList().ForEach(s => { if (s.Mentor.ID == CurrentMentor.ID) { cblStudents.Items.Add(new ListItem { Text = " " + s.Name, Value = s.ID.ToString(), Selected = s.Status.Equals("Y") }); } }); } } }
protected void Password2Validate(object source, ServerValidateEventArgs args) { using (var context = new DatabaseContext()) { Models.Mentor mentor = context.Mentor .Single(s => s.ID == CurrentMentor.ID); args.IsValid = mentor.Password.Equals(txtPassword.Text); } }
public void btnSubmit_Click(Object sender, EventArgs e) { if (Page.IsValid) { using (var context = new DatabaseContext()) { Models.Mentor mentor = context.Mentor .Single(s => s.ID == CurrentMentor.ID); mentor.Password = txtNewPassword.Text; context.SaveChanges(); lblInfo.CssClass = "text-success"; lblInfo.Text = "levi-o-sa! your password has now changed."; } } }
protected void Page_Load(object sender, EventArgs e) { this.CurrentMentor = (Models.Mentor)Session["Account"]; if (!Page.IsPostBack) { IsSearch = Request.QueryString["search"] != null; Reset(); if (IsSearch) { using (var context = new DatabaseContext()) { string name = Request.QueryString["name"].ToLower(); string course = Request.QueryString["course"].ToLower(); bool menteeOnly = Request.QueryString["mentee_only"].Equals("True"); List <int> skills = Request.QueryString["skills"].Length > 0 ? Request.QueryString["skills"].Split(',').Select(int.Parse).ToList() : new List <int>(); var query = context.Student .Include(s => s.StudentSkillSets) .ThenInclude(ss => ss.SkillSet) .Include(s => s.Mentor) .Where(s => s.Name.ToLower().Contains(name)) .Where(s => s.Course.ToLower().Contains(course)); if (skills.Count > 0) { query = query.Where(s => s.StudentSkillSets.Any(ss => skills.Contains(ss.SkillSet.ID))); } if (menteeOnly) { query = query.Where(s => s.Mentor.ID == CurrentMentor.ID); } SearchResults = query.ToList(); } } } }
protected void btnCreate_Click(object sender, EventArgs e) { string type = rblAccountType.SelectedValue; using (var context = new DatabaseContext()) { if (Page.IsValid) { if (type == "Mentor") { Models.Mentor mentor = new Models.Mentor() { Name = txtName.Text, EmailAddress = txtEmail.Text, Password = txtPassword.Text }; context.Add(mentor); } if (type == "Student") { Models.Student student = new Models.Student(); student.Name = txtName.Text; student.EmailAddress = txtEmail.Text; student.Password = txtPassword.Text; student.Course = txtCourse.Text; student.Status = "N"; student.Mentor = context.Mentor.Single(m => m.Name.Equals(ddlMentor.SelectedValue)); context.Add(student); } ; Response.Redirect("/Pages/Settings.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { this.CurrentMentor = (Models.Mentor)Session["Account"]; }