private void PrevButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (_currentPage != 1)
{
isPageSwitched = true;
_customers.Clear();
_rents.Clear();
SqlDataReader reader = CarRentalDbWorker.ExecuteFormDataCommand("SelectFromCustomers", _currentPage - 1, _connection);
_customers.Load(reader);
reader.Close();
PassBox.Text = _customers.Rows[0][1].ToString();
_oldPass = PassBox.Text;
////
SqlDataReader readerRent = CarRentalDbWorker.ExecuteFormRentDataCommand(_oldPass, _connection);
_rents.Load(readerRent);
readerRent.Close();
DataGrid.ItemsSource = _rents.DefaultView;
////
LNameBox.Text = _customers.Rows[0][2].ToString();
FNameBox.Text = _customers.Rows[0][3].ToString();
MNameBox.Text = _customers.Rows[0][4].ToString();
Title = string.Format("Клиент № {0}", _customers.Rows[0][0].ToString());
_currentPage--;
}
}
public CustomerRentForm(SqlConnection connection)
{
InitializeComponent();
CarsCatalogBlock.Visibility = Visibility.Collapsed;
_connection = connection;
_customers = new DataTable();
_rents = new DataTable();
_carsCatalog = new DataTable();
_customersRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Customers");
_rentsRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Rent");
_carsCatalogRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Cars");
SqlDataReader reader = CarRentalDbWorker.ExecuteFormDataCommand("SelectFromCustomers", _currentPage, _connection);
_customers.Load(reader);
reader.Close();
Title = string.Format("Клиент № {0}", _customers.Rows[0][0].ToString());
PassBox.Text = _customers.Rows[0][1].ToString();
_oldPass = PassBox.Text;
////
SqlDataReader readerRent = CarRentalDbWorker.ExecuteFormRentDataCommand(_oldPass, _connection);
_rents.Load(readerRent);
readerRent.Close();
DataGrid.ItemsSource = _rents.DefaultView;
////
LNameBox.Text = _customers.Rows[0][2].ToString();
FNameBox.Text = _customers.Rows[0][3].ToString();
MNameBox.Text = _customers.Rows[0][4].ToString();
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("Выберите авто из каталога");
}
}
