Esempio n. 1
0
 public async Task<List<Budgeting>> GetBudgetMonth(dates input)
 {
     return await db.GetBudgetMonth(input.month, input.year);
 }
Esempio n. 2
0
        public void CreateDays()
        {
            string[] dateStr = GetWeekById(currentWeekId).dateFrom.Split('.');
            DateTime date    = new DateTime(Convert.ToInt32(dateStr[2]), Convert.ToInt32(dateStr[1]), Convert.ToInt32(dateStr[0]));

            weekDate = new WeekDate(date);
            // weekDate.CreateDate(date);

            for (int i = 0; i < Days.Count; i++)
            {
                foreach (course f_course in courses)
                {
                    foreach (group f_group in groups)
                    {
                        foreach (times f_Time in times)
                        {
                            string currentDate   = date.AddDays(i).ToShortDateString();
                            int    currentDateId = 0;
                            if (dates.Where(p => p.date == currentDate).Count() <= 0)
                            {
                                dates dt = new dates();
                                dt.date = date.AddDays(i).ToShortDateString();
                                if (dates.Count == 0)
                                {
                                    dt.iddates = 0;
                                }
                                else
                                {
                                    dt.iddates = dates.Last().iddates + 1;
                                }
                                dates.Add(dt);
                                currentDateId = dt.iddates;
                                DataBase.timetableDB.SaveChanges();
                            }
                            else
                            {
                                currentDateId = dates.Where(p => p.date == currentDate).Last().iddates;
                            }



                            timetable tt = CheckLesson(currentWeekTimetable.ToList <timetable>(), currentDateId, f_Time.idtimes, dbDays[i].idDay, f_course.idcourse, f_group.idgroup);

                            if (tt == null)
                            {
                                tt = new timetable();

                                tt.Date   = dates.Where(p => p.date == date.AddDays(i).ToShortDateString()).Last().iddates;
                                tt.Day    = dbDays[i].idDay;
                                tt.Week   = currentWeekId;
                                tt.Group  = f_group.idgroup;
                                tt.Course = f_course.idcourse;
                                tt.Time   = f_Time.idtimes;
                                tt.times  = f_Time;
                            }
                            Days[i].Add(tt);
                        }
                    }
                }
            }
        }
        public ActionResult <IEnumerable <Patient> > FilterByDates([FromBody] dates d)
        {
            List <Patient> lists = Context.patients.Where(p => ((p.appointment_date >= d.d1) && (p.appointment_date < d.d2))).ToList();

            return(lists);
        }