/// <summary> /// Carga los horarios de Tours /// </summary> /// <history> /// [vku] 21/Jun/2016 Created /// </history> protected async void LoadListTourTimes() { string ttls = string.Empty, ttsr = string.Empty; int ttday = 0; try { status.Visibility = Visibility.Visible; string sMsj = ValidateHelper.ValidateForm(this, "Tour Times"); if (sMsj == "") { ttls = (string)cboLeadSource.SelectedValue; ttday = Convert.ToInt32(cboWeekDay.SelectedValue); ttsr = (string)cboSalesRoom.SelectedValue; TourTimes _lstTourTimes = await BRTourTimes.GetTourTimes(_enumTourTimes, ttls, ttsr, ttday); TourTimes lstTourTimes = await BRTourTimes.GetTourTimes(_enumTourTimes, ttls, ttsr, ttday); switch (_enumTourTimes) { case EnumTourTimesSchema.ttsByLeadSourceSalesRoom: _tourTimes = _lstTourTimes.TourTimeByLeadSourceSalesRoom; dgrTourTimes.DataContext = lstTourTimes.TourTimeByLeadSourceSalesRoom; dgrTourTimes.ItemsSource = lstTourTimes.TourTimeByLeadSourceSalesRoom; break; case EnumTourTimesSchema.ttsByLeadSourceSalesRoomWeekDay: _tourTimeByDay = _lstTourTimes.TourTimeByLeadSourceSalesRoomWeekDay; dgrTourTimes.DataContext = lstTourTimes.TourTimeByLeadSourceSalesRoomWeekDay; dgrTourTimes.ItemsSource = lstTourTimes.TourTimeByLeadSourceSalesRoomWeekDay; break; case EnumTourTimesSchema.ttsBySalesRoomWeekDay: _tourTimeBySalesRoomWeekDay = _lstTourTimes.TourTimeBySalesRoomWeekDay; dgrTourTimes.DataContext = lstTourTimes.TourTimeBySalesRoomWeekDay; dgrTourTimes.ItemsSource = lstTourTimes.TourTimeBySalesRoomWeekDay; break; } StatusBarReg.Content = dgrTourTimes.Items.Count - 1 + " Tour Times."; status.Visibility = Visibility.Collapsed; } } catch (Exception ex) { UIHelper.ShowMessage(ex); } }
public IActionResult AddInfo(ReservationViewModel res, int tourId) { if (ModelState.IsValid) { res.reservation.TourId = tourId; res.tour = _context.Tours.Where(t => t.TourId == tourId).SingleOrDefault(); _context.Reservation.Add(res.reservation); TourTimes result = _context.Tours.SingleOrDefault(t => t.TourId == res.tour.TourId); if (result != null) { result.Reserved = true; } _context.SaveChanges(); } return(View("Index")); }
/// <summary> /// Obtiene los horarios de tour /// </summary> /// <param name="_enumTourTimes">Enumerado de los esquemas de horarios</param> /// <param name="ttls">Clave de Lead Source</param> /// <param name="ttsr">Clave de Sales Room</param> /// <param name="ttday">Dia de la semana</param> /// <history> /// [vku] 21/Jun/2016 Created /// </history> public async static Task<TourTimes> GetTourTimes(EnumTourTimesSchema _enumTourTimes, string ttls, string ttsr, int ttday) { TourTimes lstTts = new TourTimes(); await Task.Run(() => { using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString())) { switch (_enumTourTimes) { case EnumTourTimesSchema.ttsByLeadSourceSalesRoom: lstTts.TourTimeByLeadSourceSalesRoom = dbContext.TourTimes.Where(x => (x.ttls == ttls) && (x.ttsr == ttsr)).ToList(); break; case EnumTourTimesSchema.ttsByLeadSourceSalesRoomWeekDay: lstTts.TourTimeByLeadSourceSalesRoomWeekDay = dbContext.TourTimesByDay.Where(x => (x.ttls == ttls) && (x.ttsr == ttsr) && (x.ttDay == ttday)).ToList(); break; case EnumTourTimesSchema.ttsBySalesRoomWeekDay: lstTts.TourTimeBySalesRoomWeekDay = dbContext.TourTimesBySalesRoomWeekDay.Where(x => (x.ttsr == ttsr) && (x.ttDay == ttday)).ToList(); break; } } }); return lstTts; }
//constructor for the HomeController. Establish context to database and initialize TourTimes object public HomeController(ILogger <HomeController> logger, SignUpDbContext con) { _logger = logger; context = con; tourTimes = new TourTimes(); }