private void CityBox_DropDownOpened(object sender, EventArgs e) { CityBox.SelectedIndex = -1; if (CountryBox.Text != "") { SqlManager sqlManager = new SqlManager(); int num = sqlManager.ReturnNumber("SELECT Num_country FROM Countries WHERE Name_country = '" + CountryBox.Text + "'"); if (num != -2) { CityBox.ItemsSource = null; CityBox = DataManager.PushComboBox(CityBox, "Name_city", "SELECT Name_city FROM Cities WHERE Num_country = " + num); if (CityBox == null) { PagesManager.ShowConnectionError(); } } else if (num == -2) { PagesManager.ShowConnectionError(); } } else { CityBox = DataManager.PushComboBox(CityBox, "Name_city", "SELECT Name_city FROM Cities"); if (CityBox == null) { PagesManager.ShowConnectionError(); } } System.GC.Collect(); }
private void InsertNewUserWithRight(string table, string num, int right, SqlManager connection) { flag = connection.Insert($"INSERT INTO {table}" + "(Name, Last_name, Middle_name, Passport_series, Passport_number, Phone_number, DateBirth)" + "VALUES ('" + name.Text + "','" + LastName.Text + "','" + MiddleName.Text + "'," + SeriaPass.Text + "," + NumberPass.Text + ",'" + Phone.Text + "','" + DateBirth.Text + "')"); if (flag != -2) { flag = connection.ReturnNumber($"SELECT {num} FROM {table} WHERE Passport_series = " + SeriaPass.Text + "AND Passport_number = " + NumberPass.Text); if (flag != -2) { int buf = flag; flag = connection.Insert($"INSERT INTO Accounts(login,password,access_right, {num})" + " VALUES ('" + DataManager.MakeHash(Login.Text) + "','" + DataManager.MakeHash(Password1.Password) + $"', {right}," + buf + ")"); if (flag == -2) { ShowConnectionError(); } } else if (flag == -2) { ShowConnectionError(); } } else if (flag == -2) { ShowConnectionError(); } }
public PageTrips(List <string> list) { InitializeComponent(); sqlManager = new SqlManager(); int flag = 0; if (sqlManager.UpdateActualCountTripsInDB() != -2) { listParams = list; if (listParams.ElementAt(1) != "") { Item.cityNum = sqlManager.ReturnNumber("SELECT Num_city FROM Cities WHERE Name_city = '" + listParams.ElementAt(1) + "'"); if (Item.cityNum == -2) { flag = -2; PagesManager.ShowConnectionError(); } } if (flag != -2) { UpdateListView(); } } else { PagesManager.ShowConnectionError(); } }
public static int CountTickets() { //получение количества купленных пользователем путевок SqlManager sqlManager = new SqlManager(); int flag = sqlManager.ReturnNumber("SELECT COUNT(Num_trip) " + "FROM Trips WHERE Num_tourist = " + id); return(flag); }
private void MakeTicket(string[] param) { //создание билета SqlManager sqlManager; MessageBoxResult res = MessageBox.Show("Вы хотите купить именно этот билет?", "", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { Word.Document doc = null; try { Item item; sqlManager = new SqlManager(); if (sqlManager.UpdateActualCountTripsInDB() != -2) { DataTable dt = sqlManager.ReturnTable("SELECT ActualCount " + "FROM Tours " + "WHERE Name_tour = '" + (SelectedTrips.SelectedItem as Item).NameTour + "'"); if (dt != null) { if (Convert.ToInt32(dt.Rows[0].ItemArray[0]) != 0) { //создаем новый документ Word.Application app = new Word.Application(); var location = System.Reflection.Assembly.GetExecutingAssembly().Location; doc = app.Documents.Open(Path.GetDirectoryName(location) + @"\Шаблон.docx"); doc.Activate(); //открываем шаблон и получаем список закладок Word.Bookmarks wBookmarks = doc.Bookmarks; Word.Range wRange; //положение закладки в документе List <Word.Bookmark> bookmarks = new List <Word.Bookmark>(); foreach (Word.Bookmark mark in wBookmarks) { bookmarks.Add(mark); } string[] mass = (DataPerson.right == 3) ? sqlManager.ReturnDataPerson() : param; if (mass != null) { string[] data = new string[13]; for (int i = 0; i < 6; i++) { data[i] = mass[i]; } item = Item.items.Find(x => x.NameTour == (SelectedTrips.SelectedItem as Item).NameTour); data[6] = item.NameTour; data[7] = item.NameCountry; data[8] = item.NameCity; data[9] = item.DateBegin; data[10] = item.DateEnd; data[11] = item.Price.ToString(); data[12] = DateTime.Today.ToShortDateString(); for (int i = 0; i < 13; i++) //заполнение данных на месте закладок { wRange = bookmarks.ElementAt(i).Range; wRange.Text = data[i]; } Item.items.Remove(item); SelectedTrips.Items.Remove(SelectedTrips.SelectedItem); int flag = sqlManager.ReturnNumber("SELECT Num_Tour FROM Tours WHERE Name_tour = '" + data[6] + "'"); if (flag != -2) { int buf = flag; if (sqlManager.Insert("INSERT INTO Trips(Num_tour, Num_tourist, DateOfBuy) VALUES(" + buf + "," + DataPerson.id + ", '" + DateTime.Today.Date + "')") != -2) { if ((flag = DataPerson.CountTickets()) != -2) { doc.SaveAs(FileName: @"..\Desktop\Ticket" + DataPerson.id + "_" + flag + ".docx"); doc.Close(); doc = null; MessageBox.Show("Ваш билет готов и находится на рабочем столе", "", MessageBoxButton.OK, MessageBoxImage.Information); choiseDataGrid.ItemsSource = null; choiseDataGrid.Visibility = Visibility.Hidden; label.Visibility = Visibility.Hidden; SelectedTrips.Visibility = Visibility.Visible; } else { PagesManager.ShowConnectionError(); } } else { PagesManager.ShowConnectionError(); } } else { PagesManager.ShowConnectionError(); } } else { PagesManager.ShowConnectionError(); } } else { MessageBox.Show("Билеты закончились!", "", MessageBoxButton.OK, MessageBoxImage.Warning); item = Item.items.Find(x => x.NameTour == (SelectedTrips.SelectedItem as Item).NameTour); Item.items.Remove(item); SelectedTrips.Items.Remove(SelectedTrips.SelectedItem); choiseDataGrid.ItemsSource = null; choiseDataGrid.Visibility = Visibility.Hidden; label.Visibility = Visibility.Hidden; SelectedTrips.Visibility = Visibility.Visible; } System.GC.Collect(); } else { PagesManager.ShowConnectionError(); } } else { PagesManager.ShowConnectionError(); } } catch (Exception ex) { doc.Close(); doc = null; Console.WriteLine("Во время выполнения произошла ошибка! " + ex.Message); } } }
private void Enter_Click(object sender, RoutedEventArgs e) { if (Login.Text.Length > 0 && Password.Password.Length > 0) { if (DataManager.CheckInputString(@"^(?=.{3,10}$)[A-Za-z0-9]*$", Login.Text)) //предварительная проверка логина { if (DataManager.CheckInputString(@"^(?=.{5,20}$)[A-Za-z0-9!#$%^&*]*$", Password.Password)) //предварительная проверка пароля { SqlManager connection = new SqlManager(); int flag = connection.ExistsAccount(Login.Text, Password.Password); //проверка на существование аккаунта if (flag == 0) { //получение прав доступа DataPerson.right = connection.ReturnNumber("SELECT access_right FROM Accounts " + "WHERE login = '******'"); if (DataPerson.right != -2) { //получение номера аккаунта в зависимости от прав if (DataPerson.right == 3) { DataPerson.id = connection.ReturnNumber("SELECT Num_tourist FROM Accounts " + "WHERE login = '******'"); if (DataPerson.id == -2) { flag = -2; } } else if (DataPerson.right == 2) { DataPerson.id = connection.ReturnNumber("SELECT Num_worker FROM Accounts " + "WHERE login = '******'"); if (DataPerson.id == -2) { flag = -2; } } if ((DataPerson.right == 2 || DataPerson.right == 3) && flag != -2) { TourismWindow tw = new TourismWindow(); tw.Show(); Close(); } else if (DataPerson.right == 1 && flag != -2) { WindowAdmin wa = new WindowAdmin(); wa.Show(); Close(); } else { ShowConnectionError(); } System.GC.Collect(); } else { ShowConnectionError(); } } else if (flag == -2) { ShowConnectionError(); } else { ShowError(); } } else { ShowError(); } } else { ShowError(); } } else { MessageBox.Show("Необходимо ввести пароль и логин.", "", MessageBoxButton.OK, MessageBoxImage.Warning); } }