//DataSet data = new DataSet();
//private JobPortalDAL.Personal_info3DataTable Data;
public string savePersonal_information(Personal_information pi)
{
var row = obj.Insert1(pi.FirstName, pi.LastName, pi.FatherName, pi.MotherName, pi.DateofBirth,
pi.Gender, pi.Religion, pi.MaritalStatus, pi.Nationality, pi.NationalIdNo,
pi.PassportNumber, pi.PassportIssueDate
, pi.MobileNo1, pi.MobileNo2, pi.MobileNo3, pi.Email, pi.AlternateEmail, pi.PresentAddress, pi.ParmanentAddress);
return("success");
}
public string updatepersonal_information(Personal_information pi, int id)
{
Personal_infoupdateTableAdapter update = new Personal_infoupdateTableAdapter();
DataTable da = new DataTable();
var row = update.UpdateData(pi.FirstName, pi.LastName, pi.FatherName, pi.MotherName, pi.DateofBirth,
pi.Gender, pi.Religion, pi.MaritalStatus, pi.Nationality, pi.NationalIdNo,
pi.PassportNumber, pi.PassportIssueDate
, pi.MobileNo1, pi.MobileNo2, pi.MobileNo3, pi.Email, pi.AlternateEmail, pi.PresentAddress, pi.ParmanentAddress, pi.Objective, pi.PresentSalary, pi.ExpectedSalary
, pi.LookingForJob, pi.AbailableFor, pi.PreferedJobCatagory, pi.PreferedJobLocation, pi.Special_skill, pi.Carreer_summery, pi.Special_Qualification, pi.keywords, id);
if (row.IsInitialized)
{
return("updated");
}
return("failed");
}
protected void personalbtnsave_Click(object sender, EventArgs e)
{
Personal_informationBLL personal_InformationBLL = new Personal_informationBLL();
Personal_information information = new Personal_information();
information.FirstName = FirstName.Value;
information.LastName = LastName.Value;
information.FatherName = FathersName.Value;
information.MotherName = MothersName.Value;
information.DateofBirth = DateTime.Parse(DOB.Value);
information.Gender = Gender.Value;
information.Religion = Religion.Value;
information.MaritalStatus = MStatus.Value;
information.Nationality = Nationality.Value;
information.NationalIdNo = NationalIdNo.Value;
information.PassportNumber = PassportId.Value;
information.PassportIssueDate = DateTime.Parse(PassportIssueDate.Value);
information.MobileNo1 = MobileNo1.Value;
information.MobileNo2 = MobileNo2.Value;
information.MobileNo3 = MobileNo3.Value;
information.Email = txtEmail1.Value;
information.AlternateEmail = txtEmail2.Value;
information.PresentAddress = presentAdd.Value;
information.ParmanentAddress = permanentAdd.Value;
information.Objective = Objective.Value;
information.ParmanentAddress1 = permanentAddress1.Value;
information.PresentSalary = Convert.ToDecimal(PresentSalary.Value);
information.ExpectedSalary = Convert.ToDecimal(ExpectedSalary.Value);
information.LookingForJob = jobLevel.Value;
information.AbailableFor = jobNature.Value;
information.PreferedJobCatagory = PreferredJobCatagories.Value;
information.PreferedJobLocation = PreferredJobLocation.Value;
information.Special_skill = SpecialSkills.Value;
information.Carreer_summery = CareerSummary.Value;
information.Special_Qualification = SpecialQualification.Value;
information.keywords = keywords.Value;
int id = 4;
string message = personal_InformationBLL.updatepersonal_information(information, id);
//string mess=personal_InformationBLL.savePersonal_information(information);
//messLabel.Text = mess;
}
public Personal_information searchpersonal_information(int id)
{
Personal_infogetdataTableAdapter getdata = new Personal_infogetdataTableAdapter();
Personal_information info = new Personal_information();
DataTable data = new DataTable();
data = getdata.Search(id);
info.FirstName = data.Rows[0]["FirstName"].ToString();
info.LastName = data.Rows[0]["LastName"].ToString();
info.FatherName = data.Rows[0]["FathersName"].ToString();
info.MotherName = data.Rows[0]["MothersName"].ToString();
info.DateofBirth = Convert.ToDateTime(data.Rows[0]["DateofBirth"]);
info.Gender = data.Rows[0]["Gender"].ToString();
info.Religion = data.Rows[0]["Religion"].ToString();
info.MaritalStatus = data.Rows[0]["MaritalStatus"].ToString();
info.Nationality = data.Rows[0]["Nationality"].ToString();
info.NationalIdNo = data.Rows[0]["NationalIdNo"].ToString();
info.PassportNumber = data.Rows[0]["PassportNumber"].ToString();
info.PassportIssueDate = Convert.ToDateTime(data.Rows[0]["PassportIssueDate"]);
info.MobileNo1 = data.Rows[0]["MobileNo1"].ToString();
info.MobileNo2 = data.Rows[0]["MobileNo2"].ToString();
info.MobileNo3 = data.Rows[0]["MobileNo3"].ToString();
info.Email = data.Rows[0]["Email"].ToString();
info.AlternateEmail = data.Rows[0]["AlternateEmail"].ToString();
info.PresentAddress = data.Rows[0]["PresentAddress"].ToString();
info.ParmanentAddress = data.Rows[0]["PermanentAddress"].ToString();
info.Objective = data.Rows[0]["Objectives"].ToString();
info.PresentSalary = Convert.ToDecimal(data.Rows[0]["PresentSalary"]);
info.ExpectedSalary = Convert.ToDecimal(data.Rows[0]["ExpectedSalary"]);
info.LookingForJob = data.Rows[0]["LookingForJobLevel"].ToString();
info.AbailableFor = data.Rows[0]["AvailableFor"].ToString();
info.PreferedJobCatagory = data.Rows[0]["PreferedJobCatagoryFunctional"].ToString();
info.PreferedJobLocation = data.Rows[0]["PreferedJobLocation"].ToString();
info.Special_skill = data.Rows[0]["SpecialSkill"].ToString();
info.Carreer_summery = data.Rows[0]["CareerSummery"].ToString();
info.Special_Qualification = data.Rows[0]["SpecialQualification"].ToString();
info.keywords = data.Rows[0]["Keyword"].ToString();
return(info);
}
public void SearchPersonalDetails()
{
Personal_informationBLL personal_InformationBLL = new Personal_informationBLL();
Personal_information info = new Personal_information();
int id = 4;
info = personal_InformationBLL.searchpersonal_information(id);
FirstName.Value = info.FirstName;
LastName.Value = info.LastName;
FathersName.Value = info.FatherName;
MothersName.Value = info.MotherName;
DOB.Value = Convert.ToString(info.DateofBirth);
Gender.Value = info.Gender;
Religion.Value = info.Religion;
MStatus.Value = info.MaritalStatus;
Nationality.Value = info.Nationality;
NationalIdNo.Value = info.NationalIdNo;
PassportId.Value = info.PassportNumber;
PassportIssueDate.Value = Convert.ToString(info.PassportIssueDate);
MobileNo1.Value = info.MobileNo1;
MobileNo2.Value = info.MobileNo2;
MobileNo3.Value = info.MobileNo3;
txtEmail1.Value = info.Email;
txtEmail2.Value = info.AlternateEmail;
presentAdd.Value = info.PresentAddress;
permanentAdd.Value = info.PresentAddress;
Objective.Value = info.Objective;
permanentAddress1.Value = info.ParmanentAddress1;
PresentSalary.Value = Convert.ToString(info.PresentSalary);
ExpectedSalary.Value = Convert.ToString(info.ExpectedSalary);
jobLevel.Value = info.LookingForJob;
jobNature.Value = info.AbailableFor;
PreferredJobCatagories.Value = info.PreferedJobCatagory;
PreferredJobLocation.Value = info.PreferedJobLocation;
SpecialSkills.Value = info.Special_skill;
CareerSummary.Value = info.Carreer_summery;
SpecialQualification.Value = info.Special_Qualification;
keywords.Value = info.keywords;
}
