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();
}