private void BindClassDetails(int classID) { string constr = ConfigurationManager.ConnectionStrings["CS414_FasTestConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (con) { using (SqlCommand getcmd = new SqlCommand("Get_Class_Details", con)) { con.Open(); //Get details for the selected class SqlDataAdapter da = new SqlDataAdapter(getcmd); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@pClassID", Convert.ToInt32(classID)); DataSet ds = new DataSet(); da.Fill(ds, "Assignment"); ClassInformation.DataSource = ds.Tables["Assignment"]; ClassInformation.DataBind(); da.Dispose(); con.Close(); } } } ClassStudents.SelectParameters["pClassID"].DefaultValue = classID.ToString(); ClassStudents.DataBind(); StudentsEnrolledgrid.DataBind(); }
public void Fill(int quantityBeds) { while (ClassStudents.Count() < quantityBeds) { ClassStudents.Add(new ClassStudentDto(StudentDto.StudentFree, false)); } }
public async Task <ClassStudents> GetClassRegisterByClassIdAsync(int classId) { await ClassShouldExistAsync(classId); var list = await classRegisterRepository.GetAllStudentsByClassAsync(classId); if (list.Any()) { // Would normally use a library like AutoMapper for these kinds of mapping operations, // but this is so simple in this case it was not deemed practical var students = new List <Student>(); foreach (var classRegister in list) { students.Add(new Student { StudentId = classRegister.StudentId, FirstName = classRegister.FirstName, LastName = classRegister.LastName }); } var classStudents = new ClassStudents { Class = new Class { ClassId = classId, ClassName = list.First().ClassName }, Students = students }; return(classStudents); } return(null); }
protected void GridViewStudents_PageIndexChanging(object sender, GridViewPageEventArgs e) { ClassStudents searchStudent = new ClassStudents(); searchStudent.SearchStudent(ddStudentSearch, txStudentSearch, GridViewStudents); GridViewStudents.PageIndex = e.NewPageIndex; GridViewStudents.DataBind(); }
protected void GridViewStudentModules_PageIndexChanging(object sender, GridViewPageEventArgs e) { ClassStudents loadGradeDetails = new ClassStudents(); loadGradeDetails.LoadStudentGradesToStudentGrade(GridViewStudents, GridViewStudentModules); GridViewStudentModules.PageIndex = e.NewPageIndex; GridViewStudentModules.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ClassStudents loadDetails = new ClassStudents(); loadDetails.LoadStudentDetailsToStudentGrade(GridViewStudents); } }
protected void btnUpdateStudentSubmit_Click(object sender, EventArgs e) { ClassStudents updateStudent = new ClassStudents(); updateStudent.UpdateStudent(this); string messageString = txUpdateFirstName.Text + " " + txUpdateLastName.Text + " has successfully updated."; ClientScript.RegisterStartupScript(this.GetType(), "Successful", "alert('" + messageString + "'); window.location='Students.aspx';", true); }
protected void btnAddStudentSubmit_Click(object sender, EventArgs e) { Label lblAddedBy = this.Master.FindControl("lblLoggedInUser") as Label; ClassStudents addStudent = new ClassStudents(); addStudent.AddNewStudent(this, lblAddedBy, lblAddAlert); string messageString = txAddFirstName.Text + " " + txAddLastName.Text + " has successfully registered. Student ID is " + txAddStudentId.Text; ClientScript.RegisterStartupScript(this.GetType(), "Successful", "alert('" + messageString + "'); window.location='Students.aspx';", true); }
protected void GridViewStudentObtainedGrades_PageIndexChanging(object sender, GridViewPageEventArgs e) { Label lblloggedInStudent = this.Master.FindControl("lblLoggedInUser") as Label; lblloggedInStudent.Text = Session["loggedInUser"].ToString(); ClassStudents loadObtainedGrades = new ClassStudents(); loadObtainedGrades.LoadStudentGradesToStudentGrade(GridViewStudentObtainedGrades, lblloggedInStudent); GridViewStudentObtainedGrades.PageIndex = e.NewPageIndex; GridViewStudentObtainedGrades.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["loggedInUser"] == null) { Response.Redirect("login.aspx"); } else { Label lblloggedInStudent = this.Master.FindControl("lblLoggedInUser") as Label; lblloggedInStudent.Text = Session["loggedInUser"].ToString(); ClassStudents loadObtainedGrades = new ClassStudents(); loadObtainedGrades.LoadStudentGradesToStudentGrade(GridViewStudentObtainedGrades, lblloggedInStudent); loadObtainedGrades.CalculateStudentAverageScore(GridViewStudentObtainedGrades, lblAverageScore); } }
public ActionResult Join(int id) { int uid = HttpContext.Session.GetInt32("userId").Value; var r = _context.ClassStudents.Select(x => x).Where(x => x.ClassId == id && x.StudentId == uid).FirstOrDefault(); ClassStudents classStudents = new ClassStudents { ClassId = id, StudentId = uid }; if (r == null) { _context.ClassStudents.Add(classStudents); _context.SaveChanges(); } ViewBag.classId = id; var classname = _context.Class.Select(x => x).Where(x => x.Id == id).FirstOrDefault().Name; HttpContext.Session.SetString("ClassName", classname); HttpContext.Session.SetInt32("classid", id); var messages = from x in _context.Chat where x.ClassId == id select x; var files = from x in _context.FileStorage where x.ClassId == id select x; var cid = from x in _context.Class where x.Id == id select x.CreatorId; JoinViewModel joinViewModel = new JoinViewModel { Chats = messages.ToList(), FileStorages = files.ToList() , CreatorId = cid.FirstOrDefault().HasValue ? cid.FirstOrDefault().Value : 0 }; return(View(joinViewModel)); }
protected void btnStudentSearch_Click(object sender, EventArgs e) { ClassStudents searchStudent = new ClassStudents(); searchStudent.SearchStudent(ddStudentSearch, txStudentSearch, GridViewStudents); }
protected void Page_Load(object sender, EventArgs e) { ClassStudents generateId = new ClassStudents(); txAddStudentId.Text = generateId.GenerateStudentId(); }
protected void GridViewStudents_SelectedIndexChanged(object sender, EventArgs e) { ClassStudents loadGradeDetails = new ClassStudents(); loadGradeDetails.LoadStudentGradesToStudentGrade(GridViewStudents, GridViewStudentModules); }