protected void Page_Load(object sender, EventArgs e) { if (Session["usr_id"] == null) { Response.Redirect("Login.aspx"); } else { if (Session["usr_id"].ToString() == "") { Response.Redirect("Login.aspx"); } } int usr_id = Convert.ToInt32(Session["usr_id"]); if (!IsPostBack) { //DDL Schools DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; //DDL Jobs DataSet dsJobs = ch_jobsSvc.GetJobs(); ddlJobs.DataSource = dsJobs; ddlJobs.DataValueField = "job_id"; ddlJobs.DataTextField = "job_name"; ddlJobs.DataBind(); ddlJobs.Items.Add("-בחר תפקיד-"); ddlJobs.SelectedIndex = ddlJobs.Items.Count - 1; DataRow drUser = ch_usersSvc.GetUserById(usr_id); DDLSchools.SelectedValue = drUser["usr.sc_id"].ToString(); txtAddress.Text = drUser["usr_address"].ToString(); DateTextBox.Text = Convert.ToDateTime(drUser["usr_birth_date"].ToString()).ToShortDateString(); DDLCity.SelectedItem.Text = drUser["cty_name"].ToString(); txtEmail.Text = drUser["usr_email"].ToString(); txtFirstName.Text = drUser["usr_first_name"].ToString(); rbtGender.SelectedValue = drUser["usr_gender"].ToString(); txtHomePhone.Text = drUser["usr_home_phone"].ToString(); txtCellphone.Text = drUser["usr_cellphone"].ToString(); txtIdentity.Text = drUser["usr_identity"].ToString(); txtLastName.Text = drUser["usr_last_name"].ToString(); if (ch_usersSvc.GetUsrType(usr_id) == "tch") { DataSet pro = ch_professionsSvc.GetProfessions(); DataSet tch_pro = ch_teachers_professionsSvc.GetProfessionsByTch(usr_id); int i = 0; foreach (DataRow dr_pro in pro.Tables[0].Rows) { ListItem li = new ListItem(dr_pro["pro_name"].ToString(), dr_pro["pro_id"].ToString()); lbProfessions.Items.Add(li); foreach (DataRow dr_tch_pro in tch_pro.Tables[0].Rows) { if (dr_tch_pro["pro_id"].ToString() == dr_pro["pro_id"].ToString()) { li.Selected = true; } } i++; } pnlTch.Visible = true; } if (ch_usersSvc.GetUsrType(usr_id) == "crw") { DataRow drCrew = ch_crewSvc.GetCrw(Convert.ToInt32(Session["usr_id"])); ddlJobs.SelectedValue = drCrew["job_id"].ToString(); pnlCrw.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["lvl_id"] == null) { Response.Redirect("Default.aspx"); } else { if (Convert.ToInt32(Session["lvl_id"]) < 3) { Response.Redirect("Default.aspx"); } else { if (!IsPostBack) { if (Convert.ToInt32(Session["lvl_id"]) == 3) // if editor //DDL Schools { int sc_id = Convert.ToInt32(Session["sc_id"]); DataSet dsSchools = ch_schoolsSvc.GetSchool(sc_id); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); //DDL Rooms DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(Session["sc_id"])); ddlRooms.DataSource = dsRooms; ddlRooms.DataValueField = "rm_id"; ddlRooms.DataTextField = "rm_name"; ddlRooms.DataBind(); ddlRooms.Items.Add("-בחר כיתה-"); ddlRooms.SelectedIndex = ddlRooms.Items.Count - 1; } else if (Convert.ToInt32(Session["lvl_id"]) >= 4) // if vice_manager and up //DDL Schools { DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; } //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["lvl_id"] == null) { Response.Redirect("Default.aspx"); } else { if (Convert.ToInt32(Session["lvl_id"]) < 3) { Response.Redirect("Default.aspx"); } else { if (!IsPostBack) { if (Convert.ToInt32(Session["lvl_id"]) == 3) // if editor //DDL Schools { int sc_id = Convert.ToInt32(Session["sc_id"]); DataSet dsSchools = ch_schoolsSvc.GetSchool(sc_id); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); } else if (Convert.ToInt32(Session["lvl_id"]) == 4) // if vice_manager //DDL Schools { DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; DDLSchools.DataTextField = "sc_name"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; } else if (Convert.ToInt32(Session["lvl_id"]) >= 5) // if manager and up //DDL Levels { DataSet dsLevels = ch_levelsSvc.GetLevels(); ddlLevels.DataSource = dsLevels; ddlLevels.DataValueField = "lvl_id"; ddlLevels.DataTextField = "lvl_name"; ddlLevels.DataBind(); ddlLevels.Items.Add(new ListItem("-בחר רמה-", "-1")); ddlLevels.SelectedValue = "2"; } //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; //DDL Jobs DataSet dsJobs = ch_jobsSvc.GetJobs(); ddlJobs.DataSource = dsJobs; ddlJobs.DataValueField = "job_id"; ddlJobs.DataTextField = "job_name"; ddlJobs.DataBind(); ddlJobs.Items.Add("-בחר תפקיד-"); ddlJobs.SelectedIndex = ddlJobs.Items.Count - 1; } } } }