public IHttpActionResult CreateWeek(WeekDTO _week) { week w = new week { dateFrom = DateTime.Now, dateTo = new DateTime(2016, 02, 29), enabled = true, description = _week.Description, season = (int)_week.Season, title = _week.Title }; using (var context = new escorcenterdbEntities()) { context.weeks.Add(w); context.SaveChanges(); } return Ok(w); }
WeekDTO GetPastMatchesByWeekId(long weekId, DateTime date) { match[] _matches = null; List<MatchDTO> matches = new List<MatchDTO>(); week _week = null; using (var context = new escorcenterdbEntities()) { _week = (from w in context.weeks where w.enabled == true && w.id == weekId select w).FirstOrDefault<week>(); _matches = (from m in context.matches where m.enabled == true && m.week == _week.id && m.date < date select m).OrderByDescending(m => m.date).ToArray<match>(); } matches = ParseMatches(_matches); if (matches == null || _week == null) { return null; } WeekDTO week = new WeekDTO() { DateFrom = _week.dateFrom.ToString(), DateTo = _week.dateTo.ToString(), Description = _week.description, Id = _week.id, Season = _week.season, Title = _week.title }; week.matches.AddRange(matches); return week; }