Exemple #1
0
        public void GetAllWeek()
        {
            var max = ScheduleItemList.Select(m => m.EndWeek).OrderByDescending(m => m).FirstOrDefault();

            AllWeek = max;
            var list = new ObservableCollection <int>();

            for (int i = 1; i <= max; i++)
            {
                list.Add(i);
            }
            Weeks = list;
        }
Exemple #2
0
        private static ScheduleItemList ConvertReaderDataToScheduleItemList(SqlDataReader reader)
        {
            ScheduleItemList schedules = null;

            if (reader.HasRows)
            {
                schedules = new ScheduleItemList();
                while (reader.Read())
                {
                    schedules.Add(new ScheduleItem(reader.GetValueOrDefault<int>("ID"),
                                                    reader.GetValueOrDefault<int>("ProjectID"),
                                                    reader.GetValueOrDefault<int>("EmployeeID"),
                                                    reader.GetValueOrDefault<int>("WeekID"),
                                                    reader.GetValueOrDefault<decimal>("Hours")));
                }
            }

            return schedules;
        }