private void Refresh()
 {
     locker = LockerModel.Select(searcsNumber, searcsEmpname, searcsTeamname, "", searcsState);
     DG_LockerList.ItemsSource = locker;
     lockerA = LockerModel.Select(searcsNumber, searcsEmpname, searcsTeamname, "A", searcsState);
     DG_LockerListA.ItemsSource = lockerA;
     lockerB = LockerModel.Select(searcsNumber, searcsEmpname, searcsTeamname, "B", searcsState);
     DG_LockerListB.ItemsSource = lockerB;
     lockerC = LockerModel.Select(searcsNumber, searcsEmpname, searcsTeamname, "C", searcsState);
     DG_LockerListC.ItemsSource = lockerC;
 }
        public MainWindow()
        {
            InitializeComponent();

            //minden szekrény listázása
            locker  = LockerModel.Select(null, "", null, "", "");
            lockerA = LockerModel.Select(null, "", null, "A", "");
            lockerB = LockerModel.Select(null, "", null, "B", "");
            lockerC = LockerModel.Select(null, "", null, "C", "");
            DG_LockerList.ItemsSource  = locker;
            DG_LockerListA.ItemsSource = lockerA;
            DG_LockerListB.ItemsSource = lockerB;
            DG_LockerListC.ItemsSource = lockerC;

            teams = TeamModel.Select();
            teams.Insert(0, new TeamModel(null, ""));//legördülő listában első opció üres
            CB_TeamSearch.ItemsSource = teams;
            CB_TeamSelect.ItemsSource = teams;
            states = StateModel.Select();
            CB_StateSelect.ItemsSource = states;
        }