private void fillDataForm(int ID)
{
PullCourseClass obj = new PullCourseClass();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataRow dr = obj.drgetform(id);
if (dr != null)
{
int STUid = Convert.ToInt32(dr["StudentID"].ToString());
Studnets objStu = new Studnets();
DataRow Stu = objStu.drSearchStudent(STUid);
if (Stu != null)
{
labStudentName.Text = Stu["StudentName"].ToString();
labStudentNmuber.Text = Stu["UniversityID"].ToString();
labSectionStudent.Text = Stu["SectionName"].ToString();
labCollage.Text = Stu["CollageName"].ToString();
}
labDate.Text = dr["Date"].ToString();
txtTimeCourse1.Text = dr["Course1time"].ToString();
txtTimeCourse2.Text = dr["Course2time"].ToString();
txtTimeCourse3.Text = dr["Course3time"].ToString();
txtReason.Text = dr["Description"].ToString();
txtNmberHours.Text = dr["NumHourRegester"].ToString();
txtNumHourAfter.Text = dr["NumAfterPull"].ToString();
txtNumCourse1.Text = dr["Subject1ID"].ToString();
txtNumCourse2.Text = dr["Subject2ID"].ToString();
txtNumCourse3.Text = dr["Subject3ID"].ToString();
string Year = dr["Year"].ToString();
string Semester = dr["Semester"].ToString();
RegistredCourses Subj = new RegistredCourses();
if (Convert.ToInt32(txtNumCourse1.Text.ToString()) != 0)
{
int Course1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course1, Year, Semester);
labTeacher1.Text = Sub["EmployeeName"].ToString();
ddlNameCourse1.SelectedValue = txtNumCourse1.Text.ToString();
//ddlNameCourse1.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtNumCourse2.Text.ToString()) != 0)
{
int Course2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course2, Year, Semester);
labTeacher2.Text = Sub["EmployeeName"].ToString();
//ddlNameCourse2.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
ddlNameCourse2.SelectedValue = txtNumCourse2.Text.ToString();
}
if (Convert.ToInt32(txtNumCourse3.Text.ToString()) != 0)
{
int Course3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course3, Year, Semester);
labTeacher3.Text = Sub["EmployeeName"].ToString();
//ddlNameCourse3.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
ddlNameCourse3.SelectedValue = txtNumCourse3.Text.ToString();
}
}
}
private void fillData()
{
AbsenceExam obj = new AbsenceExam();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataRow dr = obj.drgetform(id);
if (dr != null)
{
int STUid = Convert.ToInt32(dr["StudentID"].ToString());
Studnets objStu = new Studnets();
DataRow Stu = objStu.drSearchStudent(STUid);
if (Stu != null)
{
labStudentName.Text = Stu["StudentName"].ToString();
labNumberStudent.Text = Stu["UniversityID"].ToString();
labSectionStudent.Text = Stu["SectionName"].ToString();
labCollage.Text = Stu["CollageName"].ToString();
}
labDate.Text = dr["Date"].ToString();
txtDateCourse1.Text = dr["Date1"].ToString();
txtDateCourse2.Text = dr["Date2"].ToString();
txtDateCourse3.Text = dr["Date3"].ToString();
txtDateCourse3.Text = dr["Date4"].ToString();
txtReason.Text = dr["Description"].ToString();
txtCourseNum1.Text = dr["Subject1"].ToString();
txtCourseNum2.Text = dr["Subject2"].ToString();
txtCourseNum3.Text = dr["Subject3"].ToString();
txtCourseNum4.Text = dr["Subject4"].ToString();
LinkButton1.Text = dr["Attachment1"].ToString();
LinkButton2.Text = dr["Attachment2"].ToString();
string Year = dr["Year"].ToString();
string Semester = dr["Semester"].ToString();
RegistredCourses Subj = new RegistredCourses();
if (Convert.ToInt32(txtCourseNum1.Text.ToString()) != 0)
{
int Course1 = Convert.ToInt32(txtCourseNum1.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course1, Year, Semester);
labTeacher1.Text = Sub["EmployeeName"].ToString();
ddlCourse1.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtCourseNum2.Text.ToString()) != 0)
{
int Course2 = Convert.ToInt32(txtCourseNum2.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course2, Year, Semester);
labTeacher2.Text = Sub["EmployeeName"].ToString();
ddlCourse2.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtCourseNum3.Text.ToString()) != 0)
{
int Course3 = Convert.ToInt32(txtCourseNum3.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course3, Year, Semester);
labTeacher3.Text = Sub["EmployeeName"].ToString();
ddlCourse3.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtCourseNum4.Text.ToString()) != 0)
{
int Course4 = Convert.ToInt32(txtCourseNum4.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course4, Year, Semester);
labTeacher3.Text = Sub["EmployeeName"].ToString();
ddlCourse4.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
txtDescriptionDean.Text = dr["DeanDescription"].ToString();
string DeanAccept = dr["DeanAccept"].ToString();
if (DeanAccept == "1")
{
rbtAcceptDean.SelectedValue = "1";
}
else if (DeanAccept == "2")
{
rbtAcceptDean.SelectedValue = "2";
}
}
}
private void fillData(int p)
{
PullCourseClass obj = new PullCourseClass();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataRow dr = obj.drgetform(id);
if (dr != null)
{
int STUid = Convert.ToInt32(dr["StudentID"].ToString());
Studnets objStu = new Studnets();
DataRow Stu = objStu.drSearchStudent(STUid);
if (Stu != null)
{
labStudentName.Text = Stu["StudentName"].ToString();
labStudentNmuber.Text = Stu["UniversityID"].ToString();
labSectionStudent.Text = Stu["SectionName"].ToString();
labCollage.Text = Stu["CollageName"].ToString();
}
labDateReg.Text = DateTime.UtcNow.ToString("yyyy-MM-dd");
labDate.Text = dr["Date"].ToString();
txtTimeCourse1.Text = dr["Course1time"].ToString();
txtTimeCourse2.Text = dr["Course2time"].ToString();
txtTimeCourse3.Text = dr["Course3time"].ToString();
txtReason.Text = dr["Description"].ToString();
txtNmberHours.Text = dr["NumHourRegester"].ToString();
txtNumHourAfter.Text = dr["NumAfterPull"].ToString();
txtNumCourse1.Text = dr["Subject1ID"].ToString();
txtNumCourse2.Text = dr["Subject2ID"].ToString();
txtNumCourse3.Text = dr["Subject3ID"].ToString();
string Year = dr["Year"].ToString();
string Semester = dr["Semester"].ToString();
RegistredCourses Subj = new RegistredCourses();
if (Convert.ToInt32(txtNumCourse1.Text.ToString()) != 0)
{
int Course1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course1, Year, Semester);
labTeacher1.Text = Sub["EmployeeName"].ToString();
ddlNameCourse1.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtNumCourse2.Text.ToString()) != 0)
{
int Course2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course2, Year, Semester);
labTeacher2.Text = Sub["EmployeeName"].ToString();
ddlNameCourse2.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
if (Convert.ToInt32(txtNumCourse3.Text.ToString()) != 0)
{
int Course3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
DataRow Sub = Subj.drSearchRegisterSubjectID(Course3, Year, Semester);
labTeacher3.Text = Sub["EmployeeName"].ToString();
ddlNameCourse3.Items.Insert(0, new ListItem(Sub["SubjectName"].ToString(), "0"));
}
txtDescriptionHead.Text = dr["HeadDescription"].ToString();
string HeadAccept = dr["HeadAccept"].ToString();
if (HeadAccept == "1")
{
rbtAceptHead.SelectedValue = "1";
}
else if (HeadAccept == "2")
{
rbtAceptHead.SelectedValue = "2";
}
string DeanAccept = dr["DeanAccept"].ToString();
if (DeanAccept == "1")
{
rbtAcceptDean.SelectedValue = "1";
}
else if (DeanAccept == "2")
{
rbtAcceptDean.SelectedValue = "2";
}
string RegAccept = dr["RegestrationAccept"].ToString();
if (RegAccept == "1")
{
rbtAcceptRegistration.SelectedValue = "1";
}
else if (RegAccept == "2")
{
rbtAcceptRegistration.SelectedValue = "2";
}
txtDescriptionDean.Text = dr["DeanDescription"].ToString();
}
}