private void Btn_habitat_get_Click(object sender, RoutedEventArgs e) { //If a text box is blank, do not include it in the search. try { bool hasParams = false; int idVal, humiVal, tempVal; string habName; //Create the default query that will select all of the habitats string defaultQuery = "SELECT * FROM HABITAT;"; //Create a separate query that can be used for more specific //searching. string query = "SELECT * FROM HABITAT WHERE "; //Only add to the Where statement if the field is filled //by something if (txt_habitat_id.Text != "") { hasParams = true; idVal = int.Parse(txt_habitat_id.Text); query += "habitat_id = " + idVal + " and "; } if (txt_habitat_name.Text != "") { hasParams = true; habName = txt_habitat_name.Text; query += "habitat_name = " + habName + " and "; } if (txt_habitat_humidity.Text != "") { hasParams = true; humiVal = int.Parse(txt_habitat_humidity.Text); query += "humidity = " + humiVal + " and "; } if (txt_habitat_temperature.Text != "") { tempVal = int.Parse(txt_habitat_temperature.Text); query += "temperature = '" + tempVal + "' and "; } //Add a semicolon to end the statement query += ";"; //Next, remove the additional add statement along with the //extra space before the semicolon. query = query.Remove(query.Length - 5, 4); //If the user did not enter any search parameters, use the //default query. Otherwise, use the query with the where statement. if (hasParams) { datagrid_habitat.ItemsSource = Database.Query(query)?.DefaultView; } else { datagrid_habitat.ItemsSource = Database.Query(defaultQuery)?.DefaultView; } } catch { MessageBox.Show("One or more boxes are invalid because they are not numbers"); } }
private void Btn_animals_get_Click(object sender, RoutedEventArgs e) { //If a text box is blank, do not include it in the search. try { bool hasParams = false; int idVal, habIdVal, speIdVal, wei, dietID; string animalName, animalDate; //Create the default query which will select every animal string defaultQuery = "SELECT * FROM ANIMAL;"; //Create the query that will select animals with some //specified attribute string query = "SELECT * FROM ANIMAL WHERE "; //Check each field to determine if it should be added //to the search attributes. If it is blank, it is left out if (txt_animal_id.Text != "") { hasParams = true; idVal = int.Parse(txt_animal_id.Text); query += "animal_id = " + idVal + " and "; } if (txt_animal_habitat_id.Text != "") { hasParams = true; habIdVal = int.Parse(txt_animal_habitat_id.Text); query += "habitat_id = " + habIdVal + " and "; } if (txt_animal_species_id.Text != "") { hasParams = true; speIdVal = int.Parse(txt_animal_species_id.Text); query += "species_id = " + speIdVal + " and "; } if (txt_animal_name.Text != "") { hasParams = true; animalName = txt_animal_name.Text; query += "animal_name = '" + animalName + "' and "; } if (date_animal_birthday.Text != "") { hasParams = true; animalDate = date_animal_birthday.Text; query += "birthday = '" + animalDate + "' and "; } if (txt_animal_weight.Text != "") { hasParams = true; wei = int.Parse(txt_animal_weight.Text); query += "weight = " + wei + " and "; } if (txt_animal_diet_id.Text != "") { hasParams = true; dietID = int.Parse(txt_animal_diet_id.Text); query += "diet_id = " + dietID + " and "; } //add a semicolon to end the specific search query query += ";"; //Take out the last and with the additional space from //that query. query = query.Remove(query.Length - 5, 4); //If the user did not enter any data, use the default query //else use the query that we have been modifying. if (hasParams) { datagrid_animals.ItemsSource = Database.Query(query)?.DefaultView; } else { datagrid_animals.ItemsSource = Database.Query(defaultQuery)?.DefaultView; } } catch { MessageBox.Show("One or more boxes are invalid because they are not numbers"); } }
private void Btn_dpt_remove_Click(object sender, RoutedEventArgs e) { string query; if (dpt_field_name.Text.Equals("")) { MessageBox.Show("Please specfiy the department by name to remove."); } else { string get_dep_id = Get_Department(dpt_field_name.Text); if (get_dep_id.Equals("-1")) { MessageBox.Show("Department with name: " + dpt_field_name.Text); } else { query = "select * from employee where department_id=@Dept;"; if (Database.Query(query, ("@Dept", get_dep_id)).Rows.Count > 0) { MessageBox.Show("Cannot delete department: " + dpt_field_name.Text + ", because " + Database.Query(query).Rows.Count + " user(s) are still in that department."); }