private void GetOrdersOnCurrentRun() { string sqlRequest = "Select Client, CargoWeight, (select PhoneNumber from Users where Username = Client)[phoneNumber] from Orders where run = '" + FillCurrentDirectionRuns.Rows[RunsOnChosenDirection.SelectedIndex][0] + "'"; FillCurrentRunOrders = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(FillCurrentRunOrders); } catch { Switcher.Switch(new FirstPage()); } AllOrdersOnCurrentRun.Visibility = Visibility.Visible; if (FillCurrentRunOrders.Rows.Count != 0) { AllOrdersOnCurrentRunTable.ItemsSource = FillCurrentRunOrders.DefaultView; AllOrdersOnCurrentRunTable.Visibility = Visibility.Visible; AllOrdersTopic.Visibility = Visibility.Visible; NoOrders.Visibility = Visibility.Collapsed; } else { AllOrdersOnCurrentRunTable.Visibility = Visibility.Collapsed; AllOrdersTopic.Visibility = Visibility.Collapsed; NoOrders.Visibility = Visibility.Visible; } }
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 loadRunsTable() { string sqlRequest = "select Run , DepartureDate, (Select COUNT(*) from orders where Run =r.Run)[OrderCount], RunStatus from RUNS r where DIRECTION ='" + FilLCurrentUserDirections.Rows[AllDirections.SelectedIndex][0] + "'"; FillCurrentDirectionRuns = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(FillCurrentDirectionRuns); } catch { Switcher.Switch(new FirstPage()); } if (FillCurrentDirectionRuns.Rows.Count != 0) { RunsOnChosenDirection.Visibility = Visibility.Visible; NoRuns.Visibility = Visibility.Collapsed; RunsOnChosenDirection.ItemsSource = FillCurrentDirectionRuns.DefaultView; } else { RunsOnChosenDirection.Visibility = Visibility.Collapsed; NoRuns.Visibility = Visibility.Visible; } }
private void LoadOrders() { string sqlRequest = "select [Order],DepartingPoint, ArrivalPoint, Price*CargoWeight[OrderPrice], CargoWeight, OrderStatus " + "from Orders Inner join Runs on Orders.Run = Runs.Run " + "inner join Direction on Runs.Direction = Direction.Direction where Client = '" + CurrentUser.UsernameV + "'"; CurrentUserOrders = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(CurrentUserOrders); } catch { Switcher.Switch(new FirstPage()); } if (CurrentUserOrders.Rows.Count == 0) { ThisUserOrders.Visibility = System.Windows.Visibility.Collapsed; tip.Visibility = Visibility.Collapsed; NoOrders.Visibility = System.Windows.Visibility.Visible; } else { NoOrders.Visibility = System.Windows.Visibility.Collapsed; tip.Visibility = Visibility.Visible; ThisUserOrders.ItemsSource = CurrentUserOrders.DefaultView; } }
private void Page_Loaded(object sender, RoutedEventArgs e) { string sqlRequest = "select Username from users where Userstatus = 'Carrier'"; SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); DataTable Carriers = new DataTable(); try { adapter.Fill(Carriers); } catch { Switcher.Switch(new FirstPage()); } ForAdmin.Items.Clear(); for (int i = 0; i < Carriers.Rows.Count; i++) { ForAdmin.Items.Add(Convert.ToString(Carriers.Rows[i][0])); } if (CurrentUser.UserStatusV == "Admin") { ForAdmin.Visibility = Visibility.Visible; ForAdminText.Visibility = Visibility.Visible; carrier = Convert.ToString(ForAdmin.SelectedItem); } else { ForAdminText.Visibility = Visibility.Collapsed; ForAdmin.Visibility = Visibility.Collapsed; carrier = CurrentUser.UsernameV; } LoadTable(carrier); }
private void LoadTable(string carrier) { string sqlRequest = "select distinct dir.Direction, DepartingPoint, ArrivalPoint, cast(Departing as time(0))[DepartingTime], (Select Count(*) from Runs where Direction =dir.Direction)[RunsCountByDir] " + "from DIRECTION dir " + "where Carrier = '" + carrier + "'"; FilLCurrentUserDirections = new DataTable(); SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); try { adapter.Fill(FilLCurrentUserDirections); } catch { Switcher.Switch(new FirstPage()); } if (FilLCurrentUserDirections.Rows.Count == 0) { AllDirections.Visibility = Visibility.Collapsed; NoDirections.Visibility = Visibility.Visible; } else { AllDirections.Visibility = Visibility.Visible; NoDirections.Visibility = Visibility.Collapsed; AllDirections.ItemsSource = FilLCurrentUserDirections.DefaultView; } }
private void NewMessage_Click(object sender, RoutedEventArgs e) { if (CurrentUser.UserStatusV == "Admin") { { string sqlRequest = "select Username from users where Userstatus != 'Admin'"; DataTable Users = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(Users); } catch { Switcher.Switch(new FirstPage()); } SelectUser.Items.Clear(); for (int i = 0; i < Users.Rows.Count; i++) { SelectUser.Items.Add(Convert.ToString(Users.Rows[i][0])); } SelectUser.SelectedIndex = 0; } MessageText.Height = 128; ChooseUsers.Visibility = Visibility.Visible; } else { MessageText.Height = 150; ChooseUsers.Visibility = Visibility.Collapsed; } ShowAllMessages.Visibility = Visibility.Collapsed; WriteNewMessage.Visibility = Visibility.Visible; }
private void FillOutcomingMessages() { string sqlRequest = "select IDmessage, [from] , headerMessage, case when IsReaded = 0 then N'Не прочитано' else N'Прочитано' end IsReaded from ALLMESSAGERS where [from] = '" + Receiver + "'"; Outcoming = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(Outcoming); } catch { Switcher.Switch(new FirstPage()); } if (Outcoming.Rows.Count != 0) { NoOutcoming.Visibility = Visibility.Collapsed; OutMessages.Visibility = Visibility.Visible; OutMessages.ItemsSource = Outcoming.DefaultView; } else { NoOutcoming.Visibility = Visibility.Visible; OutMessages.Visibility = Visibility.Collapsed; } }
private void getOrderInfo() { string SqlRequest = "select DepartingPoint, ArrivalPoint, cast (DepartureDate as date) [DepartureDate], cast(Departing as time(0))[DepartingTime],cast(Arrival as time(0))[ArrivalTime], (select Count (*) from ORDERS)[OrderAmount], Price, case when r.AvailableSpace is NULL or (select sum (CargoWeight) from Orders where Run = r.Run) is null then 0 else (r.AvailableSpace -(select sum (CargoWeight) from Orders where Run = r.Run)) end SpaceAvailable " + "from DIRECTION inner join Runs r on r.Direction = DIRECTION.Direction where Run = " + NewOrder.RunV; SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(SqlRequest); adapter.Fill(OrderInfo); }
private void LoadTable() { string SqlRequest = "select direction.Direction[DirectionKey], Run[RunKey], DepartingPoint, ArrivalPoint, cast(Departing as time(0))[DepartingTime],cast(Arrival as time(0))[ArrivalTime], Round((cast(datediff(minute, Departing, Arrival) as float(2)) / 60), 2)[TimeToReach],Price, cast (DepartureDate as date) [DepartureDate], Carrier, Ranking " + " from DIRECTION inner join Runs on RUNS.Direction = DIRECTION.Direction " + "inner join USERS on DIRECTION.Carrier = USERS.Username "; if (FromPoint.Text != "" || ToPoint.Text != "") { SqlRequest += "where "; } if (FromPoint.Text != "") { SqlRequest += "(DepartingPoint = N'" + FromPoint.Text + "')"; if (ToPoint.Text != "") { SqlRequest += " and "; } } if (ToPoint.Text != "") { SqlRequest += "(ArrivalPoint = N'" + ToPoint.Text + "')"; } SqlRequest += " Order by "; if (HowToSort.SelectedIndex == 0) { SqlRequest += " TimeToReach"; } else { SqlRequest += " Price"; } if (Order.SelectedIndex == 1) { SqlRequest += " Desc"; } DirectionsTable = new DataTable(); try { SqlDataAdapter Adapter = ConnectionToDatabase.GetRequestResult(SqlRequest); Adapter.Fill(DirectionsTable); } catch { Switcher.Switch(new FirstPage()); } if (DirectionsTable.Rows.Count == 0) { AllDirections.Visibility = System.Windows.Visibility.Collapsed; Tip.Text = "Поиск не дал результатов."; } else { AllDirections.Visibility = System.Windows.Visibility.Visible; Tip.Text = "Нажмите на результат, для бронирования места"; AllDirections.ItemsSource = DirectionsTable.DefaultView; } }
private void UpdateTable() { SqlDataAdapter adapter; string sqlRequest = "select Username, UserPassword, Userstatus, PhoneNumber, Convert(nvarchar,RegistrationDate,1)[RegistrationDate1], Ranking from USERS "; if (SearchVar.Text != "" && SearchVar.Text != null && SearchVar.Text != " ") { sqlRequest += "where "; switch (SearchParams.SelectedIndex) { case 0: sqlRequest += "Username"; break; case 1: sqlRequest += "PhoneNumber"; break; } sqlRequest += " like N'%" + SearchVar.Text + "%' "; } sqlRequest += "ORDER BY "; switch (SortPref.SelectedIndex) { case 0: sqlRequest += "Username"; break; case 1: sqlRequest += "Userstatus"; break; case 2: sqlRequest += "Ranking"; break; case 3: sqlRequest += "RegistrationDate"; break; } if (SortOrder.SelectedIndex == 1) { sqlRequest += " Desc"; } UsersTable = new DataTable(); try { adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(UsersTable); } catch { Switcher.Switch(new FirstPage()); } AllUsers.ItemsSource = UsersTable.DefaultView; }
private void Enter(object sender, RoutedEventArgs e) { if (UsernameEntered.Text.Length == 0) { UsernameEntered.BorderBrush = Brushes.Red; UsernameError.Text = "Заполните это поле"; } if (PasswordEntered.Password.Length == 0) { PasswordEntered.BorderBrush = Brushes.Red; passwordError.Text = "Заполните это поле"; } if (UsernameError.Text == "" && passwordError.Text == "") { string sqlCommand = "select UserPassword from Users where Username = '******'"; SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlCommand); DataTable ThisUser = new DataTable(); DataTable ThisUserFound = new DataTable(); try { adapter.Fill(ThisUser); } catch (Exception ex) { Switcher.Switch(new pages.FirstPage()); } if (ThisUser.Rows.Count == 0) { UsernameEntered.BorderBrush = Brushes.Red; UsernameError.Text = "Пользователь не найден, проверьте введённые данные"; } else { if (Convert.ToString(ThisUser.Rows[0][0]) != PasswordEntered.Password) { PasswordEntered.BorderBrush = Brushes.Red; passwordError.Text = "Неверный пароль"; } else { sqlCommand = "select * from Users where Username = '******'"; adapter = ConnectionToDatabase.GetRequestResult(sqlCommand); adapter.Fill(ThisUserFound); DBUsers EnteredUser = new DBUsers((string)ThisUserFound.Rows[0][0], (string)ThisUserFound.Rows[0][1], (long)ThisUserFound.Rows[0][3], (string)ThisUserFound.Rows[0][2], (DateTime)ThisUserFound.Rows[0][4], (int)ThisUserFound.Rows[0][5]); SendedObject Send = new SendedObject(EnteredUser); Switcher.Switch(new UserMainPage(), Send); } } } }
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 OrdersAmount() { string SqlRequest = "select Count(*) from ORDERS where client = '" + CurrentUser.UsernameV + "'"; DataTable OrderCount = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(SqlRequest); adapter.Fill(OrderCount); } catch { Switcher.Switch(new FirstPage()); } ShowOrderAmount.Text = "Колличество заказов: " + OrderCount.Rows[0][0]; }
private void AllUsers_Selected(object sender, RoutedEventArgs e) { switch (UsersTable.Rows[AllUsers.SelectedIndex][2]) { case "User": ShowStatus.SelectedIndex = 0; break; case "Carrier": ShowStatus.SelectedIndex = 1; break; case "Admin": ShowStatus.SelectedIndex = 2; break; } ShowRanking.Value = Convert.ToDouble(UsersTable.Rows[AllUsers.SelectedIndex][5]); AboutAccount.Visibility = Visibility.Visible; ChangeSelectedAccount.Visibility = Visibility.Visible; { string sqlRequest = "select [Order],DepartingPoint, ArrivalPoint, Price*CargoWeight[OrderPrice], CargoWeight, OrderStatus " + "from Orders Inner join Runs on Orders.Run = Runs.Run " + "inner join Direction on Runs.Direction = Direction.Direction where Client = '" + UsersTable.Rows[AllUsers.SelectedIndex][0] + "'"; DataTable CurrentUserOrders = new DataTable(); try { SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest); adapter.Fill(CurrentUserOrders); } catch { Switcher.Switch(new FirstPage()); } if (CurrentUserOrders.Rows.Count == 0) { ThisUserOrders.Visibility = System.Windows.Visibility.Collapsed; } else { ThisUserOrders.ItemsSource = CurrentUserOrders.DefaultView; } Status.Text = "Пользователь: " + Convert.ToString(UsersTable.Rows[AllUsers.SelectedIndex][0]) + " Статус пользователя: " + Convert.ToString(UsersTable.Rows[AllUsers.SelectedIndex][2]) + " Рейтинг: " + Convert.ToString(UsersTable.Rows[AllUsers.SelectedIndex][5]); AllOrders.Text = "Всего заказов: " + Convert.ToString(CurrentUserOrders.Rows.Count); } }
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()); } } } }