private void AddButton_Click(object sender, EventArgs e) { if ( !(JobTitleBox.Text == "Job Title") && !string.IsNullOrEmpty(JobTitleBox.Text) && !(YearsOfExperience.Text == "Years of Experience") && !string.IsNullOrEmpty(YearsOfExperience.Text) && !(TypeBox.Text == "Job Type") && !string.IsNullOrEmpty(TypeBox.Text) && !(JobRoleBox.Text == "Job Role") && !string.IsNullOrEmpty(JobRoleBox.Text) && !(CareerLevelBox.Text == "Career Level") && !string.IsNullOrEmpty(CareerLevelBox.Text) && !(VacanciesBox.Text == "Vacancies") && !string.IsNullOrEmpty(VacanciesBox.Text) && !string.IsNullOrEmpty(DescBox.Text) && !string.IsNullOrEmpty(ReqBox.Text) ) { SqlConnection con = new SqlConnection(@"Data Source=OLA\SQLSERVER;Initial Catalog=ApplicantTrackingSystem;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False"); con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [Job](CompanyName,ExperienceYears,PostDate,CareerLevel,Type,Vacancies,Description,Requirements,Role,JobTitle) VALUES (@CompanyName,@ExperienceYears,@PostDate,@CareerLevel,@Type,@Vacancies,@Description,@Requirements,@Role,@JobTitle)", con); //CompanyName,ExperienceYears,PostDate,CareerLevel,Type,Vacancies,Description,Requirements,Role,JobTitle cmd.Parameters.AddWithValue("@CompanyName", HRLogin.LocalCompanyName); cmd.Parameters.AddWithValue("@ExperienceYears", YearsOfExperience.Text); cmd.Parameters.AddWithValue("@PostDate", DateTime.Now.ToString("yyyyMMdd")); cmd.Parameters.AddWithValue("@CareerLevel", CareerLevelBox.Text); cmd.Parameters.AddWithValue("@Type", TypeBox.Text); cmd.Parameters.AddWithValue("@Vacancies", VacanciesBox.Text); cmd.Parameters.AddWithValue("@Description", DescBox.Text); cmd.Parameters.AddWithValue("@Requirements", ReqBox.Text); cmd.Parameters.AddWithValue("@Role", JobRoleBox.Text); cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Job has been added successfully"); ViewJobsPanel.Show(); AddJobPanel.Hide(); } else { MessageBox.Show("Please Fill the Empty Boxes"); } }
private void ViewJobs_Click(object sender, EventArgs e) { ViewJobsPanel.Show(); AddJobPanel.Hide(); }