public string DeleteEmployment(int id) { EmploymentHistoryTableAdapter em = new EmploymentHistoryTableAdapter(); Employment_History employment = new Employment_History(); int row = em.DeleteQuery(id); if (row > 0) { return("success"); } return("failed"); }
public string UpdateEmployment(Employment_History eh, int id) { EmploymentHistoryTableAdapter em = new EmploymentHistoryTableAdapter(); Employment_History employment = new Employment_History(); int row = em.UpdateQuery(employment.CompanyName, employment.CompanyBusiness, employment.Designation, employment.Department, employment.AreaOfExperience, employment.Responsibilities, employment.CompanyLocation, employment.EmploymentPeriod, id); if (row > 0) { return("success"); } return("failed"); }
public Employment_History SearchEmployment(int id) { EmploymentHistoryTableAdapter em = new EmploymentHistoryTableAdapter(); EmploymentHistorySearchTableAdapter adapter = new EmploymentHistorySearchTableAdapter(); Employment_History employment = new Employment_History(); int row = Convert.ToInt32(em.ScalarQuery()); if (row > 0) { DataTable dt = adapter.SearchQuery(id); employment.CompanyName = dt.Rows[0]["CompanyName"].ToString(); employment.CompanyBusiness = dt.Rows[0]["CompanyBusiness"].ToString(); employment.Designation = dt.Rows[0]["Designation"].ToString(); employment.Department = dt.Rows[0]["Department"].ToString(); employment.AreaOfExperience = dt.Rows[0]["AreaofExperiences"].ToString(); employment.Responsibilities = dt.Rows[0]["Responsibilities"].ToString(); employment.CompanyLocation = dt.Rows[0]["CompanyLocation"].ToString(); employment.EmploymentPeriod = dt.Rows[0]["EmploymentPeriod"].ToString(); return(employment); } else { Education_training edu = new Education_training(); edu.LevelOfEducation = null; edu.DegreeTitle = null; edu.Group = null; edu.InstituteName = null; edu.Achievement = null; edu.Result = null; edu.YearOfoPassing = null; edu.Duration = null; return(employment); } }