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;
}
}
