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;
}
public CommoditySupplierImportService(ICommoditySupplierRepository repository, IDTOToEntityMapping mappingService, CokeDataContext ctx, IBankRepository bankRepository, IBankBranchRepository bankBranchRepository)
{
_repository = repository;
_mappingService = mappingService;
_bankRepository = bankRepository;
_bankBranchRepository = bankBranchRepository;
_ctx = ctx;
}
public CommodityOwnerImporterService(CokeDataContext ctx, ICommodityOwnerRepository commodityOwnerRepository, ICommodityOwnerTypeRepository commodityOwnerTypeRepository, ICommoditySupplierRepository commoditySupplierRepository)
{
_ctx = ctx;
_commodityOwnerRepository = commodityOwnerRepository;
_commodityOwnerTypeRepository = commodityOwnerTypeRepository;
_commoditySupplierRepository = commoditySupplierRepository;
count = 300;
}
public InventoryTransactionRepository(CokeDataContext ctx, IInventoryRepository inventoryRepository, ICacheProvider cacheProvider)
{
_ctx = ctx;
_inventoryRepository = inventoryRepository;
_cacheProvider = cacheProvider;
}
public ReturnsNoteRepository(CokeDataContext ctx,
ICostCentreRepository costCentreRepository,
IUserRepository userRepository,
IProductRepository productRepository,
ICacheProvider cacheProvider)
: base(ctx, costCentreRepository, userRepository, productRepository)
{
}
public ApplicationSetup(CokeDataContext ctx, ICostCentreFactory costCentreFactory, ICostCentreRepository costCentreRepository, IUserRepository userRepository, IUserGroupRepository userGroupRepository, IUserGroupRolesRepository userGroupRolesRepository)
{
_ctx = ctx;
_costCentreFactory = costCentreFactory;
_costCentreRepository = costCentreRepository;
_userRepository = userRepository;
_userGroupRepository = userGroupRepository;
_userGroupRolesRepository = userGroupRolesRepository;
}
public SalesmanImportService(ICostCentreRepository repository, IUserRepository userRepository, IDTOToEntityMapping mappingService, CokeDataContext ctx)
{
_repository = repository;
_userRepository = userRepository;
_mappingService = mappingService;
_ctx = ctx;
validationResultInfos=new List<ImportValidationResultInfo>();
mobileNumbers = new Dictionary<string, string>();
}
protected tblProduct GetProduct(string itemName)
{
using (var ctx = new CokeDataContext(Con))
{
tblProduct pitem = null;
if (!string.IsNullOrEmpty(itemName))
pitem = ctx.tblProduct.FirstOrDefault(p => p.ProductCode != null && p.ProductCode.ToLower() == itemName.ToLower());
return pitem;
}
}
void GenerateTestCommodityOwnerTypes(CokeDataContext ctx)
{
var cTypes = ctx.tblCommodityOwnerType.Take(10).Select(n => new CommodityOwnerTypeImport()
{
Code = n.Code,
Description = n.Description,
Name = n.Name
}).ToList();
DumpExportFilesAsync(cTypes.ToCsv(), "CommodityOwnerType.csv");
}
public void SetupServerSql(bool insertTestData, CokeDataContext ctx, IInsertTestData insertTestDataService)
{
//run script.sql
RebuildDb.RecreateTables(Server_DistributrConnectionString, CreateTablesScriptLocation);
//migrate scripts
DistributrDataHelper.Migrate(ctx);
//insert test data
if (insertTestData)
insertTestDataService.InsertTestMasterData();
}
public AddInventoryReceivedNoteLineItemCommandHandler(ICostCentreRepository costCenterRepository, IUserRepository userRepository,
IInventoryReceivedNoteRepository documentRepository, IDocumentFactory documentFactory, IProductRepository productRepository,
CokeDataContext cokeDataContext) : base(cokeDataContext)
{
_cokeDataContext = cokeDataContext;
_costCenterRepository = costCenterRepository;
_userRepository = userRepository;
_documentFactory = documentFactory;
_documentRepository = documentRepository;
_productRepository = productRepository;
}
