protected void gvHours_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Change page index gvHours.PageIndex = e.NewPageIndex; //Bind data to GridView int sc_id = Convert.ToInt32(Session["lvl_id"]) < 4 ? Convert.ToInt32(Session["sc_id"]) : Convert.ToInt32(ddlSchools.SelectedValue); if (Convert.ToInt32(Session["lvl_id"]) < 4) { //Bind data to GridView DataSet dsHours = ch_hoursSvc.GetHours(sc_id); GridViewSvc.GVBind(dsHours, gvHours); } else if (Convert.ToInt32(Session["lvl_id"]) >= 4) { if (ddlSchools.SelectedValue == "-1") { gvHours.Visible = false; btnInsert.Visible = false; } else { //Bind data to GridView DataSet dsHours = ch_hoursSvc.GetHours(sc_id); GridViewSvc.GVBind(dsHours, gvHours); gvHours.Visible = true; btnInsert.Visible = true; } } }
protected void lblLesson_Load(object sender, EventArgs e) { if (!IsPostBack) { int grd_id = Convert.ToInt32(Request.QueryString["grd_id"]); DataRow drTest = ch_gradesSvc.GetTest(grd_id); int les_id = Convert.ToInt32(drTest["les_id"].ToString()); DataRow drLessons = ch_lessonsSvc.GetLesson(les_id); lblLesson.Text = drLessons["les_name"].ToString(); DataSet studentsInLesson = ch_students_lessonsSvc.GetStudentsLesson(les_id); GridViewSvc.GVBind(studentsInLesson, gvStudents); //after gridview bind if (Convert.ToInt32(drTest["les_id"]) == les_id) { DataSet dsUsersGrades = ch_users_gradesSvc.GetUsersGrades(grd_id); int i = 0; foreach (DataRow dr in dsUsersGrades.Tables[0].Rows) { TextBox txtGrade = (TextBox)gvStudents.Rows[i].FindControl("txtGrade"); txtGrade.Text = dr["grd_num"].ToString(); i++; } } } }
protected void gvBind() { if (Request.QueryString["search"] == null) { //Bind data to GridView DataSet dsCities = ch_citiesSvc.GetCities(); GridViewSvc.GVBind(dsCities, gvCities); } else { if (Request.QueryString["search"] == "") { //Bind data to GridView DataSet dsCities = ch_citiesSvc.GetCities(); GridViewSvc.GVBind(dsCities, gvCities); } else { txtSearch.Text = Request.QueryString["search"].ToString(); //Bind data to GridView DataSet dsCities = ch_citiesSvc.GetCities(Request.QueryString["search"].ToString()); GridViewSvc.GVBind(dsCities, gvCities); } } }
protected void BindGradesReport() { int les_id = Convert.ToInt32(ddlLessons.SelectedValue); int sc_id = Convert.ToInt32(ddlSchools.SelectedValue); DataSet gradesReport = ch_gradesSvc.GradesReport(sc_id, les_id); if (gradesReport.Tables[0].Rows.Count == 0) { pnlPercents.Visible = false; } GridViewSvc.GVBind(gradesReport, gvGrades); //add footer controls DataSet tests = ch_gradesSvc.GetTests(les_id); int i = 0; foreach (DataRow dr in tests.Tables[0].Rows) { int grd_id = Convert.ToInt32(tests.Tables[0].Rows[i]["grd_id"].ToString()); HyperLink hlEdit = new HyperLink(); hlEdit.NavigateUrl = "UpdateGrades.aspx?grd_id=" + grd_id; hlEdit.ImageUrl = "~/Images/ic_edit_24px.png"; gvGrades.Rows[gradesReport.Tables[0].Rows.Count - 1].Cells[i + 3].Controls.Add(hlEdit); i++; } }
protected void gvLevels_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); } }
protected void gvJobs_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind data to GridView DataSet dsJobs = ch_jobsSvc.GetJobs(); GridViewSvc.GVBind(dsJobs, gvJobs); } }
protected void GVProfessions_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); } }
protected void gvBehaviorsTypes_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind data to GridView DataSet dsBehaviors = ch_behaviorsSvc.GetBehaviors(); GridViewSvc.GVBind(dsBehaviors, gvBehaviorsTypes); } }
protected void btn_update_rm_Click(object sender, ImageClickEventArgs e) { ImageButton btn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; int rm_id = Convert.ToInt32(gvRooms.DataKeys[gvr.RowIndex].Value.ToString()); TextBox txt_edit_rm_name = (TextBox)gvr.FindControl("txt_edit_rm_name"); if (txt_edit_rm_name.Text.Trim() != "") { //all vars to one object ch_rooms rm1 = new ch_rooms(); rm1.rm_Name = txt_edit_rm_name.Text.Trim(); string err = ch_roomsSvc.UpdateRoomById(rm_id, rm1); if (err == "")//אם העדכון התבצע { lblErrGV.Text = string.Empty; gvRooms.EditIndex = -1; if (Convert.ToInt32(Session["lvl_id"]) == 3) { //Bind data to GridView DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(Session["sc_id"])); GridViewSvc.GVBind(dsRooms, gvRooms); } else if (Convert.ToInt32(Session["lvl_id"]) >= 4) { //Bind data to GridView DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(ddlSchools.SelectedValue)); GridViewSvc.GVBind(dsRooms, gvRooms); } } else { lblErrGV.Text = err; if (Convert.ToInt32(Session["lvl_id"]) == 3) { //Bind data to GridView DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(Session["sc_id"])); GridViewSvc.GVBind(dsRooms, gvRooms); } else if (Convert.ToInt32(Session["lvl_id"]) >= 4) { //Bind data to GridView DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(ddlSchools.SelectedValue)); GridViewSvc.GVBind(dsRooms, gvRooms); } } } else { lblErrGV.Text = "הכנס חדר"; } }
protected void btn_cancel_update_bhv_Click(object sender, ImageClickEventArgs e) { gvBehaviorsTypes.EditIndex = -1; lblErr.Text = ""; //Bind data to GridView DataSet dsBehaviors = ch_behaviorsSvc.GetBehaviors(); GridViewSvc.GVBind(dsBehaviors, gvBehaviorsTypes); }
protected void btnInsert_Click(object sender, EventArgs e) { gvBehaviorsTypes.ShowFooter = true; this.btnInsert.Enabled = false; //Bind data to GridView DataSet dsBehaviors = ch_behaviorsSvc.GetBehaviors(); GridViewSvc.GVBind(dsBehaviors, gvBehaviorsTypes); }
protected void gvBehaviorsTypes_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Change page index gvBehaviorsTypes.PageIndex = e.NewPageIndex; //Bind data to GridView DataSet dsBehaviors = ch_behaviorsSvc.GetBehaviors(); GridViewSvc.GVBind(dsBehaviors, gvBehaviorsTypes); }
protected void gvLevels_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Change page index gvLevels.PageIndex = e.NewPageIndex; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); }
protected void GVProfessions_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Change page index GVProfessions.PageIndex = e.NewPageIndex; //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); }
protected void btn_cancel_update_pro_Click(object sender, ImageClickEventArgs e) { GVProfessions.EditIndex = -1; lblErrGV.Text = ""; //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); }
protected void btn_cancel_update_lvl_Click(object sender, ImageClickEventArgs e) { gvLevels.EditIndex = -1; lblErrGV.Text = ""; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); }
protected void btnInsert_Click(object sender, EventArgs e) { GVProfessions.ShowFooter = true; this.btnInsert.Enabled = false; //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); }
protected void gvJobs_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Change page index gvJobs.PageIndex = e.NewPageIndex; //Bind data to GridView DataSet dsJobs = ch_jobsSvc.GetJobs(); GridViewSvc.GVBind(dsJobs, gvJobs); }
protected void btn_cancel_update_job_Click(object sender, ImageClickEventArgs e) { gvJobs.EditIndex = -1; lblErrGV.Text = ""; //Bind data to GridView DataSet dsJobs = ch_jobsSvc.GetJobs(); GridViewSvc.GVBind(dsJobs, gvJobs); }
protected void btnInsert_Click(object sender, EventArgs e) { gvLevels.ShowFooter = true; this.btnInsert.Enabled = false; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); }
protected void btnInsert_Click(object sender, EventArgs e) { gvJobs.ShowFooter = true; this.btnInsert.Enabled = false; //Bind data to GridView DataSet dsJobs = ch_jobsSvc.GetJobs(); GridViewSvc.GVBind(dsJobs, gvJobs); }
protected void ddlProfessions_SelectedIndexChanged(object sender, EventArgs e) { if (ddlLayers.SelectedValue == "-1") // אם לא נבחר מקצוע // איפוס { ddlTeachers.Items.Clear(); ddlLayers.Enabled = true; ddlProfessions.Enabled = true; ddlTeachers.Enabled = false; } else // אם נבחר מקצוע { ddlLayers.Enabled = true; ddlProfessions.Enabled = true; ddlTeachers.Enabled = true; //בית ספר + שכבה + מקצוע int sc_id; if (Convert.ToInt32(Session["lvl_id"]) >= 4) { sc_id = Convert.ToInt32(ddlSchools.SelectedValue); } else { sc_id = Convert.ToInt32(Session["sc_id"]); } string layer = ddlLayers.SelectedItem.Text; int pro_id = Convert.ToInt32(ddlProfessions.SelectedValue); //data bind teachers DataSet dsTeachers = ch_teachers_professionsSvc.GetTeachersByProAndSchool(sc_id, layer, pro_id); ddlTeachers.DataSource = dsTeachers; ddlTeachers.DataValueField = "usr_id"; ddlTeachers.DataTextField = "usr_fullname"; ddlTeachers.DataBind(); ddlTeachers.Items.Add(new ListItem("-כל המורים-", "-1")); ddlTeachers.SelectedIndex = ddlTeachers.Items.Count - 1; ddlTeachers.Enabled = true; // מציג את כל השיעורים לפי: בית ספר + שכבה + מקצוע //data bind lessons gvLessons.Visible = true; DataSet dsSchoolLayerLessons = ch_lessonsSvc.GetLessonsGV(sc_id, layer, pro_id); for (int i = 0; i < dsSchoolLayerLessons.Tables[0].Rows.Count; i += 2) { DataRow details = dsSchoolLayerLessons.Tables[0].NewRow(); dsSchoolLayerLessons.Tables[0].Rows.InsertAt(details, i + 1); } GridViewSvc.GVBind(dsSchoolLayerLessons, gvLessons); } }
protected void btn_cancel_insert_pro_Click(object sender, ImageClickEventArgs e) { GVProfessions.ShowFooter = false; btnInsert.Enabled = true; lblErrGV.Text = ""; //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); }
protected void btn_cancel_update_hr_Click(object sender, ImageClickEventArgs e) { gvHours.EditIndex = -1; lblErrGV.Text = ""; //Bind data to GridView int sc_id = Convert.ToInt32(Session["lvl_id"]) < 4 ? Convert.ToInt32(Session["sc_id"]) : Convert.ToInt32(ddlSchools.SelectedValue); DataSet dsHours = ch_hoursSvc.GetHours(sc_id); GridViewSvc.GVBind(dsHours, gvHours); }
protected void ddlLessons_SelectedIndexChanged(object sender, EventArgs e) { int les_id = Convert.ToInt32(ddlLessons.SelectedValue); //data bind if (Convert.ToInt32(Session["lvl_id"]) == 0) // if סטודנט { if (les_id != -1) // שיעור מסויים { pnlReport.Visible = true; int usr_id = Convert.ToInt32(Session["usr_id"]); DataSet gradesReportForStu = ch_gradesSvc.GradesReportForStu(usr_id, les_id); GridViewSvc.GVBind(gradesReportForStu, gvGrades); } else { pnlReport.Visible = true; pnlPercents.Visible = false; int usr_id = Convert.ToInt32(Session["usr_id"]); DataSet gradesReportForStu = ch_gradesSvc.GradesReportForStu(usr_id); GridViewSvc.GVBind(gradesReportForStu, gvGrades); } } else if (Convert.ToInt32(Session["lvl_id"]) == 1) // if מורה { pnlReport.Visible = true; pnlPercents.Visible = true; BindGradesReport(); DataSet tests = ch_gradesSvc.GetTests(les_id); GridViewSvc.GVBind(tests, gvPercents); } else if (Convert.ToInt32(Session["lvl_id"]) >= 3) // if עורך בית ספר ומעלה { if (les_id == -1) // לא נבחר שיעור { pnlReport.Visible = false; pnlPercents.Visible = false; } else // נבחר שיעור מסויים { BindGradesReport(); DataSet tests = ch_gradesSvc.GetTests(les_id); GridViewSvc.GVBind(tests, gvPercents); pnlReport.Visible = true; pnlPercents.Visible = true; } } }
protected void btnInsert_Click(object sender, EventArgs e) { gvHours.ShowFooter = true; this.btnInsert.Enabled = false; //Bind data to GridView int sc_id = Convert.ToInt32(Session["lvl_id"]) < 4 ? Convert.ToInt32(Session["sc_id"]) : Convert.ToInt32(ddlSchools.SelectedValue); DataSet dsHours = ch_hoursSvc.GetHours(sc_id); GridViewSvc.GVBind(dsHours, gvHours); }
protected void btn_edit_pro_Click(object sender, ImageClickEventArgs e) { ImageButton btn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; GVProfessions.EditIndex = gvr.RowIndex; //Bind data to GridView DataSet dsProfessions = ch_professionsSvc.GetProfessions(); GridViewSvc.GVBind(dsProfessions, GVProfessions); }
protected void btn_cancel_insert_lvl_Click(object sender, ImageClickEventArgs e) { gvLevels.ShowFooter = false; btnInsert.Enabled = true; lblErrGV.Text = ""; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); }
protected void btn_edit_lvl_Click(object sender, ImageClickEventArgs e) { ImageButton btn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; gvLevels.EditIndex = gvr.RowIndex; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); }
protected void btn_cancel_insert_bhv_Click(object sender, ImageClickEventArgs e) { gvBehaviorsTypes.ShowFooter = false; btnInsert.Enabled = true; lblErr.Text = ""; //Bind data to GridView DataSet dsBehaviors = ch_behaviorsSvc.GetBehaviors(); GridViewSvc.GVBind(dsBehaviors, gvBehaviorsTypes); }