private static RecordType05 LoadRec05(Receipt receipt) { RecordType05 rec05 = new RecordType05(); rec05.SduBatchId = receipt.GlobalBatchID.ToString(); rec05.SduTranId = String.IsNullOrEmpty(receipt.SDUTranID) ? CreateSduTranID(receipt.GlobalStubID) : receipt.SDUTranID; rec05.ReceiptNumber = receipt.RTNumber; rec05.RetransmittalIndicator = IsRetransmittal(receipt); // processingDate is required rec05.PayorID = receipt.PersonID.Trim() == "0" ? "AR00000000000" : receipt.PersonID; rec05.PayorSSN = receipt.SSN; rec05.PaidBy = receipt.PaidBy; rec05.PayorLastName = receipt.LastName; rec05.PayorFirstName = receipt.FirstName; rec05.PayorMiddleName = receipt.MiddleName; rec05.PayorSuffix = receipt.Suffix; rec05.Amount = receipt.Amount ?? 0; rec05.OfcAmount = receipt.OFCAmount ?? 0; rec05.PaymentMode = receipt.PaymentMode; rec05.PaymentSource = receipt.PaymentSource; rec05.ReceiptReceivedDate = receipt.ProcessingDate.ToString(); rec05.ReceiptEffectiveDate = receipt.EffectiveDate.ToString(); rec05.CheckNumber = receipt.Serial; rec05.ComplianceExemptionReason = GetComplianceExemptionReason(receipt).ToString(); rec05.TargetedPaymentIndicator = receipt.TargetedPayment; rec05.Fips = receipt.FIPS; rec05.CourtCaseNumber = receipt.CaseNumber; rec05.CourtJudgementNumber = receipt.CourtJudgment; rec05.CourtGuidelineNumber = receipt.CourtGuideline; rec05.ReasonCode = receipt.ReasonCode; return(rec05); }
private static void ProcessRecords() { List <Receipt> allReceipts = GetReceiptList().OrderBy(x => x.GlobalStubID).ToList <Receipt>(); Log.WriteLine(String.Format("GetReceipts() returned {0} records.{1}", allReceipts.Count, Environment.NewLine)); UnidentifiedReceipts(allReceipts); SkippedReceipts(allReceipts); /// NORMAL RECEIPTS List <Receipt> receipts = FilterReceipts(allReceipts, NotPredeposited).OrderBy(x => x.GlobalBatchID).ToList(); if (receipts.Count > 0) { RecordType01 rec01 = new RecordType01(CurrentDate); //header RecordType05[] rec05 = new RecordType05[receipts.Count]; //detail ProcessReceipts(receipts, rec01, rec05); } else { //no records found throw new CustomException("Receipt Export found " + receipts.Count + " to process", ExitCode.NoRecordsFound); } }
private static void LogErrorColumns(RecordType05 rec05) { errMsg = String.Format("Record: {0}. Invalid length: {1}", rec05.SduTranId, rec05.RecordLine().Length); if (rec05.SduBatchId.Length > (int)FieldLength.SduBatchId) { errMsg += String.Format("{0}SduBatchId length: {1}. Max is: {2}", Environment.NewLine, rec05.SduBatchId.Length, (int)FieldLength.SduBatchId); } if (rec05.SduTranId.Length > (int)FieldLength.SduTranId) { errMsg += String.Format("{0}SduTranId length: {1}. Max is: {2}", Environment.NewLine, rec05.SduTranId.Length, (int)FieldLength.SduTranId); } if (rec05.ReceiptNumber.Length > (int)FieldLength.ReceiptNumber) { errMsg += String.Format("{0}ReceiptNumber length: {1}. Max is: {2}", Environment.NewLine, rec05.ReceiptNumber.Length, (int)FieldLength.ReceiptNumber); } if (rec05.StrRetransmittalIndicator.Length > (int)FieldLength.RetransmittalIndicator) { errMsg += String.Format("{0}RetransmittalIndicator length: {1}. Max is: {2}", Environment.NewLine, rec05.StrRetransmittalIndicator.Length, (int)FieldLength.RetransmittalIndicator); } if (rec05.PayorID.Length > (int)FieldLength.PayorID) { errMsg += String.Format("{0}PayorID length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorID.Length, (int)FieldLength.PayorID); } if (rec05.PayorSSN.Length > (int)FieldLength.PayorSSN) { errMsg += String.Format("{0}PayorSSN length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorSSN.Length, (int)FieldLength.PayorSSN); } if (rec05.PaidBy.Length > (int)FieldLength.PaidBy) { errMsg += String.Format("{0}PaidBy length: {1}. Max is: {2}", Environment.NewLine, rec05.PaidBy.Length, (int)FieldLength.PaidBy); } if (rec05.PayorLastName.Length > (int)FieldLength.PayorLastName) { errMsg += String.Format("{0}PayorLastName length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorLastName.Length, (int)FieldLength.PayorLastName); } if (rec05.PayorFirstName.Length > (int)FieldLength.PayorFirstName) { errMsg += String.Format("{0}PayorFirstName length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorFirstName.Length, (int)FieldLength.PayorFirstName); } if (rec05.PayorMiddleName.Length > (int)FieldLength.PayorMiddleName) { errMsg += String.Format("{0}PayorMiddleName length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorMiddleName.Length, (int)FieldLength.PayorMiddleName); } if (rec05.PayorSuffix.Length > (int)FieldLength.PayorSuffix) { errMsg += String.Format("{0}PayorSuffix length: {1}. Max is: {2}", Environment.NewLine, rec05.PayorSuffix.Length, (int)FieldLength.PayorSuffix); } if (rec05.StrAmount.Length > (int)FieldLength.Amount) { errMsg += String.Format("{0}Amount length: {1}. Max is: {2}", Environment.NewLine, rec05.StrAmount.Length, (int)FieldLength.Amount); } if (rec05.StrOfcAmount.Length > (int)FieldLength.OfcAmount) { errMsg += String.Format("{0}OfcAmount length: {1}. Max is: {2}", Environment.NewLine, rec05.StrOfcAmount.Length, (int)FieldLength.OfcAmount); } if (rec05.PaymentMode.Length > (int)FieldLength.PaymentMode) { errMsg += String.Format("{0}PaymentMode length: {1}. Max is: {2}", Environment.NewLine, rec05.PaymentMode.Length, (int)FieldLength.PaymentMode); } if (rec05.PaymentSource.Length > (int)FieldLength.PaymentSource) { errMsg += String.Format("{0}PaymentSource length: {1}. Max is: {2}", Environment.NewLine, rec05.PaymentSource.Length, (int)FieldLength.PaymentSource); } if (rec05.ReceiptReceivedDate.Length > (int)FieldLength.ReceiptReceivedDate) { errMsg += String.Format("{0}ReceiptReceivedDate length: {1}. Max is: {2}", Environment.NewLine, rec05.ReceiptReceivedDate.Length, (int)FieldLength.ReceiptReceivedDate); } if (rec05.ReceiptEffectiveDate.Length > (int)FieldLength.ReceiptEffectiveDate) { errMsg += String.Format("{0}ReceiptEffectiveDate length: {1}. Max is: {2}", Environment.NewLine, rec05.ReceiptEffectiveDate.Length, (int)FieldLength.ReceiptEffectiveDate); } if (rec05.CheckNumber.Length > (int)FieldLength.CheckNumber) { errMsg += String.Format("{0}CheckNumber length: {1}. Max is: {2}", Environment.NewLine, rec05.CheckNumber.Length, (int)FieldLength.CheckNumber); } if (rec05.ComplianceExemptionReason.Length > (int)FieldLength.ComplianceExemptionReason) { errMsg += String.Format("{0}ComplianceExemptionReason length: {1}. Max is: {2}", Environment.NewLine, rec05.ComplianceExemptionReason.Length, (int)FieldLength.ComplianceExemptionReason); } if (rec05.TargetedPaymentIndicator.Length > (int)FieldLength.TargetedPaymentIndicator) { errMsg += String.Format("{0}TargetedPaymentIndicator length: {1}. Max is: {2}", Environment.NewLine, rec05.TargetedPaymentIndicator.Length, (int)FieldLength.TargetedPaymentIndicator); } if (rec05.Fips.Length > (int)FieldLength.Fips) { errMsg += String.Format("{0}Fips length: {1}. Max is: {2}", Environment.NewLine, rec05.Fips.Length, FieldLength.Fips); } if (rec05.CourtCaseNumber.Length > (int)FieldLength.CourtCaseNumber) { errMsg += String.Format("{0}CourtCaseNumber length: {1}. Max is: {2}", Environment.NewLine, rec05.CourtCaseNumber.Length, FieldLength.CourtCaseNumber); } if (rec05.CourtJudgementNumber.ToString().Length > (int)FieldLength.CourtJudgementNumber) { errMsg += String.Format("{0}CourtJudgementNumber length: {1}. Max is: {2}", Environment.NewLine, rec05.CourtJudgementNumber.Length, FieldLength.CourtJudgementNumber); } if (rec05.CourtGuidelineNumber.ToString().Length > (int)FieldLength.CourtGuidelineNumber) { errMsg += String.Format("{0}CourtGuidelineNumber length: {1}. Max is: {2}", Environment.NewLine, rec05.CourtGuidelineNumber.Length, FieldLength.CourtGuidelineNumber); } if (rec05.ReasonCode.Length > (int)FieldLength.ReasonCode) { errMsg += String.Format("{0}ReasonCode length: {1}. Max is: {2}", Environment.NewLine, rec05.ReasonCode.Length, FieldLength.ReasonCode); } errMsg += Environment.NewLine; // spacer Log.WriteLine(errMsg); }