public void fillDataForm(int ID) { 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 = 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(); RegistredCourses objj = new RegistredCourses(); DataTable tbl1 = objj.dtSearchRegisterSubjectStu(ID, semester, year); gvCourses.DataSource = tbl1; gvCourses.DataBind(); } }
private void fillGv() { DropSemester obj = new DropSemester(); DataTable TBL1 = obj.dtNotAcceptDropSemesterAcademicAdvisorApplication(); gvDropSemester.DataSource = TBL1; gvDropSemester.DataBind(); }
public void NotAccept(int ID) { DropSemester obj = new DropSemester(); if (obj.NotAcceptAcademicAdvisorDropSemester(ID) == 1) { fillGv(); } }
private void fillGv() { int ID = Convert.ToInt32(Session["ID"].ToString()); DropSemester obj = new DropSemester(); DataTable TBL1 = obj.dtViewStudents(ID); gvDropSemester.DataSource = TBL1; gvDropSemester.DataBind(); }
public void NotAccept(int ID) { DropSemester obj = new DropSemester(); if (obj.NotAcceptRegDropSemester(ID) == 1) { fillGv(); } }
public void Accept(int ID) { DropSemester obj = new DropSemester(); if (obj.AcceptDeanDropSemester(ID) == 1) { fillGv(); } }
protected void Button1_Click(object sender, EventArgs e) { string date1 = DateTime.Today.ToString(); string Reason = txtReasons.Text.ToString(); int ID = Convert.ToInt32(Session["ID"].ToString()); DropSemester objsem = new DropSemester(); if (objsem.AddDropSemester(ID, Reason, date1, "", 0, "", 0, "", 0, "", 0, "", 2) == 1) { txtReasons.Text = ""; } }
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"; } } }
protected void gvDropSemesterView_RowCommand(object sender, GridViewCommandEventArgs e) { GridView grid = sender as GridView; if (e.CommandName == "dispaly1") { int rowIndex = int.Parse(e.CommandArgument.ToString()); int val = (int)this.gvDropSemester.DataKeys[rowIndex]["ID"]; Response.Redirect("DropSemesterDisplayAll.aspx?id=" + val); } else if (e.CommandName == "edit1") { int rowIndex = int.Parse(e.CommandArgument.ToString()); int val = (int)this.gvDropSemester.DataKeys[rowIndex]["ID"]; DropSemester obj = new DropSemester(); DataRow dr = obj.dreditform(val); if (dr == null) { fillGv(); errorLabel.Text = "لا يمكن تعديل هذا الطلب"; errorLabel.Visible = true; errorLabel.ForeColor = Color.Red; } else { Response.Redirect("DropSemesterUpdate.aspx?id=" + val); } } else if (e.CommandName == "delete") { int rowIndex = int.Parse(e.CommandArgument.ToString()); int val = (int)this.gvDropSemester.DataKeys[rowIndex]["ID"]; DropSemester obj = new DropSemester(); int del = obj.DeleteDreopSemesterSelected(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 ddlRequest_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRequest.SelectedIndex != 0 && ddlRequest.SelectedIndex != -1) { if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 1) { // ShowStatusClass obj = new ShowStatusClass(); // DataTable dt = obj.dtGetAll(); // 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.dtGetAll(); 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(); } } }
protected void Button1_Click(object sender, EventArgs e) { bool Result = false; int ID = Convert.ToInt32(Session["ID"]); string Path = ""; string Data = labDate.Text.ToString() + txtNumHours.Text.ToString(); if (fuSignature.HasFile) { string Private = fuSignature.FileName.ToString(); Path = System.Web.HttpContext.Current.Server.MapPath("Test") + "/" + Private; string Pasword = txtPassSign.Text.ToString(); fuSignature.SaveAs(Server.MapPath("Test") + "/" + fuSignature.FileName); SignatureStudents newSig = new SignatureStudents(); string strencrypt = newSig.encrypet(Data, Path, Pasword); Result = newSig.Decreypt(strencrypt, ID); } if (Result == true) { string date1 = labDate.Text.ToString(); string Reason = txtReasons.Text.ToString(); DropSemester objsem = new DropSemester(); int NumOFHour = Convert.ToInt32(txtNumHours.Text.ToString()); NowTimeUniversity timee = new NowTimeUniversity(); DataRow T = timee.drSearchYearANdSemester(); string semester = T["NowSemester"].ToString(); string Year = T["NowYear"].ToString(); if (objsem.AddDropSemester(ID, Year, semester, Reason, NumOFHour, date1, "", 0, "", 0, "", 0, "", 0, 0, "", 2) == 1) { txtReasons.Text = ""; SentMail s = new SentMail(); s.sendemailAcadimic(ID); Response.Redirect("HomeStudent.aspx"); } errorLabel.Visible = false; } else { errorLabel.Text = " التوقيع المدخل خاطئ أو كلمة المرور"; errorLabel.Visible = true; } }
protected void btnSaveHead_Click(object sender, EventArgs e) { bool Result = false; int ID = Convert.ToInt32(Session["ID"].ToString()); string Path = ""; string Data = DateTime.Today.ToString() + txtNumHours.Text.ToString() + labDate.Text.ToString(); if (fuSignatureAcadimic.HasFile) { string Private = fuSignatureAcadimic.FileName.ToString(); Path = System.Web.HttpContext.Current.Server.MapPath("../Test") + "/" + Private; string Pasword = txtPassSign.Text.ToString(); fuSignatureAcadimic.SaveAs(Server.MapPath("../Test") + "/" + fuSignatureAcadimic.FileName); SignatureEmployee newSig = new SignatureEmployee(); string strencrypt = newSig.encrypet(Data, Path, Pasword); Result = newSig.Decreypt(strencrypt, ID); } if (Result == true) { DropSemester obj = new DropSemester(); int id = Convert.ToInt32(Request.QueryString["id"]); int AcceptAcadimic = Convert.ToInt32(rbtAcceptAcadimic.SelectedValue.ToString()); string AcadimicDec = txtDescriptionAcadimic.Text.ToString(); if (obj.AcceptAcademicAdvisorDropSemester(id, AcceptAcadimic, AcadimicDec) == 1) { DataRow dr = obj.drgetform(id); int STUid = Convert.ToInt32(dr["StudentID"].ToString()); SentMail s = new SentMail(); s.sendemailHead(STUid); Response.Redirect("processRequestAcademic1.aspx"); } errorAcadimic.Visible = false; } else { errorAcadimic.Text = "التوقيع المدخل خاطئ او كلمة المرور"; errorAcadimic.Visible = true; } }
protected void ddlRequest_SelectedIndexChanged(object sender, EventArgs e) { int ID = Convert.ToInt32(Session["ID"].ToString()); if (ddlRequest.SelectedIndex != 0 && ddlRequest.SelectedIndex != -1) { if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 4) { AlternativeSub obj = new AlternativeSub(); DataTable dt = obj.dtNotAcceptAliSubAcademicAdvisorApplication(ID); gvRequest.DataSource = dt; gvRequest.DataBind(); } else if (Convert.ToInt32(ddlRequest.SelectedValue.ToString()) == 5) { DropSemester obj = new DropSemester(); DataTable dt = obj.dtNotAcceptDropSemesterAcademicAdvisorApplication(ID); gvRequest.DataSource = dt; gvRequest.DataBind(); } } }
protected void Button1_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 = DateTime.Today.ToString() + txtNumHours.Text.ToString(); if (fuSignature.HasFile) { string Private = fuSignature.FileName.ToString(); Path = Path + Private; fuSignature.SaveAs(Server.MapPath("Test") + "/" + fuSignature.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 date1 = DateTime.Today.ToString(); string Reason = txtReasons.Text.ToString(); DropSemester objsem = new DropSemester(); if (objsem.AddDropSemester(ID, Reason, date1, "", 0, "", 0, "", 0, "", 0, "", 2) == 1) { txtReasons.Text = ""; txtNumHours.Text = ""; } errorLabel.Visible = false; } else { errorLabel.Text = "التوقيع المدخل خاطئ"; errorLabel.Visible = true; } }
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(); } } }