private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
NowTimeUniversity timee = new NowTimeUniversity();
DataRow T = timee.drSearchYearANdSemester();
string year = T["NowYear"].ToString();
string Semester = T["NowSemester"].ToString();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID, year, Semester);
ddlNameCourse1.DataSource = tbl1;
ddlNameCourse1.DataTextField = "SubjectName";
ddlNameCourse1.DataValueField = "SubjectID";
ddlNameCourse1.DataBind();
ddlNameCourse2.DataSource = tbl1;
ddlNameCourse2.DataTextField = "SubjectName";
ddlNameCourse2.DataValueField = "SubjectID";
ddlNameCourse2.DataBind();
ddlNameCourse3.DataSource = tbl1;
ddlNameCourse3.DataTextField = "SubjectName";
ddlNameCourse3.DataValueField = "SubjectID";
ddlNameCourse3.DataBind();
ddlNameCourse1.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse2.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse3.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
}
private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID);
ddlNameCourse1.DataSource = tbl1;
ddlNameCourse1.DataTextField = "SubjectName";
ddlNameCourse1.DataValueField = "SubjectID";
ddlNameCourse1.DataBind();
ddlNameCourse2.DataSource = tbl1;
ddlNameCourse2.DataTextField = "SubjectName";
ddlNameCourse2.DataValueField = "SubjectID";
ddlNameCourse2.DataBind();
ddlNameCourse3.DataSource = tbl1;
ddlNameCourse3.DataTextField = "SubjectName";
ddlNameCourse3.DataValueField = "SubjectID";
ddlNameCourse3.DataBind();
ddlNameCourse1.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse2.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse3.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
}
private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID);
gvCourses.DataSource = tbl1;
gvCourses.DataBind();
}
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();
}
labDateHead.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"));
}
}
}
private void fillData()
{
DropSemester obj = new DropSemester();
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)
{
labNameStudent.Text = Stu["StudentName"].ToString();
labNumStudent.Text = Stu["UniversityID"].ToString();
labSection.Text = Stu["SectionName"].ToString();
labCollage.Text = Stu["CollageName"].ToString();
}
labDate.Text = dr["Date"].ToString();
labDateDean.Text = DateTime.UtcNow.ToString("yyyy-MM-dd");
txtNumHours.Text = dr["NumofHourReg"].ToString();
txtReasons.Text = dr["Description"].ToString();
string semester = dr["Semester"].ToString();
string year = dr["Year"].ToString();
int ID = Convert.ToInt32(dr["StudentID"].ToString());
RegistredCourses objj = new RegistredCourses();
DataTable tbl1 = objj.dtSearchRegisterSubjectStu(ID, semester, year);
gvCourses.DataSource = tbl1;
gvCourses.DataBind();
txtDescriptionAcadimic.Text = dr["AcademicAdvisor_Descr"].ToString();
txtDescriptionHead.Text = dr["HeadDescription"].ToString();
string Acadimic = dr["AcademicAdvisorAccept"].ToString();
if (Acadimic == "1")
{
rbtAcceptAcadimic.SelectedValue = "1";
}
else if (Acadimic == "2")
{
rbtAcceptAcadimic.SelectedValue = "2";
}
string HeadAcept = dr["HeadAccept"].ToString();
if (HeadAcept == "1")
{
rbtAceptHead.SelectedValue = "1";
}
else if (HeadAcept == "2")
{
rbtAceptHead.SelectedValue = "2";
}
}
}
private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
NowTimeUniversity timee = new NowTimeUniversity();
DataRow T = timee.drSearchYearANdSemester();
string year = T["NowYear"].ToString();
string Semester = T["NowSemester"].ToString();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID, year, Semester);
gvCourses.DataSource = tbl1;
gvCourses.DataBind();
}
protected void fillEditddl()
{
PullCourseClass obj = new PullCourseClass();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataRow dr = obj.drgetform(id);
RegistredCourses obj1 = new RegistredCourses();
int ID = Convert.ToInt32(Session["ID"].ToString());
int CourseID = 0;
DataRow dr1;
if (dr != null)
{
ddlNameCourse1.SelectedValue = dr["Subject1ID"].ToString();
ddlNameCourse2.SelectedValue = dr["Subject2ID"].ToString();
ddlNameCourse3.SelectedValue = dr["Subject3ID"].ToString();
if (ddlNameCourse1.SelectedIndex != 0 && ddlNameCourse1.SelectedIndex != -1)
{
txtNumCourse1.Text = ddlNameCourse1.SelectedValue.ToString();
CourseID = Convert.ToInt32(ddlNameCourse1.SelectedValue.ToString());
dr1 = obj1.drSearchRegisterSubjectTeacher(ID, CourseID);
if (dr1 != null)
{
labTeacher1.Text = dr1["EmployeeName"].ToString();
}
}
if (ddlNameCourse3.SelectedIndex != 0 && ddlNameCourse3.SelectedIndex != -1)
{
txtNumCourse3.Text = ddlNameCourse3.SelectedValue.ToString();
CourseID = Convert.ToInt32(ddlNameCourse3.SelectedValue.ToString());
dr1 = obj1.drSearchRegisterSubjectTeacher(ID, CourseID);
if (dr1 != null)
{
labTeacher3.Text = dr1["EmployeeName"].ToString();
}
}
if (ddlNameCourse2.SelectedIndex != 0 && ddlNameCourse2.SelectedIndex != -1)
{
txtNumCourse2.Text = ddlNameCourse2.SelectedValue.ToString();
ID = Convert.ToInt32(Session["ID"].ToString());
CourseID = Convert.ToInt32(ddlNameCourse2.SelectedValue.ToString());
dr1 = obj1.drSearchRegisterSubjectTeacher(ID, CourseID);
if (dr1 != null)
{
labTeacher2.Text = dr1["EmployeeName"].ToString();
}
}
}
}
protected void ddlCourse4_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCourse4.SelectedIndex != 0 && ddlCourse4.SelectedIndex != -1)
{
txtCourseNum4.Text = ddlCourse4.SelectedValue.ToString();
RegistredCourses obj1 = new RegistredCourses();
int ID = Convert.ToInt32(Session["ID"].ToString());
int CourseID = Convert.ToInt32(ddlCourse4.SelectedValue.ToString());
DataRow dr1;
dr1 = obj1.drSearchRegisterSubjectTeacher(ID, CourseID);
if (dr1 != null)
{
labTeacher4.Text = dr1["EmployeeName"].ToString();
}
}
}
private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
NowTimeUniversity timee = new NowTimeUniversity();
DataRow T = timee.drSearchYearANdSemester();
string year = T["NowYear"].ToString();
string Semester = T["NowSemester"].ToString();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID, year, Semester);
ddlNameCourse1.DataSource = tbl1;
ddlNameCourse1.DataTextField = "SubjectName";
ddlNameCourse1.DataValueField = "SubjectID";
ddlNameCourse1.DataBind();
ddlNameCourse2.DataSource = tbl1;
ddlNameCourse2.DataTextField = "SubjectName";
ddlNameCourse2.DataValueField = "SubjectID";
ddlNameCourse2.DataBind();
ddlNameCourse3.DataSource = tbl1;
ddlNameCourse3.DataTextField = "SubjectName";
ddlNameCourse3.DataValueField = "SubjectID";
ddlNameCourse3.DataBind();
ddlNameCourse1.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse2.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlNameCourse3.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
int RegHours = 0;
for (int i = 0; i < tbl1.Rows.Count; i++)
{
DataRow dr = tbl1.Rows[i];
RegHours = RegHours + Convert.ToInt32(dr["Hours"].ToString());
}
txtNmberHours.Text = RegHours + "";
}
private void fillddl()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
RegistredCourses obj = new RegistredCourses();
NowTimeUniversity timee = new NowTimeUniversity();
DataRow T = timee.drSearchYearANdSemester();
string year = T["NowYear"].ToString();
string Semester = T["NowSemester"].ToString();
DataTable tbl1 = obj.dtSearchRegisterSubject(ID, year, Semester);
gvCourses.DataSource = tbl1;
gvCourses.DataBind();
int RegHours = 0;
for (int i = 0; i < tbl1.Rows.Count; i++)
{
DataRow dr = tbl1.Rows[i];
RegHours = RegHours + Convert.ToInt32(dr["Hours"].ToString());
}
txtNumHours.Text = RegHours + "";
}
private void fillddl()
{
RegistredCourses obj1 = new RegistredCourses();
int ID = Convert.ToInt32(Session["ID"].ToString());
DataTable tb1 = obj1.dtSearchNotRegisterSubject(ID);
Subjects obj2 = new Subjects();
DataTable tb2 = obj2.dtSearchStudentSubjectNotRegester(ID);
ddlAlternativeCourse1.DataSource = tb2;
ddlAlternativeCourse1.DataTextField = "SubjectName";
ddlAlternativeCourse1.DataValueField = "SubjectID";
ddlAlternativeCourse1.DataBind();
ddlCourse1.DataSource = tb1;
ddlCourse1.DataTextField = "SubjectName";
ddlCourse1.DataValueField = "SubjectID";
ddlCourse1.DataBind();
ddlCourse1.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
ddlAlternativeCourse1.Items.Insert(0, new ListItem("<اختر مادة>", "0"));
}
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 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.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();
}
}
