private SaleProductDTO Map(tblProduct tbl) { var dto = new SaleProductDTO { MasterId = tbl.id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Description = tbl.Description, ProductBrandMasterId = tbl.BrandId ?? Guid.Empty, ProductPackagingMasterId = tbl.PackagingId ?? Guid.Empty, ProductPackagingTypeMasterId = tbl.PackagingTypeId ?? Guid.Empty, ProductCode = tbl.ProductCode, ReturnableTypeMasterId = tbl.ReturnableType, VatClassMasterId = tbl.VatClassId, ExFactoryPrice = tbl.ExFactoryPrice, ProductFlavourMasterId = tbl.FlavourId ?? Guid.Empty, ProductTypeMasterId = tbl.ProductTypeId.HasValue ?tbl.ProductTypeId.Value: Guid.Empty, ReturnableProductMasterId = tbl.Returnable ?? Guid.Empty, }; if (tbl.Returnable.HasValue) { string sql = string.Format( "select c.Id,c.Capacity from tblProduct r join tblProduct c on c.id=r.Returnable where r.id='{0}'", tbl.Returnable.Value); var container = _context.ExecuteStoreQuery<ReturnableContainer>(sql).FirstOrDefault(); if (container != null) { dto.ContainerCapacity = container.Capacity; dto.ReturnableContainerMasterId = container.Id; } } return dto; }
public SaleProduct Map(SaleProductDTO dto) { if (dto == null) return null; var saleProduct = Mapper.Map<SaleProductDTO, SaleProduct>(dto); saleProduct.ReturnableProduct = (ReturnableProduct) _productRepository.GetById(dto.ReturnableProductMasterId); saleProduct.ProductType = _productTypeRepository.GetById(dto.ProductTypeMasterId); saleProduct.Flavour = _productFlavourRepository.GetById(dto.ProductFlavourMasterId); saleProduct.Brand = _productBrandRepository.GetById(dto.ProductBrandMasterId); saleProduct.PackagingType = _productPackagingTypeRepository.GetById(dto.ProductPackagingTypeMasterId); saleProduct.VATClass = _vatClassRepository.GetById(dto.VatClassMasterId.Value); saleProduct.Packaging = _productPackagingRepository.GetById(dto.ProductPackagingMasterId); return saleProduct; }