Пример #1
0
        public void WriteHeader(PrismCustomerInfoContext context, TypeCustomerInfoFile file)
        {
            var line = string.Format("HDR|MTCRCustomerInformation|{0}|{1}",
                                     file.FileNumber, file.CrDuns);

            context.AppendLine(line);
        }
Пример #2
0
        public void When_Parsing_Customer_Info_Error_With_Field_Zero_Equal_To_ER1_Then_Record_Type_Id_Is_Set_To_One()
        {
            // arrange
            const int expected = 1;

            var context   = new PrismCustomerInfoContext();
            var fileModel = new TypeCustomerInfoFile();

            context.PushModel(fileModel);

            var fields = new[] { "ER1", "", "PREMNO", "" };

            // act
            concern.ParseError(context, fields);
            context.ResolveToFile();

            // assert
            var results    = context.Results;
            var collection = results.TypeHeaders;
            var model      = collection.First();

            var errors = model.ErrorRecords;

            Assert.AreEqual(1, errors.Length);

            var error = errors[0];

            Assert.AreEqual(expected, error.RecordTypeId);
            Assert.IsNull(error.FieldName);
        }
Пример #3
0
        public void SaveHeader(TypeCustomerInfoFile file)
        {
            logger.Trace("Start inserting customer info file.");

            var fileKey = clientDataAccess.InsertFile(file);

            logger.DebugFormat("Inserted Customer Billing File \"{0}\".", fileKey);

            foreach (var errorRecord in file.ErrorRecords)
            {
                errorRecord.FileId = fileKey;
                var errorKey = clientDataAccess.InsertErrorRecord(errorRecord);
                logger.DebugFormat("Inserted Error Record \"{0}\" for Customer Billing File \"{1}\".", errorKey, fileKey);
            }

            logger.Trace("Completed inserting customer info file.");
        }
Пример #4
0
        public TypeCustomerInfoFile[] ListCustomerInfoReadyForTransmission()
        {
            using (var connection = new SqlConnection(connectionString))
                using (var command = connection.CreateCommand("esp_CustomerBillingFileListByStatus"))
                {
                    // Status Id 3 => Ready For Transmission
                    command.AddWithValue("@StatusID", 3);

                    if (connection.State != ConnectionState.Open)
                    {
                        connection.Open();
                    }

                    var collection = new List <TypeCustomerInfoFile>();
                    using (var reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var item = new TypeCustomerInfoFile
                            {
                                Direction   = false,
                                CrDuns      = reader.GetString("CRDuns"),
                                CspDunsId   = reader.GetInt32("CSPDUNSID"),
                                FileId      = reader.GetInt32("CustomerBillingFileID"),
                                FileTypeId  = reader.GetInt32("TypeID"),
                                Status      = (CustomerInfoFileStatusOptions)reader.GetInt32("StatusID"),
                                ErrorCount  = reader.GetInt32("ErrorCount"),
                                RecordCount = reader.GetInt32("RecordCount"),
                            };

                            reader.TryGetString("CustomerBillingFileNumber", x => item.FileNumber = x);
                            reader.TryGetString("CustomerBillingFileReferenceNumber", x => item.ReferenceNumber = x);
                            reader.TryGetString("FileName", x => item.FileName       = x);
                            reader.TryGetDateTime("StatusDate", x => item.StatusDate = x);
                            reader.TryGetDateTime("CreateDate", x => item.CreateDate = x);
                            reader.TryGetInt32("UserID", x => item.UserId            = x);

                            collection.Add(item);
                        }

                        return(collection.ToArray());
                    }
                }
        }
Пример #5
0
        public TypeCustomerInfoFile LoadCustomerInfoFile(int fileId)
        {
            using (var connection = new SqlConnection(connectionString))
                using (var command = connection.CreateCommand("esp_CustomerBillingFileLoad"))
                {
                    command.AddWithValue("@CustomerBillingFileID", fileId);

                    if (connection.State != ConnectionState.Open)
                    {
                        connection.Open();
                    }

                    using (var reader = command.ExecuteReader())
                    {
                        if (!reader.Read())
                        {
                            return(null);
                        }

                        var item = new TypeCustomerInfoFile
                        {
                            Direction   = false,
                            CrDuns      = reader.GetString("CRDuns"),
                            CspDunsId   = reader.GetInt32("CSPDUNSID"),
                            FileId      = reader.GetInt32("CustomerBillingFileID"),
                            FileTypeId  = reader.GetInt32("TypeID"),
                            Status      = (CustomerInfoFileStatusOptions)reader.GetInt32("StatusID"),
                            ErrorCount  = reader.GetInt32("ErrorCount"),
                            RecordCount = reader.GetInt32("RecordCount"),
                        };

                        reader.TryGetString("CustomerBillingFileNumber", x => item.FileNumber = x);
                        reader.TryGetString("CustomerBillingFileReferenceNumber", x => item.ReferenceNumber = x);
                        reader.TryGetString("FileName", x => item.FileName       = x);
                        reader.TryGetDateTime("StatusDate", x => item.StatusDate = x);
                        reader.TryGetDateTime("CreateDate", x => item.CreateDate = x);
                        reader.TryGetInt32("UserID", x => item.UserId            = x);

                        return(item);
                    }
                }
        }
