public DataSet getMemActivity(BEJobSeeker bemem)
{
SqlParameter param = new SqlParameter("@email", SqlDbType.NVarChar, 50);
param.Value = bemem.email;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsJSLogininf", param));
}
public string registerJobSeeker(BEJobSeeker beReg)
{
SqlParameter[] param = new SqlParameter[22];
param[0] = new SqlParameter("@Fname", SqlDbType.VarChar, 100);
param[0].Value = beReg.firstName;
param[1] = new SqlParameter("@MName", SqlDbType.VarChar, 5);
param[1].Value = beReg.middleName;
param[2] = new SqlParameter("@Lname", SqlDbType.VarChar, 100);
param[2].Value = beReg.lastName;
param[3] = new SqlParameter("@Add1", SqlDbType.VarChar);
param[3].Value = beReg.address1;
param[4] = new SqlParameter("@Add2", SqlDbType.VarChar);
param[4].Value = beReg.address2;
param[5] = new SqlParameter("@city", SqlDbType.VarChar, 200);
param[5].Value = beReg.city;
param[6] = new SqlParameter("@state", SqlDbType.VarChar, 100);
param[6].Value = beReg.state;
param[7] = new SqlParameter("@zip", SqlDbType.VarChar, 20);
param[7].Value = beReg.zip;
param[8] = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
param[8].Value = beReg.phone;
param[9] = new SqlParameter("@Mobile", SqlDbType.VarChar, 20);
param[9].Value = beReg.mobile;
param[10] = new SqlParameter("@Email", SqlDbType.VarChar, 200);
param[10].Value = beReg.email;
param[11] = new SqlParameter("@LegallyUs", SqlDbType.VarChar, 10);
param[11].Value = beReg.legallyUs;
param[12] = new SqlParameter("@RecentEmployer", SqlDbType.VarChar, 200);
param[12].Value = beReg.mRecentEmp;
param[13] = new SqlParameter("@JobTitle", SqlDbType.VarChar, 200);
param[13].Value = beReg.jobTitle;
param[14] = new SqlParameter("@FiledofExpertise", SqlDbType.VarChar, 200);
param[14].Value = beReg.fieldExpertise;
param[15] = new SqlParameter("@Exp", SqlDbType.VarChar, 20);
param[15].Value = beReg.experience;
param[16] = new SqlParameter("@PrefLoc", SqlDbType.VarChar, 50);
param[16].Value = beReg.prefLoc;
param[17] = new SqlParameter("@Education", SqlDbType.VarChar, 50);
param[17].Value = beReg.HighEdu;
param[18] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
param[18].Value = beReg.password;
param[19] = new SqlParameter("@filename", SqlDbType.VarChar, 10);
param[19].Value = beReg.filename;
param[20] = new SqlParameter("@Message", SqlDbType.VarChar, 50);
param[20].Direction = ParameterDirection.Output;
param[21] = new SqlParameter("@RegSession", SqlDbType.NVarChar, 50);
param[21].Value = beReg.tempId;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsMemRegForUploadResume", param);
return(Convert.ToString(param[20].Value));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblResume.Visible = false;
if (Session["PSJUID"].ToString() != "")
{
BEJobSeeker bemem = new BEJobSeeker();
BAJobSeeker bamem = new BAJobSeeker();
bemem.email = Session["PSJUID"].ToString();
ds = new DataSet();
ds = bamem.GetMemActivity(bemem);
ViewState["filename"] = ds.Tables[0].Rows[0]["filename"].ToString();
string username = ds.Tables[0].Rows[0]["username"].ToString();
Session["username"] = ds.Tables[0].Rows[0]["username"].ToString();
ViewState["username"] = ds.Tables[0].Rows[0]["username"].ToString();
lblUsername.Text = ds.Tables[0].Rows[0]["firstname"].ToString();
lblname.Text = ds.Tables[0].Rows[0]["firstname"].ToString();
Session["LoginTime"] = ds.Tables[2].Rows[0]["LoginTime"].ToString();
lblLastLoginTime.Text = ds.Tables[2].Rows[0]["LoginTime"].ToString();
lblLogintime.Text = ds.Tables[1].Rows[0]["IntialLogin"].ToString();
lblact.Text = ds.Tables[0].Rows[0]["AccountDt"].ToString();
#region JobAlert
beJobAlert.jobSeekerID = Session["PSJUID"].ToString();
beJobAlert.type = 0;
dsjob = new DataSet();
dsjob = bajob.GetJobAlerts(beJobAlert);
if (dsjob.Tables[0].Rows.Count == 0)
{
dlJobAlerts.DataSource = null;
dlJobAlerts.DataBind();
hpkjobalert.Visible = false;
}
else
{
dlJobAlerts.DataSource = dsjob;
dlJobAlerts.DataBind();
}
#endregion
}
else
{
Response.Redirect("JobSeekerLogin.aspx", false);
}
}
}
public void updateMemReg(BEJobSeeker beReg, BEMemDetails beMem)
{
SqlParameter[] param = new SqlParameter[19];
param[0] = new SqlParameter("@firstname", SqlDbType.VarChar, 100);
param[0].Value = beReg.firstName;
param[1] = new SqlParameter("@middlename", SqlDbType.VarChar, 5);
param[1].Value = beReg.middleName;
param[2] = new SqlParameter("@lastname", SqlDbType.VarChar, 100);
param[2].Value = beReg.lastName;
param[3] = new SqlParameter("@address1", SqlDbType.VarChar);
param[3].Value = beReg.address1;
param[4] = new SqlParameter("@address2", SqlDbType.VarChar);
param[4].Value = beReg.address2;
param[5] = new SqlParameter("@city", SqlDbType.VarChar, 200);
param[5].Value = beReg.city;
param[6] = new SqlParameter("@state", SqlDbType.VarChar, 100);
param[6].Value = beReg.state;
param[7] = new SqlParameter("@zip", SqlDbType.VarChar, 20);
param[7].Value = beReg.zip;
param[8] = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
param[8].Value = beReg.phone;
param[9] = new SqlParameter("@Mobile", SqlDbType.VarChar, 20);
param[9].Value = beReg.mobile;
param[10] = new SqlParameter("@Email", SqlDbType.VarChar, 200);
param[10].Value = beReg.email;
param[11] = new SqlParameter("@LegallyUs", SqlDbType.VarChar, 10);
param[11].Value = beReg.legallyUs;
param[12] = new SqlParameter("@RecentEmp", SqlDbType.VarChar, 200);
param[12].Value = beReg.mRecentEmp;
param[13] = new SqlParameter("@JobTitle", SqlDbType.VarChar, 200);
param[13].Value = beReg.jobTitle;
param[14] = new SqlParameter("@category", SqlDbType.VarChar, 200);
param[14].Value = beReg.fieldExpertise;
param[15] = new SqlParameter("@Exp", SqlDbType.VarChar, 20);
param[15].Value = beReg.experience;
param[16] = new SqlParameter("@preferredLoc", SqlDbType.VarChar, 50);
param[16].Value = beReg.prefLoc;
param[17] = new SqlParameter("@Education", SqlDbType.VarChar, 50);
param[17].Value = beReg.HighEdu;
param[18] = new SqlParameter("@memEmail", SqlDbType.NVarChar, 50);
param[18].Value = beMem.email;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsUpdateMemberReg", param);
}
public string InsertCandidateData(BEJobSeeker bemarreg)
{
SqlParameter[] param = new SqlParameter[15];
param[0] = new SqlParameter("@Fname", SqlDbType.VarChar, 100);
param[0].Value = bemarreg.firstName;
param[1] = new SqlParameter("@MName", SqlDbType.VarChar, 5);
param[1].Value = bemarreg.middleName;
param[2] = new SqlParameter("@Lname", SqlDbType.VarChar, 100);
param[2].Value = bemarreg.lastName;
param[3] = new SqlParameter("@city", SqlDbType.VarChar, 50);
param[3].Value = bemarreg.city;
param[4] = new SqlParameter("@state", SqlDbType.VarChar, 100);
param[4].Value = bemarreg.state;
param[5] = new SqlParameter("@address", SqlDbType.VarChar);
param[5].Value = bemarreg.address1;
param[6] = new SqlParameter("@Mobile", SqlDbType.VarChar, 20);
param[6].Value = bemarreg.mobile;
param[7] = new SqlParameter("@Emailid", SqlDbType.VarChar, 400);
param[7].Value = bemarreg.email;
param[8] = new SqlParameter("@TotalExp", SqlDbType.VarChar, 20);
param[8].Value = bemarreg.experience;
param[9] = new SqlParameter("@Industry1", SqlDbType.VarChar, 50);
param[9].Value = bemarreg.Industry1;
param[10] = new SqlParameter("@Industry2", SqlDbType.VarChar, 50);
param[10].Value = bemarreg.Industry2;
param[11] = new SqlParameter("@Industry3", SqlDbType.VarChar, 50);
param[11].Value = bemarreg.Industry3;
param[12] = new SqlParameter("@Ext", SqlDbType.VarChar, 50);
param[12].Value = "docx";
param[13] = new SqlParameter("@ContactNum", SqlDbType.VarChar, 50);
param[13].Value = bemarreg.phone;
param[14] = new SqlParameter("@Status", SqlDbType.VarChar, 1000);
param[14].Value = bemarreg.Status;
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "sps_inSertCandidateResumData", param);
return(ds.Tables[0].Rows[0][0].ToString());
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string selectedItem = string.Empty;
if (lbPreLoc.Items.Count > 0)
{
for (int i = 0; i < lbPreLoc.Items.Count; i++)
{
if (lbPreLoc.Items[i].Selected)
{
selectedItem += lbPreLoc.Items[i].Value + ',';
}
}
}
selectedItem = selectedItem.Remove(selectedItem.Length - 1);
BEJobSeeker beDetails = new BEJobSeeker();
BEMemDetails beMem = new BEMemDetails();
BAJobSeeker baUpdate = new BAJobSeeker();
beDetails.firstName = txtFName.Text;
beDetails.lastName = txtLName.Text;
beDetails.middleName = txtMName.Text;
beDetails.address1 = txtAddr1.Text;
beDetails.address2 = txtAddr2.Text;
beDetails.city = txtCity.Text;
beDetails.state = ddlState.SelectedValue;
beDetails.zip = txtZip.Text;
beDetails.phone = txtPhone.Text;
beDetails.mobile = txtMobile.Text;
beDetails.email = txtEmail.Text;
beDetails.legallyUs = rbLegallyUs.SelectedValue;
beDetails.mRecentEmp = txtMRecentEmployer.Text;
beDetails.jobTitle = txtJobTitle.Text;
beDetails.HighEdu = ddlHEdu.SelectedValue;
beDetails.fieldExpertise = ddlFieldExpertise.SelectedValue;
beDetails.experience = ddlYearsExp.SelectedValue + "." + ddlMonthsExp.SelectedValue;
beDetails.prefLoc = selectedItem;
beMem.email = Session["PSJUID"].ToString();
try
{
baUpdate.updateMemReg(beDetails, beMem);
btnUpdate.Visible = false;
txtFName.Text = "";
txtMName.Text = "";
txtLName.Text = "";
txtAddr1.Text = "";
txtAddr2.Text = "";
txtCity.Text = "";
ddlState.SelectedIndex = 0;
txtZip.Text = "";
txtPhone.Text = "";
txtMobile.Text = "";
txtEmail.Text = "";
rbLegallyUs.SelectedValue = "";
txtMRecentEmployer.Text = "";
txtJobTitle.Text = "";
ddlFieldExpertise.SelectedIndex = 0;
ddlMonthsExp.SelectedValue = "-1";
ddlYearsExp.SelectedValue = "-1";
lbPreLoc.ClearSelection();
ddlHEdu.SelectedValue = "-1";
Response.Redirect("ViewProfile.aspx");
}
catch (Exception)
{ }
finally
{
}
}
public DataSet GetMemActivity(BEJobSeeker bemem)
{
return(DAreg.getMemActivity(bemem));
}
public void updateMemReg(BEJobSeeker beReg, BEMemDetails beMem)
{
DAreg.updateMemReg(beReg, beMem);
}
public string regJobSeeker(BEJobSeeker beReg)
{
return(DAreg.registerJobSeeker(beReg));
}