private void AddButton_Click(object sender, RoutedEventArgs e)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
if (violationName.Text != CheckViolation.CheckViolationName(violationName.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationName(violationName.Text));
return;
}
if (violationCost.Text != CheckViolation.CheckViolationCost(violationCost.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationCost(violationCost.Text));
return;
}
string findReplays = "SELECT ViolationCode FROM Violation WHERE (ViolationName = '" + violationName.Text + "' AND ViolationCost = '" + Convert.ToDouble(violationCost.Text) + "') OR ViolationName = '" + violationName.Text + "'";
SqlCommand sqlCommand3 = new SqlCommand(findReplays, connection);
SqlDataReader sqlDataReader = sqlCommand3.ExecuteReader();
if (sqlDataReader.HasRows)
{
System.Windows.MessageBox.Show("Этот нарушение уже есть в базе.");
return;
}
else
{
using (SqlConnection changeSum = new SqlConnection(connectionString))
using (SqlCommand lastCommnd = changeSum.CreateCommand())
{
lastCommnd.CommandText = "INSERT INTO Violation(ViolationName, ViolationCost) VALUES (@name, @cost)";
lastCommnd.Parameters.AddWithValue("@name", violationName.Text);
lastCommnd.Parameters.AddWithValue("@cost", Convert.ToDouble(violationCost.Text));
changeSum.Open();
lastCommnd.ExecuteNonQuery();
changeSum.Close();
}
System.Windows.MessageBox.Show("Автонарушение добавлено.");
connection.Close();
}
sqlDataReader.Close();
connection.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (criterion.Text == "Название нарушения")
{
if (searchCriterion.Text != CheckViolation.CheckViolationName(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationName(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Сумма штрафа")
{
if (searchCriterion.Text != CheckViolation.CheckViolationCost(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationCost(searchCriterion.Text));
return;
}
}
else
{
System.Windows.MessageBox.Show("Вы не выбрали критерий поиска.");
return;
}
StreamWriter writeCriterion = new StreamWriter("Criterion.txt");
writeCriterion.Write(criterion.Text);
writeCriterion.Close();
StreamWriter writeSearchCriterion = new StreamWriter("SearchCriterion.txt");
writeSearchCriterion.Write(searchCriterion.Text);
writeSearchCriterion.Close();
ViolationsSearchResults violationsSearchResults = new ViolationsSearchResults();
violationsSearchResults.Show();
this.Close();
}
private void SaveChanges(object sender, RoutedEventArgs e)
{
if (criterion.Text != string.Empty && searchCriterion.Text != string.Empty)
{
if (criterion.Text == "Название нарушения")
{
if (changingCriterion.Text != CheckViolation.CheckViolationName(changingCriterion.Text))
{
MessageBox.Show(CheckViolation.CheckViolationName(changingCriterion.Text));
return;
}
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string findReplays = "SELECT ViolationCode FROM Violation WHERE ViolationName = '" + changingCriterion.Text + "'";
SqlCommand sqlCommand3 = new SqlCommand(findReplays, sqlConnection);
SqlDataReader sqlDataReader = sqlCommand3.ExecuteReader();
if (sqlDataReader.HasRows)
{
MessageBox.Show("Данное нарушение уже имеется в базе. Повторно добавить его нельзя.");
return;
}
else
{
using (SqlConnection updateName = new SqlConnection(connectionString))
using (SqlCommand lastCommnd = updateName.CreateCommand())
{
lastCommnd.CommandText = "UPDATE Violation SET ViolationName = @name WHERE ViolationCode = @code";
lastCommnd.Parameters.AddWithValue("@name", changingCriterion.Text);
lastCommnd.Parameters.AddWithValue("@code", Convert.ToInt32(searchCriterion.Text));
updateName.Open();
lastCommnd.ExecuteNonQuery();
updateName.Close();
}
}
sqlConnection.Close();
}
else if (criterion.Text == "Стоимость нарушения")
{
if (changingCriterion.Text != CheckViolation.CheckViolationCost(changingCriterion.Text))
{
MessageBox.Show(CheckViolation.CheckViolationCost(changingCriterion.Text));
return;
}
using (SqlConnection updateCost = new SqlConnection(connectionString))
using (SqlCommand lastCommnd = updateCost.CreateCommand())
{
lastCommnd.CommandText = "UPDATE Violation SET ViolationCost = @cost WHERE ViolationCode = @code";
lastCommnd.Parameters.AddWithValue("@cost", Convert.ToDouble(changingCriterion.Text));
lastCommnd.Parameters.AddWithValue("@code", Convert.ToInt32(searchCriterion.Text));
updateCost.Open();
lastCommnd.ExecuteNonQuery();
updateCost.Close();
}
}
}
else
{
MessageBox.Show("Вы не выбрали данные для изменения.");
return;
}
MessageBoxResult mboxResult = MessageBox.Show("Данные обновлены. Желаете изменить что-нибудь еще?", "Предупреждение", MessageBoxButton.YesNo);
if (mboxResult == MessageBoxResult.No)
{
ChangeViolationsData changeViolationsData = new ChangeViolationsData();
changeViolationsData.Show();
this.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (criterion.Text == "Дата нарушения")
{
if (searchCriterion.Text != CheckJournalEntry.CheckEnrtyDate(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckJournalEntry.CheckEnrtyDate(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Время нарушения")
{
if (searchCriterion.Text != CheckJournalEntry.CheckEntryTime(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckJournalEntry.CheckEntryTime(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Тип нарушения")
{
if (searchCriterion.Text != CheckViolation.CheckViolationName(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationName(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Номер автомобиля")
{
if (searchCriterion.Text != CheckCar.CheckCarStateNumber(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckCar.CheckCarStateNumber(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Марка автомобиля")
{
if (searchCriterion.Text != CheckCar.CheckCarModel(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckCar.CheckCarModel(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Фамилия нарушителя")
{
if (searchCriterion.Text != CheckViolator.CheckViolatorSurname(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolator.CheckViolatorSurname(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Имя нарушителя")
{
if (searchCriterion.Text != CheckViolator.CheckViolatorName(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolator.CheckViolatorName(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Отчество нарушителя")
{
if (searchCriterion.Text != CheckViolator.CheckViolatorPatronymic(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolator.CheckViolatorPatronymic(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Сумма штрафа (руб.)")
{
if (searchCriterion.Text != CheckViolation.CheckViolationCost(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckViolation.CheckViolationCost(searchCriterion.Text));
return;
}
}
else if (criterion.Text == "Статус оплаты")
{
if (searchCriterion.Text != CheckJournalEntry.CheckPaymentStatus(searchCriterion.Text))
{
System.Windows.MessageBox.Show(CheckJournalEntry.CheckPaymentStatus(searchCriterion.Text));
return;
}
}
else
{
System.Windows.MessageBox.Show("Вы не выбрали критерий поиска.");
return;
}
StreamWriter writeCriterion = new StreamWriter("Criterion.txt");
writeCriterion.Write(criterion.Text);
writeCriterion.Close();
StreamWriter writeSearchCriterion = new StreamWriter("SearchCriterion.txt");
writeSearchCriterion.Write(searchCriterion.Text);
writeSearchCriterion.Close();
JournalEntriesResult journalEntriesResult = new JournalEntriesResult();
journalEntriesResult.Show();
this.Close();
}
