private void OkButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { byte rentDays = 0; int findUserResult = 0; if (PassBox.Text != string.Empty) { string query = string.Format("Select @Count = COUNT(SeriesAndPassNum) From Customers Where SeriesAndPassNum = '{0}'", PassBox.Text); SqlCommand cmdFindUser = new SqlCommand(query, _connection); SqlParameter parameter = new SqlParameter("@Count", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; cmdFindUser.Parameters.Add(parameter); cmdFindUser.ExecuteNonQuery(); findUserResult = (int)parameter.Value; } if (findUserResult == 1 && byte.TryParse(RentDaysBox.Text, out rentDays) && rentDays != 0) { CarRentalDbWorker.AddNewRent(_connection, rentDays, PassBox.Text, _govNum); new PrintRentForm(_connection); DialogResult = true; Close(); } else { if (PassBox.Text != string.Empty && LNameBox.Text != string.Empty && FNameBox.Text != string.Empty && byte.TryParse(RentDaysBox.Text, out rentDays) && rentDays != 0) { CarRentalDbWorker.AddNewCustomer(_connection, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text); CarRentalDbWorker.AddNewRent(_connection, rentDays, PassBox.Text, _govNum); new PrintRentForm(_connection); DialogResult = true; Close(); } else { MessageBox.Show("Неверно введены данные"); } } }
private void SubmitRent_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { byte rentDays = 0; try { _carCatalogRow = CarsDataGrid.SelectedItem as DataRowView; if (byte.TryParse(RentDaysBox.Text, out rentDays) && rentDays != 0 && PassBox.Text != string.Empty && LNameBox.Text != string.Empty && FNameBox.Text != string.Empty) { CarRentalDbWorker.AddNewRent(_connection, rentDays, PassBox.Text, _carCatalogRow[1].ToString()); new PrintRentForm(_connection); SqlDataReader readerRent = CarRentalDbWorker.ExecuteFormRentDataCommand(_oldPass, _connection); _rents.Clear(); _rents.Load(readerRent); readerRent.Close(); CarsCatalogBlock.Visibility = Visibility.Collapsed; DataGrid.ItemsSource = _rents.DefaultView; } else { MessageBox.Show("Неверно введены данные"); } } catch (Exception) { MessageBox.Show("Выберите авто из каталога"); } }