private void btnInsertFailure_Click(object sender, EventArgs e) { var user = _failureRepository.GetUserByUsername(lblUserFirstLastName.Text); int userId = user.Id; string countyComboBox = comboBoxCounties.SelectedValue.ToString(); var county = _failureRepository.GetCountyComboBoxValue(countyComboBox); int countyId = county.Id; string cityComboBox = comboBoxCities.SelectedValue.ToString(); var city = _failureRepository.GetCityComboBoxValue(cityComboBox); int cityId = city.Id; string typeOfFailureComboBox = comboBoxTypesOfFailure.SelectedValue.ToString(); var typeOfFailure = _failureRepository.GetTypeOfFailureComboBoxValue(typeOfFailureComboBox); int typeOfFailureId = typeOfFailure.Id; string additionalDescription = richTextBoxAdditionalDescription.Text.ToString(); dateTimePickerBeginOfFailure.Value = DateTime.UtcNow; var dateTimeFrom = Convert.ToDateTime(dateTimePickerBeginOfFailure.Value); var failure = new Failure { Id_Username = userId, Id_TypeOfFailure = typeOfFailureId, Id_City = cityId, BeginOfFailure = dateTimeFrom, AdditionalDescription = additionalDescription }; _failureRepository.AddFailure(failure); _tableBindingSource.DataSource = _failureRepository.GetFailures(); }