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