Пример #6
0
        public int InsertFile(TypeCustomerInfoFile model)
        {
            using (var connection = new SqlConnection(connectionString))
                using (var command = connection.CreateCommand("esp_CustomerBillingFileInsert"))
                {
                    SqlParameter keyParameter;

                    command
                    .AddWithValue("@CustomerBillingFileNumber", model.FileNumber)
                    .AddIfNotEmptyOrDbNull("@CustomerBillingFileReferenceNumber", model.ReferenceNumber)
                    .AddWithValue("@FileName", model.FileName)
                    .AddWithValue("@CSPDUNSID", model.CspDunsId)
                    .AddWithValue("@StatusID", (int)model.Status)
                    .AddWithValue("@TypeID", model.FileTypeId)
                    .AddWithValue("@DirectionFlag", true)
                    .AddWithValue("@CreateDate", DateTime.Now)
                    .AddWithValue("@StatusDate", model.StatusDate)
                    .AddWithValue("@UserID", model.UserId)
                    .AddOutParameter("@CustomerBillingFileID", SqlDbType.Int, out keyParameter);

                    if (connection.State != ConnectionState.Open)
                    {
                        connection.Open();
                    }

                    command.ExecuteNonQuery();

                    if (keyParameter.Value == null)
                    {
                        throw new Exception();
                    }

                    var fileId = (int)keyParameter.Value;
                    model.FileId = fileId;

                    return(fileId);
                }
        }
Пример #7
0
        public void WriteRecord(PrismCustomerInfoContext context, TypeCustomerInfoFile file)
        {
            var records = exportDataAccess.ListRecords(file.FileId);

            foreach (var record in records)
            {
                var email = (emailMatch.IsMatch(record.Email))
                                ? record.Email
                                : string.Empty;

                var line =
                    string.Format(
                        "DET|{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}|{8}|{9}|{10}|{11}|{12}|{13}|{14}|{15}|{16}|{17}|{18}|{19}",
                        record.SequenceId, record.CrDuns, record.PremNo, record.CustNo,
                        alphaNumericExp.Replace(record.FirstName, string.Empty),
                        alphaNumericExp.Replace(record.LastName, string.Empty),
                        alphaNumericExp.Replace(record.CompanyName, string.Empty),
                        alphaNumericExp.Replace(record.ContactName, string.Empty),
                        alphaNumericExp.Replace(record.BillingCareOfName, string.Empty),
                        alphaNumericExp.Replace(record.BillingAddress1, string.Empty),
                        alphaNumericExp.Replace(record.BillingAddress2, string.Empty),
                        alphaNumericExp.Replace(record.BillingCity, string.Empty),
                        record.BillingState,
                        alphaNumericExp.Replace(record.BillingPostalCode, string.Empty),
                        record.BillingCountryCode.Trim().Substring(0, 2),
                        numericExp.Replace(record.PrimaryTelephone, string.Empty),
                        alphaNumericExp.Replace(record.PrimaryTelephoneExt, string.Empty),
                        alphaNumericExp.Replace(record.SecondaryTelephone, string.Empty),
                        numericExp.Replace(record.SecondaryTelephoneExt, string.Empty),
                        email);

                context.AppendLine(line);
            }

            context.AppendLine(string.Format("SUM|{0}|0|0", records.Length));
        }
Пример #8
0
        public void ParseHeader(PrismCustomerInfoContext context, string[] fields)
        {
            var typeId        = 3;
            var typeIndicator = fields.AtIndex(1);

            if (typeIndicator.Equals("MTCRCUSTOMERINFORMATIONERCOTRESPONSE", StringComparison.OrdinalIgnoreCase))
            {
                typeId = 2;
            }

            var model = new TypeCustomerInfoFile
            {
                FileTypeId      = typeId,
                ReferenceNumber = fields.AtIndex(2),
                CrDuns          = fields.AtIndex(3),
                Status          = CustomerInfoFileStatusOptions.Imported,
            };

            var cspDunsId = clientDataAccess.IdentifyCspDunsId(model.CrDuns);

            model.CspDunsId = cspDunsId;

            context.PushModel(model);
        }
Пример #9
0
 public void AddHeader(TypeCustomerInfoFile item)
 {
     headers.Add(item);
 }