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("Выберите авто из каталога");
}
}
