private void fillDataForm(int ID)
{
Studnets objStu = new Studnets();
DataRow Stu = objStu.drSearchStudent(ID);
if (Stu != null)
{
labStudentName.Text = Stu["StudentName"].ToString();
labStudentNmuber.Text = Stu["UniversityID"].ToString();
labSectionStudent.Text = Stu["SectionName"].ToString();
labCollage.Text = Stu["CollageName"].ToString();
}
PullCourseClass obj = new PullCourseClass();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataRow dr = obj.drgetform(id);
if (dr != null)
{
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();
}
labDate.Text = DateTime.Today.ToString();
}
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();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string Reson = "";
int NumHoursResginter;
int NumpullHours;
int CourseNum1 = 0;
int CourseNum2 = 0;
int CourseNum3 = 0;
int CourseNum4 = 0;
if (txtNumCourse1.Text != string.Empty)
{
CourseNum1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
}
if (txtNumCourse2.Text != string.Empty)
{
CourseNum2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
}
if (txtNumCourse3.Text != string.Empty)
{
CourseNum3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
}
if (txtNmberHours.Text != string.Empty)
{
NumHoursResginter = Convert.ToInt32(txtNmberHours.Text.ToString());
}
if (txtNumHourAfter.Text != string.Empty)
{
NumpullHours = Convert.ToInt32(txtNumHourAfter.Text.ToString());
}
string Course1time = txtTimeCourse1.Text.ToString();
string Course2time = txtTimeCourse2.Text.ToString();
string Course3time = txtTimeCourse3.Text.ToString();
string DateNow = DateTime.Today.ToString();
int ID = Convert.ToInt32(Session["ID"]);
PullCourseClass obj = new PullCourseClass();
if (obj.AddPullCourse(ID, "", CourseNum1, CourseNum2, CourseNum3, DateNow, Reson, "", "", 0, "", "", 0, 0, 5) == 1)
{
txtReason.Text = "";
txtNumCourse1.Text = "";
txtNumCourse2.Text = "";
txtNumCourse3.Text = "";
ddlNameCourse1.SelectedIndex = -1;
ddlNameCourse2.SelectedIndex = -1;
ddlNameCourse3.SelectedIndex = -1;
labTeacher1.Text = "";
labTeacher2.Text = "";
labTeacher3.Text = "";
txtNmberHours.Text = "";
txtNumHourAfter.Text = "";
txtTimeCourse1.Text = "";
txtTimeCourse2.Text = "";
txtTimeCourse3.Text = "";
}
}
private void fillGv()
{
PullCourseClass obj = new PullCourseClass();
DataTable TBL1 = obj.dtNotAcceptDeanPullCourseApplication();
gvPullCourse.DataSource = TBL1;
gvPullCourse.DataBind();
}
private void fillGv()
{
int ID = Convert.ToInt32(Session["ID"].ToString());
PullCourseClass obj = new PullCourseClass();
DataTable TBL1 = obj.dtViewStudents(ID);
gvPullCourse.DataSource = TBL1;
gvPullCourse.DataBind();
}
public void NotAccept(int ID)
{
PullCourseClass obj = new PullCourseClass();
if (obj.NotAcceptDeanPullCourse(ID) == 1)
{
fillGv();
}
}
public void Accept(int ID)
{
PullCourseClass obj = new PullCourseClass();
if (obj.AcceptRegPullCourse(ID) == 1)
{
fillGv();
}
}
protected void gvPullCourseView_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = 0;
GridViewRow row;
GridView grid = sender as GridView;
if (e.CommandName == "dispaly")
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
int val = (int)this.gvPullCourse.DataKeys[rowIndex]["ID"];
}
else if (e.CommandName == "edit1")
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
int val = (int)this.gvPullCourse.DataKeys[rowIndex]["ID"];
PullCourseClass obj = new PullCourseClass();
DataRow dr = obj.dreditform(val);
if (dr == null)
{
fillGv();
errorLabel.Text = "لا يمكن تعديل هذا الطلب";
errorLabel.Visible = true;
errorLabel.ForeColor = Color.Red;
}
else
{
Response.Redirect("UpdateForm/PullCourseUpdate.aspx?id=" + val);
}
}
else if (e.CommandName == "delete")
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
int val = (int)this.gvPullCourse.DataKeys[rowIndex]["ID"];
PullCourseClass obj = new PullCourseClass();
int del = obj.DeletePullCourseSelected(val);
errorLabel.Text = del + "";
errorLabel.Visible = true;
if (del == 0)
{
errorLabel.Text = "لا يمكن حذف هذا الطلب لأنه غير مكتمل";
errorLabel.Visible = true;
errorLabel.ForeColor = Color.Red;
}
if (del == 1)
{
errorLabel.Text = "تمت العملية بنجاح";
errorLabel.Visible = true;
errorLabel.ForeColor = Color.DarkGreen;
}
}
}
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 btnSaveHead_Click(object sender, EventArgs e)
{
bool Result = false;
int ID = Convert.ToInt32(Session["ID"].ToString());
string Path = "";
string Data = txtNumCourse1.Text.ToString() + txtNumCourse2.Text.ToString() + txtNumCourse3.Text.ToString() +
txtNmberHours.Text.ToString() + txtNumHourAfter.Text.ToString() + DateTime.Today.ToString() + rbtAceptHead.SelectedValue.ToString();
if (fuSignatureHead.HasFile)
{
string Private = fuSignatureHead.FileName.ToString();
Path = System.Web.HttpContext.Current.Server.MapPath("Test") + "/" + Private;
string Pasword = txtPassSign.Text.ToString();
fuSignatureHead.SaveAs(Server.MapPath("Test") + "/" + fuSignatureHead.FileName);
SignatureEmployee newSig = new SignatureEmployee();
string strencrypt = newSig.encrypet(Data, Path, Pasword);
Result = newSig.Decreypt(strencrypt, ID);
}
if (Result == true)
{
PullCourseClass obj = new PullCourseClass();
int id = Convert.ToInt32(Request.QueryString["id"]);
int AcceptHead = Convert.ToInt32(rbtAceptHead.SelectedValue.ToString());
string HeadDec = txtDescriptionHead.Text.ToString();
if (obj.AcceptHeadPullCourse(id, AcceptHead, HeadDec) == 1)
{
DataRow dr = obj.drgetform(id);
int STUid = Convert.ToInt32(dr["StudentID"].ToString());
SentMail s = new SentMail();
s.sendemailDean(STUid);
Response.Redirect("ProcessRequest.aspx");
}
errorHead.Visible = false;
}
else
{
errorHead.Text = "التوقيع المدخل خاطئ او كلمة المرور";
errorHead.Visible = true;
}
}
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();
}
}
protected void ddlRequest_SelectedIndexChanged(object sender, EventArgs e)
{
int ID = Convert.ToInt32(Session["ID"].ToString());
Position emp = new Position();
DataRow dr = emp.drSearchEmployeePosition(ID);
int position = Convert.ToInt32(dr["Position"].ToString());
if (position == 2)
{
Employee info = new Employee();
DataRow section = info.drSearchEmployeeSection(ID);
int sec = Convert.ToInt32(section["SectionID"].ToString());
College col = new College();
DataRow college = col.drSearchColloge(sec);
int Collegeid = Convert.ToInt32(college["CollegeID"].ToString());
if (ddlRequest.SelectedIndex != 0 && ddlRequest.SelectedIndex != -1)
{
if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 1)
{
ShowStatusClass obj = new ShowStatusClass();
DataTable dt = obj.dtNotAcceptDeanShowStatusApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 2)
{
PullCourseClass obj = new PullCourseClass();
DataTable dt = obj.dtNotAcceptDeanPullCourseApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 3)
{
AbsenceExam obj = new AbsenceExam();
DataTable dt = obj.dtNotAcceptDeanAbsenceExamApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 4)
{
AlternativeSub obj = new AlternativeSub();
DataTable dt = obj.dtNotAcceptDeanAltSubApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 5)
{
DropSemester obj = new DropSemester();
DataTable dt = obj.dtNotAcceptDeanDropSemesterApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 6)
{
DelaySemesterClass obj = new DelaySemesterClass();
DataTable dt = obj.dtNotAcceptDeanDelaySemesterApplication(Collegeid);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
}
}
else if (position == 3)
{
Employee info = new Employee();
DataRow section = info.drSearchEmployeeSection(ID);
int sec = Convert.ToInt32(section["SectionID"].ToString());
if (ddlRequest.SelectedIndex != 0 && ddlRequest.SelectedIndex != -1)
{
if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 1)
{
ShowStatusClass obj = new ShowStatusClass();
DataTable dt = obj.dtNotAcceptHeadShowStatusApplication(sec);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 2)
{
PullCourseClass obj = new PullCourseClass();
DataTable dt = obj.dtNotAcceptHeadPullCourseApplication(sec);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 4)
{
AlternativeSub obj = new AlternativeSub();
DataTable dt = obj.dtNotAcceptHeadAltSubApplication(sec);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 5)
{
DropSemester obj = new DropSemester();
DataTable dt = obj.dtNotAcceptHeadDropSemesterApplication(sec);
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
}
}
else if (position == 5)
{
if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 6)
{
DelaySemesterClass obj = new DelaySemesterClass();
DataTable dt = obj.dtNotAcceptRegestDelaySemesterApplication();
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 2)
{
PullCourseClass obj = new PullCourseClass();
DataTable dt = obj.dtNotAcceptRegPullCourseApplication();
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 4)
{
AlternativeSub obj = new AlternativeSub();
DataTable dt = obj.dtNotAcceptHeadAltSubApplication();
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 5)
{
DropSemester obj = new DropSemester();
DataTable dt = obj.dtNotAcceptRegDropSemesterApplication();
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
}
else if (position == 1)
{
if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 5)
{
DropSemester obj = new DropSemester();
DataTable dt = obj.dtNotAcceptDeputyAcademicAcceptDropSemesterApplication();
gvRequest.DataSource = dt;
gvRequest.DataBind();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool Result = false;
int ID = Convert.ToInt32(Session["ID"]);
string Path = "C:/Users/Dua'a-Orcas/Desktop/WebApplication1/WebApplication1/WebApplication1/PageStudents/Test/";
string Data = txtNumCourse1.Text.ToString() + txtNumCourse2.Text.ToString() + txtNumCourse3.Text.ToString() +
txtNmberHours.Text.ToString() + txtNumHourAfter.Text.ToString() + DateTime.Today.ToString();
if (fuSignatureStudent.HasFile)
{
string Private = fuSignatureStudent.FileName.ToString();
Path = Path + Private;
fuSignatureStudent.SaveAs(Server.MapPath("Test") + "/" + fuSignatureStudent.FileName);
// Path = "/Test/" + fuSignatureStudent.FileName;
SignatureStudents newSig = new SignatureStudents();
string strencrypt = newSig.encrypet(Data, Path, ID);
Result = newSig.Decreypt(strencrypt, ID);
}
if (Result == true)
{
string Reson = "";
int NumHoursResginter;
int NumpullHours;
int CourseNum1 = 0;
int CourseNum2 = 0;
int CourseNum3 = 0;
if (txtNumCourse1.Text != string.Empty)
{
CourseNum1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
}
if (txtNumCourse2.Text != string.Empty)
{
CourseNum2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
}
if (txtNumCourse3.Text != string.Empty)
{
CourseNum3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
}
if (txtNmberHours.Text != string.Empty)
{
NumHoursResginter = Convert.ToInt32(txtNmberHours.Text.ToString());
}
if (txtNumHourAfter.Text != string.Empty)
{
NumpullHours = Convert.ToInt32(txtNumHourAfter.Text.ToString());
}
if (txtReason.Text != string.Empty)
{
Reson = txtReason.Text.ToString();
}
string Course1time = txtTimeCourse1.Text.ToString();
string Course2time = txtTimeCourse2.Text.ToString();
string Course3time = txtTimeCourse3.Text.ToString();
int NumHourREG = Convert.ToInt32(txtNmberHours.Text.ToString());
int NumHourAFpull = Convert.ToInt32(txtNumHourAfter.Text.ToString());
string DateNow = DateTime.Today.ToString();
int roww = Convert.ToInt32(Request.QueryString["id"]);
PullCourseClass obj = new PullCourseClass();
if (obj.UpdatePullCourse(roww, ID, CourseNum1, CourseNum2, CourseNum3, DateNow, Reson, Course1time, Course2time, Course3time, NumHourREG, NumHourAFpull, "", "", 0, "", "", 0, 0, 5) == 1)
{
txtReason.Text = "";
txtNumCourse1.Text = "";
txtNumCourse2.Text = "";
txtNumCourse3.Text = "";
ddlNameCourse1.SelectedIndex = -1;
ddlNameCourse2.SelectedIndex = -1;
ddlNameCourse3.SelectedIndex = -1;
labTeacher1.Text = "";
labTeacher2.Text = "";
labTeacher3.Text = "";
txtNmberHours.Text = "";
txtNumHourAfter.Text = "";
txtTimeCourse1.Text = "";
txtTimeCourse2.Text = "";
txtTimeCourse3.Text = "";
}
errorLabel.Visible = false;
}
else
{
errorLabel.Text = "التوقيع المدخل خاطئ";
errorLabel.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool Result = false;
int ID = Convert.ToInt32(Session["ID"]);
string Path = "";
string Data = txtNumCourse1.Text.ToString() + txtNumCourse2.Text.ToString() + txtNumCourse3.Text.ToString() +
txtNmberHours.Text.ToString() + txtNumHourAfter.Text.ToString() + DateTime.Today.ToString();
if (fuSignatureStudent.HasFile)
{
string Private = fuSignatureStudent.FileName.ToString();
Path = System.Web.HttpContext.Current.Server.MapPath("Test") + "/" + Private;
string Pasword = txtPassSign.Text.ToString();
fuSignatureStudent.SaveAs(Server.MapPath("Test") + "/" + fuSignatureStudent.FileName);
SignatureStudents newSig = new SignatureStudents();
string strencrypt = newSig.encrypet(Data, Path, Pasword);
Result = newSig.Decreypt(strencrypt, ID);
}
if (Result == true)
{
string Reson = "";
int NumHoursResginter;
int NumpullHours;
int CourseNum1 = 0;
int CourseNum2 = 0;
int CourseNum3 = 0;
if (txtNumCourse1.Text != string.Empty)
{
CourseNum1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
}
if (txtNumCourse2.Text != string.Empty)
{
CourseNum2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
}
if (txtNumCourse3.Text != string.Empty)
{
CourseNum3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
}
if (txtNmberHours.Text != string.Empty)
{
NumHoursResginter = Convert.ToInt32(txtNmberHours.Text.ToString());
}
if (txtNumHourAfter.Text != string.Empty)
{
NumpullHours = Convert.ToInt32(txtNumHourAfter.Text.ToString());
}
if (txtReason.Text != string.Empty)
{
Reson = txtReason.Text.ToString();
}
string Course1time = txtTimeCourse1.Text.ToString();
string Course2time = txtTimeCourse2.Text.ToString();
string Course3time = txtTimeCourse3.Text.ToString();
int NumHourREG = Convert.ToInt32(txtNmberHours.Text.ToString());
int NumHourAFpull = Convert.ToInt32(txtNumHourAfter.Text.ToString());
string DateNow = DateTime.Today.ToString();
int roww = Convert.ToInt32(Request.QueryString["id"]);
PullCourseClass obj = new PullCourseClass();
if (obj.UpdatePullCourse(roww, ID, CourseNum1, CourseNum2, CourseNum3, DateNow, Reson, Course1time, Course2time, Course3time, NumHourREG, NumHourAFpull, "", "", 0, "", "", 0, 0, 5) == 1)
{
Response.Redirect("PullCourseDisplay.aspx");
}
errorLabel.Visible = false;
}
else
{
errorLabel.Text = "التوقيع المدخل خاطئ";
errorLabel.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool Result = false;
int ID = Convert.ToInt32(Session["ID"]);
string Path = "";
string Data = txtNumCourse1.Text.ToString() + txtNumCourse2.Text.ToString() + txtNumCourse3.Text.ToString() +
txtNmberHours.Text.ToString() + txtNumHourAfter.Text.ToString() + DateTime.Today.ToString();
if (fuSignatureStudent.HasFile)
{
string Private = fuSignatureStudent.FileName.ToString();
Path = System.Web.HttpContext.Current.Server.MapPath("Test") + "/" + Private;
string Pasword = txtPassSign.Text.ToString();
fuSignatureStudent.SaveAs(Server.MapPath("Test") + "/" + fuSignatureStudent.FileName);
SignatureStudents newSig = new SignatureStudents();
string strencrypt = newSig.encrypet(Data, Path, Pasword);
Result = newSig.Decreypt(strencrypt, ID);
}
if (Result == true)
{
string Reson = "";
int NumHoursResginter;
int NumpullHours;
int CourseNum1 = 0;
int CourseNum2 = 0;
int CourseNum3 = 0;
if (txtNumCourse1.Text != string.Empty)
{
CourseNum1 = Convert.ToInt32(txtNumCourse1.Text.ToString());
}
if (txtNumCourse2.Text != string.Empty)
{
CourseNum2 = Convert.ToInt32(txtNumCourse2.Text.ToString());
}
if (txtNumCourse3.Text != string.Empty)
{
CourseNum3 = Convert.ToInt32(txtNumCourse3.Text.ToString());
}
if (txtNmberHours.Text != string.Empty)
{
NumHoursResginter = Convert.ToInt32(txtNmberHours.Text.ToString());
}
if (txtNumHourAfter.Text != string.Empty)
{
NumpullHours = Convert.ToInt32(txtNumHourAfter.Text.ToString());
}
if (txtReason.Text != string.Empty)
{
Reson = txtReason.Text.ToString();
}
string Course1time = txtTimeCourse1.Text.ToString();
string Course2time = txtTimeCourse2.Text.ToString();
string Course3time = txtTimeCourse3.Text.ToString();
int NumHourREG = Convert.ToInt32(txtNmberHours.Text.ToString());
int NumHourAFpull = Convert.ToInt32(txtNumHourAfter.Text.ToString());
string DateNow = labDate.Text.ToString();
NowTimeUniversity timee = new NowTimeUniversity();
DataRow T = timee.drSearchYearANdSemester();
string semester = T["NowSemester"].ToString();
string Year = T["NowYear"].ToString();
PullCourseClass obj = new PullCourseClass();
if (NumHourAFpull >= 9)
{
if (obj.AddPullCourse(ID, Year, semester, CourseNum1, CourseNum2, CourseNum3, DateNow, Reson, Course1time, Course2time, Course3time, NumHourREG, NumHourAFpull, "", "", 0, "", "", 0, 0, 5) == 1)
{
txtReason.Text = "";
txtNumCourse1.Text = "";
txtNumCourse2.Text = "";
txtNumCourse3.Text = "";
ddlNameCourse1.SelectedIndex = -1;
ddlNameCourse2.SelectedIndex = -1;
ddlNameCourse3.SelectedIndex = -1;
labTeacher1.Text = "";
labTeacher2.Text = "";
labTeacher3.Text = "";
txtNmberHours.Text = "";
txtNumHourAfter.Text = "";
txtTimeCourse1.Text = "";
txtTimeCourse2.Text = "";
txtTimeCourse3.Text = "";
labError.Visible = false;
error.Style.Add("display", "none");
SentMail s = new SentMail();
s.sendemailHead(ID);
Response.Redirect("HomeStudent.aspx");
}
}
else
{
labError.Visible = true;
error.Style.Add("display", "block");
}
errorLabel.Visible = false;
}
else
{
errorLabel.Text = " التوقيع المدخل خاطئ أو كلمة المرور";
errorLabel.Visible = true;
}
}
