Exemplo n.º 1
0
        //public List<OneDayData> GetOneDayDatas(Model.DataBase_manager db, DateTime date)
        //{ }
        public List <Employee> GetAllEmployees(Model.DataBase_manager db, DateTime date)
        {
            List <Employee>       employees = new List <Employee>();
            List <List <string> > Lists     = db.GetAllRowFromTable(db.NameOfTablenamberUserTable);

            Lists.ForEach(i => {
                employees.Add(new Employee()
                {
                    TabelNumber      = i[0],
                    Surname          = i[1],
                    Name             = i[2],
                    Patronymic       = i[3],
                    DataOfEmployment = Convert.ToInt64(i[4]),
                    DateOfDismiss    = Convert.ToInt64(i[5]),
                    Salary           = Convert.ToInt32(i[6]),
                    Post             = i[7]
                });
            });
            return(employees);
        }
Exemplo n.º 2
0
        public Presenter(MainWindow imain)
        {
            this.imain = imain;
            DBmanager  = new Model.DataBase_manager("TabelDB");
            DBmanager.CreateTabelUserTable();
            DBmanager.CreateHoliTabel();
            imain.LoadHoli             += Imain_LoadHoli;
            imain.GetMonthEmployeeData += Imain_GetMonthEmployeeData;
            imain.UpdateMonthEmployees += Imain_UpdateMonthEmployees;
            imain.LoadDataTableToDB    += Imain_LoadDataTableToDB;
            //monthemployees = new ObservableCollection<MonthEmployeesDatasOld>(Imain_GetMonthEmployeeData(imain.dtMain));

            imain.mu.Loaded     += Mu_Loaded;
            imain.mu.AddNewEmpl += Mu_AddNewEmpl;
            imain.mu.Setsource  += Mu_Setsource;
            imain.mu.ChangeEmpl += Mu_ChangeEmpl;
            imain.ShowCalendar  += Imain_ShowCalendar;
            imain.SpecialDays    = DBmanager.Get_DayTypeInYear(imain.dtMain.Date.Year);
            imain.monthEmployees = GetMonthEmployees();
            imain.SetlbUsers(monthemployees);
        }