Exemple #1
0
        private void InitNote()
        {
            SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Mydruy\\Desktop\\Курсовой\\Курсовой\\Cursach\\Multiplex.mdf;Integrated Security=True");

            con.Open();

            SqlCommand  readCommand = new SqlCommand("SELECT * FROM [Note] ORDER BY id DESC", con);
            StaticArray staticArray = new StaticArray();

            TableUser.Width = this.Width;

            Button b = new Button();

            b.Content = "22";
            b.Width   = 100;
            b.Height  = 100;

            TableUser.Rows    = 17;
            TableUser.Columns = 4;
            using (SqlDataReader dataRead = readCommand.ExecuteReader())
            {
                if (dataRead != null)
                {
                    while (dataRead.Read())
                    {
                        Image image = new Image();
                        image.Width  = 100;
                        image.Margin = new Thickness(0, 10, 0, 10);
                        image.Source = (new ImageSourceConverter()).ConvertFromString("pack://application:,,,/Resource/note-" + Convert.ToInt32(dataRead["img"]) + ".png") as ImageSource;

                        //  image.Source = (new ImageSourceConverter()).ConvertFromString(dataRead["img"].ToString()) as ImageSource;
                        TableUser.Children.Add(image);

                        Label lab = new Label();

                        lab.Content    = dataRead["text"].ToString();
                        lab.Foreground = System.Windows.Media.Brushes.White;
                        lab.Margin     = new Thickness(0, 30, 0, 0);
                        TableUser.Children.Add(lab);

                        Label lab1 = new Label();
                        lab1.Content    = "Одесский Офисс";
                        lab1.Foreground = System.Windows.Media.Brushes.White;
                        lab1.Margin     = new Thickness(0, 30, 0, 0);
                        TableUser.Children.Add(lab1);

                        Button c = new Button();
                        c.Tag     = dataRead["id"];
                        c.Click  += Pod_Click;
                        c.Content = "Удалить";
                        c.Width   = 100;
                        c.Height  = 30;

                        TableUser.Children.Add(c);
                    }
                }
            }
        }
        //Выводим данные о сотрудниках
        void viewListStaff()
        {
            SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Mydruy\\Desktop\\Курсовой\\Курсовой\\Cursach\\Multiplex.mdf;Integrated Security=True");

            con.Open();

            SqlCommand  readCommand = new SqlCommand("SELECT * FROM [Staff]", con);
            StaticArray staticArray = new StaticArray();



            TableUser.Width = this.Width;

            Button b = new Button();

            b.Content = "22";
            b.Width   = 100;
            b.Height  = 100;

            TableUser.Rows    = 17;
            TableUser.Columns = 4;
            using (SqlDataReader dataRead = readCommand.ExecuteReader())
            {
                if (dataRead != null)
                {
                    while (dataRead.Read())
                    {
                        Image image = new Image();
                        image.Width  = 100;
                        image.Margin = new Thickness(0, 10, 0, 10);
                        if (dataRead["img"] == "")
                        {
                            image.Source = (new ImageSourceConverter()).ConvertFromString("pack://application:,,,/Resource/user.png") as ImageSource;
                        }
                        else
                        {
                            image.Source = (new ImageSourceConverter()).ConvertFromString(dataRead["img"].ToString()) as ImageSource;
                        }
                        TableUser.Children.Add(image);

                        Label lab = new Label();

                        lab.Content    = dataRead["name"].ToString() + " " + dataRead["famil"].ToString() + " " + dataRead["otch"].ToString();
                        lab.Foreground = System.Windows.Media.Brushes.White;
                        lab.Margin     = new Thickness(0, 30, 0, 0);
                        TableUser.Children.Add(lab);

                        Label lab1 = new Label();
                        lab1.Content    = staticArray.stringPosition[Convert.ToInt32(dataRead["position"])];
                        lab1.Foreground = System.Windows.Media.Brushes.White;
                        lab1.Margin     = new Thickness(0, 30, 0, 0);
                        TableUser.Children.Add(lab1);

                        Button c = new Button();
                        c.Tag     = dataRead["id"];
                        c.Click  += Pod_Click;
                        c.Content = "Подробно";
                        c.Width   = 100;
                        c.Height  = 30;

                        TableUser.Children.Add(c);
                    }
                }
            }

            for (int i = 0; i < 100; i++)
            {
            }
        }