protected override void BeforeChange(DataColumn dc, DataRow ddr)
{
CLAS.CashBlotterRow dr = (CLAS.CashBlotterRow)ddr;
switch (dc.ColumnName)
{
case "FirstConfirm":
if (!myA.CheckDomain(dr.FirstConfirm, myA.FM.Codes("OfficerList")))
{
throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Officer List");
}
break;
case "SecondConfirm":
if (!myA.CheckDomain(dr.SecondConfirm, myA.FM.Codes("OfficerList")))
{
throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Officer List");
}
break;
case "OfficeID":
if (!myA.CheckDomain(dr.OfficeID, myA.FM.Codes("OfficeList")))
{
throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Office List");
}
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)
{
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)
{
CLAS.CostRow dr = (CLAS.CostRow)ddr;
switch (dc.ColumnName)
{
case CostFields.CostAmount:
if (dr.IsCostAmountNull() || dr.CostAmount <= 0)
{
throw new AtriumException(Resources.MustBeGreaterThanZero, Resources.CostCostAmount);
}
break;
case CostFields.RateType:
if (dr.IsNull(dc))
{
throw new RequiredException(Resources.ResourceManager.GetString("Cost" + dc.ColumnName));
}
else 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 CostFields.InterestRate:
case CostFields.CostDate:
if (dr.IsNull(dc))
{
throw new RequiredException(Resources.ResourceManager.GetString("Cost" + dc.ColumnName));
}
break;
case CostFields.PostJudgmentActivityCode:
if (dr.IsNull(dc))
{
throw new RequiredException(Resources.ResourceManager.GetString("Cost" + dc.ColumnName));
}
else if (!myA.CheckDomain(dr.PostJudgmentActivityCode, myA.FM.Codes("PostJudgmentActivity")))
{
throw new AtriumException(atriumBE.Properties.Resources.BadDomainValue, dc.ColumnName, dr.Table.TableName, "Post Judgment Activity Type");
}
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;
}
}
