public DateTime GetDepartDateTime(Train train, DateTime departDate) { int occurID = db.TrainsRecurring.Where(tr => tr.TrainID == train.ID).ToList()[0].OccurID; string frequency = db.Occurs.Where(o => o.ID == occurID).ToList()[0].Frequency; if (train != null) { switch (frequency) { case "Monthly": { TrainRecurring tr = trainRecrrRepo.GetByTrainId(train.ID); if (tr != null) { return(departDate.AddHours(tr.DepartureTime.Hours).AddMinutes(tr.DepartureTime.Minutes)); } break; } case "Weekly": { System.DayOfWeek dayOfWeek = (System.DayOfWeek)departDate.DayOfWeek; int dayOfWeekId = db.DaysOfWeek.Where(d => d.WeekDay == dayOfWeek.ToString()).ToList()[0].ID; TrainRecurring trRcr = trainRecrrRepo.GetByDaysOfWeekIdAndTrainId(dayOfWeekId, train.ID); if (trRcr != null) { return(departDate.AddHours(trRcr.DepartureTime.Hours).AddMinutes(trRcr.DepartureTime.Minutes)); } break; } case "Every day": { TrainRecurring trRcr = trainRecrrRepo.GetByTrainId(train.ID); if (trRcr != null) { return(departDate.AddHours(trRcr.DepartureTime.Hours).AddMinutes(trRcr.DepartureTime.Minutes)); } break; } } } return(new DateTime(1, 1, 1)); }
public void Update(TrainRecurring trainRecurring) { trainRecurringRepo.Update(trainRecurring); }
public void Create(TrainRecurring trainRecurring) { trainRecurringRepo.Create(trainRecurring); }
public void Update(TrainRecurring trainRecurring) { db.Entry(trainRecurring).State = EntityState.Modified; db.SaveChanges(); }
public void Create(TrainRecurring trainRecurring) { db.TrainsRecurring.Add(trainRecurring); db.SaveChanges(); }