public DataSet getMemCompleteDetails(BEMemDetails beMem) { SqlParameter param = new SqlParameter("@email", SqlDbType.NVarChar, 50); param.Value = beMem.email; return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsGetMemCompleteDetails", param)); }
public void fillGrid(string email) { BEMemDetails beApplied = new BEMemDetails(); beApplied.email = email; BAJobSearch baApplied = new BAJobSearch(); DataSet ds = new DataSet(); ds = baApplied.getJobsApplied(beApplied); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { 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; dljobdet.DataSource = _PageDataSource; dljobdet.DataBind(); this.doPaging(); } else { pnlMain.Visible = false; pnlSub.Visible = true; } } }
protected void btnUpload_Click(object sender, EventArgs e) { BAJobSeeker BAreg = new BAJobSeeker(); BEMemDetails beMem = new BEMemDetails(); BEUpdateResume beresm = new BEUpdateResume(); if (Session["PSJUID"].ToString() != "" || Session["PSJUID"].ToString() != null) { name = Session["PSJUID"].ToString(); beMem.email = name; ds = BAreg.getMemDetails(beMem); } if (uploadFile.HasFile) { if (uploadFile.PostedFile.ContentLength <= 1024000) { if (checkFileType(uploadFile.FileName)) { string ext = Path.GetExtension(uploadFile.FileName).ToLower(); uploadFile.SaveAs(ConfigurationManager.AppSettings["Resumes"].ToString() + ds.Tables[0].Rows[0]["id"] + ext); beresm.filename = ext; beresm.email = name; string ReturnMsg = BAreg.Updateresume(beresm); if (ReturnMsg == "Success") { lblMsg.Text = "Resume successfully updated."; lblMsg.Visible = true; } else { lblMsg.Text = "Error in updating the resume"; lblMsg.Visible = true; } } else { lblMsg.Text = "Please upload your resume in .doc or .docx format only."; lblMsg.Visible = true; } } else { lblMsg.Text = "File size exceeded the maximum size limit. Please upload file having size below 1 megabyte."; lblMsg.Visible = true; } } else { lblMsg.Text = "Please add the file to upload."; lblMsg.Visible = true; } }
public string getMemLastLogin(BEMemDetails beMem) { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@email", SqlDbType.NVarChar, 50); param[0].Value = beMem.email; param[1] = new SqlParameter("@lastlogouttime", SqlDbType.NVarChar, 50); param[1].Direction = ParameterDirection.Output; SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsGetMemLastLogin", param); return(Convert.ToString(param[1].Value)); }
public string ResetPswJobSeeker(BEMemDetails beMem) { SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@email", SqlDbType.NVarChar, 50); param[0].Value = beMem.email; param[1] = new SqlParameter("@password", SqlDbType.NVarChar, 50); param[1].Value = beMem.password; param[2] = new SqlParameter("@result", SqlDbType.NVarChar, 50); param[2].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsSetForgotPassword", param); return(Convert.ToString(param[2].Value)); }
protected void Page_Load(object sender, EventArgs e) { name = Request.QueryString["PSJUID"]; if (!IsPostBack) { if (Session["PSJUID"] != null) { BAJobSeeker baMem = new BAJobSeeker(); BEMemDetails beMem = new BEMemDetails(); beMem.email = Session["PSJUID"].ToString(); DataSet ds = new DataSet(); ds = baMem.getMemCompleteDetails(beMem); dlUserProfile.DataSource = ds.Tables[0]; dlUserProfile.DataBind(); } } }
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); }
protected void btnlogin_Click(object sender, EventArgs e) { string EncryptedPwd = EncryptPassword_Client(Session.SessionID.ToString()); DataSet ds = new DataSet(); BEMemDetails beMem = new BEMemDetails(); BAJobSeeker baMem = new BAJobSeeker(); beMem.email = TextBox2.Text; beMem.password = EncryptedPwd; ds = baMem.getMemDetails(beMem); if (ds.Tables[0].Rows.Count != 0) { string result = baMem.ResetPswJobSeeker(beMem); if (result == "success") { messageconfirm = SendMail(); } else { lblFail.Text = "Your account is not verified. Please activate your account by clicking on the activation link sent to your email."; } } if (messageconfirm == true) { pnlForgotpass.Visible = false; pnlMsg.Visible = true; lblSuccess.Visible = true; lblFail.Visible = false; } else { pnlForgotpass.Visible = true; pnlMsg.Visible = true; lblSuccess.Visible = false; lblFail.Visible = true; } }
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 { } }
protected void Page_Load(object sender, EventArgs e) { BEMemDetails beMem = new BEMemDetails(); BAJobSeeker baMem = new BAJobSeeker(); beMem.email = Session["PSJUID"].ToString(); ds = baMem.getMemCompleteDetails(beMem); if (!IsPostBack) { BindCategory(); if (ds.Tables[0].Rows.Count != 0) { txtFName.Focus(); lblSuccess.Visible = false; txtFName.Text = ds.Tables[0].Rows[0]["firstname"].ToString(); txtMName.Text = ds.Tables[0].Rows[0]["middlename"].ToString(); txtLName.Text = ds.Tables[0].Rows[0]["lastname"].ToString(); txtAddr1.Text = ds.Tables[0].Rows[0]["addressline1"].ToString(); txtAddr2.Text = ds.Tables[0].Rows[0]["addressline2"].ToString(); txtCity.Text = ds.Tables[0].Rows[0]["city"].ToString(); ddlState.SelectedValue = ds.Tables[0].Rows[0]["state"].ToString(); txtZip.Text = ds.Tables[0].Rows[0]["zip"].ToString(); txtPhone.Text = ds.Tables[0].Rows[0]["phone"].ToString(); txtMobile.Text = ds.Tables[0].Rows[0]["mobile"].ToString(); txtEmail.Text = ds.Tables[0].Rows[0]["email"].ToString(); if (ds.Tables[0].Rows[0]["LegallyUs"].ToString().Trim() == "Yes") { rbLegallyUs.SelectedValue = "Yes"; } else { rbLegallyUs.SelectedValue = "No"; } txtMRecentEmployer.Text = ds.Tables[0].Rows[0]["RecentEmployer"].ToString(); txtJobTitle.Text = ds.Tables[0].Rows[0]["JobTitle"].ToString(); ddlFieldExpertise.SelectedValue = ds.Tables[0].Rows[0]["Category"].ToString(); ddlYearsExp.SelectedValue = ds.Tables[0].Rows[0]["Exp"].ToString().Split('.')[0]; string x = ds.Tables[0].Rows[0]["Exp"].ToString(); string y = string.Empty; if (!string.IsNullOrEmpty(x)) { y = x.Split('.')[1]; } ddlMonthsExp.SelectedValue = y.Trim(); ddlHEdu.SelectedValue = ds.Tables[0].Rows[0]["edu"].ToString(); string[] substring = ds.Tables[0].Rows[0]["PreferredLoc"].ToString().Split(','); foreach (string str in substring) { for (int intItem = 0; intItem <= lbPreLoc.Items.Count - 1; intItem++) { if (lbPreLoc.Items[intItem].Value == str) { lbPreLoc.Items[intItem].Selected = true; } } } } else { Response.Redirect("UserHome.aspx"); } } }
public string ResetPswJobSeeker(BEMemDetails beMem) { return(DAreg.ResetPswJobSeeker(beMem)); }
public void updateMemReg(BEJobSeeker beReg, BEMemDetails beMem) { DAreg.updateMemReg(beReg, beMem); }
public string getMemLastLogin(BEMemDetails beMem) { return(DAreg.getMemLastLogin(beMem)); }
public DataSet getMemDetails(BEMemDetails beMem) { return(DAreg.getMemDetails(beMem)); }
//public DataSet getJobsApplied(BEMemDetails beMem) //{ // return daJob.getJobsApplied(beMem); //} public DataSet getJobsApplied(BEMemDetails beApplied) { return(daJob.getJobsApplied(beApplied)); }