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