protected void DDLDistrict_SelectedIndexChanged(object sender, EventArgs e)
{
List <string> ls2 = new List <string>();
ls2.Clear();
ls2.Add("--Select City--");
switch (DDLDistrict.Text)
{
case "Bangalore":
ls2.Add("Garden City");
break;
case "Hosur":
ls2.Add("Hosur City");
break;
case "Kuppam":
ls2.Add("Kuppam City");
break;
case "Kerala One":
ls2.Add("Kerala One City");
break;
}
DDLCity.DataSource = ls2;
DDLCity.DataBind();
}
private void BindCity()
{
try
{
DDLCity.Enabled = true;
rfvDDLCity.Enabled = true;
DDLCity.Items.Clear();
DataSet ds = new DataSet();
int state_id = Convert.ToInt32(DDLProvince.SelectedValue.ToString());
ds = _objBoutility.get_City_State(state_id);
if (ds.Tables[0].Rows.Count > 0)
{
DDLCity.DataSource = ds.Tables[0];
DDLCity.DataTextField = "Name";
DDLCity.DataValueField = "Id";
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("-- Please Select --", "0"));
}
else
{
DDLCity.DataSource = null;
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("-- Please Select --", "0"));
}
}
catch (Exception ex)
{
lblMsg.Text = _objBoutility.ShowMessage("danger", "error", ex.Message);
ExceptionLogging.SendExcepToDB(ex);
}
}
public void cleanbt1()
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox10.Text = "";
TextBox11.Text = "";
DataView dvc = (DataView)this.SqlDataSourceCity.Select(new DataSourceSelectArguments());
DataView dvs = (DataView)this.SqlDataSourceAccess.Select(new DataSourceSelectArguments());
DDLCity.Items.Clear();
DDLCity.Items.Add("請選擇縣市");
DDLCity.DataSource = dvc;
DDLCity.DataTextField = "city";
DDLCity.DataBind();
DDLAccess.Items.Clear();
DDLAccess.Items.Add("請選擇");
DDLAccess.DataSource = dvs;
DDLAccess.DataTextField = "Cols";
DDLAccess.DataBind();
}
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
{
DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLCity.Enabled = true;
}
public void BindCity_State()
{
DDLCity.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLState.SelectedValue.ToString()), "ListCity");
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("All", "0"));
DDLCity.Enabled = true;
}
protected void grdBankDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
pnlBank.Visible = false;
Panel1.Visible = true;
btnsave.Visible = true;
filter.Visible = false;
txtbankCode.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkCode")).Text;
DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state");
DDLstate.DataBind();
DDLstate.Items.Insert(0, new ListItem("--Select State--", "0"));
DDLstate.Enabled = true;
//
pnlBank.Visible = false;
Panel1.Visible = true;
lblBankId.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankID")).Text;
txtbankName.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkName")).Text;
txtbDesc.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankdecp")).Text;
txtcountry.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcountry")).Text;
DDLCity.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcity")).Text;
DDLstate.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblstate")).Text;
DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLCity.Enabled = true;
chekactive.Checked = ((CheckBox)grdBankDetails.Rows[e.NewEditIndex].FindControl("chkactive")).Checked;
}
catch
{
}
}
protected void DDLState_SelectedIndexChanged(object sender, EventArgs e)
{
string connetionString;
SqlConnection cnn;
connetionString = @"Data Source=DESKTOP-NCLVKS1;Initial Catalog=E-Employment ;User ID=sa;Password=allohomora";
String sql;
cnn = new SqlConnection(connetionString);
SqlCommand command;
cnn.Open();
sql = "Select * from City where [State Id] = @stateId";
command = new SqlCommand(sql, cnn);
command.Parameters.AddWithValue("@stateId", DDLState.SelectedIndex);
SqlDataAdapter sda = new SqlDataAdapter(command);
DataTable dt = new DataTable();
sda.Fill(dt);
DDLCity.DataSource = dt;
DDLCity.DataTextField = "Name";
DDLCity.DataValueField = "Id";
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("Select", "0".ToString()));
cnn.Close();
}
protected void DDLCountry_SelectedIndexChanged(object sender, EventArgs e)
{
int countID = Convert.ToInt32(DDLCountry.SelectedItem.Value);
if (countID > 0)
{
conn = DB_Connect.GetConnection();
conn.Open();
string query = "Select * from City Where CountryID = " + countID;
SqlDataAdapter _sqlda = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
_sqlda.Fill(dt);
DDLCity.DataSource = dt;
DDLCity.DataValueField = "CityID";
DDLCity.DataTextField = "CityName";
DDLCity.DataBind();
}
}
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["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();
}
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;
}
}
}
}
protected void DDLState_SelectedIndexChanged(object sender, EventArgs e)
{
List <string> ls = new List <string>();
ls.Clear();
ls.Add("Select City");
switch (DDLState.Text)
{
case "TamilNadu":
ls.Add("Chennai");
ls.Add("Vellore");
ls.Add("Hosur");
break;
case "Karnataka":
ls.Add("Bangalore");
ls.Add("Mysore");
ls.Add("Glbarga");
ls.Add("Chitradurga");
ls.Add("Bidar");
ls.Add("Shimoga");
ls.Add("Hubli");
ls.Add("Chikkamagaluru");
ls.Add("Hassan");
break;
case "Nassarawa":
ls.Add("Karau");
ls.Add("Karau Mada");
break;
case "Kaduna":
ls.Add("Romi");
ls.Add("Television");
ls.Add("Sabon Tasha");
break;
case "Abuja":
ls.Add("Maraba Yanya");
ls.Add("Airport Road");
ls.Add("Estate Road");
break;
case "Lagos":
ls.Add("Lag 1");
ls.Add("Lag 2");
break;
case "Washington":
ls.Add("Washington City");
ls.Add("Wash 2");
break;
case "England":
ls.Add("Eng 1");
ls.Add("Eng 2");
break;
}
DDLCity.DataSource = ls;
DDLCity.DataBind();
}
