/// <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();
}
