protected override void BeforeChange(DataColumn dc, DataRow ddr) { base.BeforeChange(dc, ddr); string ObjectName = this.myDebtorDT.TableName; CLAS.DebtorRow dr = (CLAS.DebtorRow)ddr; switch (dc.ColumnName) { case "AddressCurrentID": if (ddr.IsNull(dc)) { throw new AtriumException(Resources.DebtAddressRqd); } break; case "SexCode": if (ddr.IsNull(dc)) { throw new RequiredException(Resources.DebtorSexCode); } if (!dr.IsNull("SexCode") && !myA.CheckDomain(dr.SexCode, myA.FM.Codes("Sex"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Gender Code"); } break; case "LanguageCode": if (ddr.IsNull(dc)) { throw new RequiredException(Resources.DebtorLanguageCode); } else if (!myA.CheckDomain(dr.LanguageCode, myA.FM.Codes("LanguageCode"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Language Code"); } break; case "BirthDate": if (ddr.IsNull(dc)) { throw new RequiredException(Resources.DebtorBirthDate); } myA.IsValidDate(Resources.DebtorBirthDate, (System.DateTime)ddr[dc], false, DateTime.Today.AddYears(-100), DateTime.Today.AddYears(-15), Resources.Validation100yearsago, Resources.Validation15yearsago); break; case "CeasedToBeStudentDate": if (!dr.IsCeasedToBeStudentDateNull()) { myA.IsValidDate(Resources.DebtorCeasedToBeStudentDate, dr.CeasedToBeStudentDate, false, DebtorBE.CSLBegin, DateTime.Today, Resources.ValidationCSLBegin, Resources.ValidationToday); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myTaxingDT.TableName; CLAS.TaxingRow dr = (CLAS.TaxingRow)ddr; switch (dc.ColumnName) { case TaxingFields.Comment: if (dr.IsNull(dc)) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } break; case TaxingFields.ReasonCode: if (dr.IsNull(dc)) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } else if (!myA.CheckDomain(dr.ReasonCode, myA.FM.Codes("ReasonCode"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Reason Code"); } break; case TaxingFields.OfficeID: if (dr.IsNull("OfficeID")) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } else if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("officelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Office List"); } break; case TaxingFields.OfficerID: if (dr.IsOfficerIDNull()) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } else if (!myA.CheckDomain(dr.OfficerID, myA.FM.Codes("claslist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Officer List"); } break; case TaxingFields.TaxingDate: if (dr.IsTaxingDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.TaxingTaxingDate); } myA.IsValidDate(atriumBE.Properties.Resources.TaxingTaxingDate, dr.TaxingDate, false, DateTime.Today.AddMonths(-6), DateTime.Today, atriumBE.Properties.Resources.ValidationSixMonthsAgo, atriumBE.Properties.Resources.ValidationToday); break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myAccountHistoryDT.TableName; CLAS.AccountHistoryRow dr = (CLAS.AccountHistoryRow)ddr; switch (dc.ColumnName) { case "SentToOfficeDate": if (dr.IsSentToOfficeDateNull()) { throw new RequiredException(Resources.AccountHistorySentToOfficeDate); } // if(dr.DebtRow.IsReceivedByJusticeDateNull()) // this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.RelatedDateRequired, myA.GetLabelLeft(ObjectName, dc.ColumnName), myA.GetLabelLeft("FileAccount", "ReceivedByJusticeDate")); myA.IsValidDate(Resources.AccountHistorySentToOfficeDate, dr.SentToOfficeDate, false, dr.DebtRow.ReceivedByJusticeDate, DateTime.Today.AddDays(7), Resources.DebtReceivedByJusticeDate, Resources.ValidationSevenDaysLater); break; case "ReceivedByOfficeDate": // if(dr.IsReceivedByOfficeDateNull()) // this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); if (dr.IsSentToOfficeDateNull()) { throw new RelatedException(Resources.AccountHistoryReceivedByOfficeDate, Resources.AccountHistorySentToOfficeDate); } if (!dr.IsReceivedByOfficeDateNull()) { myA.IsValidDate(Resources.AccountHistoryReceivedByOfficeDate, dr.ReceivedByOfficeDate, true, dr.SentToOfficeDate, DateTime.Today, Resources.AccountHistorySentToOfficeDate, Resources.ValidationToday); } break; case "ReturnedByOfficeDate": if (dr.IsReceivedByOfficeDateNull()) { throw new AtriumException(Resources.AccountNotReceived); //this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); } // if(dr.IsReceivedByOfficeDateNull()) // this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.RelatedDateRequired,myA.GetLabelLeft(ObjectName, dc.ColumnName),myA.GetLabelLeft(ObjectName, "ReceivedByOfficeDate")); if (!dr.IsReturnedByOfficeDateNull()) { myA.IsValidDate(Resources.AccountHistoryReturnedByOfficeDate, dr.ReturnedByOfficeDate, true, dr.ReceivedByOfficeDate, DateTime.Today, Resources.AccountHistoryReceivedByOfficeDate, Resources.ValidationToday); } break; case "ReceivedFromOfficeDate": // if(dr.IsReceivedFromOfficeDateNull()) // this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); if (dr.IsReceivedByOfficeDateNull()) { throw new RelatedException(Resources.AccountHistoryReceivedFromOfficeDate, Resources.AccountHistoryReceivedByOfficeDate); } if (!dr.IsReceivedFromOfficeDateNull()) { myA.IsValidDate(Resources.AccountHistoryReceivedFromOfficeDate, dr.ReceivedFromOfficeDate, true, dr.ReturnedByOfficeDate, DateTime.Today, Resources.AccountHistoryReturnedByOfficeDate, Resources.ValidationToday); } break; case "OfficeId": if (dr.IsNull(dc)) { throw new RequiredException(Resources.OfficeID); } else if (!myA.CheckDomain(dr.OfficeId, myA.FM.Codes("officelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Office List"); } break; case "StatusCode": if (!myA.CheckDomain(dr.StatusCode, myA.FM.Codes("status"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Status Code"); } break; //case "SubFileType": // if (dr.IsNull(dc)) // myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); // else if (!myA.Codes("HistoryType").Rows.Contains(dr.SubFileType)) // myA.RaiseError((int)AtriumEnum.AppErrorCodes.FHInvalidFileType); // break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myWritDT.TableName; CLAS.WritRow dr = (CLAS.WritRow)ddr; switch (dc.ColumnName) { case "IssueRenewalDate": if (dr.IsIssueRenewalDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.WritIssueRenewalDate); } if (dr.JudgmentRow.IsJudgmentDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.WritIssueRenewalDate, atriumBE.Properties.Resources.JudgmentJudgmentDate); } myA.IsValidDate(atriumBE.Properties.Resources.WritIssueRenewalDate, dr.IssueRenewalDate, false, dr.JudgmentRow.JudgmentDate, DateTime.Today, atriumBE.Properties.Resources.JudgmentJudgmentDate, atriumBE.Properties.Resources.ValidationToday); break; case "ExpiryDate": if (dr.IsExpiryDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.WritExpiryDate); } if (dr.IsIssueRenewalDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.WritExpiryDate, atriumBE.Properties.Resources.WritIssueRenewalDate); } myA.IsValidDate(atriumBE.Properties.Resources.WritExpiryDate, dr.ExpiryDate, false, dr.IssueRenewalDate, DateTime.Today.AddYears(30), atriumBE.Properties.Resources.WritIssueRenewalDate, atriumBE.Properties.Resources.ValidationThirtyYearsLater); break; case "ExecutionorRegistrationNumber": if (dr.IsExecutionorRegistrationNumberNull()) { throw new RequiredException(atriumBE.Properties.Resources.WritExecutionorRegistrationNumber); } break; case "OfficeID": if (dr.IsOfficeIDNull()) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } else if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("officelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Office List"); } break; case "TypeofWritCode": if (dr.IsTypeofWritCodeNull()) { throw new RequiredException(atriumBE.Properties.Resources.ResourceManager.GetString(ObjectName + dc.ColumnName)); } else if (!myA.CheckDomain(dr.TypeofWritCode, myA.FM.Codes("TypeofWrit"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Writ Type"); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { CLAS.InsolvencyRow dr = (CLAS.InsolvencyRow)ddr; switch (dc.ColumnName) { case "InsolvencyPeriod": if (!dr.IsInsolvencyPeriodNull() && (dr.InsolvencyType != "O" && (dr.InsolvencyPeriod < 0 || dr.InsolvencyPeriod > 60))) { throw new AtriumException("Insolvency Period must be between {0} and {1} months", "0", "60"); } if (!dr.IsInsolvencyPeriodNull() && (dr.InsolvencyType == "O" && (dr.InsolvencyPeriod < 0 || dr.InsolvencyPeriod > 150))) { throw new AtriumException("Insolvency Period must be between {0} and {1} months", "0", "150"); } break; case InsolvencyFields.InsolvencyFiledDate: if (dr.IsInsolvencyFiledDateNull()) { throw new RequiredException(Properties.Resources.InsolvencyInsolvencyFiledDate); } myA.IsValidDate(atriumBE.Properties.Resources.InsolvencyInsolvencyFiledDate, dr.InsolvencyFiledDate, false, (dr.IsPreviousInsolvencyDateNull() ? DebtorBE.CSLBegin : dr.PreviousInsolvencyDate), DateTime.Today, "", atriumBE.Properties.Resources.ValidationToday); break; case "ProofOfClaimFiledDate": if (!dr.IsProofOfClaimFiledDateNull()) { if (dr.IsInsolvencyFiledDateNull()) { throw new RelatedException("Proof of Claim Filed Date", "Insolvency Filed Date"); } myA.IsValidDate("Proof of Claim Filed Date", dr.ProofOfClaimFiledDate, true, dr.InsolvencyFiledDate, DateTime.Today, "Insolvency Filed Date", Properties.Resources.ValidationToday); } break; case "AcceptanceDate": if (!dr.IsAcceptanceDateNull()) { if (dr.IsInsolvencyFiledDateNull()) { throw new RelatedException("Acceptance Date", "Insolvency Filed Date"); } myA.IsValidDate("Acceptance Date", dr.AcceptanceDate, true, dr.InsolvencyFiledDate, DateTime.Today, "Insolvency Filed Date", Properties.Resources.ValidationToday); } break; case "DefaultDate": if (!dr.IsDefaultDateNull()) { myA.IsValidDate("Default Date", dr.DefaultDate, true, dr.AcceptanceDate, DateTime.Today, "Acceptance Date", Properties.Resources.ValidationToday); } break; case "InsolvencyFulfilledDate": if (!dr.IsInsolvencyFulfilledDateNull()) { myA.IsValidDate("Fulfilled Date", dr.InsolvencyFulfilledDate, true, dr.AcceptanceDate, DateTime.Today, "Acceptance Date", Properties.Resources.ValidationToday); } break; case "InsolvencyType": if (!myA.CheckDomain(dr.InsolvencyType, myA.FM.Codes("InsolvencyType"))) { throw new AtriumException(Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Insolvency Type"); } break; case "OfficeID": if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("OfficeList"))) { throw new AtriumException(Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Office List"); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { switch (dc.ColumnName) { case "ActiveWithJustice": //cqn't be active if filestatus is ACM if ((bool)ddr[dc.ColumnName] && "ACM".IndexOf(this.myA.FM.CurrentFile.StatusCode) > 0) { throw new AtriumException(Resources.AccountCannotBeActiveWhenTheFileIsClosed); } break; case "AccountTypeId": if (ddr.IsNull(dc)) { throw new RequiredException(Resources.FileAccountAccountTypeId); } // JLL 2010-08-09 commented out checkdomain as it causes issues ... trying to setup clas workflows for demo //else if (!myA.CheckDomain((string)ddr[dc.ColumnName], myA.Codes("accounttypelist"))) // throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Account Type"); break; case "ReceivedByJusticeDate": if (ddr.IsNull(dc)) { throw new RequiredException(Resources.FileAccountReceivedByJusticeDate); } myA.IsValidDate(Resources.FileAccountReceivedByJusticeDate, (DateTime)ddr[dc], false, DebtorBE.CSLBegin, DateTime.Today, Resources.ValidationCSLBegin, Resources.ValidationToday); break; case "ClosureDate": if (ddr.IsNull(dc) && !ddr.IsNull("ClosureCode")) { throw new RequiredException(Resources.FileAccountClosureDate); } if (ddr.IsNull("ReceivedByJusticeDate")) { throw new RelatedException(Resources.FileAccountClosureDate, Resources.FileAccountReceivedByJusticeDate); } if (!ddr.IsNull(dc)) { myA.IsValidDate(Resources.FileAccountClosureDate, (DateTime)ddr[dc], true, (DateTime)ddr["ReceivedByJusticeDate"], DateTime.Today, Resources.FileAccountReceivedByJusticeDate, Resources.ValidationToday); } break; case "ClosureCode": if (!ddr.IsNull("ClosureDate") && ddr.IsNull(dc)) { throw new AtriumException(Resources.DebtCloseCodeRqd); } else if (!ddr.IsNull(dc) && !myA.CheckDomain((string)ddr[dc.ColumnName], myA.FM.Codes("returncode"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Closure Code"); } break; case "OfficeID": if (!myA.CheckDomain((int)ddr[dc.ColumnName], myA.FM.Codes("officelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Office List"); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myJudgmentDT.TableName; CLAS.JudgmentRow dr = (CLAS.JudgmentRow)ddr; switch (dc.ColumnName) { case "JudgmentID": // if CLng(vNewValue) <> mrst(dc.ColumnName)) // Me.Find vNewValue // End If break; case "ActionNumber": if (dr.IsActionNumberNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentActionNumber); } break; case "JudgmentCourtLevelCode": if (dr.IsJudgmentCourtLevelCodeNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentJudgmentCourtLevelCode); } else if (!myA.CheckDomain(dr.JudgmentCourtLevelCode, myA.FM.Codes("JudgmentCourtLevel"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Judgment Court Level"); } break; case "OfficeID": if (dr.IsOfficeIDNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentOfficeID); } else if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("officelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Office List"); } break; case "StatementofClaimIssuedDate": if (dr.IsStatementofClaimIssuedDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate); } myA.IsValidDate(atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate, dr.StatementofClaimIssuedDate, false, DebtorBE.CSLBegin, DateTime.Today, atriumBE.Properties.Resources.ValidationCSLBegin, atriumBE.Properties.Resources.ValidationToday); break; case "StatementofClaimServedDate": if (dr.IsStatementofClaimServedDateNull() & !dr.IsDefenceDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentStatementofClaimServedDate); } if (!dr.IsStatementofClaimServedDateNull()) { if (dr.IsStatementofClaimIssuedDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.JudgmentStatementofClaimServedDate, atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate); } this.myA.IsValidDate(atriumBE.Properties.Resources.JudgmentStatementofClaimServedDate, dr.StatementofClaimServedDate, true, dr.StatementofClaimIssuedDate, DateTime.Today, atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate, atriumBE.Properties.Resources.ValidationToday); } break; case "DefenceDate": //2017-09-20 commented out ... otherwise we're saying: once you've provided value, you can't remove it. odd rule. //if (dr.IsDefenceDateNull()) // throw new RequiredException(atriumBE.Properties.Resources.JudgmentDefenceDate); if (dr.IsStatementofClaimServedDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.JudgmentDefenceDate, atriumBE.Properties.Resources.JudgmentStatementofClaimServedDate); } if (!dr.IsDefenceDateNull()) { myA.IsValidDate(atriumBE.Properties.Resources.JudgmentDefenceDate, dr.DefenceDate, true, dr.StatementofClaimServedDate, DateTime.Today, atriumBE.Properties.Resources.JudgmentStatementofClaimServedDate, atriumBE.Properties.Resources.ValidationToday); } break; case "ClaimAgainstCrown": if (dr.IsClaimAgainstCrownNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentClaimAgainstCrown); } if (dr.IsStatementofClaimIssuedDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.JudgmentClaimAgainstCrown, atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate); } myA.IsValidDate(atriumBE.Properties.Resources.JudgmentClaimAgainstCrown, dr.ClaimAgainstCrown, true, dr.StatementofClaimIssuedDate, DateTime.Today, atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate, atriumBE.Properties.Resources.ValidationToday); break; case "JudgmentDate": if (dr.IsJudgmentDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentJudgmentDate); } if (!dr.IsStatementofClaimIssuedDateNull()) { myA.IsValidDate(atriumBE.Properties.Resources.JudgmentJudgmentDate, dr.JudgmentDate, true, dr.StatementofClaimIssuedDate, DateTime.Today, atriumBE.Properties.Resources.JudgmentStatementofClaimIssuedDate, atriumBE.Properties.Resources.ValidationToday); } else { myA.IsValidDate(atriumBE.Properties.Resources.JudgmentJudgmentDate, dr.JudgmentDate, true, DebtorBE.CSLBegin, DateTime.Today, atriumBE.Properties.Resources.ValidationCSLBegin, atriumBE.Properties.Resources.ValidationToday); } break; case "JudgmentLPDate": if (dr.IsJudgmentLPDateNull()) { throw new RequiredException(atriumBE.Properties.Resources.JudgmentJudgmentLPDate); } if (dr.IsJudgmentDateNull()) { throw new RelatedException(atriumBE.Properties.Resources.JudgmentJudgmentLPDate, atriumBE.Properties.Resources.JudgmentJudgmentDate); } this.myA.IsValidDate(atriumBE.Properties.Resources.JudgmentJudgmentLPDate, dr.JudgmentLPDate, true, dr.JudgmentDate, DateTime.Today.AddYears(30), atriumBE.Properties.Resources.JudgmentJudgmentDate, atriumBE.Properties.Resources.ValidationThirtyYearsLater); break; case "JudgmentTypeCode": if (!myA.CheckDomain(dr.JudgmentTypeCode, myA.FM.Codes("JudgmentType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Judgment Type"); } break; case "ProcessTypeCode": if (!myA.CheckDomain(dr.ProcessTypeCode, myA.FM.Codes("ProcessType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Legal Process Type"); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myCBDetailDT.TableName; CLAS.CBDetailRow dr = (CLAS.CBDetailRow)ddr; switch (dc.ColumnName) { case "ValuableAmount": if (dr.IsValuableAmountNull()) { throw new RequiredException(Resources.CBDetailValuableAmount); } if (dr.ValuableAmount < 0) { throw new AtriumException(Resources.MustBeGreaterThanZero, Resources.CBDetailValuableAmount); } break; case "ValuableType": if (dr.IsValuableTypeNull()) { throw new RequiredException(Resources.CBDetailValuableType); } else if (!myA.CheckDomain(dr.ValuableType, myA.FM.Codes("CBInstrumentType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Instrument Type"); } break; case "OfficeID": if (dr.IsOfficeIDNull()) { throw new RequiredException(Resources.CBDetailOfficeID); } else if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("OfficeList"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Office List"); } break; case "CurrencyCode": if (dr.IsCurrencyCodeNull()) { throw new RequiredException(Resources.CBDetailCurrencyCode); } else if (!myA.CheckDomain(dr.CurrencyCode, myA.FM.Codes("currencycode"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Currency Code"); } break; case "StatusCode": if (dr.IsStatusCodeNull()) { throw new RequiredException(Resources.CBDetailStatusCode); } else if (!myA.CheckDomain(dr.StatusCode, myA.FM.Codes("CBStatus"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Payment Status Code"); } break; case "PaymentSource": if (dr.IsPaymentSourceNull()) { throw new RequiredException(Resources.CBDetailPaymentSource); } else if (!myA.CheckDomain(dr.PaymentSource, myA.FM.Codes("CBPaymentSource"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Payment Source Code"); } break; case "NatureOfPayment": if (dr.IsNatureOfPaymentNull()) { throw new RequiredException(Resources.CBDetailNatureOfPayment); } else if (!myA.CheckDomain(dr.NatureOfPayment, myA.FM.Codes("CBNatureOfPayment"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Nature of Payment Code"); } break; // case "NumberInSeries": // if (dr.IsNull(dc,DataRowVersion.Current)) // myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); // break; case "ValuableDate": if (dr.IsValuableDateNull()) { throw new RequiredException(Resources.CBDetailValuableDate); } myA.IsValidDate(Resources.CBDetailValuableDate, dr.ValuableDate, false, DateTime.Today.AddMonths(-6), DateTime.Today.AddYears(3), Resources.ValidationSixMonthsAgo, Resources.Validation3YearsLater); if (!dr.IsLastDayOfMonthNull() && dr.LastDayOfMonth && dr.ValuableDate.AddDays(1).Month == dr.ValuableDate.Month) { RaiseWarning(WarningLevel.Display, Resources.CBDetailValuableNotEOM); } break; case "ReceivedDate": if (dr.IsReceivedDateNull()) { throw new RequiredException(Resources.CBDetailReceivedDate); } myA.IsValidDate(Resources.CBDetailReceivedDate, dr.ReceivedDate, false, DateTime.Today.AddMonths(-6), DateTime.Today, Resources.ValidationSixMonthsAgo, Resources.ValidationToday); break; case "SIN": if (!dr.IsSINNull()) { if (dr.SIN.Length != 9) { throw new AtriumException(Resources.BadSIN, dr.SIN); } else if (!ContactBE.IsValidSIN(dr.SIN)) { throw new AtriumException(Resources.BadSIN, dr.SIN); } } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myJudgmentAccountDT.TableName; CLAS.JudgmentAccountRow dr = (CLAS.JudgmentAccountRow)ddr; switch (dc.ColumnName) { case "CostDate": if (dr.IsCostDateNull()) { throw new RequiredException(Resources.JudgmentAccountCostDate); } if (dr.JudgmentRow.IsJudgmentDateNull()) { throw new RelatedException(Resources.JudgmentAccountCostDate, Resources.JudgmentJudgmentDate); } myA.IsValidDate(Resources.JudgmentAccountCostDate, dr.CostDate, true, dr.JudgmentRow.JudgmentDate, DateTime.Today, Resources.JudgmentJudgmentDate, Resources.ValidationToday); break; case "CostAmount": if (!dr.IsCostAmountNull() && (dr.CostAmount < 0)) { throw new AtriumException(Resources.MustBeGreaterThanZero, Resources.JudgmentAccountCostAmount); } if (!dr.IsCostAmountNull() && dr.CostAmount > 40000) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.CostShouldNotBeGreaterThanX); } break; case "InterestIncluded": break; case "JudgmentAmount": if (dr.JudgmentAmount != dr.CostAmount + dr.PreJudgmentInterestAmount + dr.PrincipalAmountBeforeJudgment) { throw new AtriumException(Resources.JudgmentAccountInvalidJudgAmt); } if (!dr.IsJudgmentAmountNull() && (dr.JudgmentAmount < 0)) { throw new AtriumException(Resources.MustBeGreaterThanZero, Resources.JudgmentAccountJudgmentAmount); } if (!dr.IsJudgmentAmountNull() && (dr.JudgmentAmount > 100000)) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.JudgmentAmountShouldNotBeGreaterThanX); } break; case "PostJudgmentInterestRate": if (dr.IsPostJudgmentInterestRateNull() || dr.PostJudgmentInterestRate > 60 || dr.PostJudgmentInterestRate < 0) { throw new AtriumException(Resources.InvalidInterestRate, Resources.JudgmentAccountPostJudgmentInterestRate); } break; case "PreJudgmentInterestRate": if (dr.IsPreJudgmentInterestRateNull() || dr.PreJudgmentInterestRate > 60 || dr.PreJudgmentInterestRate < 0) { throw new AtriumException(Resources.InvalidInterestRate, Resources.JudgmentAccountPreJudgmentInterestRate); } break; case "PostJudgmentRateType": if (!myA.CheckDomain(dr.PostJudgmentRateType, myA.FM.Codes("InterestRateType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Interest Rate Type"); } break; case "PreJudgmentInterestAmount": if (!dr.IsPreJudgmentInterestAmountNull() && (dr.PreJudgmentInterestAmount > 100000)) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.AmountNotGreaterThan, "Pre-Judgment Interest Amount", 100000); } break; case "PreJudgmentRateType": if (!myA.CheckDomain(dr.PreJudgmentRateType, myA.FM.Codes("InterestRateType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Interest Rate Type"); } break; case "PrincipalAmountBeforeJudgment": if (!dr.IsPrincipalAmountBeforeJudgmentNull() && (dr.PrincipalAmountBeforeJudgment > 100000)) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.AmountNotGreaterThan, "Principal Amount Before Judgment", 100000); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { string ObjectName = this.myFileHistoryDT.TableName; CLAS.FileHistoryRow dr = (CLAS.FileHistoryRow)ddr; switch (dc.ColumnName) { case "SentToOfficeDate": if (dr.IsSentToOfficeDateNull()) { throw new RequiredException(Resources.FileHistorySentToOfficeDate); } if (myA.FM.CurrentFile.IsOpenedDateNull()) { throw new RelatedException(Resources.FileHistorySentToOfficeDate, Resources.EFileOpenedDate); } myA.IsValidDate(Resources.FileHistorySentToOfficeDate, dr.SentToOfficeDate, false, myA.FM.CurrentFile.OpenedDate, DateTime.Today.AddDays(7), Resources.EFileOpenedDate, Resources.ValidationSevenDaysLater); //this should be moved to before update // ok, moved 2015-04-29 JLL to row.added condition //if (dr.IsReceivedByOfficeDateNull()) //{ // this.myA.FM.GetFileOffice().AddOfficeToFile(dr.OfficeId, false, true, false); //} break; case "ReceivedByOfficeDate": if (myA.FM.CurrentFile.LeadOfficeId != this.myA.AtMng.WorkingAsOfficer.OfficeId) { //and lead office is not online officeDB.OfficeRow or = this.myA.AtMng.OfficeMng.DB.Office.FindByOfficeId(myA.FM.CurrentFile.LeadOfficeId); if (or == null) { or = this.myA.AtMng.GetOffice(myA.FM.CurrentFile.LeadOfficeId).CurrentOffice; } if (or.IsOnLine && myA.FM.CurrentFile.StatusCode == "O") { throw new AtriumException(Resources.OnlyTheLeadOfficeCanReceiveTheFile); } } if (!dr.IsReceivedByOfficeDateNull()) { if (dr.IsSentToOfficeDateNull()) { throw new RelatedException(Resources.FileHistoryReceivedByOfficeDate, Resources.FileHistorySentToOfficeDate); } myA.IsValidDate(Resources.FileHistoryReceivedByOfficeDate, dr.ReceivedByOfficeDate, true, dr.SentToOfficeDate, DateTime.Today, Resources.FileHistorySentToOfficeDate, Resources.ValidationToday); } break; case "ReturnedByOfficeDate": if (!dr.IsReturnedByOfficeDateNull()) { if (dr.IsReceivedByOfficeDateNull()) { throw new RelatedException(Resources.FileHistoryReturnedByOfficeDate, Resources.FileHistoryReceivedByOfficeDate); } myA.IsValidDate(Resources.FileHistoryReturnedByOfficeDate, dr.ReturnedByOfficeDate, true, dr.ReceivedByOfficeDate, DateTime.Today, Resources.FileHistoryReceivedByOfficeDate, Resources.ValidationToday); } break; case "ReceivedFromOfficeDate": if (!dr.IsReceivedFromOfficeDateNull()) { if (dr.IsReturnedByOfficeDateNull()) { throw new RelatedException(Resources.FileHistoryReceivedFromOfficeDate, Resources.FileHistoryReturnedByOfficeDate); } myA.IsValidDate(Resources.FileHistoryReceivedFromOfficeDate, dr.ReceivedFromOfficeDate, true, dr.ReturnedByOfficeDate, DateTime.Today, Resources.FileHistoryReturnedByOfficeDate, Resources.ValidationToday); } break; case "OfficeId": if (dr.IsNull(dc)) { throw new RequiredException(Resources.FileHistoryOfficeId); } else if (!myA.CheckDomain(dr.OfficeId, myA.FM.Codes("OfficeList"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Office List"); } //don't allow officeid to be updated after it has been created if (dr.RowState != DataRowState.Added && !ddr[dc, DataRowVersion.Current].Equals(ddr[dc, DataRowVersion.Original])) { throw new AtriumException("The Office Code cannot be changed. Either return the file, or delete the File History record altogether (if applicable)"); } break; case "BillingCode": if (dr.IsBillingCodeNull()) { throw new RequiredException(Resources.FileHistoryBillingCode); } break; default: break; } }
protected override void BeforeChange(DataColumn dc, DataRow ddr) { base.BeforeChange(dc, ddr); string ObjectName = this.myDebtDT.TableName; CLAS.DebtRow dr = (CLAS.DebtRow)ddr; DataRow acctR; switch (dc.ColumnName) { case "AccountTypeId": if (!myA.CheckDomain(dr.AccountTypeId, myA.FM.Codes("vaccounttypelist"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dc.Table.TableName, "Account Type List"); } break; case "RateType": if (!myA.CheckDomain(dr.RateType, myA.FM.Codes("InterestRateType"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Interest Rate Type"); } break; case DebtFields.DARSOccurenceDate: if (dr.IsDARSOccurenceDateNull() & dr.AccountTypeCode == "CSL") { throw new RequiredException(Resources.DebtDARSOccuranceDate); } break; case "InvoiceNumber": if (dr.IsInvoiceNumberNull() & (dr.AccountTypeCode == "CPP" | dr.AccountTypeCode == "OAS")) { throw new RequiredException(Resources.DebtInvoiceNumber); } break; //case "SequenceBalance": // if (dr.IsSequenceBalanceNull() & dr.AccountTypeCode == "EI") // throw new RequiredException(Resources.DebtSequenceBalance); // break; case "StatementRequest": if (dr.MSOAOverDARS && dr.StatementRequest) { throw new AtriumException(Resources.MSOAOverDARS); } break; case "InterestRate": if (dr.IsInterestRateNull() || dr.InterestRate > 60 || dr.InterestRate < 0) { throw new AtriumException(Resources.InvalidInterestRate, Resources.DebtInterestRate); } break; case "PrincipalAmount": if (dr.IsPrincipalAmountNull()) { throw new RequiredException(Resources.DebtPrincipalAmount); } else if (dr.PrincipalAmount > 100000) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.AmountNotGreaterThan, "Principal amount", 100000); } break; case "InterestAmount": if (!dr.IsInterestAmountNull() && dr.InterestAmount > 100000) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.AmountNotGreaterThan, "Interest amount", 100000); } break; case "CurrentLiability": if (!dr.IsCurrentLiabilityNull() && dr.CurrentLiability > 100000) { RaiseWarning(WarningLevel.Interrupt, Properties.Resources.AmountNotGreaterThan, "Current liability", 100000); } break; case "LPCode": acctR = this.AccountTypeInfo(dr.AccountTypeId); if (dr.IsLPCodeNull() && (acctR["AccountTypeCode"].ToString() != "CPP" && acctR["AccountTypeCode"].ToString() != "OAS")) { throw new RequiredException(Resources.DebtLPCode); } else if (!myA.CheckDomain(dr.LPCode, myA.FM.Codes("LP"))) { throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Limitation Period Code"); } break; case "CurrentTo": if (dr.IsCurrentToNull()) { throw new RequiredException(Resources.DebtCurrentTo); } myA.IsValidDate(Resources.DebtCurrentTo, dr.CurrentTo, false, DebtorBE.CSLBegin, DateTime.Today, Resources.ValidationCSLBegin, Resources.ValidationToday); break; case "InterestFromDate": if (!dr.IsInterestFromDateNull()) { myA.IsValidDate(Resources.DebtInterestFromDate, dr.InterestFromDate, true, DebtorBE.CSLBegin, DateTime.Today, Resources.ValidationCSLBegin, Resources.ValidationToday); } //this.myA.RaiseError((int)AtriumEnum.AppErrorCodes.CannotBeBlank, myA.GetLabelLeft(ObjectName, dc.ColumnName)); break; case "LPDate": acctR = this.AccountTypeInfo(dr.AccountTypeId); if (dr.IsLPDateNull() && (acctR["AccountTypeCode"].ToString() != "CPP" && acctR["AccountTypeCode"].ToString() != "OAS")) { throw new RequiredException(Resources.DebtLPDate); } myA.IsValidDate(Resources.DebtLPDate, dr.LPDate, false, DebtorBE.CSLBegin, DateTime.Today, Resources.ValidationCSLBegin, Resources.ValidationToday); break; case "LPExpires": acctR = this.AccountTypeInfo(dr.AccountTypeId); if (dr.IsLPExpiresNull() && (acctR["AccountTypeCode"].ToString() != "CPP" && acctR["AccountTypeCode"].ToString() != "OAS")) { throw new RequiredException(Resources.DebtLPExpires); } if (!dr.IsLPDateNull()) { myA.IsValidDate(Resources.DebtLPExpires, dr.LPExpires, false, dr.LPDate, DateTime.Today.AddYears(20), Resources.DebtLPDate, Resources.Validation20YearsLater); } break; default: break; } }