Esempio n. 1
0
 //changes the contents in the textboxes and listboxes when the value in the drop down box changes
 private void JobBox_SelectedIndexChanged(object sender, EventArgs e)
 {
     showSector();
     showDescription();
     showJobBenefits();
     if (RemvBeneList.Items.Count == 0)
     {
         RemvBeneBox.Clear();
     }
 }
Esempio n. 2
0
        //Removes the chosen entitlement from the chosen Job
        private void RemvBeneBtn_Click(object sender, EventArgs e)
        {
            if (JobBox.Items.Count > 0)
            {
                if (RemvBeneList.Items.Count > 0)
                {
                    String query = "Delete from [Job Benefits] where JobID = (Select [JobID] from Jobs where [Job Name] = @JobName) and EntitlementID = @EntitlementID";

                    using (connection = new SqlConnection(connectionString))
                        using (SqlCommand command = new SqlCommand(query, connection))
                            using (SqlDataAdapter adapter = new SqlDataAdapter(command))
                            {
                                connection.Open();
                                command.Parameters.AddWithValue("@JobName", JobBox.Text);
                                command.Parameters.AddWithValue("@EntitlementID", RemvBeneList.Text);

                                try
                                {
                                    command.ExecuteNonQuery();
                                }
                                catch
                                {
                                }
                            }
                    showJobBenefits();
                    if (RemvBeneList.Items.Count == 0)
                    {
                        RemvBeneBox.Clear();
                    }
                }
                else
                {
                    MessageBox.Show("No Benefits to remove");
                }
            }
            else
            {
                MessageBox.Show("No Job to remove benefits from.");
            }
        }