private DataTable fillGridCol() { int noOfLec = new StdClass().getNoOfLec(int.Parse(ddlClasses.SelectedValue.ToString())); DataTable dt = new StdClass().GetCourses(int.Parse(ddlClasses.SelectedValue.ToString())); DataTable table = new DataTable(); if (grid.Columns.Count != noOfLec) { GridViewDataComboBoxColumn x; GridViewDataComboBoxColumn ThisBool = new GridViewDataComboBoxColumn(); for (int i = 1; i <= noOfLec; i++) { table.Columns.Add("Lecture" + i.ToString(), typeof(String)); x = grid.Columns["Lecture" + i.ToString()] as GridViewDataComboBoxColumn; if (x == null) { ThisBool = new GridViewDataComboBoxColumn(); ThisBool.Caption = "Lecture" + i.ToString(); ThisBool.FieldName = "Lecture" + i.ToString(); ThisBool.Name = "Lecture" + i.ToString(); ThisBool.VisibleIndex = i + 3; ThisBool.PropertiesComboBox.DataSource = dt; ThisBool.PropertiesComboBox.TextField = "Name"; ThisBool.PropertiesComboBox.ValueField = "ID"; ThisBool.Visible = true; grid.Columns.Add(ThisBool); } } } return(table); }
public CY.GFive.Core.Business.StdClass GetClassByStudentCode(string code) { StdClass sc = new StdClass(); SqlServerUtility utility = new SqlServerUtility(); utility.AddParameter("StdCode", SqlDbType.VarChar, code); SqlDataReader reader = utility.ExecuteSqlReader(SQL_GET_CLASS_BY_CODE); if (reader != null && !reader.IsClosed) { if (reader.Read()) { if (!reader.IsDBNull(0)) sc.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) sc.StdCode = reader.GetString(1); if (!reader.IsDBNull(2)) sc.ClassCode = reader.GetString(2); if (!reader.IsDBNull(3)) sc.State = reader.GetBoolean(3); } reader.Close(); } return sc; }
protected void ddlClasses_SelectedIndexChanged(object sender, EventArgs e) { StdClass st = new StdClass(); int classID = Convert.ToInt32(ddlClasses.SelectedValue.ToString()); st.getSchdulebyclass(classID); DataTable dt = st.ClassSchedule; if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { // grid.DataSource = dt; // grid.DataBind(); fillGridCol(); } else { Session["Table"] = null; dt = GetTable(); } grid.DataSource = dt; grid.DataBind(); dt.PrimaryKey = new DataColumn[] { dt.Columns["ID"] }; dt.Columns["ID"].ReadOnly = true; Session["Table"] = dt; }
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.Classes, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } AddSubmitEvent(); DataTable dt = new StdClass().getList(); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); AddSubmitEvent(); if (!IsPostBack) { if (Request.QueryString["alert"] == "success") { Response.Write("<script>alert('تم الحفظ بنجاح.');</script>"); } } }
protected void btnEdit_Click(object sender, EventArgs e) { StdClass sc = new StdClass(); sc.Name = txtClassName.Text; sc.ID = Convert.ToInt32(Request.QueryString["id"].ToString()); int EdtYear = 0; int.TryParse(ddlEdtYear.SelectedValue.ToString(), out EdtYear); sc.EdID = EdtYear; int supID = 0; int.TryParse(ddlSup.SelectedValue.ToString(), out supID); sc.SupID = supID; HttpCookie myCookie = Request.Cookies["user"]; sc.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString()); sc.CoursesTeachers = Session["table"] as DataTable; int id = sc.update(); if (id > 0) { Response.Redirect("~/StudentAfair/Classes.aspx?alert=success"); } else { Response.Redirect("~/StudentAfair/AddClass.aspx?id=0&&alret=notpass"); } }
protected void btnSave_Click(object sender, EventArgs e) { StdClass st = new StdClass(); st.ClassSchedule = Session["Table"] as DataTable; st.ID = Convert.ToInt32(ddlClasses.SelectedValue.ToString()); st.updateSchdulebyclass(); }
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.AddClass, 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())); //txtNoOfStudent.Text=sttclass. txtClassName.Text = sttclass.Name; ddlEdtYear.SelectedValue = sttclass.EdID.ToString(); if (sttclass.SupID != 0) { ddlSup.SelectedValue = sttclass.SupID.ToString(); } ASPxGridView1.DataSource = sttclass.CoursesTeachers; ASPxGridView1.DataBind(); string sql = "select ID as TeacherID,Name as TeacherName from Std_Teacher "; DataTable dt = DataAccess.ExecuteSQLQuery(sql); GridViewDataComboBoxColumn regioncolumn = (ASPxGridView1.Columns["clTeacher"] as GridViewDataComboBoxColumn); regioncolumn.PropertiesComboBox.DataSource = dt; regioncolumn.PropertiesComboBox.ValueField = "TeacherID"; regioncolumn.PropertiesComboBox.TextField = "TeacherName"; Session["table"] = sttclass.CoursesTeachers; btnSave.Visible = false; btnEdit.Visible = true; } else { btnSave.Visible = true; btnEdit.Visible = false; } } } if (IsPostBack) { ASPxGridView1.DataSource = Session["table"]; ASPxGridView1.DataBind(); } }
protected void ddlClasses_SelectedIndexChanged(object sender, EventArgs e) { StdClass st = new StdClass(); int classID = Convert.ToInt32(ddlEmaxName.SelectedValue.ToString()); //st.getSchdulebyclass(classID); int colNo = grid.Columns.Count - 1; List <GridViewColumn> cols = new List <GridViewColumn>(); foreach (GridViewColumn col in grid.Columns) { if (col.Name == "StudentName" || col.Name == "ID" || col.Name == "#" || col.Name == "Edit") { cols.Add(col); } } grid.Columns.Clear(); for (int i = 0; i < cols.Count; i++) { grid.Columns.Add(cols[i]); } //grid.Columns = cols; Session["TableDegree"] = null; DataTable dt = new DataTable(); DataColumn colid = dt.Columns.Add("ID", typeof(Int32)); DataColumn Days = dt.Columns.Add("StudentName", typeof(String)); fillGridCol(dt); /* * if (dt != null && dt.Rows != null && dt.Rows.Count > 0) * { * * // grid.DataSource = dt; * // grid.DataBind(); * fillGridCol(dt); * } * else * { * Session["Table"] = null; * dt = GetTable(); * * }*/ grid.DataSource = dt; grid.DataBind(); dt.PrimaryKey = new DataColumn[] { dt.Columns["ID"] }; dt.Columns["ID"].ReadOnly = true; Session["TableDegree"] = dt; }
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.ViewDocuments, 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) { Document doc = new Document(); doc.get(Convert.ToInt32(Request.QueryString["id"].ToString())); txtName.Text = doc.Name; //FileUpload1.ResolveUrl(doc.URL); Course course = new Course(); course.get(doc.CourseID); ddlcourses.Text = course.Name; StdClass stdclass = new StdClass(); stdclass.get(doc.ClassID); ddlClasse.Text = stdclass.Name; btnEdit.Visible = true; linkButton1.Visible = true; // downloadUrl = doc.URL; } else { linkButton1.Visible = false; btnEdit.Visible = false; } } } }
protected void btnSave_Click(object sender, EventArgs e) { StdClass sc = new StdClass(); sc.Name = txtClassName.Text; int EdtYear = 0; int.TryParse(ddlEdtYear.SelectedValue.ToString(), out EdtYear); sc.EdID = EdtYear; int supID = 0; int.TryParse(ddlSup.SelectedValue.ToString(), out supID); sc.SupID = supID; HttpCookie myCookie = Request.Cookies["user"]; sc.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString()); /*DataTable dtcourseteacher = new DataTable(); * dtcourseteacher.Columns.Add("Course"); * dtcourseteacher.Columns.Add("Teacher"); * for (int i = 0; i < count; i++) * { * string opid1 = "lblCourse" + dt2.Rows[i]["Name"].ToString() ; * Label lblName = (Label)panel.FindControl(opid1); * string Attr; * Attr = "ddlTeacher" + dt3.Rows[i]["Name"].ToString(); * DropDownList ddlTeacher = (DropDownList)panel.FindControl(Attr); * DataRow dr = dtcourseteacher.NewRow(); * dr["Course"] = lblName.Text; * dr["Teacher"] = ddlTeacher.SelectedValue; * dtcourseteacher.Rows.Add(dr); * }*/ sc.CoursesTeachers = Session["table"] as DataTable; int id = sc.save(); if (id > 0) { Response.Redirect("~/StudentAfair/Classes.aspx?alert=success"); } else { Response.Redirect("~/StudentAfair/AddClass.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(); }