public async Task<List<Budgeting>> GetBudgetMonth(dates input) { return await db.GetBudgetMonth(input.month, input.year); }
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); }