public void DataBinding()
        {
            //Hämta frånvaro typer
            attendancecategories = DbOperations.GetAttendances();

            comboBoxAbscence.ItemsSource       = attendancecategories;
            comboBoxAbscence.DisplayMemberPath = "Fullinformation";

            comboBoxAbscence.SelectedIndex = 0;

            //Hämta veckor
            weeks = DbOperations.GetWeek();

            comboBoxWeek.ItemsSource       = weeks;
            comboBoxWeek.DisplayMemberPath = "InformationWeek";

            //Hämta dagar
            Weeks week = new Weeks();

            week.Week = 1;
            dates     = DbOperations.GetDays(week);

            comboBoxDay.ItemsSource       = dates;
            comboBoxDay.DisplayMemberPath = "InformationDay";
        }
 private void ComboBoxWeek_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     if (comboBoxWeek.SelectedItem != null)
     {
         Weeks week = (Weeks)comboBoxWeek.SelectedItem;
         dates = DbOperations.GetDays(week);
         comboBoxDay.ItemsSource       = dates;
         comboBoxDay.DisplayMemberPath = "InformationDay";
     }
 }
        //Hämtar alla datum
        public static List <Date> GetDays(Weeks week)
        {
            var weeks = week.Week;

            using (IDbConnection connection = new NpgsqlConnection(ConnString.ConnVal("dbConn")))
            {
                var output = connection.Query <Date>($@"SELECT dates.id, week, dates.day 
                            FROM dates 
                            WHERE week=@Week
                            GROUP BY dates.id, week, dates.day
                            ORDER BY dates.id ASC", new { Week = weeks }).ToList();
                return(output);
            }
        }
        public void DataBinding()
        {
            //Hämta barn
            children = DbOperations.GetChildrenOfGuardian();

            comboBoxChildren.ItemsSource       = children;
            comboBoxChildren.DisplayMemberPath = "Fullinformation";

            comboBoxChildren.SelectedIndex = 0;

            //Hämta barn se
            children = DbOperations.GetChildrenOfGuardian();

            comboBoxChildren2.ItemsSource       = children;
            comboBoxChildren2.DisplayMemberPath = "Fullinformation";

            comboBoxChildren2.SelectedIndex = 0;

            //Hämta frånvaro typer
            attendancecategories = DbOperations.GetAttendances();

            comboBoxAbscence.ItemsSource       = attendancecategories;
            comboBoxAbscence.DisplayMemberPath = "Fullinformation";

            comboBoxAbscence.SelectedIndex = 0;

            //Hämta veckor
            weeks = DbOperations.GetWeek();

            comboBoxWeek.ItemsSource       = weeks;
            comboBoxWeek.DisplayMemberPath = "InformationWeek";

            //Hämta dagar
            Weeks week = new Weeks();

            week.Week = 1;
            dates     = DbOperations.GetDays(week);
            comboBoxDay.ItemsSource       = dates;
            comboBoxDay.DisplayMemberPath = "InformationDay";

            Activechild.Setactivechild((Child)comboBoxChildren.SelectedItem);
        }
        public void DataBinding()
        {
            //Hämta barn
            children = DbOperations.GetChildrenOfGuardian();

            comboBoxChildren.ItemsSource       = children;
            comboBoxChildren.DisplayMemberPath = "Fullinformation";
            comboBoxChildren.SelectedIndex     = 0;

            comboBoxChildMeals.ItemsSource       = children;
            comboBoxChildMeals.DisplayMemberPath = "Fullinformation";
            comboBoxChildMeals.SelectedIndex     = 0;

            comboBoxChildren2.ItemsSource       = children;
            comboBoxChildren2.DisplayMemberPath = "Fullinformation";
            comboBoxChildren2.SelectedIndex     = 0;

            //Hämta veckor
            weeks = DbOperations.GetWeek();

            comboBoxWeek.ItemsSource       = weeks;
            comboBoxWeek.DisplayMemberPath = "InformationWeek";

            //Hämta dagar
            Weeks week = new Weeks();

            week.Week = 1;
            dates     = DbOperations.GetDays(week);

            comboBoxDay.ItemsSource       = dates;
            comboBoxDay.DisplayMemberPath = "InformationDay";


            //Hämta Morgon/Kväll
            attendancecategories = DbOperations.GetFritidsMorningEvening();

            comboBoxType.ItemsSource       = attendancecategories;
            comboBoxType.DisplayMemberPath = "Fullinformation";
        }