protected void saveButton_Click(object sender, EventArgs e) { try { JobSeekerProfileBO jobSeeker = new JobSeekerProfileBO(); jobSeeker.LoginId = (long)(Session["loginId"]); jobSeeker.CandidateName = candidateNameTextBox.Text; jobSeeker.YearsOfExperience = Convert.ToInt32(yearsOfExperienceTextBox.Text); jobSeeker.SkillSet = skillSetTextBox.Text; jobSeeker.Address = addressTextBox4.Text; jobSeeker.EmailId = emailIdTextBox.Text; jobSeeker.Phone = phoneNumberTextBox.Text; jobSeeker.Industry = industryTextBox.Text; jobSeeker.CurrentPosition = currentPositionTextBox.Text; jobSeeker.CurrentSalary = Math.Round(Convert.ToDouble(currentSalaryTextBox.Text)); jobSeeker.ExpectedPosition = expectedPositionTextBox.Text; jobSeeker.ExpectedJobLocation = expectedJobLocationTextBox.Text; var allowedExtensions = new string[] { "doc", "docx", "pdf" }; var extension = Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower().Replace(".", ""); if (allowedExtensions.Contains(extension)) { jobSeeker.ResumeFileName = Path.GetFileName(FileUpload1.PostedFile.FileName); const string path = @"D:\406440\MFRP Change Request\RecruitmentSolutionChangeRequest\uploads\"; FileUpload1.SaveAs(path + jobSeeker.ResumeFileName); jobSeeker.ResumeFilePath = path + jobSeeker.ResumeFilePath; JobSeekerProfileBLL jobSeekerProfile = new JobSeekerProfileBLL(); int queryStatus = jobSeekerProfile.InsertJobSeekerProfile(jobSeeker); if (queryStatus < 0) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert(' details uploaded succesfully ')", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert(' details not uploaded ')", true); //messageLabel.Text = "failure"; //messageLabel.Visible = false; } } else { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert(' upload only DOC or Docx file')", true); } } catch (SqlException) { } }
public int InsertJobSeekerProfile(JobSeekerProfileBO jobSeeker) { dbConnection.DBDataTable = new DataTable("JobSeekerProfile"); dbConnection.DBDataTable.Columns.Add("LoginId", typeof(long)); dbConnection.DBDataTable.Columns.Add("CandidateName", typeof(string)); dbConnection.DBDataTable.Columns.Add("YearsOfExp", typeof(int)); dbConnection.DBDataTable.Columns.Add("SkillSet", typeof(string)); dbConnection.DBDataTable.Columns.Add("Address", typeof(string)); dbConnection.DBDataTable.Columns.Add("mail_id", typeof(string)); dbConnection.DBDataTable.Columns.Add("Phone", typeof(string)); dbConnection.DBDataTable.Columns.Add("Industry", typeof(string)); dbConnection.DBDataTable.Columns.Add("CurrentPosition", typeof(string)); dbConnection.DBDataTable.Columns.Add("CurrentSalary", typeof(float)); dbConnection.DBDataTable.Columns.Add("ExpectedPosition", typeof(string)); dbConnection.DBDataTable.Columns.Add("ExpectedJobLocation", typeof(string)); dbConnection.DBDataTable.Columns.Add("ResumeFileName", typeof(string)); dbConnection.DBDataTable.Columns.Add("ResumeFilePath", typeof(string)); dbConnection.DBDataTable.Rows.Add(jobSeeker.LoginId, jobSeeker.CandidateName,jobSeeker.YearsOfExperience,jobSeeker.SkillSet, jobSeeker.Address, jobSeeker.EmailId, jobSeeker.Phone, jobSeeker.Industry, jobSeeker.CurrentPosition, jobSeeker.CurrentSalary, jobSeeker.ExpectedPosition, jobSeeker.ExpectedJobLocation,jobSeeker.ResumeFileName,jobSeeker.ResumeFilePath); try { dbConnection.DBConnection.Open(); using (dbConnection.DBConnection) { dbConnection.DBCommand = new SqlCommand("uspInsertJobSeekerProfile", dbConnection.DBConnection); dbConnection.DBCommand.CommandType = CommandType.StoredProcedure; SqlParameter tvpParameter = dbConnection.DBCommand.Parameters.AddWithValue("@TVP", dbConnection.DBDataTable); tvpParameter.SqlDbType = SqlDbType.Structured; queryStatus = dbConnection.DBCommand.ExecuteNonQuery(); return queryStatus; } } catch (SqlException) { return queryStatus; } finally { dbConnection.DBConnection.Close(); } }
protected void Page_Load(object sender, EventArgs e) { DataTable ObjDataTable = new DataTable(); JobSeekerProfileBO ObjJobSeekerProfile = new JobSeekerProfileBO(); InterviewApprovalBLL ObjInterviewApprovalBLL = new InterviewApprovalBLL(); string str = Request.QueryString[0]; ObjJobSeekerProfile.LoginId = int.Parse(Request.QueryString[0].ToString()); ObjDataTable.Clear(); ObjDataTable = ObjInterviewApprovalBLL.LoadApplicantDetails(ObjJobSeekerProfile); NewMethod(ObjDataTable); }
public DataTable LoadApplicantDetails(JobSeekerProfileBO ObjJobSeekerProfile) { ObjDatabaseObject.DBDataTable = new DataTable(); ObjDatabaseObject.DBAdapter = new SqlDataAdapter(); ObjDatabaseObject.DBAdapter.SelectCommand = new SqlCommand(@"uspLoadApplicantDetails", ObjDatabaseObject.DBConnection); SqlParameter sqlParameter = new SqlParameter(); sqlParameter.ParameterName = "@LoginId"; sqlParameter.Value = ObjJobSeekerProfile.LoginId; ObjDatabaseObject.DBAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; ObjDatabaseObject.DBAdapter.SelectCommand.Parameters.Add(sqlParameter); ObjDatabaseObject.DBAdapter.Fill(ObjDatabaseObject.DBDataTable); return ObjDatabaseObject.DBDataTable; }
public DataTable LoadApplicantDetails(JobSeekerProfileBO ObjJobSeekerProfile) { return ObjInterviewApprovalDAL.LoadApplicantDetails(ObjJobSeekerProfile); }
public int InsertJobSeekerProfile(JobSeekerProfileBO jobSeeker) { return jobSeekerProfile.InsertJobSeekerProfile(jobSeeker); }