protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadDDLs(); if (CurrentCheckedStudent != 0) { //BindData(); DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetStudent(CurrentCheckedStudent); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentsAbsence.DataSource = db.GetMonthlyAttendanceReportByStudentID(CurrentCheckedStudent); uiGridViewStudentsAbsence.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(CurrentCheckedStudent); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentsAbsence.DataSource = db.GetMonthlyAttendanceReportByStudentID(CurrentCheckedStudent); uiGridViewStudentsAbsence.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 == "EditReports") { int id = Convert.ToInt32(e.CommandArgument.ToString()); CurrentCheckedStudent = id; DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetStudent(CurrentCheckedStudent); if (ds.Tables[0].Rows.Count > 0) { uiGridViewStudentsAbsence.DataSource = db.GetMonthlyAttendanceReportByStudentID(CurrentCheckedStudent); uiGridViewStudentsAbsence.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; } }