public MDay GetReservations(string userId, DateTime Day) { var currentUser = _dbContext.Users .SingleOrDefault(u => u.Id.Equals(userId)); var days = _dbContext.Days .Where(d => d.Date.Equals(Day)) .Join(_dbContext.Hours, d => d.Id, h => h.ScheduleDayId, (d, h) => new { Day = d, Hour = h }) .Where(dh => dh.Hour.ShortName.Equals(currentUser.Email)) .ToList(); var setDay = new MDay(days[0].Day.WeekDay); foreach (var day in days) { var tempHour = day.Hour; var newHour = new MHour(day.Hour.which); newHour.Class = tempHour.Class; newHour.Course = tempHour.Course; newHour.Teacher = tempHour.ShortName; newHour.Reserved = true; setDay.Hours.Add(newHour); } return(setDay); }
//Make hour from hint private void NewHour(MHour currentMHour, string dayId) { var newHour = new Hour(); newHour.Id = Guid.NewGuid().ToString(); newHour.which = currentMHour.HourId; newHour.Class = currentMHour.Class; newHour.Course = currentMHour.Course; newHour.ShortName = currentMHour.Teacher; newHour.ScheduleDayId = dayId; newHour.UserId = null; _dbAgenda.SaveHour(newHour); }