Пример #1
0
        public IEnumerable <Protocol> GetProtocol(DateTime from_, DateTime to_, RezultTest typeRezult = RezultTest.All)
        {
            List <Protocol> prot    = new List <Protocol>();
            string          command = "";

            switch (typeRezult)
            {
            case RezultTest.All:
                command = string.Format("SELECT * FROM [View_Ticket] WHERE time>='{0}' AND time<'{1}'", from_.ToString("yyyy-MM-dd"), to_.ToString("yyyy-MM-dd"));
                break;

            case RezultTest.Good:
                command = string.Format("SELECT * FROM [View_Ticket] WHERE time>='{0}' AND time<'{1}' AND IsPassed='1'", from_.ToString("yyyy-MM-dd"), to_.ToString("yyyy-MM-dd"));
                break;

            case RezultTest.Bad:
                command = string.Format("SELECT * FROM [View_Ticket] WHERE time>='{0}' AND time<'{1}' AND IsPassed='0'", from_.ToString("yyyy-MM-dd"), to_.ToString("yyyy-MM-dd"));
                break;
            }

            SqlCommand cmd = new SqlCommand(command, connection);

            using (var reader = cmd.ExecuteReader())
                while (reader.Read())
                {
                    prot.Add(new Protocol()
                    {
                        ticket = new Ticket()
                        {
                            ID        = reader.GetInt32(0),
                            level     = reader.GetString(7),
                            date      = reader.GetDateTime(1),
                            IsOffline = reader.IsDBNull(reader.GetOrdinal("IsPrint")) ? "так" : reader.GetBoolean(5) ? "ні" : "так",
                            IsPassed  = reader.IsDBNull(reader.GetOrdinal("IsPassed")) ? "--" : reader.GetBoolean(6) ? "так" : "ні",
                            user      = new UserInfo()
                            {
                                ID    = reader.GetInt32(2),
                                Lname = reader.GetString(3),
                                Fname = reader.GetString(4)
                            },
                        }
                    });
                }

            for (int i = 0; i < prot.Count(); i++)
            {
                command         = string.Format("SELECT Count(*) FROM [View_Rezult] where ticket_id='{0}'", prot[i].ticket.ID);// [Exam].[dbo].
                cmd             = new SqlCommand(command, connection);
                prot[i].answers = (int)cmd.ExecuteScalar();

                command        = string.Format("SELECT Count(*) FROM [View_Rezult] where ticket_id='{0}' AND istrue='false' ", prot[i].ticket.ID);// [Exam].[dbo].
                cmd            = new SqlCommand(command, connection);
                prot[i].errors = (int)cmd.ExecuteScalar();
            }

            return(prot);
        }
Пример #2
0
        private void Search()
        {
            if (pick1.SelectedDate == null || pick2.SelectedDate == null)
            {
                MessageBox.Show("Вкажіть період !!!"); return;
            }

            progressbar.Visibility = Visibility.Visible;

            RezultTest RezTest = RezultTest.All;

            int count = VisualTreeHelper.GetChildrenCount(groupBox);

            for (int i = 0; i < count; i++)
            {
                Visual childVisual = (Visual)VisualTreeHelper.GetChild(groupBox, i);

                if (childVisual is RadioButton)
                {
                    RadioButton rb = (RadioButton)childVisual;

                    if ((bool)rb.IsChecked)
                    {
                        if (rb.Content.ToString() == "Успішні")
                        {
                            RezTest = RezultTest.Good;
                        }
                        else
                        if (rb.Content.ToString() == "Провалені")
                        {
                            RezTest = RezultTest.Bad;
                        }

                        break;
                    }
                }
            }

            object param_ = new { dateFrom = (DateTime)pick1.SelectedDate, dateTo = (DateTime)pick2.SelectedDate, rezTest = RezTest };

            backWorker.RunWorkerAsync(param_);
        }