public virtual Basket GetBasketBySessionId(string externalSessionId) { var basket = _repository.GetSingle( x => x.ExternalCookieValue != null && x.ExternalCookieValue.Trim().Equals(externalSessionId.Trim(), StringComparison.CurrentCultureIgnoreCase)); if (basket != null && (basket.BasketLines == null || basket.BasketLines.Count == 0)) { basket.BasketLines = _lineRepository.GetList(x => x.BasketId == basket.Id); } return(basket); }
public ApiResponse <IList <DTOReporteEstatico> > GetReporteEstatico(DTOReporteEstatico reporteEstatico) { ApiResponse <IList <DTOReporteEstatico> > apiResponse = new ApiResponse <IList <DTOReporteEstatico> >(); try { IList <Derechohabiente> derechohabientes = _derechohabienteRepository.GetList(x => (reporteEstatico.IdEstado != null ? x.IdEstado == reporteEstatico.IdEstado : x.IdEstado == x.IdEstado) && (reporteEstatico.IdGenero != null ? x.IdGenero == reporteEstatico.IdGenero : x.IdGenero == x.IdGenero) && (reporteEstatico.RangoInferior != null ? (reporteEstatico.RangoInferior <= (DateTime.Now.Year - x.FechaNacimiento.Year)) : x.FechaNacimiento == x.FechaNacimiento) && (reporteEstatico.RangoInferior != null ? (reporteEstatico.RangoSuperior >= (DateTime.Now.Year - x.FechaNacimiento.Year)) : x.FechaNacimiento == x.FechaNacimiento)); apiResponse.Data = (from encuesta in _encuestaRepository.GetList(x => x.FechaAplicacion >= reporteEstatico.FechaInicio.Date && x.FechaAplicacion.Date <= reporteEstatico.FechaFin.Date) join derechohabiente in derechohabientes on encuesta.IdDerechohabiente equals derechohabiente.IdDerechohabiente from tipoDestino in _tiposDestinoRepository.GetList(x => x.IdTipoDestino == encuesta.IdTipoDestino).Take(1).DefaultIfEmpty() from temporada in _temporadasRepository.GetList(x => x.IdTemporada == encuesta.IdTemporada).Take(1).DefaultIfEmpty() from viaje in _tiposViajeRepository.GetList(x => x.IdTipoViaje == encuesta.IdTipoViaje).Take(1).DefaultIfEmpty() from genero in _generoRepository.GetList(x => x.IdGenero == derechohabiente.IdGenero).Take(1).DefaultIfEmpty() from estado in _estadoRepository.GetList(x => x.IdEstado == derechohabiente.IdEstado).Take(1).DefaultIfEmpty() select new DTOReporteEstatico { Destino = tipoDestino.Nombre, TemporadaVacacional = temporada.Nombre, Viaje = viaje.Nombre, Genero = genero.Genero, Edad = DateTime.Now.Year - derechohabiente.FechaNacimiento.Year, Estado = estado.Nombre }).ToList(); if (apiResponse.Data != null) { apiResponse.Result = (int)ApiResult.Success; apiResponse.Message = Resources.ConsultaExitosa; } else { apiResponse.Result = (int)ApiResult.Failure; apiResponse.Message = Resources.ConsultaFallida; } } catch (Exception ex) { apiResponse.Result = (int)ApiResult.Exception; apiResponse.Message = ex.Message; } return(apiResponse); }
public virtual Basket GetLatestBasket() { var all = _repository.GetList(x => !string.IsNullOrEmpty(x.ExternalCookieValue)); var topBasket = all.OrderByDescending(x => x.DateCreated); return(topBasket.FirstOrDefault()); }
/// <summary> /// Loads all categories from the database to the data collection /// </summary> public void Load() { Data.Clear(); foreach (var category in dataAccess.GetList()) { Data.Add(category); } }
/// <summary> /// Loads all accounts from the database to the data collection /// </summary> public void Load() { Data.Clear(); foreach (var account in dataAccess.GetList()) { Data.Add(account); } }
private void DeleteRecurringPaymentIfLastAssociated(PaymentViewModel item) { if (Data.All(x => x.RecurringPayment != item.RecurringPayment)) { var recurringList = recurringDataAccess.GetList(x => x.Id == item.RecurringPayment.Id).ToList(); foreach (var recTrans in recurringList) { recurringDataAccess.Delete(recTrans); } } }
/// <summary> /// Loads all payments from the database to the data collection /// </summary> public void Load() { Data.Clear(); var payments = dataAccess.GetList(null, payment => payment.ChargedAccount, payment => payment.Category, payment => payment.RecurringPayment); foreach (var payment in payments) { Data.Add(new PaymentViewModel(payment)); } }
public IList<ClientAsset> GetClientAssetsByClientID(int ClientID) { IList<ClientAsset> list = new List<ClientAsset>(); try { list = _clientAssetRepository.GetList(p => p.ClientID == ClientID); } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return list; }
public ApiResponse <CatPaquetesTuristicos> GetPaqueteTuristicoPromocionado() { ApiResponse <CatPaquetesTuristicos> apiResponse = new ApiResponse <CatPaquetesTuristicos>(); try { Random random = new Random(); apiResponse.Data = _repository.GetList(x => x.Promocionado == true) .OrderBy(x => random.Next()) .Take(1) .FirstOrDefault(); if (apiResponse.Data != null) { apiResponse.Result = (int)ApiResult.Success; apiResponse.Message = Resources.ConsultaExitosa; } else if (apiResponse.Data == null) { apiResponse.Result = (int)ApiResult.Initial; apiResponse.Message = Resources.ConsultaSinResultados; } else { apiResponse.Result = (int)ApiResult.Failure; apiResponse.Message = Resources.ConsultaFallida; } } catch (Exception ex) { apiResponse.Result = (int)ApiResult.Exception; apiResponse.Message = ex.Message; } return(apiResponse); }
public List <MileStoneTaskType> GetMileStoneTaskTypeByMileStoneID(int MileStoneId) { return(_mileStoneTaskTypeRepository.GetList(c => c.MileStoneID == MileStoneId).ToList <MileStoneTaskType>()); }
public override List <Book> Filter(Func <Book, bool> filter) { return((List <Book>)repository.GetList(filter)); }
public UserComment GetCommentListByCommentID_UserID(Int32 CommentID, Int32 UserID) { return(_usercommentRepository.GetList(p => p.CommentID == CommentID && p.UserID == UserID).FirstOrDefault()); }
public IList <Comment> GetCommentRecordsOnly(Int32 ID) { return(_commentRepository.GetList(p => p.ID == ID)); }
public List <ProjectWB> getProjectWBSListByProjectID(int projectID) { return(_projectWBS.GetList(d => d.ProjectID == projectID).ToList <ProjectWB>()); }
public IList <EcrOrderLineBarcode> GetOrderEcrBarcodes(int orderNumber) { return(_ecrBarcodeRepository.GetList(x => x.OrderNumber == orderNumber)); }