protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.EducationYears, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } AddSubmitEvent(); DataTable dt = new EducationalYear().getList(); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); AddSubmitEvent(); if (!IsPostBack) { if (Request.QueryString["alert"] == "success") { Response.Write("<script>alert('تم الحفظ بنجاح.');</script>"); } } }
private void FillGrid() { if (Request.QueryString["id"].ToString() != null) { System.Data.DataTable dt = new DataTable(); string sql = ""; if (Session["Table"] == null) { ddlOldEdyYear.SelectedValue = Request.QueryString["id"].ToString(); sql = "select ID,Name as oldClass,'' as newClass from Std_Class where EdyID = " + Request.QueryString["id"].ToString(); dt = DataAccess.ExecuteSQLQuery(sql); Session["Table"] = dt; } else { dt = Session["Table"] as DataTable; } grid.DataSource = dt; grid.DataBind(); sql = "select ID,Name as oldClass from Std_Class where EdyID = " + ddlOldEdyYear.SelectedValue.ToString(); dt = DataAccess.ExecuteSQLQuery(sql); GridViewDataComboBoxColumn regioncolumn = (grid.Columns["oldClass"] as GridViewDataComboBoxColumn); regioncolumn.PropertiesComboBox.DataSource = dt; regioncolumn.PropertiesComboBox.ValueField = "ID"; regioncolumn.PropertiesComboBox.TextField = "oldClass"; regioncolumn.ReadOnly = true; FillNewClass(); if (ddlOldEdyYear.SelectedValue != "") { //get students in this year didn't pay the total money DataTable notPaid = new EducationalYear().getStudentnotPaid(int.Parse(ddlOldEdyYear.SelectedValue.ToString())); if (notPaid != null) { studentnotPaid.Visible = true; studentnotPaid.DataSource = notPaid; studentnotPaid.DataBind(); } else { studentnotPaid.Visible = false; } } else { studentnotPaid.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewYear, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } if (!IsPostBack) { if (Request.QueryString["id"].ToString() != null) { if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0) { EducationalYear ed = new EducationalYear(); ed.get(Convert.ToInt32(Request.QueryString["id"].ToString())); lblEducationYearID.Text = ed.ID.ToString(); lblEducationYearName.Text = ed.Name; lblRank.Text = ed.Rank.ToString(); lblLastModifiedDate.Text = ed.LastModifiedDate.ToString(); lblCreationDate.Text = ed.CreationDate.ToString(); txtBreakFrom.Text = ed.Breaks.Rows[0]["BreakFrom"].ToString(); txtBreakTo.Text = ed.Breaks.Rows[0]["BreakTo"].ToString(); txtLecTime.Text = ed.LecTimeMin.ToString(); txtNoOfLec.Text = ed.NoOfLec.ToString(); DataTable dt = ed.GetClasses(ed.ID); ASPxGridView2.DataSource = dt; ASPxGridView2.DataBind(); DataTable dt2 = ed.GetCourses(ed.ID); ASPxGridView1.DataSource = dt2; ASPxGridView1.DataBind(); btnEdit.Visible = true; } else { btnEdit.Visible = false; } } } AddSubmitEvent(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.AddYear, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } if (!IsPostBack) { if (Request.QueryString["alert"] == "notpass") { Response.Write("<script>alert('لم يتم الحفظ');</script>"); } if (Request.QueryString["id"].ToString() != null) { if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0) { EducationalYear ed = new EducationalYear(); ed.get(Convert.ToInt32(Request.QueryString["id"].ToString())); txtYearName.Text = ed.Name; ddlRank.SelectedValue = ed.Rank.ToString(); txtNoOfLec.Text = ed.NoOfLec.ToString(); txtLecTime.Text = ed.LecTimeMin.ToString(); if (ed.Breaks != null && ed.Breaks.Rows != null && ed.Breaks.Rows.Count > 0) { txtBreakFrom.Text = ed.Breaks.Rows[0]["BreakFrom"].ToString(); txtBreakTo.Text = ed.Breaks.Rows[0]["BreakTo"].ToString(); } btnSave.Visible = false; btnEdit.Visible = true; } else { btnSave.Visible = true; btnEdit.Visible = false; } } } }
protected void btnEdit_Click(object sender, EventArgs e) { EducationalYear ed = new EducationalYear(); ed.Name = txtYearName.Text; ed.ID = Convert.ToInt32(Request.QueryString["id"].ToString()); int Yrank = 0; int.TryParse(ddlRank.SelectedValue, out Yrank); ed.Rank = Yrank; int YNoLec = 0; int.TryParse(txtNoOfLec.Text, out YNoLec); ed.NoOfLec = YNoLec; int YLecPeriod = 0; int.TryParse(txtLecTime.Text, out YLecPeriod); ed.LecTimeMin = YLecPeriod; DataTable dt = new DataTable(); dt.Columns.Add("BreakFrom"); dt.Columns.Add("BreakTo"); DataRow dr = dt.NewRow(); dr["BreakFrom"] = txtBreakFrom.Text; dr["BreakTo"] = txtBreakTo.Text; dt.Rows.Add(dr); ed.Breaks = dt; HttpCookie myCookie = Request.Cookies["user"]; ed.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString()); int id = ed.update(); if (id > 0) { Response.Redirect("~/StudentAfair/EducationYears.aspx?alert=success"); } else { Response.Redirect("~/StudentAfair/AddYear.aspx?id=0&&alret=notpass"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewClass, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } if (!IsPostBack) { if (Request.QueryString["id"].ToString() != null) { if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0) { StdClass sttclass = new StdClass(); sttclass.get(Convert.ToInt32(Request.QueryString["id"].ToString())); EducationalYear edy = new EducationalYear(); edy.get(sttclass.EdID); txtClassName.Text = sttclass.Name; ddlEdtYear.Text = edy.Name; Teacher teacher = new Teacher(); teacher.get(sttclass.SupID); ddlSup.Text = teacher.Name; ASPxGridView1.DataSource = sttclass.CoursesTeachers; ASPxGridView1.DataBind(); btnEdit.Visible = true; } else { btnEdit.Visible = false; } } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewStudent, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } if (!IsPostBack) { if (Request.QueryString["id"].ToString() != null) { if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0) { Student student = new Student(); student.get(Convert.ToInt32(Request.QueryString["id"].ToString())); lblStudentID.Text = student.ID.ToString(); Parent parent = new Parent(); lblStudentName.Text = student.Name; parent.get(student.ParentID); lblParentName.Text = parent.Name; lblParentJob.Text = parent.Job; lblBirthDate.Text = student.BirthDate.ToShortDateString(); DateTime ioct = new DateTime(DateTime.Now.Year, 10, 1); lbl1oct.Text = (((ioct - student.BirthDate)).TotalDays / 365).ToString(); ddlType.Text = student.Type.ToString(); lblAddress.Text = student.Address.ToString(); lblPhone.Text = student.Phone; StdClass sclass = new StdClass(); sclass.get(student.StudClass); lblClass.Text = sclass.Name; lblGender.Text = student.Gender; lblReligion.Text = student.Religion; if (student.LearningDisabilities == 1) { cbtxtDisabilities.Checked = true; } else { cbtxtDisabilities.Checked = false; } txtDisabilities.Text = student.Note; if (student.Father != 0) { parent.get(student.Father); lblFather.Text = parent.Name; txtfjob.Text = parent.Job; txtfPhone.Text = parent.Phone; txtfAddress.Text = parent.Address; } if (student.Mother != 0) { parent.get(student.Mother); ddlMpther.Text = parent.Name; txtmJob.Text = parent.Job; txtmphone.Text = parent.Phone; txtmAddress.Text = parent.Address; } btnEdit.Visible = true; DataTable dt = new DataTable();//Exams ASPxGridView3.DataSource = dt; ASPxGridView3.DataBind(); StdClass c = new StdClass(); c.get(student.StudClass); DataTable dt2 = new EducationalYear().GetCourses(c.EdID);//Courses coursesGrid.DataSource = dt2; coursesGrid.DataBind(); DataTable dt3 = new Student().getAbsent(int.Parse(lblStudentID.Text));//Absents absentGrid.DataSource = dt3; absentGrid.DataBind(); } else { btnEdit.Visible = false; } } AddSubmitEvent(); } AddSubmitEvent(); }