public DistributorsImportService(ICostCentreRepository repository, IDTOToEntityMapping mappingService, CokeDataContext ctx)
 {
     _repository = repository;
     _mappingService = mappingService;
     _ctx = ctx;
     validationResultInfos = new List<ImportValidationResultInfo>();
 }

 public InvoiceExportDocumentRepository(CokeDataContext ctx, IInvoiceRepository invoiceRepository,
                                        IMainOrderRepository orderRepository)
 {
     _ctx = ctx;
     _invoiceRepository = invoiceRepository;
     _orderRepository = orderRepository;
 }

 public ConfirmInventoryReceivedNoteCommandHandler(IInventoryReceivedNoteRepository documentRepository, IInventoryWorkflow inventoryWorkflow,
     CokeDataContext cokeDataContext) : base(cokeDataContext)
 {
     _cokeDataContext = cokeDataContext;
     _documentRepository = documentRepository;
     _inventoryWorkflow = inventoryWorkflow;
 }

 public ReceiptExportDocumentRepository(CokeDataContext ctx, IReceiptRepository receiptRepository, IMainOrderRepository mainOrderRepository, IRouteRepository routeRepository)
 {
     _ctx = ctx;
     _receiptRepository = receiptRepository;
     _mainOrderRepository = mainOrderRepository;
     _routeRepository = routeRepository;
 }

 public AreaImporterService(CokeDataContext context, IAreaRepository areaRepository, IRegionRepository regionRepository)
 {
     _areaRepository = areaRepository;
     _regionRepository = regionRepository;
     _context = context;
    
 }

 public ProductDiscountGroupImporterService(IProductDiscountGroupRepository productDiscountGroupRepository, CokeDataContext context, IDiscountGroupRepository discountGroupRepository, IProductRepository productRepository)
 {
     _productDiscountGroupRepository = productDiscountGroupRepository;
     _context = context;
     _discountGroupRepository = discountGroupRepository;
     _productRepository = productRepository;
 }

 public DistrictImportService(IDistrictRepository repository, IDTOToEntityMapping mappingService, CokeDataContext ctx, List<ImportValidationResultInfo> validationResultInfos)
 {
     _repository = repository;
     _mappingService = mappingService;
     _ctx = ctx;
     this.validationResultInfos = validationResultInfos;
 }

 public ConfirmMainOrderCommandHandler(
      CokeDataContext cokeDataContext)
     : base(cokeDataContext)
 {
    
     _cokeDataContext = cokeDataContext;
 }

 public ConfirmInvoiceCommandHandler(IFinancialsWorkflow financialsWorkflow, IInvoiceRepository documentRepository, CokeDataContext cokeDataContext) 
     : base(cokeDataContext)
 {
     _financialsWorkflow = financialsWorkflow;
     _documentRepository = documentRepository;
     _cokeDataContext = cokeDataContext;
 }

 public ProductFlavourImportService(IProductFlavourRepository repository, IDTOToEntityMapping mappingService, CokeDataContext ctx)
 {
     _repository = repository;
     _mappingService = mappingService;
     _ctx = ctx;
     validationResultInfos=new List<ImportValidationResultInfo>();
 }

 public ConfirmReceiptCommandHandler(IFinancialsWorkflow financialsWorkflow, CokeDataContext context, IReceiptRepository receiptRepository)
     :base(context)
 {
     _cokeDataContext = context;
     _financialsWorkflow = financialsWorkflow;
     _receiptRepository =receiptRepository;
 }

 public ChannelPackagingImportService(IDTOToEntityMapping mappingService, IChannelPackagingRepository repository, CokeDataContext ctx)
 {
     _mappingService = mappingService;
     _repository = repository;
     _ctx = ctx;
     validationResultInfos=new List<ImportValidationResultInfo>();
 }

 IEnumerable<ImportEntity> GetProducts(ThirdPartyMasterDataQuery myQuery, out bool hasNext)
 {
    
     using (var ctx=new CokeDataContext(Con))
     {
         IQueryable<tblProduct> query=null;
         hasNext = false;
         if (Enumerable.Any<string>(myQuery.SearchTextList))
         {
             List<tblProduct> items = new List<tblProduct>();
             foreach (var productcode in myQuery.SearchTextList)
             {
                 var found = ctx.tblProduct.FirstOrDefault(
                     p =>
                     p.ProductCode.Trim().Equals(productcode.Trim(),
                                                 StringComparison.CurrentCultureIgnoreCase));
                 if (found != null)
                     items.Add(found);
             }
             if (!items.Any()) return null;
             return items.Select(Map);
         }
         return null;
     }
    
 }

 public ReceivedDeliveryRepository(CokeDataContext ctx, IContainerTypeRepository containerTypeRepository, ICostCentreRepository costCentreRepository, 
     IUserRepository userRepository, ICommodityRepository commodityRepository, ICommodityOwnerRepository commodityOwnerRepository, 
     ICommodityProducerRepository commodityProducerRepository)
     : base(containerTypeRepository, ctx, costCentreRepository, userRepository, commodityRepository, commodityOwnerRepository, commodityProducerRepository)
 {
     documents = _ctx.tblSourcingDocument.Where(s => s.DocumentTypeId == (int)DocumentType.ReceivedDelivery);
 }

 private void GenerateTestCommodityOwneres(CokeDataContext ctx)
 {
     var cTypes = ctx.tblCommodityOwner.Take(10).Select(n => new CommodityOwnerImport()
                                                                 {
                                                                     Code = n.Code,
                                                                     Description = n.Description,
                                                                     Email = n.Email,
                                                                     LastName = n.LastName,
                                                                     FaxNumber = n.FaxNo,
                                                                     PinNo = n.PINNo,
                                                                     BusinessNumber = n.PINNo,
                                                                     CommodityOwnerTypeName =
                                                                         n.tblCommodityOwnerType.Name,
                                                                     CommoditySupplierName = n.tblCostCentre.Name,
                                                                     DateOfBirth = n.DOB,
                                                                     GenderEnum = n.Gender,
                                                                     IdNo = n.IdNo,
                                                                     OfficeNumber = n.OfficeNo,
                                                                     PhoneNumber = n.PhoneNo,
                                                                     PostalAddress = n.PostalAddress,
                                                                     Surname = n.Surname,
                                                                     FirstName = n.FirstName,
                                                                     PhysicalAddress = n.PhysicalAddress,
                                                                 }).ToList();
     DumpExportFilesAsync(cTypes.ToCsv(), "farmers.csv");
 }

 public ProductPackagingTypeImportService(IDTOToEntityMapping mappingService, IProductPackagingTypeRepository repository, CokeDataContext ctx)
 {
     _mappingService = mappingService;
     _repository = repository;
     _ctx = ctx;
     
 }

 public ServiceProviderController(IDTOToEntityMapping dtoToEntityMapping, IMasterDataToDTOMapping masterDataToDtoMapping, CokeDataContext context, IServiceProviderRepository serviceProviderRepository, IBankRepository bankRepository, IBankBranchRepository bankBranchRepository)
     : base(dtoToEntityMapping, masterDataToDtoMapping, context)
 {
     _serviceProviderRepository = serviceProviderRepository;
     _bankRepository = bankRepository;
     _bankBranchRepository = bankBranchRepository;
 }

 public AddInvoiceLineItemCommandHandler(IInvoiceRepository documentRepository, IProductRepository productRepository, CokeDataContext cokeDataContext) 
     : base(cokeDataContext)
 {
     _cokeDataContext = cokeDataContext;
     _documentRepository = documentRepository;
     _productRepository = productRepository;
 }

 public DistributorSalesmanImportService(ICostCentreRepository costCentreRepository, ICostCentreFactory costCentreFactory, IUserRepository userRepository, CokeDataContext ctx)
 {
     _costCentreRepository = costCentreRepository;
     _costCentreFactory = costCentreFactory;
     _userRepository = userRepository;
     _ctx = ctx;
     _repositoryHelpers=new RepositoryHelpers(ctx);
 }

 public AddInventoryTransferNoteLineItemCommandHandler(
     IInventoryTransferNoteRepository documentRepository, 
     IProductRepository productRepository,CokeDataContext cokeDataContext ) : base(cokeDataContext)
 {
     _documentRepository = documentRepository;
     _productRepository = productRepository;
     _cokeDataContext = cokeDataContext;
 }