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