public VesselStatusViewModel GetVesselByCode(string vesselCode) { var vesselStatus = new VesselStatusViewModel(); var vessel = _vesselRepository.Query(cus => cus.VesselC == vesselCode).FirstOrDefault(); if (vessel != null) { var vesselViewModel = Mapper.Map <Vessel_M, VesselViewModel>(vessel); vesselViewModel.VesselIndex = FindIndex(vesselCode); vesselStatus.Vessel = vesselViewModel; vesselStatus.Status = CustomerStatus.Edit.ToString(); // set shipping company name var shippingCompanyC = vesselViewModel.ShippingCompanyC; var shpCompany = _shippingCompanyRepository.Query(s => s.ShippingCompanyC.Equals(shippingCompanyC)).FirstOrDefault(); if (shpCompany != null) { vesselViewModel.ShippingCompanyN = shpCompany.ShippingCompanyN; } } else { vesselStatus.Status = CustomerStatus.Add.ToString(); } return(vesselStatus); }
public OrderPatternViewModel GetOrderPattern(string custMainCode, string custSubCode, string orderPatternC, DateTime?date) { var pattern = _orderPatternRepository.Query(pat => pat.CustomerMainC == custMainCode && pat.CustomerSubC == custSubCode && pat.OrderPatternC.Equals(orderPatternC)).FirstOrDefault(); if (pattern == null) { return(null); } var destination = Mapper.Map <OrderPattern_M, OrderPatternViewModel>(pattern); var customer = _customerRepository.Query( p => p.CustomerMainC == destination.CustomerMainC && p.CustomerSubC == destination.CustomerSubC) .FirstOrDefault(); destination.CustomerN = customer != null ? customer.CustomerN : String.Empty; var shippingCompany = _shippingCompanyRepository.Query(p => p.ShippingCompanyC == destination.ShippingCompanyC).FirstOrDefault(); destination.ShippingCompanyN = shippingCompany != null ? shippingCompany.ShippingCompanyN : String.Empty; var vessel = _vesselRepository.Query(p => p.VesselC == destination.VesselC).FirstOrDefault(); destination.VesselN = vessel != null ? vessel.VesselN : String.Empty; var shipper = _shipperRepository.Query(p => p.ShipperC == destination.ShipperC).FirstOrDefault(); destination.ShipperN = shipper != null ? shipper.ShipperN : String.Empty; var locLoadingPlace = _locationRepository.Query(p => p.LocationC == destination.LoadingPlaceC).FirstOrDefault(); destination.LoadingPlaceN = locLoadingPlace != null ? locLoadingPlace.LocationN : String.Empty; var locStopoverPlace = _locationRepository.Query(p => p.LocationC == destination.StopoverPlaceC).FirstOrDefault(); destination.StopoverPlaceN = locStopoverPlace != null ? locStopoverPlace.LocationN : String.Empty; var locDischargePlace = _locationRepository.Query(p => p.LocationC == destination.DischargePlaceC).FirstOrDefault(); destination.DischargePlaceN = locDischargePlace != null ? locDischargePlace.LocationN : String.Empty; var conttainertype = _containerTypeRepository.Query(p => p.ContainerTypeC == destination.ContainerTypeC).FirstOrDefault(); destination.ContainerTypeN = conttainertype != null ? conttainertype.ContainerTypeN : String.Empty; destination.PatternIndex = FindIndex(custMainCode, custSubCode, orderPatternC); //get list of contract tariff pattern destination.ContractTariffPatterns = _contractTariffPatternService.GetContractTariffPatterns(destination.CustomerMainC, destination.CustomerSubC, destination.LoadingPlaceC, destination.DischargePlaceC, date); return(destination); }
public IEnumerable <ShippingCompanyViewModel> GetShippingCompanies(string value) { var shipComs = _shippingCompanyRepository.Query(shp => shp.ShippingCompanyC.Contains(value) || shp.ShippingCompanyN.Contains(value)); if (shipComs != null) { var destination = Mapper.Map <IEnumerable <ShippingCompany_M>, IEnumerable <ShippingCompanyViewModel> >(shipComs); return(destination); } return(null); }