Esempio n. 1
0
        private DataTable FindProductNotInReceivedFile(Config config, DataTable dataTable)
        {
            using (var sdService = new SuppDistService(config.TargetConnectionString)) {
                DataTable sc_products = sdService.GetAllSupplierProducts(config.FileName);

                var rowsOnlyInDt1 = sc_products.AsEnumerable().Where(r2 => !dataTable.AsEnumerable()
                                                                     .Any(r => r[1].ToString().Trim().ToLower() == r2["supplier_code"].ToString().Trim().ToLower() && r[1].ToString().Trim().ToLower() == r2["supplier_code"].ToString().Trim().ToLower()));
                DataTable result = new DataTable();
                if (rowsOnlyInDt1.Count() > 0)
                {
                    result = rowsOnlyInDt1.CopyToDataTable();//The third table
                }
                return(result);
            }
        }
Esempio n. 2
0
        private ImportDataException ValidateUniqueDistributorCode(MappingTable mappingTable, DataRow row)
        {
            if (mappingTable.TableName.ToUpperInvariant() != "INGREDIENT")
            {
                return(null);
            }

            int?distributorNameOrdinal = mappingTable.ColumnOrdinalOf("distributor_id");
            int?distributorCodeOrdinal = mappingTable.ColumnOrdinalOf("distributor_code");

            if (distributorNameOrdinal == null || distributorCodeOrdinal == null)
            {
                return(null);
            }

            string importDistName = row[Convert.ToInt32(distributorNameOrdinal)].ToString().Trim();
            string importDistCode = row[Convert.ToInt32(distributorCodeOrdinal)].ToString().Trim();

            if (string.IsNullOrEmpty(importDistName) || string.IsNullOrEmpty(importDistCode))
            {
                return(null);
            }

            using (var sdService = new SuppDistService(_config.TargetConnectionString))
            {
                if (sdService.DistributorCodeUsedForProduct(importDistName, importDistCode))
                {
                    string columnName  = mappingTable.ColumnNameOf("distributor_code");
                    string mappingName = mappingTable.MappingNameOf("distributor_code");
                    return(new ImportDataException
                    {
                        ExceptionType = ExceptionType.DuplicateDistributorCode,
                        TemplateColumnName = columnName,
                        IsValid = false,
                        TemplateMappingColumn = mappingName
                    });
                }
            }
            return(null);
        }