Пример #1
0
        private void update_click(object sender, RoutedEventArgs e)
        {
            string id_edit_employee = this.id_employee;

            login_er.Visibility       = Visibility.Hidden;
            surname_er.Visibility     = Visibility.Hidden;
            first_name_er.Visibility  = Visibility.Hidden;
            middle_name_er.Visibility = Visibility.Hidden;
            phone_er.Visibility       = Visibility.Hidden;
            passport_er.Visibility    = Visibility.Hidden;
            email_er.Visibility       = Visibility.Hidden;
            bool   er        = false;
            string error_msg = "";

            if ((error_msg = AddEmployee.check_login(login_text.Text)) != "")
            {
                er = true;
                login_er.Content    = error_msg;
                login_er.Visibility = Visibility.Visible;
            }
            if ((error_msg = AddEmployee.check_surname(surname.Text)) != "")
            {
                er = true;
                surname_er.Content    = error_msg;
                surname_er.Visibility = Visibility.Visible;
            }
            if ((error_msg = AddEmployee.check_name(first_name.Text)) != "")
            {
                er = true;
                first_name_er.Content    = error_msg;
                first_name_er.Visibility = Visibility.Visible;
            }
            if ((error_msg = AddEmployee.check_name(middle_name.Text)) != "")
            {
                er = true;
                middle_name_er.Content    = error_msg;
                middle_name_er.Visibility = Visibility.Visible;
            }

            if ((error_msg = AddEmployee.check_phone(phone.Text)) != "")
            {
                er = true;
                phone_er.Content    = error_msg;
                phone_er.Visibility = Visibility.Visible;
            }

            if ((error_msg = AddEmployee.check_passport(passport.Text)) != "")
            {
                er = true;
                passport_er.Content    = error_msg;
                passport_er.Visibility = Visibility.Visible;
            }

            if ((error_msg = AddEmployee.check_email(email.Text)) != "")
            {
                er = true;
                email_er.Content    = error_msg;
                email_er.Visibility = Visibility.Visible;
            }


            if (!er)
            {
                string login_trm       = login_text.Text.Trim();
                string surname_trm     = surname.Text.Trim();
                string name_trm        = first_name.Text.Trim();
                string middle_name_trm = middle_name.Text.Trim();
                string phone_trm       = phone.Text.Trim();
                string passport_trm    = passport.Text.Trim();
                string email_trm       = email.Text.Trim();


                try
                {
                    string sqlExpression = " UPDATE dbo.EMPLOYEES SET dbo.EMPLOYEES.id_employee = @login_value, dbo.EMPLOYEES.last_name_employee = @surname_value, dbo.EMPLOYEES.first_name_employee = @name_value, "
                                           + " dbo.EMPLOYEES.middle_name_employee = @middle_name_value, dbo.EMPLOYEES.phone_employee = @phone_value, dbo.EMPLOYEES.passport_employee = @passport_value, "
                                           + " dbo.EMPLOYEES.email_employee = @email_value "
                                           + " FROM dbo.EMPLOYEES" + " WHERE(id_employee = '" + id_edit_employee + "') ";
                    SqlCommand   command     = new SqlCommand(sqlExpression, connection);
                    SqlParameter login_param = new SqlParameter("@login_value", login_trm);
                    command.Parameters.Add(login_param);
                    SqlParameter surname_param = new SqlParameter("@surname_value", surname_trm);
                    command.Parameters.Add(surname_param);
                    SqlParameter name_param = new SqlParameter("@name_value", name_trm);
                    command.Parameters.Add(name_param);
                    SqlParameter middle_name_param = new SqlParameter("@middle_name_value", middle_name_trm);
                    command.Parameters.Add(middle_name_param);
                    SqlParameter phone_param = new SqlParameter("@phone_value", phone_trm);
                    command.Parameters.Add(phone_param);
                    SqlParameter passport_param = new SqlParameter("@passport_value", passport_trm);
                    command.Parameters.Add(passport_param);
                    SqlParameter email_param = new SqlParameter("@email_value", email_trm);
                    command.Parameters.Add(email_param);
                    command.ExecuteNonQuery();
                    ((EditAllProfiles)parent_window).update_employees();
                    MessageBox.Show("Данные обновлены!");
                }

                catch (SqlException en)
                {
                    MessageBox.Show((en.Number).ToString() + " " + en.Message);
                }
            }
        }
