protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadDDLs(); if (CurrentActiveStudent != 0) { //BindData(); DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetStudent(CurrentActiveStudent); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentResults.DataSource = db.GetResultByStudentIDAndSchoolYearForAdmin(CurrentActiveStudent, Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); uiGridViewStudentResults.DataBind(); uiLabelStudentName.Text = ds.Tables[0].Rows[0]["ArStudentName"].ToString() + ds.Tables[0].Rows[0]["ArFatherName"].ToString(); DataSet StudentClassRoom = new DataSet(); StudentClassRoom = db.GetClassRoom(Convert.ToInt32(ds.Tables[0].Rows[0]["ClassRoomID"].ToString())); DataSet StudentClass = new DataSet(); StudentClass = db.GetClass(Convert.ToInt32(StudentClassRoom.Tables[0].Rows[0]["ClassID"].ToString())); uiLabelClass.Text = StudentClass.Tables[0].Rows[0]["ArName"].ToString(); } uiPanelCurrentStudents.Visible = false; uiPanelCurrent.Visible = true; } else { uiPanelCurrentStudents.Visible = true; uiPanelCurrent.Visible = false; BindStudentData(); } } }
private void BindData() { DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetStudent(CurrentActiveStudent); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentResults.DataSource = db.GetResultByStudentIDAndSchoolYearForAdmin(CurrentActiveStudent, Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); uiGridViewStudentResults.DataBind(); uiLabelStudentName.Text = ds.Tables[0].Rows[0]["ArStudentName"].ToString() + ds.Tables[0].Rows[0]["ArFatherName"].ToString(); DataSet StudentClassRoom = new DataSet(); StudentClassRoom = db.GetClassRoom(Convert.ToInt32(ds.Tables[0].Rows[0]["ClassRoomID"].ToString())); DataSet StudentClass = new DataSet(); StudentClass = db.GetClass(Convert.ToInt32(StudentClassRoom.Tables[0].Rows[0]["ClassID"].ToString())); uiLabelClass.Text = StudentClass.Tables[0].Rows[0]["ArName"].ToString(); } uiPanelCurrentStudents.Visible = false; uiPanelCurrent.Visible = true; }
protected void uiGridViewStudents_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditResults") { int id = Convert.ToInt32(e.CommandArgument.ToString()); CurrentActiveStudent = id; DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetStudent(id); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentResults.DataSource = db.GetResultByStudentIDAndSchoolYearForAdmin(CurrentActiveStudent, Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); uiGridViewStudentResults.DataBind(); uiLabelStudentName.Text = ds.Tables[0].Rows[0]["ARStudentName"].ToString() + " " + ds.Tables[0].Rows[0]["ArFatherName"].ToString(); DataSet StudentClassRoom = new DataSet(); StudentClassRoom = db.GetClassRoom(Convert.ToInt32(ds.Tables[0].Rows[0]["ClassRoomID"].ToString())); DataSet StudentClass = new DataSet(); StudentClass = db.GetClass(Convert.ToInt32(StudentClassRoom.Tables[0].Rows[0]["ClassID"].ToString())); uiLabelClass.Text = StudentClass.Tables[0].Rows[0]["ArName"].ToString(); } uiPanelCurrentStudents.Visible = false; uiPanelCurrent.Visible = true; } }