private void fillLocations() { try { BA_postjobs pst2 = new BA_postjobs(); //code for selecting location DataSet dslocations = new DataSet();; dslocations = pst2.getLocations(); ddlLocation.DataSource = dslocations; ddlLocation.DataTextField = "PreLoc"; ddlLocation.DataValueField = "PreLoc"; ddlLocation.DataBind(); ddlLocation.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlLocation.Items.Insert(1, new ListItem("--OTHER--", "--OTHER--")); } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { PSEJobId = Session["PSEJobId"].ToString(); if (!Page.IsPostBack) { //code for selecting industry BA_postjobs pst2 = new BA_postjobs(); DataSet dsindustries = new DataSet();; dsindustries = pst2.getindustries(); ddIndustry.DataSource = dsindustries; ddIndustry.DataTextField = "IndusName"; ddIndustry.DataValueField = "ID"; ddIndustry.DataBind(); ddIndustry.Items.Insert(0, new ListItem("--Select--", "--Select--")); //code for selecting experience fro &to ddlmin.Items.Insert(0, new ListItem("Min", "Min")); ddlmax.Items.Insert(0, new ListItem("Max", "Max")); for (int i = 0; i <= 10; i++) { ddlmax.Items.Add(i.ToString()); ddlmin.Items.Add(i.ToString()); } //code for selecting location DataSet dslocations = new DataSet();; dslocations = pst2.getLocations(); ddlLocation.DataSource = dslocations; ddlLocation.DataTextField = "PreLoc"; ddlLocation.DataValueField = "PreLoc"; ddlLocation.DataBind(); ddlLocation.Items.Insert(0, new ListItem("--Select--", "--Select--")); //code for jobtype ddlJobType.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlJobType.Items.Add("Permanent"); ddlJobType.Items.Add("Contract"); //BindRepeater(); //Functionl Area DataSet dt = new DataSet(); SqlCommand cmd1 = new SqlCommand("select ID,FuncArea from tblFunctionalArea where IndusID='" + dsindustries.Tables[0].Rows[0]["ID"].ToString() + "'", con); SqlDataAdapter da3 = new SqlDataAdapter(cmd1); con.Open(); cmd1.ExecuteNonQuery(); ds1 = new DataSet(); da3.Fill(ds1); con.Close(); ddlFunctionalArea.DataSource = ds1.Tables[0]; ddlFunctionalArea.DataTextField = "FuncArea"; ddlFunctionalArea.DataValueField = "id"; ddlFunctionalArea.DataBind(); ddlFunctionalArea.Items.Insert(0, new ListItem("--Select--", "--Select--")); if (Session["PSEJobId"] != null) { dsload.Tables.Add("tblJobPosting"); daload = new SqlDataAdapter("select * from tblJobPosting where id='" + Session["PSEJobId"].ToString() + "'", con); daload.Fill(dsload.Tables["tblJobPosting"]); daload.Dispose(); } if (Session["PSEJobId"] != null) { if (dsload.Tables[0].Rows.Count > 0) { txtJobTitle.Text = dsload.Tables[0].Rows[0]["JobTitle"].ToString(); txtJobDesc.Text = dsload.Tables[0].Rows[0]["JobDescription"].ToString(); DataSet dt1 = new DataSet(); string quer = "select ID from tblIndustries where IndusName='" + dsload.Tables[0].Rows[0]["Industry"].ToString() + "'"; SqlDataAdapter da1 = new SqlDataAdapter("select ID from tblIndustries where IndusName='" + dsload.Tables[0].Rows[0]["Industry"].ToString() + "'", con); da1.Fill(dt1); ddIndustry.SelectedValue = dt1.Tables[0].Rows[0]["ID"].ToString(); ds = new DataSet(); string quer1 = "select ID from tblFunctionalArea where FuncArea='" + dsload.Tables[0].Rows[0]["FunctionalArea"].ToString() + "'"; da2 = new SqlDataAdapter("select ID from tblFunctionalArea where FuncArea='" + dsload.Tables[0].Rows[0]["FunctionalArea"].ToString() + "'", con); da2.Fill(ds); if (ds.Tables[0].Rows[0]["id"].ToString() == "" || ds.Tables[0].Rows[0]["id"].ToString() == null) { ddlFunctionalArea.SelectedIndex = 0; //ddlFunctionalArea.SelectedItem == "--Select--"; } else { ddlFunctionalArea.SelectedValue = ds.Tables[0].Rows[0]["id"].ToString(); } ddlmin.SelectedValue = dsload.Tables[0].Rows[0]["ExpFrom"].ToString(); ddlmax.SelectedValue = dsload.Tables[0].Rows[0]["ExpTo"].ToString(); txtRate.Text = dsload.Tables[0].Rows[0]["Rate"].ToString(); ddlLocation.SelectedValue = dsload.Tables[0].Rows[0]["Location"].ToString(); ddlJobType.SelectedValue = dsload.Tables[0].Rows[0]["JobType"].ToString(); txtVacancy.Text = dsload.Tables[0].Rows[0]["Vacancies"].ToString(); //repeater1.DataSource = dsload.Tables[0].Rows[0]["Responsibilities"].ToString(); //repeater1.DataBind(); txtSkills.Text = dsload.Tables[0].Rows[0]["Skills"].ToString(); } } } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["PSEEMAIL"].ToString() != "" && Session["PSEName"].ToString() != "") { this.Master.ErrorMessage = this.Title; ds = new DataSet(); w = Request.QueryString["memid"].ToString(); jobtitle = Request.QueryString["jobid"].ToString(); ency = new EncryptDecrypt(); MemID = ency.EncryptDecryptString("£", Request.QueryString["memid"].ToString()); jobid = ency.EncryptDecryptString("£", Request.QueryString["jobid"].ToString()); ViewState["orderby"] = "0"; BA_Jobseeker1 bajobseeker = new BA_Jobseeker1(); DataSet ds1 = new DataSet(); ds1 = bajobseeker.getjobseeker(Convert.ToInt32(ViewState["orderby"].ToString()), MemID, jobid); string s = Session["PSEName"].ToString(); string id = Session["PSMEID"].ToString(); SqlCommand cmd = new SqlCommand("select * from [tblMerchantReg] where [MemID]='" + MemID + "'", con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); da.Dispose(); lblError.Visible = false; if (!Page.IsPostBack) { txtJobDesc.Text = ds1.Tables[0].Rows[0]["JobDescription"].ToString(); txtJobTitle.Text = ds1.Tables[0].Rows[0]["JobTitle"].ToString(); //txtLoc.Text = ds1.Tables[0].Rows[0]["Location"].ToString(); txtRate.Text = ds1.Tables[0].Rows[0]["Rate"].ToString(); txtSkills.Text = ds1.Tables[0].Rows[0]["Skills"].ToString(); //code for selecting industry BA_Marketing mar = new BA_Marketing(); BA_postjobs pst2 = new BA_postjobs(); DataSet dsindustries = new DataSet();; dsindustries = mar.fillcategory(); ddIndustry.DataSource = dsindustries; ddIndustry.DataTextField = "indusname"; ddIndustry.DataValueField = "ID"; ddIndustry.DataBind(); ddIndustry.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlcbIndustry.DataSource = dsindustries; ddlcbIndustry.DataTextField = "indusname"; ddlcbIndustry.DataValueField = "indusname"; ddlcbIndustry.DataBind(); DataTable dt = dsindustries.Tables[0]; List <string> lst = new List <string>(); string industriesList = ds1.Tables[0].Rows[0]["Industry"].ToString(); string[] ss = industriesList.Split(','); if (ss.Length > 0) { for (int j = 0; j < ss.Length; j++) { foreach (System.Web.UI.WebControls.ListItem item in ddlcbIndustry.Items) { string name = item.ToString(); if (ss[j] == name) { // int index= ddlcbIndustry.Items.IndexOf(item); // ddlcbIndustry.SelectedIndex = index; item.Selected = true; } } } lblIndus.Text = "You have Selected : " + ConvertStringArrayToStringJoin(ss); } // ddlcbIndustry.Items.Insert(0, new ListItem("--Select--", "--Select--")); //code for selecting experience fro &to ddlmax.Items.Insert(0, new ListItem("Max", "Max")); ddlmin.Items.Insert(0, new ListItem("Min", "Min")); for (int i = 0; i <= 10; i++) { ddlmax.Items.Add(i.ToString()); ddlmin.Items.Add(i.ToString()); } ddlmax.SelectedValue = ds1.Tables[0].Rows[0]["ExpTo"].ToString(); ddlmin.SelectedValue = ds1.Tables[0].Rows[0]["ExpFrom"].ToString(); //code for selecting location DataSet dslocations = new DataSet();; dslocations = pst2.getLocations(); ddlLocation.DataSource = dslocations; ddlLocation.DataTextField = "PreLoc"; ddlLocation.DataValueField = "PreLoc"; ddlLocation.DataBind(); ddlLocation.SelectedItem.Text = ds1.Tables[0].Rows[0]["Location"].ToString(); ddlLocation.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlLocation.Items.Insert(1, new ListItem("--OTHER--", "--OTHER--")); //code for jobtype //ddlJobType.Items.Insert(0, new ListItem("--Select--", "--Select--")); //ddlJobType.Items.Add("Permanent"); //ddlJobType.Items.Add("Contract"); //code for Binding Repeater // BindRepeater(); } } else { Response.Redirect("~/employlogin.aspx", false); } } catch (Exception ex) { Response.Redirect("~/employlogin.aspx", false); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["PSEEMAIL"].ToString() != "" && Session["PSEName"].ToString() != "") { this.Master.ErrorMessage = this.Title; ds = new DataSet(); w = Request.QueryString["memid"].ToString(); ency = new EncryptDecrypt(); MemID = ency.EncryptDecryptString("£", Request.QueryString["memid"].ToString()); string s = Session["PSEName"].ToString(); string id = Session["PSMEID"].ToString(); SqlCommand cmd = new SqlCommand("select * from [tblMerchantReg] where [MemID]='" + MemID + "'", con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); da.Dispose(); lblError.Visible = false; if (!Page.IsPostBack) { //code for selecting industry BA_Marketing mar = new BA_Marketing(); BA_postjobs pst2 = new BA_postjobs(); DataSet dsindustries = new DataSet();; dsindustries = mar.fillcategory(); ddIndustry.DataSource = dsindustries; ddIndustry.DataTextField = "indusname"; ddIndustry.DataValueField = "ID"; ddIndustry.DataBind(); ddIndustry.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlcbIndustry.DataSource = dsindustries; ddlcbIndustry.DataTextField = "indusname"; ddlcbIndustry.DataValueField = "indusname"; ddlcbIndustry.DataBind(); DataTable dt = dsindustries.Tables[0]; List <string> lst = new List <string>(); // ddlcbIndustry.Items.Insert(0, new ListItem("--Select--", "--Select--")); //code for selecting experience fro &to ddlmax.Items.Insert(0, new ListItem("Max", "Max")); ddlmin.Items.Insert(0, new ListItem("Min", "Min")); for (int i = 0; i <= 10; i++) { ddlmax.Items.Add(i.ToString()); ddlmin.Items.Add(i.ToString()); } //code for selecting location DataSet dslocations = new DataSet();; dslocations = pst2.getLocations(); ddlLocation.DataSource = dslocations; ddlLocation.DataTextField = "PreLoc"; ddlLocation.DataValueField = "PreLoc"; ddlLocation.DataBind(); ddlLocation.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlLocation.Items.Insert(1, new ListItem("--OTHER--", "--OTHER--")); //code for jobtype //ddlJobType.Items.Insert(0, new ListItem("--Select--", "--Select--")); //ddlJobType.Items.Add("Permanent"); //ddlJobType.Items.Add("Contract"); //code for Binding Repeater // BindRepeater(); } } else { Response.Redirect("~/employlogin.aspx", false); } } catch (Exception ex) { Response.Redirect("~/employlogin.aspx", false); } }