Пример #2
0
        private void sell(object sender, RoutedEventArgs e)
        {
            string   id_client;
            DateTime local_time = DateTime.Now;
            string   order      = local_time.ToString("yyyyMMddhhmm") + this.id_sell_car;
            int      vehicle    = this.id_sell_car;
            string   employee   = Manager.ID_SELLER;
            DateTime date       = DateTime.Now;

            if ((bool)exist_client.IsChecked)
            {
                clients buyer = (clients)grid_clients.SelectedItem;
                if (buyer == null)
                {
                    return;
                }
                id_client = buyer.LOGIN;
            }
            else
            {
                login_er.Visibility       = Visibility.Hidden;
                surname_er.Visibility     = Visibility.Hidden;
                first_name_er.Visibility  = Visibility.Hidden;
                middle_name_er.Visibility = Visibility.Hidden;
                dob_er.Visibility         = Visibility.Hidden;
                phone_er.Visibility       = Visibility.Hidden;
                passport_er.Visibility    = Visibility.Hidden;
                email_er.Visibility       = Visibility.Hidden;

                bool   er        = false;
                string error_msg = "";
                if ((error_msg = AddEmployee.check_login(login.Text)) != "")
                {
                    er = true;
                    login_er.Content    = error_msg;
                    login_er.Visibility = Visibility.Visible;
                }
                if ((error_msg = AddEmployee.check_surname(surname.Text)) != "")
                {
                    er = true;
                    surname_er.Content    = error_msg;
                    surname_er.Visibility = Visibility.Visible;
                }
                if ((error_msg = AddEmployee.check_name(first_name.Text)) != "")
                {
                    er = true;
                    first_name_er.Content    = error_msg;
                    first_name_er.Visibility = Visibility.Visible;
                }
                if ((error_msg = AddEmployee.check_name(middle_name.Text)) != "")
                {
                    er = true;
                    middle_name_er.Content    = error_msg;
                    middle_name_er.Visibility = Visibility.Visible;
                }

                if ((error_msg = AddEmployee.check_phone(phone.Text)) != "")
                {
                    er = true;
                    phone_er.Content    = error_msg;
                    phone_er.Visibility = Visibility.Visible;
                }

                if ((error_msg = AddEmployee.check_dob(dob.DisplayDate)) != "")
                {
                    er                = true;
                    dob_er.Content    = error_msg;
                    dob_er.Visibility = Visibility.Visible;
                }

                if ((error_msg = AddEmployee.check_passport(passport.Text)) != "")
                {
                    er = true;
                    passport_er.Content    = error_msg;
                    passport_er.Visibility = Visibility.Visible;
                }

                if ((error_msg = AddEmployee.check_email(email.Text)) != "")
                {
                    er = true;
                    email_er.Content    = error_msg;
                    email_er.Visibility = Visibility.Visible;
                }


                if (!er)
                {
                    string   login_trm       = login.Text.Trim();
                    string   surname_trm     = surname.Text.Trim();
                    string   name_trm        = first_name.Text.Trim();
                    string   middle_name_trm = middle_name.Text.Trim();
                    DateTime dob_trm         = dob.DisplayDate;
                    string   phone_trm       = phone.Text.Trim();
                    string   passport_trm    = passport.Text.Trim();
                    string   email_trm       = email.Text.Trim();
                    char     gender          = ((bool)m_gender.IsChecked) ? 'м' : 'ж';
                    id_client = login_trm;


                    try
                    {
                        string     sqlExpression = " INSERT INTO CLIENTS VALUES (@login_value, @surname_value, @name_value, @middle_name_value, @dob_value, @phone_value, @passport_value, @email_value, @gender_value) ";
                        SqlCommand command       = new SqlCommand(sqlExpression, connection);

                        SqlParameter login_param = new SqlParameter("@login_value", login_trm);
                        command.Parameters.Add(login_param);
                        SqlParameter surname_param = new SqlParameter("@surname_value", surname_trm);
                        command.Parameters.Add(surname_param);
                        SqlParameter name_param = new SqlParameter("@name_value", name_trm);
                        command.Parameters.Add(name_param);
                        SqlParameter middle_name_param = new SqlParameter("@middle_name_value", middle_name_trm);
                        command.Parameters.Add(middle_name_param);
                        SqlParameter dob_param = new SqlParameter("@dob_value", dob_trm);
                        command.Parameters.Add(dob_param);
                        SqlParameter phone_param = new SqlParameter("@phone_value", phone_trm);
                        command.Parameters.Add(phone_param);
                        SqlParameter passport_param = new SqlParameter("@passport_value", passport_trm);
                        command.Parameters.Add(passport_param);
                        SqlParameter email_param = new SqlParameter("@email_value", email_trm);
                        command.Parameters.Add(email_param);
                        SqlParameter gender_param = new SqlParameter("@gender_value", gender);
                        command.Parameters.Add(gender_param);
                        command.ExecuteNonQuery();

                        sqlExpression = " INSERT INTO ORDERS VALUES (@id_order, @id_vehicle, @id_client, @id_employee, @current_date) ";
                        command       = new SqlCommand(sqlExpression, connection);
                        SqlParameter id_order_par = new SqlParameter("@id_order", order);
                        command.Parameters.Add(id_order_par);
                        SqlParameter id_vehicle_par = new SqlParameter("@id_vehicle", vehicle);
                        command.Parameters.Add(id_vehicle_par);
                        SqlParameter id_client_par = new SqlParameter("@id_client", id_client);
                        command.Parameters.Add(id_client_par);
                        SqlParameter id_employee_par = new SqlParameter("@id_employee", employee);
                        command.Parameters.Add(id_employee_par);
                        SqlParameter current_date_par = new SqlParameter("@current_date", date);
                        command.Parameters.Add(current_date_par);
                        command.ExecuteNonQuery();

                        sqlExpression = " UPDATE VEHICLES SET id_status = @id_status WHERE id_vehicle = @id_vehicle; ";
                        command       = new SqlCommand(sqlExpression, connection);
                        SqlParameter id_status_par = new SqlParameter("@id_status", 'S');
                        command.Parameters.Add(id_status_par);
                        id_vehicle_par = new SqlParameter("@id_vehicle", vehicle);
                        command.Parameters.Add(id_vehicle_par);
                        command.ExecuteNonQuery();
                        MessageBox.Show("Автомобиль продан!");
                        ((SellCar)parent_window).update_sell_car();
                        parent_window.Visibility = Visibility.Visible;
                        this.Close();
                    }

                    catch (SqlException en)
                    {
                        MessageBox.Show((en.Number).ToString() + " " + en.Message);
                    }
                }
                return;
            }

            try
            {
                string       sqlExpression = " INSERT INTO ORDERS VALUES (@id_order, @id_vehicle, @id_client, @id_employee, @current_date) ";
                SqlCommand   command       = new SqlCommand(sqlExpression, connection);
                SqlParameter id_order_par  = new SqlParameter("@id_order", order);
                command.Parameters.Add(id_order_par);
                SqlParameter id_vehicle_par = new SqlParameter("@id_vehicle", vehicle);
                command.Parameters.Add(id_vehicle_par);
                SqlParameter id_client_par = new SqlParameter("@id_client", id_client);
                command.Parameters.Add(id_client_par);
                SqlParameter id_employee_par = new SqlParameter("@id_employee", employee);
                command.Parameters.Add(id_employee_par);
                SqlParameter current_date_par = new SqlParameter("@current_date", date);
                command.Parameters.Add(current_date_par);
                command.ExecuteNonQuery();

                sqlExpression = " UPDATE VEHICLES SET id_status = @id_status WHERE id_vehicle = @id_vehicle; ";
                command       = new SqlCommand(sqlExpression, connection);
                SqlParameter id_status_par = new SqlParameter("@id_status", 'S');
                command.Parameters.Add(id_status_par);
                id_vehicle_par = new SqlParameter("@id_vehicle", vehicle);
                command.Parameters.Add(id_vehicle_par);
                command.ExecuteNonQuery();
                MessageBox.Show("Автомобиль продан!");
                string       file_name = order + ".txt";
                StreamWriter file      = new StreamWriter(order);
                file.WriteLine("Номер заказа: " + order);
                file.WriteLine("Дата заказа: " + date);
                file.Close();

                ((SellCar)parent_window).update_sell_car();
                parent_window.Visibility = Visibility.Visible;
                this.Close();
            }

            catch (SqlException en)
            {
                MessageBox.Show((en.Number).ToString() + " " + en.Message);
            }
        }