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