private void NextButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
isPageSwitched = true;
_customers.Clear();
if (_currentPage != _customersRowCount)
{
SqlDataReader reader = CarRentalDbWorker.ExecuteFormDataCommand("SelectFromCustomers", _currentPage + 1, _connection);
_customers.Load(reader);
reader.Close();
PassBox.Text = _customers.Rows[0][1].ToString();
_oldPass = PassBox.Text;
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++;
}
else
{
_oldPass = string.Empty;
Title = "Новый клиент";
PassBox.Text = string.Empty;
LNameBox.Text = string.Empty;
FNameBox.Text = string.Empty;
MNameBox.Text = string.Empty;
}
}
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 PrintRentForm(SqlConnection connection)
{
InitializeComponent();
RentDataViewer.Reset();
DataTable rentData = CarRentalDbWorker.RentToPrintData(connection);
string currentUser = rentData.Rows[0][rentData.Columns[3]].ToString();
DataTable customerData = CarRentalDbWorker.RentCustomerToPrintData(connection, currentUser);
string currentCar = rentData.Rows[0][rentData.Columns[4]].ToString();
DataTable carsData = CarRentalDbWorker.RentCarToPrintData(connection, currentCar);
ReportDataSource RentDataSource = new ReportDataSource("RentData", rentData);
ReportDataSource CustomerDataSource = new ReportDataSource("CustomerData", customerData);
ReportDataSource CarDataSource = new ReportDataSource("CarData", carsData);
RentDataViewer.LocalReport.DataSources.Add(RentDataSource);
RentDataViewer.LocalReport.DataSources.Add(CustomerDataSource);
RentDataViewer.LocalReport.DataSources.Add(CarDataSource);
RentDataViewer.LocalReport.ReportEmbeddedResource = "CarRentDBApp.RentReport.rdlc";
RentDataViewer.RefreshReport();
ShowActivated = true;
Show();
}
public MainWindow(SqlConnection connection)
{
InitializeComponent();
_connection = connection;
_carRentalDb = new CarRentalDbWorker(_connection);
SqlCommand cmd = new SqlCommand("DefinePermissionLevel", _connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
string accessSchemaName = cmd.ExecuteScalar().ToString();
if (accessSchemaName.Equals("CarRentalDbAdmin"))
{
isAdmin = true;
}
if (!isAdmin)
{
TablesMenu.Children.Remove(CustomersNavItem);
TablesMenu.Children.Remove(RentNavItem);
RequestMenu.Children.Remove(RentDetailsRequest);
RequestMenu.Children.Remove(RentsForTimeRequest);
}
}
private void OkButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
short year = 0;
decimal price = 0;
decimal worth = 0;
if (short.TryParse(YearBox.Text, out year) &&
decimal.TryParse(PriceBox.Text, out price) &&
decimal.TryParse(WorthBox.Text, out worth) == true &&
YearBox.Text.Length == 4)
{
CarRentalDbWorker.AddNewCar(_connection,
GovNumBox.Text,
ModelBox.Text,
ColorBox.Text,
year,
price,
worth);
DialogResult = true;
Close();
}
else
{
MessageBox.Show("Неверно введены данные");
}
}
private void InitRentBtnsHandlers()
{
_rentContainer.EditingBlock.Children.Remove(_rentContainer.NewRent);
_rentContainer.EditingBlock.Children.Remove(_rentContainer.AddButton);
_rentContainer.EditB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
DataRowView row = null;
try
{
row = _rentContainer.DataGrid.SelectedItem as DataRowView;
EditRentDialog EditRent = new EditRentDialog(_connection, row);
if (EditRent.DialogResult == true)
{
AddTableTab(_carRentalDb.Rent.TableName);
}
}
catch (Exception)
{
MessageBox.Show("Не выбрано ни одной строки");
}
};
_rentContainer.DeleteB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
DataRowView row = null;
try
{
row = _rentContainer.DataGrid.SelectedItem as DataRowView;
string message = "Удалить из базы запись о прокате №: " + row[1].ToString() + "?";
string caption = "Удалить запись";
MessageBoxButton buttons = MessageBoxButton.OKCancel;
MessageBoxImage icon = MessageBoxImage.Question;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult);
if (result == MessageBoxResult.OK)
{
CarRentalDbWorker.DeleteRent(_connection, int.Parse(row[1].ToString()));
AddTableTab(_carRentalDb.Rent.TableName);
}
}
catch (Exception)
{
MessageBox.Show("Не выбрано ни одной строки");
}
};
}
public CarsReportForm(SqlConnection connection)
{
InitializeComponent();
DataTable carsData = CarRentalDbWorker.GetCarsReport(connection);
ReportDataSource dataSource = new ReportDataSource("CarsReportData", carsData);
CarsReportViewer.LocalReport.DataSources.Add(dataSource);
CarsReportViewer.LocalReport.ReportEmbeddedResource = "CarRentDBApp.CarsReport.rdlc";
CarsReportViewer.RefreshReport();
Show();
}
private void OkButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
byte rentDays = 0;
if (byte.TryParse(RentDaysBox.Text, out rentDays))
{
CarRentalDbWorker.EditRent(_connection, _orderId, rentDays);
DialogResult = true;
Close();
}
else
{
MessageBox.Show("Неверно введены данные");
}
}
private void OkButton_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (PassBox.Text != string.Empty &&
LNameBox.Text != string.Empty &&
FNameBox.Text != string.Empty)
{
CarRentalDbWorker.EditCustomer(_connection, _oldPassData, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
DialogResult = true;
Close();
}
else
{
MessageBox.Show("Неверно введены данные");
}
}
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 ToEnd_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
isPageSwitched = true;
_customers.Clear();
SqlDataReader reader = CarRentalDbWorker.ExecuteFormDataCommand("SelectFromCustomers", _customersRowCount, _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;
LNameBox.Text = _customers.Rows[0][2].ToString();
FNameBox.Text = _customers.Rows[0][3].ToString();
MNameBox.Text = _customers.Rows[0][4].ToString();
}
private void OkButtonForEdit_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
decimal price = 0;
decimal worth = 0;
if (decimal.TryParse(PriceBox.Text, out price) &&
decimal.TryParse(WorthBox.Text, out worth) == true)
{
CarRentalDbWorker.EditCar(_connection,
_oldGovNum,
GovNumBox.Text,
ColorBox.Text,
price,
worth);
DialogResult = true;
Close();
}
else
{
MessageBox.Show("Неверно введены данные");
}
}
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 NewRentB_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
CarsCatalogBlock.Visibility = Visibility.Visible;
_carsCatalog.Clear();
int pagesQuantity = 0;
ExecutePage(_connection, "SelectFromCars", 1, _carsCatalog, CarsDataGrid);
MouseButtonEventHandler handler = (object sender1, MouseButtonEventArgs e1) =>
{
TextBlock button = sender1 as TextBlock;
int rowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Cars");
if (!rowCount.Equals(_carsCatalogRowCount))
{
ExecutePage(_connection, "SelectFromCars", 1, _carsCatalog, CarsDataGrid);
pagesQuantity = PagesCounter(_carsCatalogRowCount);
InitPageControls(this, pagesQuantity);
}
PageSwitcherLogic("SelectFromCars", this, _carsCatalog, button);
};
PageNum1.MouseLeftButtonDown += handler;
PageNum2.MouseLeftButtonDown += handler;
PageNum3.MouseLeftButtonDown += handler;
PageNum4.MouseLeftButtonDown += handler;
PageNum5.MouseLeftButtonDown += handler;
PageNum6.MouseLeftButtonDown += handler;
NextPage.MouseLeftButtonDown += handler;
PrevPage.MouseLeftButtonDown += handler;
pagesQuantity = PagesCounter(_carsCatalogRowCount);
InitPageControls(this, pagesQuantity);
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
if (!isPageSwitched)
{
int findUserResult = 0;
if (PassBox.Text != string.Empty &&
LNameBox.Text != string.Empty &&
FNameBox.Text != string.Empty)
{
string query = string.Format("Select @Count = COUNT(SeriesAndPassNum) From Customers Where SeriesAndPassNum = '{0}'", _oldPass);
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)
{
CarRentalDbWorker.EditCustomer(_connection, _oldPass, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
_oldPass = PassBox.Text;
}
else if (findUserResult == 0 &&
PassBox.Text != string.Empty &&
LNameBox.Text != string.Empty &&
FNameBox.Text != string.Empty)
{
CarRentalDbWorker.AddNewCustomer(_connection, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
_oldPass = PassBox.Text;
_customersRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Customers");
}
}
}
isPageSwitched = false;
}
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("Выберите авто из каталога");
}
}
public CustomersForm(SqlConnection connection)
{
InitializeComponent();
_connection = connection;
_customers = new DataTable();
_customersRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Customers");
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;
LNameBox.Text = _customers.Rows[0][2].ToString();
FNameBox.Text = _customers.Rows[0][3].ToString();
MNameBox.Text = _customers.Rows[0][4].ToString();
Show();
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
if (!isPageSwitched)
{
int findUserResult = 0;
if (PassBox.Text != string.Empty &&
LNameBox.Text != string.Empty &&
FNameBox.Text != string.Empty)
{
string query = string.Format("Select @Count = COUNT(SeriesAndPassNum) From Customers Where SeriesAndPassNum = '{0}'", _oldPass);
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)
{
CarRentalDbWorker.EditCustomer(_connection, _oldPass, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
_oldPass = PassBox.Text;
}
else if (findUserResult == 0 &&
PassBox.Text != string.Empty &&
LNameBox.Text != string.Empty &&
FNameBox.Text != string.Empty)
{
CarRentalDbWorker.AddNewCustomer(_connection, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
_oldPass = PassBox.Text;
_customersRowCount = CarRentalDbWorker.TotalFormDataRowCount(_connection, "Customers");
}
}
}
//else if(!isPageSwitched && _oldPass == string.Empty &&
// PassBox.Text == string.Empty &&
// LNameBox.Text == string.Empty &&
// FNameBox.Text == string.Empty)
//{
// Title = "asdfs";
// int findUserResult = 0;
// if(PassBox.Text != string.Empty)
// {
// string query = string.Format("Select @Count = COUNT(SeriesAndPassNum) From Customers Where SeriesAndPassNum = '{0}'", _oldPass);
// 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)
// {
// query = string.Format("Select LName, FName, MName From Customers Where SeriesAndPassNum= '{0}'", PassBox.Text);
// cmdFindUser = new SqlCommand(query, _connection);
// SqlDataReader reader = cmdFindUser.ExecuteReader();
// while (reader.Read())
// {
// LNameBox.Text = reader[0].ToString();
// FNameBox.Text = reader[1].ToString();
// MNameBox.Text = reader[2].ToString();
// }
// reader.Close();
// CarRentalDbWorker.EditCustomer(_connection, _oldPass, PassBox.Text, LNameBox.Text, FNameBox.Text, MNameBox.Text);
// _oldPass = PassBox.Text;
// }
// }
//}
isPageSwitched = false;
}
private void InitCarsEditBtnsHandlers()
{
_carsContainer.AddB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
NewCarRecordDialog newCarDialog = new NewCarRecordDialog(_connection);
if (newCarDialog.DialogResult == true)
{
AddTableTab(_carRentalDb.Cars.TableName);
}
};
_carsContainer.EditB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
DataRowView row = null;
try
{
row = _carsContainer.DataGrid.SelectedItem as DataRowView;
NewCarRecordDialog editCar = new NewCarRecordDialog(_connection, row);
if (editCar.DialogResult == true)
{
AddTableTab(_carRentalDb.Cars.TableName);
}
}
catch (Exception)
{
MessageBox.Show("Не выбрано ни одной строки");
}
};
_carsContainer.DeleteB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
DataRowView row = null;
try
{
row = _carsContainer.DataGrid.SelectedItem as DataRowView;
string message = "Удалить из базы автомобиль Гос.Номер: " + row[1].ToString() + "?";
string caption = "Удалить запись";
MessageBoxButton buttons = MessageBoxButton.OKCancel;
MessageBoxImage icon = MessageBoxImage.Question;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult);
if (result == MessageBoxResult.OK)
{
CarRentalDbWorker.DeleteCar(_connection, row[1].ToString());
AddTableTab(_carRentalDb.Cars.TableName);
}
}
catch (Exception)
{
MessageBox.Show("Не выбрано ни одной строки");
}
};
_carsContainer.NewRentB.MouseLeftButtonDown += (object sender, MouseButtonEventArgs e) =>
{
DataRowView row = null;
try
{
row = _carsContainer.DataGrid.SelectedItem as DataRowView;
FormalizeRent NewRent = new FormalizeRent(_connection, row);
if (NewRent.DialogResult == true)
{
AddTableTab(_carRentalDb.Cars.TableName);
}
}
catch (Exception)
{
MessageBox.Show("Не выбрано ни одной строки");
}
};
}
