protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { if (Session["PSMEID"].ToString() != "" && Session["PSMEName"].ToString() != "") { BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); ds = mar.fillcategory(); ddlindustry.DataSource = ds.Tables[0]; ddlindustry.DataTextField = "indusname"; ddlindustry.DataValueField = "indusname"; ddlindustry.DataBind(); ddlstate.DataSource = ds.Tables[1]; ddlstate.DataTextField = "State"; ddlstate.DataValueField = "State"; ddlstate.DataBind(); ddlindustry.Items.Insert(0, new ListItem("Select", "Select")); ddlstate.Items.Insert(0, new ListItem("Select", "Select")); ddlcity.Items.Insert(0, new ListItem("Select", "Select")); FillGrid(); } else { Response.Redirect("~/MarketingLogin.aspx", false); } } catch (Exception ex) { Response.Redirect("~/MarketingLogin.aspx", false); } } }
private void fillIndustrieslist() { BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); ds = mar.fillcategory(); ddlIndustries1.DataSource = ds.Tables[0]; ddlIndustries1.DataTextField = "indusname"; ddlIndustries1.DataValueField = "indusname"; ddlIndustries1.DataBind(); ddlIndustries1.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlIndustries2.DataSource = ds.Tables[0]; ddlIndustries2.DataTextField = "indusname"; ddlIndustries2.DataValueField = "indusname"; ddlIndustries2.DataBind(); ddlIndustries2.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlIndustry3.DataSource = ds.Tables[0]; ddlIndustry3.DataTextField = "indusname"; ddlIndustry3.DataValueField = "indusname"; ddlIndustry3.DataBind(); ddlIndustry3.Items.Insert(0, new ListItem("--Select--", "--Select--")); ddlState.DataSource = ds.Tables[1]; ddlState.DataTextField = "State"; ddlState.DataValueField = "State"; ddlState.DataBind(); ddlState.Items.Insert(0, new ListItem("Select", "Select")); }
public void load() { try { EncryptDecrypt ency = new EncryptDecrypt(); ViewState["jsid"] = ency.EncryptDecryptString("£", Request.QueryString["id"].ToString()); string jsid = ViewState["jsid"].ToString(); BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); ds = mar.GetHireCandidateDetails(jsid); string date = ds.Tables[0].Rows[0]["AppointingDate"].ToString(); DateTime dt = Convert.ToDateTime(date); txtApnmtDate.Text = dt.ToString("MM/dd/yyyy"); txtCName.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString(); txtLocation.Text = ds.Tables[0].Rows[0]["CompanyLocation"].ToString(); string date1 = ds.Tables[0].Rows[0]["ContractFromDate"].ToString(); DateTime dt1 = Convert.ToDateTime(date1); txtFromDate.Text = dt1.ToString("MM/dd/yyyy"); txtPosition.Text = ds.Tables[0].Rows[0]["Position"].ToString(); txtjobType.Text = ds.Tables[0].Rows[0]["JobType"].ToString(); txtSalary.Text = ds.Tables[0].Rows[0]["Salary"].ToString(); ddlSalaryType.SelectedItem.Text = ds.Tables[0].Rows[0]["SalaryType"].ToString(); string date2 = ds.Tables[0].Rows[0]["ContractToDate"].ToString(); DateTime dt2 = Convert.ToDateTime(date2); txtToDate.Text = dt2.ToString("MM/dd/yyyy"); txtName.Text = ds.Tables[0].Rows[0]["name"].ToString(); } catch (Exception ex) { Response.Redirect("~/MarketingLogin.aspx", false); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (ddlSalaryType.SelectedItem.Text != "--Select--" || ddlSalaryType.SelectedItem.Text != "" || ddlSalaryType.SelectedItem.Text != "Select") { string apnmntdate = txtApnmtDate.Text; string cname = txtCName.Text; string clocatiion = txtLocation.Text; string fromdate = txtFromDate.Text; string name = txtName.Text; string position = txtPosition.Text; string jobType = txtjobType.Text; string salary = txtSalary.Text; string salarytype = ddlSalaryType.SelectedItem.Text; string todate = txtToDate.Text; string jsid = ViewState["jsid"].ToString(); BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); ds = mar.UpdateHireCandidateDetails(jsid, apnmntdate, cname, clocatiion, fromdate, name, position, jobType, salary, salarytype, todate); load(); btnUpdate.Visible = false; txtApnmtDate.Enabled = false; txtCName.Enabled = false; txtLocation.Enabled = false; txtFromDate.Enabled = false; txtName.Enabled = false; txtPosition.Enabled = false; txtjobType.Enabled = false; txtSalary.Enabled = false; ddlSalaryType.Enabled = false; txtToDate.Enabled = false; btnUpdate.Visible = false; FillHiredGrid(); System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Updated Successfully');", true); } else { System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Please Select Salary Type');", true); } } catch (Exception ex) { load(); btnUpdate.Visible = false; txtApnmtDate.Enabled = false; txtCName.Enabled = false; txtLocation.Enabled = false; txtFromDate.Enabled = false; txtName.Enabled = false; txtPosition.Enabled = false; txtSalary.Enabled = false; ddlSalaryType.Enabled = false; txtToDate.Enabled = false; btnUpdate.Visible = false; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Update Failure');", true); } }
protected void btnsearch_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); BA_Marketing mar = new BA_Marketing(); if (ddlIndustry.SelectedItem.Value == "Select") { ds = mar.SearchHiringData(txtcomp.Text, txtHireCompany.Text, txtHireDate.Text, ""); } else { ds = mar.SearchHiringData(txtcomp.Text, txtHireCompany.Text, txtHireDate.Text, ddlIndustry.SelectedItem.Text); } DataTable dt = ds.Tables[0]; //if (ddlsort.SelectedItem.Text == "Name") //{ // dt.DefaultView.Sort = "Name "; //} //else //{ // dt.DefaultView.Sort = "uploaddate desc"; //} if (ds != null && ds.Tables[0].Rows.Count > 0) { //DataTable dt = ds1.Tables[0]; //if (dddlsort.SelectedIndex != 0) //{ // dt.DefaultView.Sort = dddlsort.SelectedValue.ToString(); //} pnlMain.Visible = true; pnlSub.Visible = false; _PageDataSource.DataSource = ds.Tables[0].DefaultView; _PageDataSource.AllowPaging = true; _PageDataSource.PageSize = PageSize; _PageDataSource.CurrentPageIndex = CurrentPage; ViewState["TotalPages"] = _PageDataSource.PageCount; this.lblPageInfo.Text = "Page " + (CurrentPage + 1) + " of " + _PageDataSource.PageCount; this.lbtnPrevious.Enabled = !_PageDataSource.IsFirstPage; this.lbtnNext.Enabled = !_PageDataSource.IsLastPage; this.lbtnFirst.Enabled = !_PageDataSource.IsFirstPage; dljobseekerdet.DataSource = _PageDataSource; dljobseekerdet.DataBind(); this.doPaging(); lblCount.Text = Convert.ToString(ds.Tables[0].Rows.Count); } else { pnlMain.Visible = false; pnlSub.Visible = true; } }
public void FillGrid() { ViewState["sort"] = 1; DataSet ds = new DataSet(); BA_Marketing mar = new BA_Marketing(); ds = mar.HoldmarketList(); DataTable dt = ds.Tables[0]; if (ds != null && ds.Tables[0].Rows.Count > 0) { if (ddlsort.SelectedItem.Text.Trim() == "Name") { dt.DefaultView.Sort = "FName"; } else { dt.DefaultView.Sort = "Jsid desc"; } //DataTable dt = ds1.Tables[0]; //if (dddlsort.SelectedIndex != 0) //{ // dt.DefaultView.Sort = dddlsort.SelectedValue.ToString(); //} pnlMain.Visible = true; pnlSub.Visible = false; _PageDataSource.DataSource = dt.DefaultView; _PageDataSource.AllowPaging = true; _PageDataSource.PageSize = PageSize; _PageDataSource.CurrentPageIndex = CurrentPage; ViewState["TotalPages"] = _PageDataSource.PageCount; this.lblPageInfo.Text = "Page " + (CurrentPage + 1) + " of " + _PageDataSource.PageCount; this.lbtnPrevious.Enabled = !_PageDataSource.IsFirstPage; this.lbtnNext.Enabled = !_PageDataSource.IsLastPage; this.lbtnFirst.Enabled = !_PageDataSource.IsFirstPage; dljobseekerdet.DataSource = _PageDataSource; dljobseekerdet.DataBind(); this.doPaging(); lblCount.Text = Convert.ToString(ds.Tables[0].Rows.Count); } else { pnlMain.Visible = false; pnlSub.Visible = true; } }
private void fillIndustrieslist() { BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); try { ds = mar.fillcategory(); ddlIndustry.DataSource = ds.Tables[0]; ddlIndustry.DataTextField = "indusname"; ddlIndustry.DataValueField = "indusname"; ddlIndustry.DataBind(); ddlIndustry.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "Select")); } catch (Exception ex) { } }
private void fillCategories() { BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); try { ds = mar.fillcategory(); ddlCategory.DataSource = ds.Tables[0]; ddlCategory.DataTextField = "indusname"; ddlCategory.DataValueField = "indusname"; ddlCategory.DataBind(); ddlCategory.Items.Insert(0, new ListItem("----------Select----------", "----------Select----------")); } catch (Exception ex) { } }
public void SearchGrid(int status) { try { if (txtcomp.Text == "" && ddlexpfrom.SelectedItem.Text == "From" && ddlexpto.SelectedItem.Text == "To" && ddlindustry.SelectedItem.Text == "Select" && ddlstate.SelectedItem.Text == "Select") { System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Please Enter Name Or Exp Or Industry or State or City');", true); } else { BA_Marketing mar = new BA_Marketing(); DataSet ds = new DataSet(); string expfrom = ddlexpfrom.SelectedItem.ToString(); string expto = ddlexpto.SelectedItem.ToString(); string industry = ddlindustry.SelectedItem.ToString(); string state = ddlstate.SelectedItem.ToString(); string city = ""; if (txtcomp.Text.ToString() == "") { ViewState["search"] = ""; } else { ViewState["search"] = "%" + txtcomp.Text.ToString() + "%"; } if (expfrom == "From") { expfrom = ""; } if (expto == "To") { expto = ""; } if (industry == "Select") { industry = ""; } if (state == "Select") { state = ""; } ds = mar.SearchMarketlist(ViewState["search"].ToString(), expfrom, expto, industry, status, state, city); if (ds != null && ds.Tables[0].Rows.Count > 0) { //DataTable dt = ds1.Tables[0]; //if (dddlsort.SelectedIndex != 0) //{ // dt.DefaultView.Sort = dddlsort.SelectedValue.ToString(); //} pnlMain.Visible = true; pnlSub.Visible = false; _PageDataSource.DataSource = ds.Tables[0].DefaultView; _PageDataSource.AllowPaging = true; _PageDataSource.PageSize = PageSize; _PageDataSource.CurrentPageIndex = CurrentPage; ViewState["TotalPages"] = _PageDataSource.PageCount; this.lblPageInfo.Text = "Page " + (CurrentPage + 1) + " of " + _PageDataSource.PageCount; this.lbtnPrevious.Enabled = !_PageDataSource.IsFirstPage; this.lbtnNext.Enabled = !_PageDataSource.IsLastPage; this.lbtnFirst.Enabled = !_PageDataSource.IsFirstPage; dljobseekerdet.DataSource = _PageDataSource; dljobseekerdet.DataBind(); this.doPaging(); lblCount.Text = Convert.ToString(ds.Tables[0].Rows.Count); } else { pnlMain.Visible = false; pnlSub.Visible = true; } } } catch (Exception e) { Response.Redirect("~/Marketing/MarketingLogin.aspx"); } }
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); } }