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