private void btnSaveVacancy_Click(object sender, EventArgs e) { //Create a new row that variables will be added into DataRow newVacancyRow = DM.dtVacancy.NewRow(); //If the salary isn't fulfill the condition then do not write data and return; if ((txtAddVacancyDescription.Text == "") || (txtAddVacancySalary.Text == "")) { MessageBox.Show("You must type a value for each of the text fields", "Error"); return; } //transfer the object then it can compare with number . int x = Convert.ToInt32(this.txtAddVacancySalary.Text); if (x < 30000 || x > 200000) { MessageBox.Show("The salary must meet the condition of between 30000 and 200000", "Error"); return; } else { newVacancyRow["Description"] = txtAddVacancyDescription.Text; newVacancyRow["Salary"] = txtAddVacancySalary.Text; newVacancyRow["Status"] = "current"; newVacancyRow["EmployerID"] = cboEmID.Text; DM.dtVacancy.Rows.Add(newVacancyRow); DM.UpdateVacancy(); MessageBox.Show("Vacancy added successfully", "Success"); } return; }
//delete the current row private void btnDeleteVacancy_Click(object sender, EventArgs e) { DataRow deleteVacancyRow = DM.dtVacancy.Rows[currencyManager.Position]; if (MessageBox.Show("Are you sure you want to delete this record?", "Warning", MessageBoxButtons.OKCancel) == DialogResult.OK) { //assign the application table to an array(vacancies) vacancies = DM.lookingGlassDS.Tables["APPLICATION"].Select(); //use for loop to compare input ID with the vacancyID in the application table for (int i = 0; i < vacancies.Length; i++) { DataRow drVacancy = vacancies[i]; int vacID = Convert.ToInt32(txtVacancyID.Text); int vacID2 = Convert.ToInt32(drVacancy["VacancyID"]); //if find the same id ,return if (vacID == vacID2) { MessageBox.Show("You may only delete a vacancy that has no applications"); return; } } //assign the vacancyskills table to an array(vacancyskill) vacancyskills = DM.lookingGlassDS.Tables["VACANCYSKILL"].Select(); //use for loop to compare input ID with the vacancyID in the vacancyskill table for (int i = 0; i < vacancyskills.Length; i++) { DataRow drVacancySkill = vacancyskills[i]; int vacID = Convert.ToInt32(txtVacancyID.Text); int vacID2 = Convert.ToInt32(drVacancySkill["VacancyID"]); //if find the same id delete the vacancy information from the vacancyskill table if (vacID == vacID2) { drVacancySkill.Delete(); DM.UpdateVacancySkill(); } } deleteVacancyRow.Delete(); MessageBox.Show("Vacancy deleted successfully"); DM.UpdateVacancy(); return; } else { return; } }