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