private void showFullMessage(int messageID)
{
string sqlRequest = "Select [from], headerMessage, messageMain, [to] from ALLMESSAGERS where IDmessage = '" + messageID + "';";
DataTable CurrentMessage = new DataTable();
try
{
SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest);
adapter.Fill(CurrentMessage);
}
catch
{
Switcher.Switch(new FirstPage());
}
if (!outMessage)
{
sqlRequest = "Update ALLMESSAGERS set IsReaded = 1 where IDmessage = '" + messageID + "'";
}
ConnectionToDatabase.insertData(sqlRequest);
Sender.Text = Convert.ToString(CurrentMessage.Rows[0][0]);
Adresee.Text = Convert.ToString(CurrentMessage.Rows[0][3]);
Header.Text = Convert.ToString(CurrentMessage.Rows[0][1]);
Text.Text = Convert.ToString(CurrentMessage.Rows[0][2]);
ReadMessage.Visibility = Visibility.Visible;
ShowAllMessages.Visibility = Visibility.Collapsed;
}
private void AddRunButton_Click(object sender, RoutedEventArgs e)
{
Regex reg = new Regex(@"^\d{2}-\d{2}-\d{4}$");
if (RunDepartingTime.Text.Length == 0)
{
RunDepartingTimeError.Text = "Заполните это поле";
RunDepartingTime.BorderBrush = Brushes.Red;
}
else
{
if (!reg.IsMatch(RunDepartingTime.Text))
{
RunDepartingTimeError.Text = "Введите дату в формате дд-мм-гггг";
RunDepartingTime.BorderBrush = Brushes.Red;
}
}
reg = new Regex(@"\D");
if (RunAvailableCapacity.Text.Length == 0)
{
RunAvailableCapacityError.Text = "Заполните это поле";
RunAvailableCapacity.BorderBrush = Brushes.Red;
}
else
{
if (reg.IsMatch(RunAvailableCapacity.Text))
{
RunAvailableCapacityError.Text = "Введено некорректное значение";
RunAvailableCapacity.BorderBrush = Brushes.Red;
}
}
if (RunAvailableCapacityError.Text == "" && RunDepartingTimeError.Text == "")
{
string sqlRequest = "insert into RUNS (RUN, Direction, DepartureDate, AvailableSpace, RunStatus) values (select((select count (*) from RUNS )+1), '" + FilLCurrentUserDirections.Rows[AllDirections.SelectedIndex][0] + "', '" + RunDepartingTime.Text + "', '" + RunAvailableCapacity.Text + "', 'Ordered' )";
try
{
ConnectionToDatabase.insertData(sqlRequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
loadRunsTable();
AddRun.Visibility = Visibility.Collapsed;
}
}
private void DeleteDirection_Click(object sender, RoutedEventArgs e)
{
if (AllDirections.SelectedIndex != -1)
{
string sqlRequest = "Delete DIRECTION where direction = '" + FilLCurrentUserDirections.Rows[AllDirections.SelectedIndex][0] + "'";
try
{
ConnectionToDatabase.insertData(sqlRequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
LoadTable(carrier);
}
RunsOnChosenDirectionStats.Visibility = Visibility.Collapsed;
DeleteDirection.Visibility = Visibility.Collapsed;
}
private void ThisUserOrders_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
MessageBoxResult messsageBox = MessageBox.Show("Вы действительно хотите отменить заказ?", "Отменить заказ", MessageBoxButton.YesNo);
if (messsageBox == MessageBoxResult.Yes)
{
string sql = "delete orders where [order] = '" + CurrentUserOrders.Rows[ThisUserOrders.SelectedIndex][0] + "'";
try
{
ConnectionToDatabase.insertData(sql);
}
catch
{
Switcher.Switch(new FirstPage());
}
MessageBox.Show("Заказ отменён");
OrdersAmount();
LoadOrders();
}
}
private void ToMakeOrder(object sender, RoutedEventArgs e)
{
if (EnterWeight.Text.Length == 0)
{
EnterError.Text = "Заполните это поле";
EnterWeight.BorderBrush = Brushes.Red;
}
else
{
if (Regex.IsMatch(EnterWeight.Text, @"\D"))
{
EnterError.Text = "Введены некорректные данные";
EnterWeight.BorderBrush = Brushes.Red;
}
else
{
if (Convert.ToInt32(OrderInfo.Rows[0][7]) == 0)
{
EnterError.Text = "Введённая масса не может быть перевезена этим перевозчиком";
EnterWeight.BorderBrush = Brushes.Red;
}
else if (Convert.ToInt32(EnterWeight.Text) > Convert.ToInt32(OrderInfo.Rows[0][7]))
{
EnterError.Text = "Введённая масса не может быть перевезена этим перевозчиком";
EnterWeight.BorderBrush = Brushes.Red;
}
}
}
if (EnterError.Text == "")
{
MessageBoxResult messageBox = MessageBox.Show("Вы действительно хотите оформить заказ?", "Подтвердите действие", MessageBoxButton.YesNo);
if (messageBox == MessageBoxResult.Yes)
{
string sqlRequest = "insert into Orders ([Order], CargoWeight, Run, Client, OrderStatus) values " +
"('" + NewOrder.OrderV + "', '" + EnterWeight.Text + "', '" + NewOrder.RunV + "', '" + NewOrder.ClientV + "', '" + NewOrder.OrderStatusV + "')";
ConnectionToDatabase.insertData(sqlRequest);
MessageBox.Show("Заказ оформлен успешно");
ToFindDirection();
}
}
}
private void CompleteRun_Click(object sender, RoutedEventArgs e)
{
string sqlCommand = "update RUNS set RunStatus = 'Completed' where run = '" + FillCurrentDirectionRuns.Rows[RunsOnChosenDirection.SelectedIndex][0] + "'";
sqlCommand += " update Orders set OrderStatus = 'Completed' Where run = '" + FillCurrentDirectionRuns.Rows[RunsOnChosenDirection.SelectedIndex][0] + "'";
MessageBoxResult messsageBox = MessageBox.Show("Вы действительно хотите подтвердить прибытие рейса?", "Подтвердить прибытие рейса", MessageBoxButton.YesNo);
if (messsageBox == MessageBoxResult.Yes)
{
MessageBox.Show("Прибытие рейса подтверждено");
try
{
ConnectionToDatabase.insertData(sqlCommand);
}
catch
{
Switcher.Switch(new FirstPage());
}
deleteRun.Visibility = Visibility.Collapsed;
completeRun.Visibility = Visibility.Collapsed;
}
}
private void SaveChanges_Click(object sender, RoutedEventArgs e)
{
if (ChangePassword.Text.Length < 4 && ChangePassword.Text.Length != 0)
{
PasswordError.Text = "Пароль слишком короткий (минимум 4 символа)";
ChangePassword.BorderBrush = Brushes.Red;
}
if ((ChangePhone.Text.Length < 12 || Regex.IsMatch(ChangePhone.Text, @"\D")) && ChangePhone.Text.Length != 0)
{
PhoneError.Text = "Введите корректный номер мобильного телефона, начиная с цифры";
ChangePhone.BorderBrush = Brushes.Red;
}
if (PhoneError.Text == "" && PasswordError.Text == "")
{
string sqlRequest = "Update USERS set Userstatus = '" + ShowStatus.Text + "' where Username = '******'";
if (ChangePassword.Text.Length != 0)
{
sqlRequest += " Update USERS set UserPassword = '******' where Username = '******'";
}
if (ChangePhone.Text.Length != 0)
{
sqlRequest += " Update USERS set PhoneNumber = '" + ChangePhone.Text + "' where Username = '******'";
}
sqlRequest += "Update USERS set Ranking = '" + ShowRanking.Value + "' where Username = '******'";
try
{
ConnectionToDatabase.insertData(sqlRequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
MessageBox.Show("Данные успешно обновлены");
ChangeSelectedAccount.Visibility = Visibility.Collapsed;
UpdateTable();
}
}
private void SendMessageButtonClick(object sender, RoutedEventArgs e)
{
if (EnterHeader.Text.Length == 0)
{
EnterHeader.BorderBrush = Brushes.Red;
EnterHeaderError.Text = "Это обязательное поле";
}
if (EnterHeaderError.Text == "")
{
string ToSomeone, FromSomeone;
if (CurrentUser.UserStatusV != "Admin")
{
ToSomeone = "ADMIN";
FromSomeone = CurrentUser.UsernameV;
}
else
{
FromSomeone = "ADMIN";
ToSomeone = Convert.ToString(SelectUser.SelectedItem);
}
string sqlRequest = "insert into ALLMESSAGERS (IDmessage, [from], [to], headerMessage, messageMain, IsReaded) values ((select count(*) from ALLMESSAGERS)+1, '" + FromSomeone + " ', '" + ToSomeone + " ' , N'" + EnterHeader.Text + " ', N'" + MessageText.Text + " ', 0)";
try
{
ConnectionToDatabase.insertData(sqlRequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
MessageBox.Show("Письмо отправлено");
FillIncomingMessages();
FillOutcomingMessages();
ToMainView();
}
}
private void Register(object sender, RoutedEventArgs e)
{
string sqlRequest = "select Username from Users where Username = '******'";
DataTable Usernames = new DataTable();
try
{
if (UsernameEntered.Text.Length == 0)
{
usernameError.Text = "Заполните это поле";
UsernameEntered.BorderBrush = Brushes.Red;
}
else
{
if (Regex.IsMatch(UsernameEntered.Text, @"\W"))
{
usernameError.Text = "Имя пользователя должно состоять из чисел и букв";
UsernameEntered.BorderBrush = Brushes.Red;
}
else
{
SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest);
adapter.Fill(Usernames);
if (Usernames.Rows.Count != 0)
{
usernameError.Text = "Имя пользователя занято";
UsernameEntered.BorderBrush = Brushes.Red;
}
}
}
if (PasswordEntered1.Password.Length == 0)
{
password1Error.Text = "Заполните это поле";
PasswordEntered1.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password.Length < 4)
{
password1Error.Text = "Пароль слишком короткий (минимум 4 символа)";
PasswordEntered1.BorderBrush = Brushes.Red;
}
}
if (PasswordEntered2.Password.Length == 0)
{
password2Error.Text = "Заполните это поле";
PasswordEntered2.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password != PasswordEntered2.Password)
{
password2Error.Text = "Пароли не совпадают";
PasswordEntered1.BorderBrush = Brushes.Red;
PasswordEntered2.BorderBrush = Brushes.Red;
}
}
if (PhoneNumber.Text.Length == 0)
{
phoneError.Text = "Заполните это поле";
PhoneNumber.BorderBrush = Brushes.Red;
}
else
{
if (PhoneNumber.Text.Length < 12 || Regex.IsMatch(PhoneNumber.Text, @"\D"))
{
phoneError.Text = "Введите корректный номер мобильного телефона, начиная с цифры";
PhoneNumber.BorderBrush = Brushes.Red;
}
}
if (usernameError.Text == "" && password1Error.Text == "" && password2Error.Text == "" && phoneError.Text == "")
{
DBUsers CurrentUser = new DBUsers(UsernameEntered.Text, PasswordEntered1.Password, Convert.ToInt64(PhoneNumber.Text));
sqlRequest = "insert into " +
"USERS (Username, UserPassword, PhoneNumber, RegistrationDate, Ranking) " +
"values ('" + CurrentUser.UsernameV + "', '" + CurrentUser.UserPasswordV + "', '" + CurrentUser.PhoneNumberV + "', '" + CurrentUser.RegistrarionDateV.Year + "-" + CurrentUser.RegistrarionDateV.Month + "-" + CurrentUser.RegistrarionDateV.Day + "', '" + CurrentUser.RankingV + "')";
int i = ConnectionToDatabase.insertData(sqlRequest);
if (i == 0)
{
SendedObject send = new SendedObject(CurrentUser);
Switcher.Switch(new UserMainPage(), send);
}
}
}
catch
{
Switcher.Switch(new FirstPage());
}
}
private void AddDirectionButton_Click(object sender, RoutedEventArgs e)
{
if (DepartingPointIn.Text.Length == 0)
{
DepartingPointInError.Text = "Заполните это поле";
DepartingPointIn.BorderBrush = Brushes.Red;
}
if (ArrivalPointIn.Text.Length == 0)
{
ArrivalPointInError.Text = "Заполните это поле";
ArrivalPointIn.BorderBrush = Brushes.Red;
}
if (PriceIn.Text.Length == 0)
{
PriceInError.Text = "Заполните это поле";
PriceIn.BorderBrush = Brushes.Red;
}
else
{
if (Regex.IsMatch(PriceIn.Text, @"\D"))
{
PriceInError.Text = "В данном поле могут быть только цифры";
PriceIn.BorderBrush = Brushes.Red;
}
}
if (CapacityIn.Text.Length == 0)
{
CapacityInError.Text = "Заполните это поле";
CapacityIn.BorderBrush = Brushes.Red;
}
else
{
if (Regex.IsMatch(CapacityIn.Text, @"\D"))
{
CapacityInError.Text = "В данном поле могут быть только цифры";
CapacityIn.BorderBrush = Brushes.Red;
}
}
Regex reg = new Regex(@"^[0-2][0-9]:[0-5][0-9]$");
if (ArrivalTime.Text.Length == 0)
{
ArrivalTimeInError.Text = "Заполните это поле";
ArrivalTime.BorderBrush = Brushes.Red;
}
else
{
if (!reg.IsMatch(ArrivalTime.Text))
{
MessageBox.Show(CapacityIn.Text);
ArrivalTimeInError.Text = "Введите время в формате чч:мм";
ArrivalTime.BorderBrush = Brushes.Red;
}
}
if (DepartureTimeIn.Text.Length == 0)
{
DepartureTimeInError.Text = "Заполните это поле";
DepartureTimeIn.BorderBrush = Brushes.Red;
}
else
{
if (!reg.IsMatch(DepartureTimeIn.Text))
{
DepartureTimeInError.Text = "Введите время в формате чч:мм";
DepartureTimeIn.BorderBrush = Brushes.Red;
}
}
if (DepartingPointInError.Text == "" && ArrivalPointInError.Text == "" && PriceInError.Text == "" && DepartureTimeInError.Text == "" && ArrivalTimeInError.Text == "" && CapacityInError.Text == "")
{
int DirNumber;
if (FilLCurrentUserDirections.Rows.Count == 0)
{
DirNumber = (10000 * ForAdmin.Items.Count) + 1;
}
else
{
DirNumber = (Convert.ToInt32(FilLCurrentUserDirections.Rows[0][0]) / 10000) * 10000 + FilLCurrentUserDirections.Rows.Count + 1;
}
string sqlRequest = "insert Into DIRECTION (Direction, DepartingPoint, ArrivalPoint, Price, Departing,Arrival, Carrier, Capacity) values " +
" ('" + DirNumber + "', '" + DepartingPointIn.Text + "', '" + ArrivalPointIn.Text + "', '" + PriceIn.Text + "', '" + DepartureTimeIn.Text + "', '" + ArrivalTime.Text + "', '" + carrier + "', '" + CapacityIn.Text + "')";
try
{
ConnectionToDatabase.insertData(sqlRequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
MessageBox.Show("Маршрут добавлен");
LoadTable(carrier);
FormToAddDirection.Visibility = Visibility.Collapsed;
}
}
private void ChangePassword(object sender, RoutedEventArgs e)
{
if (PasswordOld.Password.Length == 0)
{
passwordOldError.Text = "Заполните это поле";
PasswordOld.BorderBrush = Brushes.Red;
}
else
{
if (PasswordOld.Password != CurrentUser.UserPasswordV)
{
passwordOldError.Text = "Введён неверный пароль";
PasswordOld.BorderBrush = Brushes.Red;
}
}
if (PasswordEntered1.Password.Length == 0)
{
password1Error.Text = "Заполните это поле";
PasswordEntered1.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password.Length < 4)
{
password1Error.Text = "Пароль слишком короткий (минимум 4 символа)";
PasswordEntered1.BorderBrush = Brushes.Red;
}
}
if (PasswordEntered2.Password.Length == 0)
{
password2Error.Text = "Заполните это поле";
PasswordEntered2.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password != PasswordEntered2.Password)
{
password2Error.Text = "Пароли не совпадают";
PasswordEntered1.BorderBrush = Brushes.Red;
PasswordEntered2.BorderBrush = Brushes.Red;
}
}
if (passwordOldError.Text == "" && password1Error.Text == "" && password2Error.Text == "")
{
MessageBoxResult messsageBox = MessageBox.Show("Вы действительно хотите изменить пароль", "Сменить пароль", MessageBoxButton.YesNo);
if (messsageBox == MessageBoxResult.Yes)
{
MessageBox.Show("Пароль успешно изменён");
string Sqlrequest = "update USERS set UserPassword = '******' where Username = '******'";
CurrentUser.UserPasswordV = PasswordEntered2.Password;
try
{
ConnectionToDatabase.insertData(Sqlrequest);
}
catch
{
Switcher.Switch(new FirstPage());
}
}
}
}
