protected void btnSubmit_Click(object sender, EventArgs e)
{
//string constring = "Data Source=192.168.100.122;user id=sa;password=Connect@123;Initial Catalog=jobportal";
SqlConnection con = new SqlConnection(constrng);
//string insrtstr = "update tblMerchantReg set userid='" + txtUid.Text + "', firstname='" + txtFName.Text + "', lastname='" + txtLastName.Text + "', email='" + txtEmail.Text + "', companyname='" + txtCompanyName.Text + "',phone='" + txtPhone.Text + "',city='" + txtCity.Text + "',state='" + ddlState.SelectedValue + "',zipcode='" + txtZip.Text + "',typeofenquiry='" + ddlenquiry.SelectedValue + "',positions='" + txtPositions.Text + "',hereaboutploutos='" +ddlhearabtploutos.SelectedValue + "',comments='" + txtcomments.Text + "' where userid='" + txtUid.Text + "'";
//string insrtstr = "update tblMerchantReg set email='" + txtEmail.Text + "', companyname='" + txtCompanyName.Text + "',phone='" + txtPhone.Text + "',city='" + txtCity.Text + "',state='" + ddlState.SelectedValue + "',zipcode='" + txtZip.Text + "' where email='" + txtEmail.Text + "' ";
BE_ViewSelected beviewselected = new BE_ViewSelected();
BA_Employer baemp = new BA_Employer();
beviewselected.Email = txtEmail.Text;
//beviewselected.Company = txtCompanyName.Text;
beviewselected.Phone = txtContactNumber.Text;
beviewselected.City = txtCity.Text;
beviewselected.State = ddlState.SelectedValue;
beviewselected.Zip = txtZip.Text;
beviewselected.Addressline1 = txtAdd1.Text;
beviewselected.Website = txtWebSite.Text;
beviewselected.Contact = txtContact.Text;
beviewselected.Mobile = txtMobile.Text;
beviewselected.Category = ddlCategory.SelectedValue;
beviewselected.MemID = lblID.Text;
baemp.editemployee(beviewselected);
Response.Redirect("UpdateSuccess.aspx");
//btnLogin.Visible = true;
}
protected void Button1_Click(object sender, EventArgs e)
{
BE_ViewSelected beview = new BE_ViewSelected();
BA_SubUsers basub = new BA_SubUsers();
beview.Contact = txtSubUserName.Text;
beview.Mobile = txtMobile.Text;
beview.Email = txtEmail.Text;
beview.Company = company;
beview.RefID = MemID;
beview.pwd = EncryptPassword_Client(txtPassword.Text);;
beview.Role = 2;
beview.Category = Category;
beview.Phone = ContactNo;
beview.City = City;
beview.State = State;
beview.Zip = ZipCode;
beview.Addressline1 = Address;
beview.Website = Website;
beview.ActiveStatus = 1;
string ReturnMsg = basub.SubUserReg(beview);
if (ReturnMsg == "Email Already Exist")
{
lblsuccess.Visible = true;
lblsuccess.Text = "Email Already Exists....";
txtEmail.Text = "";
}
else
{
Response.Redirect("~/Employer/SubUserSucess.aspx");
}
}
public DataSet ViewPremanentEmployee(BE_ViewSelected beviewselected)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@JobID", SqlDbType.VarChar, 100);
param[0].Value = beviewselected.JobID;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsViewPremanentEmployee", param));
}
public DataSet ContractEmp(BE_ViewSelected beviewselected)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@company", SqlDbType.VarChar, 100);
param[0].Value = beviewselected.Company;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsContarctEmployes", param));
}
public DataSet ViewSelectedCandidates(BE_ViewSelected beviewselected)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = beviewselected.JobID;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsViewCandidates", param));
}
public string EmpReg(BE_ViewSelected beview)
{
SqlParameter[] param = new SqlParameter[16];
param[0] = new SqlParameter("@CompanyName ", SqlDbType.VarChar, 50);
param[0].Value = beview.Company;
param[1] = new SqlParameter("@Category", SqlDbType.VarChar, 50);
param[1].Value = beview.Category;
param[2] = new SqlParameter("@Website", SqlDbType.VarChar, 100);
param[2].Value = beview.Website;
param[3] = new SqlParameter("@address1", SqlDbType.VarChar, 100);
param[3].Value = beview.Addressline1;
param[4] = new SqlParameter("@city", SqlDbType.VarChar, 100);
param[4].Value = beview.City;
param[5] = new SqlParameter("@state", SqlDbType.VarChar, 50);
param[5].Value = beview.State;
param[6] = new SqlParameter("@zipcode", SqlDbType.VarChar, 50);
param[6].Value = beview.Zip;
param[7] = new SqlParameter("@email", SqlDbType.VarChar, 50);
param[7].Value = beview.Email;
param[8] = new SqlParameter("@ContactInfo", SqlDbType.VarChar, 50);
param[8].Value = beview.Contact;
param[9] = new SqlParameter("@ContactNum", SqlDbType.VarChar, 50);
param[9].Value = beview.Phone;
param[10] = new SqlParameter("@Mobile", SqlDbType.VarChar, 50);
param[10].Value = beview.Mobile;
param[11] = new SqlParameter("@role", SqlDbType.Int);
param[11].Value = beview.Role;
param[12] = new SqlParameter("@RefID", SqlDbType.VarChar, 10);
param[12].Value = beview.RefID;
param[13] = new SqlParameter("@Pwd", SqlDbType.VarChar, 10);
param[13].Value = beview.pwd;
param[14] = new SqlParameter("@ActiveStatus", SqlDbType.Int);
param[14].Value = beview.ActiveStatus;
param[15] = new SqlParameter("@Message", SqlDbType.VarChar, 50);
param[15].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spEmployerReg", param);
return(Convert.ToString(param[15].Value));
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
try
{
BE_ViewSelected beviewselected = new BE_ViewSelected();
BA_Employer baemp = new BA_Employer();
beviewselected.Company = txtCompanyName.Text;
beviewselected.Category = ddlCategory.SelectedValue.ToString();
beviewselected.Website = txtWebSite.Text;
beviewselected.Addressline1 = txtAdd1.Text;
beviewselected.City = txtCity.Text;
beviewselected.State = ddlState.SelectedItem.Text;
beviewselected.Zip = txtZip.Text;
beviewselected.Contact = txtContact.Text;
beviewselected.Phone = txtContactNumber.Text;
beviewselected.Mobile = txtMobile.Text;
beviewselected.Email = txtEmail.Text;
beviewselected.Role = 1;
beviewselected.RefID = "";
beviewselected.pwd = "Welcome@123";
beviewselected.ActiveStatus = 0;
string ReturnMsg = baemp.empreg(beviewselected);
if (ReturnMsg == "Email Already Exist")
{
lblsuccess.Visible = true;
lblsuccess.Text = "This Email Already Exist";
}
else
{
strQuery1 = "insert into tblMerchantLastLogin values ( '" + txtEmail.Text + "','" + null + "','" + null + "')";
cmd = new SqlCommand(strQuery1, conn);
conn.Open();
cmd.ExecuteNonQuery();
lblsuccess.Visible = true;
lblsuccess.Text = " Registration successful. Login credentials will send to your mail shortly";
SendMail();
Response.Redirect("EmployerRegSuccess.aspx");
conn.Close();
}
}
catch (Exception ex)
{
}
//finally
//{
// SendMail();
// Response.Redirect("EmployerRegSuccess.aspx");
// conn.Close();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
BE_ViewSelected beview = new BE_ViewSelected();
BA_PremanentEmp bapremanentemp = new BA_PremanentEmp();
DA_PremanentEmployee dapremanent = new DA_PremanentEmployee();
string s = Request.QueryString["id"].ToString();
beview.JobID = Convert.ToInt32(s);
ds = bapremanentemp.getViewPremanentEmp(beview);
dlContractEmp.DataSource = ds.Tables[0];
dlContractEmp.DataBind();
}
public void EditEmployee(BE_ViewSelected beviewselected)
{
SqlParameter[] param = new SqlParameter[12];
param[0] = new SqlParameter("@email", SqlDbType.VarChar, 100);
param[0].Value = beviewselected.Email;
param[1] = new SqlParameter("@company", SqlDbType.VarChar, 100);
param[1].Value = beviewselected.Company;
param[2] = new SqlParameter("@phone", SqlDbType.VarChar, 100);
param[2].Value = beviewselected.Phone;
param[3] = new SqlParameter("@city", SqlDbType.VarChar, 100);
param[3].Value = beviewselected.City;
param[4] = new SqlParameter("@state", SqlDbType.VarChar, 100);
param[4].Value = beviewselected.State;
param[5] = new SqlParameter("@zipcode", SqlDbType.VarChar, 100);
param[5].Value = beviewselected.Zip;
param[6] = new SqlParameter("@address1", SqlDbType.VarChar, 100);
param[6].Value = beviewselected.Addressline1;
param[7] = new SqlParameter("@Website", SqlDbType.VarChar, 100);
param[7].Value = beviewselected.Website;
param[8] = new SqlParameter("@Contact", SqlDbType.VarChar, 100);
param[8].Value = beviewselected.Contact;
param[9] = new SqlParameter("@MemID", SqlDbType.VarChar, 100);
param[9].Value = beviewselected.MemID;
param[10] = new SqlParameter("@mobile", SqlDbType.VarChar, 100);
param[10].Value = beviewselected.Mobile;
param[11] = new SqlParameter("@Category", SqlDbType.VarChar, 100);
param[11].Value = beviewselected.Category;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spUpdateEmployer", param);
}
protected void Page_Load(object sender, EventArgs e)
{
BE_ViewSelected beview = new BE_ViewSelected();
DA_ViewSelected daviewselected = new DA_ViewSelected();
BA_ViewSelected baviewselected = new BA_ViewSelected();
txtStartDate.Visible = false;
txtEndDate.Visible = false;
string s = Request.QueryString["id"].ToString();
//SqlCommand cmd = new SqlCommand("spsViewCandidates", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@id", SqlDbType.VarChar, 50).Value = s;
//SqlDataAdapter da = new SqlDataAdapter(cmd);
// ds= new DataSet();
//da.Fill(ds);
beview.JobID = Convert.ToInt16(s);
ds = baviewselected.getSelectedCandidates(beview);
dlUserProfile.DataSource = ds.Tables[0];
dlUserProfile.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
BE_ViewSelected beviewselected = new BE_ViewSelected();
BA_ViewSelected baviewselected = new BA_ViewSelected();
beviewselected.Firstname = ds.Tables[0].Rows[0]["firstname"].ToString();
beviewselected.Middlename = ds.Tables[0].Rows[0]["middlename"].ToString();
beviewselected.Lastname = ds.Tables[0].Rows[0]["lastname"].ToString();
beviewselected.Addressline1 = ds.Tables[0].Rows[0]["addressline1"].ToString();
beviewselected.Addressline2 = ds.Tables[0].Rows[0]["addressline2"].ToString();
beviewselected.City = ds.Tables[0].Rows[0]["city"].ToString();
beviewselected.State = ds.Tables[0].Rows[0]["state"].ToString();
beviewselected.Zip = ds.Tables[0].Rows[0]["zip"].ToString();
beviewselected.Phone = ds.Tables[0].Rows[0]["phone"].ToString();
beviewselected.Mobile = ds.Tables[0].Rows[0]["mobile"].ToString();
beviewselected.Email = ds.Tables[0].Rows[0]["email"].ToString();
beviewselected.RecentEmployer = ds.Tables[0].Rows[0]["RecentEmployer"].ToString();
beviewselected.JobTitle = ds.Tables[0].Rows[0]["JobTitle"].ToString();
beviewselected.Exp = ds.Tables[0].Rows[0]["Exp"].ToString();
beviewselected.LegallyUs = ds.Tables[0].Rows[0]["LegallyUs"].ToString();
beviewselected.Education = ds.Tables[0].Rows[0]["education"].ToString();
beviewselected.Category = ds.Tables[0].Rows[0]["Category"].ToString();
beviewselected.Position = ds.Tables[0].Rows[0]["Position"].ToString();
beviewselected.Company = ds.Tables[0].Rows[0]["company"].ToString();
beviewselected.Positiongiven = txtPosition.Text;
beviewselected.Rate = txtRate.Text;
beviewselected.RateType = ddlRate.SelectedValue;
beviewselected.Jobtype = ddlJobType.SelectedValue;
beviewselected.Startdate = Convert.ToDateTime(txtStartDate.Text);
beviewselected.Enddate = txtEndDate.Text.ToString();
beviewselected.Joiningdate = Convert.ToDateTime(txtJoiningDate.Text);
beviewselected.jobid = ds.Tables[0].Rows[0]["jobid"].ToString();
beviewselected.Jobseekerid = ds.Tables[0].Rows[0]["id"].ToString();
baviewselected.submitSelectedCanditates(beviewselected);
Response.Redirect("~/Employer/SchCandidates.aspx");
}
protected void FillGrid()
{
DataSet ds = new DataSet();
BA_ContractEmp bacontract = new BA_ContractEmp();
BE_ViewSelected beviewselected = new BE_ViewSelected();
beviewselected.Company = Session["PSEName"].ToString();
ds = bacontract.getContractEmp(beviewselected);
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;
}
}
else
{
pnlMain.Visible = false;
pnlSub.Visible = true;
}
}
public DataSet getContractEmp(BE_ViewSelected beviewselected)
{
return(dacontractEmp.ContractEmp(beviewselected));
}
public string empreg(BE_ViewSelected beviewselected)
{
return(daemployer.EmpReg(beviewselected));
}
public int SubmitViewSelected(BE_ViewSelected beviewselected)
{
SqlParameter[] param = new SqlParameter[28];
param[0] = new SqlParameter("@firstname", SqlDbType.VarChar, 100);
param[0].Value = beviewselected.Firstname;
param[1] = new SqlParameter("@middlename", SqlDbType.VarChar, 100);
param[1].Value = beviewselected.Lastname;
param[2] = new SqlParameter("@lastname", SqlDbType.VarChar, 100);
param[2].Value = beviewselected.Lastname;
param[3] = new SqlParameter("@addressline1", SqlDbType.VarChar, 100);
param[3].Value = beviewselected.Addressline1;
param[4] = new SqlParameter("@addressline2", SqlDbType.VarChar, 100);
param[4].Value = beviewselected.Addressline2;
param[5] = new SqlParameter("@city", SqlDbType.VarChar, 100);
param[5].Value = beviewselected.City;
param[6] = new SqlParameter("@state", SqlDbType.VarChar, 100);
param[6].Value = beviewselected.State;
param[7] = new SqlParameter("@zip", SqlDbType.VarChar, 100);
param[7].Value = beviewselected.Zip;
param[8] = new SqlParameter("@phone", SqlDbType.VarChar, 100);
param[8].Value = beviewselected.Phone;
param[9] = new SqlParameter("@mobile", SqlDbType.VarChar, 100);
param[9].Value = beviewselected.Mobile;
param[10] = new SqlParameter("@email", SqlDbType.VarChar, 100);
param[10].Value = beviewselected.Email;
param[11] = new SqlParameter("@RecentEmployer", SqlDbType.VarChar, 100);
param[11].Value = beviewselected.RecentEmployer;
param[12] = new SqlParameter("@JobTitle", SqlDbType.VarChar, 100);
param[12].Value = beviewselected.Jobtype;
param[13] = new SqlParameter("@Exp", SqlDbType.VarChar, 100);
param[13].Value = beviewselected.Exp;
param[14] = new SqlParameter("@LegallyUs", SqlDbType.VarChar, 100);
param[14].Value = beviewselected.LegallyUs;
param[15] = new SqlParameter("@education", SqlDbType.VarChar, 100);
param[15].Value = beviewselected.Education;
param[16] = new SqlParameter("@Category", SqlDbType.VarChar, 100);
param[16].Value = beviewselected.Category;
param[17] = new SqlParameter("@Position", SqlDbType.VarChar, 100);
param[17].Value = beviewselected.Position;
param[18] = new SqlParameter("@company", SqlDbType.VarChar, 100);
param[18].Value = beviewselected.Company;
param[19] = new SqlParameter("@positiongiven", SqlDbType.VarChar, 100);
param[19].Value = beviewselected.Positiongiven;
param[20] = new SqlParameter("@rate", SqlDbType.VarChar, 100);
param[20].Value = beviewselected.Rate;
param[21] = new SqlParameter("@jobtype", SqlDbType.VarChar, 100);
param[21].Value = beviewselected.Jobtype;
param[22] = new SqlParameter("@startdate", SqlDbType.DateTime);
param[22].Value = beviewselected.Startdate;
param[23] = new SqlParameter("@enddate", SqlDbType.VarChar, 50);
param[23].Value = beviewselected.Enddate;
param[24] = new SqlParameter("@joiningdate", SqlDbType.DateTime);
param[24].Value = beviewselected.Joiningdate;
param[25] = new SqlParameter("@jobid", SqlDbType.VarChar, 100);
param[25].Value = beviewselected.jobid;
param[26] = new SqlParameter("@jobseekerid", SqlDbType.VarChar, 100);
param[26].Value = beviewselected.Jobseekerid;
param[27] = new SqlParameter("@ratetype", SqlDbType.VarChar, 50);
param[27].Value = beviewselected.RateType;
return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsSubmitSelectedCanditates", param));
}
public int submitSelectedCanditates(BE_ViewSelected beviewselected)
{
return(daviewselected.SubmitViewSelected(beviewselected));
}
public void editemployee(BE_ViewSelected beviewselected)
{
daemployer.EditEmployee(beviewselected);
}
public DataSet getSelectedCandidates(BE_ViewSelected beviewselected)
{
return(daviewselected.ViewSelectedCandidates(beviewselected));
}
public string SubUserReg(BE_ViewSelected beview)
{
return(dasubusers.SubUserReg(beview));
}
public DataSet getViewPremanentEmp(BE_ViewSelected beviewselected)
{
return(dapremanentemp.ViewPremanentEmployee(beviewselected));
}
public DataSet getPremanentEmp(BE_ViewSelected beviewselected)
{
return(dapremanentemp.PremanentEmp(beviewselected));
}
public DataSet getViewContractEmp(BE_ViewSelected beviewselected)
{
return(dacontractEmp.ViewContractEmployee(beviewselected));
}
