public List <KravToday> KravTodayMethod([FromBody] UserControll uc)
        {
            List <KravToday> ktList = new List <KravToday>();

            //System.Threading.Thread.Sleep(5000);
            //Connect and retrieve data
            if (Login.CheckLogging(uc.user))
            {
                string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    SqlCommand cmd = new SqlCommand("Dashboard_KravToday", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    con.Open();
                    SqlDataReader rdr = cmd.ExecuteReader();
                    while (rdr.Read())
                    {
                        KravToday kt = new KravToday();
                        kt.saknas = Convert.ToInt32(rdr["saknas"]);
                        kt.ok     = Convert.ToInt32(rdr["ok"]);
                        kt.ejok   = Convert.ToInt32(rdr["ejok"]);
                        kt.krav   = rdr["krav"].ToString();
                        ktList.Add(kt);
                    }
                }
            }

            return(ktList);
        }
Пример #2
0
        private async void AddUser(string[] com)
        {
            try
            {
                Dispatcher.Invoke(() =>
                {
                    for (int i = 0; i < Users.Count; i++)
                    {
                        Users[i].Checked = false;
                    }
                });

                for (int i = 0; i < com.Length; i += 3)
                {
                    int eq = 0;
                    Dispatcher.Invoke(() =>
                    {
                        var user = new UserControll(Convert.ToInt32(com[i]), com[i + 1], com[i + 2]);

                        for (int k = 0; k < Users.Count; k++)
                        {
                            if (user.ID == Users[k].ID)
                            {
                                Users[k].Checked = true;
                                eq++;
                            }
                        }
                    });

                    if (eq == 0)
                    {
                        Dispatcher.Invoke(() =>
                        {
                            var user          = new UserControll(Convert.ToInt32(com[i]), com[i + 1], com[i + 2]);
                            user.ActiveEvent += User_ActiveEvent;
                            Users.Add(user);
                            FullTable.Items.Add(user);
                            if (Status != "Simple")
                            {
                                user.SetEnabled(1, true);
                            }
                        });
                        await Task.Run(Users[Users.Count - 1].LoadedAnimation);
                    }
                }

                for (int i = 0; i < Dispatcher.Invoke(() => Users.Count); i++)
                {
                    if (Dispatcher.Invoke(() => !Users[i].Checked))
                    {
                        RemoveUser(i);
                    }
                }
            }
            catch { }
        }