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