public async Task <Guid[]> AddDeduction(Guid businessID, DeductionModel deductionModel)
{
try
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var deductionDetails = new Npgsql.NpgsqlParameter("@thedeductiondetails", NpgsqlDbType.Json)
{
Direction = ParameterDirection.InputOutput,
Value = deductionModel.DeductionDetails != null ? deductionModel.DeductionDetails : (object)DBNull.Value
};
DeductionAddingButEmployeeIDsNotPresent deductionAddingButEmployeeIDsNotPresent = await Task.Run(() => _projectContextDb.DeductionAddingButEmployeeIDsNotPresent.FromSqlRaw("select * from adddeduction(@thebusinessid,@thedeductiondetails)", businessId, deductionDetails)
.Select(e => new DeductionAddingButEmployeeIDsNotPresent()
{
NotFoundEmployeesIds = e.NotFoundEmployeesIds
}).FirstOrDefault());
if (deductionAddingButEmployeeIDsNotPresent.NotFoundEmployeesIds.Length == 0)
{
return(null);
}
return(deductionAddingButEmployeeIDsNotPresent.NotFoundEmployeesIds);
}
catch (Exception ex)
{
return(null);
}
}
public object ValidateDeductionData(DeductionModel deductionModel)
{
ResponseList = new List <object>();
foreach (DeductionDetails deductionDetails in deductionModel.DeductionDetails)
{
if (deductionDetails.Amount <= 0)
{
Success = "Failed";
ResponseList.Add(_deductionResponseMessages.InvalidAmount());
}
if (string.IsNullOrEmpty(deductionDetails.Description.Trim()))
{
Success = "Failed";
ResponseList.Add(_deductionResponseMessages.DescNotProvided());
}
else
{
if (deductionDetails.Description.Length > 100)
{
Success = "Failed";
ResponseList.Add(_deductionResponseMessages.DescExceedsLimit());
}
}
}
if (Success != null)
{
return(this);
}
return(null);
}
public async Task <IActionResult> Create(DeductionModel deduction)
{
if (ModelState.IsValid)
{
try
{
_context.Add(deduction);
await _context.SaveChangesAsync();
}
catch (Exception)
{
return(BadRequest(new { error = "There was an error creating this deduction" }));
}
}
return(Ok(deduction));
}
public void Create(DeductionModel model, out Guid deductionId)
{
var companyId = this.GetCurrentCompanyId();
if (this._repoDeduction.Query().Filter(x => x.code == model.code && x.companyId == companyId).Get().Any())
{
throw new Exception(model.code + " is already exists");
}
var userId = this.GetCurrentUserId();
var ins = this._repoDeduction.Insert(new mf_Deduction()
{
companyId = companyId,
code = model.code,
description = model.description,
updatedBy = userId,
});
this._unitOfWork.Save();
deductionId = ins.id;
}
public async Task <IActionResult> Edit(string id, DeductionModel deduction)
{
if (id != deduction.ID.ToString())
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(deduction);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
}
return(Ok(deduction));
}
public ActionResult DeductionCRUD([DataSourceRequest] DataSourceRequest request
, UpdateType updateType
, DeductionModel model)
{
if (model != null && ModelState.IsValid)
{
try
{
switch (updateType)
{
case UpdateType.Create:
Guid deductionId;
_deductionService.Create(model, out deductionId);
model.id = deductionId;
break;
case UpdateType.Update:
this._deductionService.Update(model);
break;
case UpdateType.Destroy:
this._deductionService.Delete(model.id.Value);
break;
default:
break;
}
}
catch (Exception ex)
{
this.AddModelError(ex);
}
}
if (model.id.HasValue && updateType != UpdateType.Destroy)
{
model = this._deductionService.GetById(model.id.Value);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public void Update(DeductionModel model)
{
var upt = this._repoDeduction.Find(model.id);
if (upt.code != model.code)
{
var companyId = this.GetCurrentCompanyId();
if (this._repoDeduction.Query().Filter(x => x.code == model.code && x.companyId == companyId).Get().Any())
{
throw new Exception(model.code + " is already exists");
}
upt.code = model.code;
}
var userId = this.GetCurrentUserId();
upt.description = model.description;
upt.updatedBy = userId;
upt.updatedDate = DateTime.Now;
this._repoDeduction.Update(upt);
this._unitOfWork.Save();
}
public async Task <object> AddDeduction(Guid businessID, [FromBody] DeductionModel deductionModel)
{
var checkBusinessId = await _commonLogic.CheckBusinessID(businessID);
if (checkBusinessId)
{
var errors = _deductionValidation.ValidateDeductionData(deductionModel);
if (errors != null)
{
return(errors);
}
var response = await _deductionLogic.AddDeduction(businessID, deductionModel);
if (response == null)
{
return(_deductionValidation.DeductionAddedSuccess());
}
return(_commonValidation.TheseEmployeesIdsNotFound(response));
}
return(_commonValidation.BusinessIdNotExists(businessID));
}
public Task <Guid[]> AddDeduction(Guid businessID, DeductionModel deductionModel)
{
return(_deductionDAL.AddDeduction(businessID, deductionModel));
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
UserModel user = new UserModel
{
_id = Guid.Parse("2F4CC25D-C51B-4297-85D7-2B540AFDDE50"),
FName = "Alice",
LName = "Wong",
Username = "******",
Email = "*****@*****.**",
HashedPassword = "******",
Salt = "1PMnOU",
IsAdmin = true
};
UserModel user2 = new UserModel
{
_id = Guid.Parse("b282699b-5f9e-475d-85f4-5ef375e6b596"),
FName = "Bob",
LName = "Robertson",
Username = "******",
Email = "*****@*****.**",
HashedPassword = "******",
Salt = "1PMnOU",
IsAdmin = false
};
var textNote = new
{
ID = Guid.Parse("36ae8212-14f7-4f8a-9314-71a5202e43e6"),
NoteText = @"This is some test note text.Lorem ipsum dolor sit amet, consectetur adipiscing elit,
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim vniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",
LastEditedBy_id = user._id,
LastEditedOn = DateTime.Parse("2020-10-13")
};
var textNote2 = new
{
ID = Guid.Parse("a18ccee1-05cd-4537-af28-fc79eb7984e4"),
NoteText = @"This is some test note text.Lorem ipsum dolor sit amet, consectetur adipiscing elit,
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim vniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",
LastEditedBy_id = user2._id,
LastEditedOn = DateTime.Parse("2020-10-13")
};
AddressModel address = new AddressModel
{
ID = Guid.Parse("4f375627-00fc-4d3c-8175-fc57c2b14e16"),
Address1 = "123 Easy Street",
Address2 = "",
City = "Sacramento",
State = "CA",
Zip = "95819"
};
AddressModel address2 = new AddressModel
{
ID = Guid.Parse("fcc822ac-55aa-4e12-9dfd-25616caae425"),
Address1 = "456 North-South-West Street",
Address2 = "Apt. 57",
City = "Sacramento",
State = "CA",
Zip = "95825"
};
AddressModel propertyAddr1 = new AddressModel
{
ID = Guid.Parse("8f6c9cf9-7af6-4ebb-a052-f4f97a1957df"),
Address1 = "1234 Street Lane",
Address2 = "",
City = "Sacramento",
State = "CA",
Zip = "95817"
};
AddressModel propertyAddr2 = new AddressModel
{
ID = Guid.Parse("3e32a6a4-7c5d-42b6-afd3-ac482d7352d2"),
Address1 = "8762 Willow Road",
Address2 = "",
City = "Sacramento",
State = "CA",
Zip = "95818"
};
AddressModel moneyBrokersPO = new AddressModel
{
ID = Guid.Parse("4bd597e4-aee4-4130-a4c3-4b312ed48775"),
Address1 = "P.O. Box 214507",
Address2 = "",
City = "Sacramento",
State = "CA",
Zip = "95821-0507"
};
var borrower = new
{
ID = Guid.Parse("608513C1-C9BC-458C-9ED8-641C442D2925"),
CompanyName = "Testing Corp",
DOB = DateTime.Parse("1990-10-10"),
Fname = "John",
Lname = "Smith",
SSN = "123-456-7890",
Title = "Sir",
CompanyIsBorrower = false,
AddressID = address.ID
};
var borrower2 = new
{
ID = Guid.Parse("f0860cdf-bed2-47c8-bfee-9f2b92ed81d0"),
CompanyName = "Really Cool Business Ltd.",
DOB = DateTime.Parse("1990-10-10"),
Fname = "Mallory",
Lname = "Johnson",
SSN = "098-765-4321",
Title = "Miss",
CompanyIsBorrower = false,
AddressID = address2.ID
};
var phone = new
{
PhoneID = Guid.Parse("D3D78C50-824C-400C-8FFF-26A002209C01"),
Phone = "916-555-5555",
BorrowerID = borrower.ID
};
var phone2 = new
{
PhoneID = Guid.Parse("1258259e-958a-40c0-ae7f-dc3a0485457d"),
Phone = "916-555-6789",
BorrowerID = borrower2.ID
};
PhoneModel moneyBrokersPhone = new PhoneModel
{
PhoneID = Guid.Parse("3cfb74a5-6894-4e0f-8819-270576c9750f"),
Phone = "916-481-9999"
};
TrusteeModel trustee = new TrusteeModel
{
ID = Guid.Parse("501BC54C-783D-40EF-8D1F-F93CC2C83D05"),
Fname = "Bob",
Lname = "Jones",
Mailto = "123 Easy Street, Sacramento CA, 95825",
};
TrusteeModel trustee2 = new TrusteeModel
{
ID = Guid.Parse("c928dfd5-328d-4463-bdc9-0b386523a499"),
Fname = "Miguel",
Lname = "Sanchez",
Mailto = "999 Main Lane, Sacramento CA, 95819",
};
NoteModel note1 = new NoteModel
{
ID = Guid.Parse("db7b4f4e-0949-463e-8032-fc8ab19e8e54"),
LateFee = true,
LateChargeDays = 10,
LateChargeMinimum = 5.00f,
LateChargePercentage = 10.000f,
ReturnCheckPercentage = 0.000f,
ReturnCheckMinFee = 25.00f,
ReturnCheckMaxFee = 25.00f,
PrepaymentPenalty = true,
SubjectToMinCharge = false,
MinCharge = 0.00f,
BankruptcyAdminFee = 0.00f,
RefundIfPaidOff = false,
Assumable = false,
NoIncomeDocumentation = true
};
NoteModel note2 = new NoteModel
{
ID = Guid.Parse("29b6eed3-a0d5-4968-af2d-42f7b5fdcefa"),
LateFee = true,
LateChargeDays = 20,
LateChargeMinimum = 10.00f,
LateChargePercentage = 20.000f,
ReturnCheckPercentage = 1.000f,
ReturnCheckMinFee = 25.00f,
ReturnCheckMaxFee = 25.00f,
PrepaymentPenalty = true,
SubjectToMinCharge = false,
MinCharge = 0.00f,
BankruptcyAdminFee = 0.00f,
RefundIfPaidOff = false,
Assumable = false,
NoIncomeDocumentation = true
};
AddtlServicingModel addtl1 = new AddtlServicingModel
{
ID = Guid.Parse("c4781f88-4562-4503-9916-b8bef6dac97d"),
ServicingAmount = 10.00f,
ServicingPercent = 0.000f,
ServicingPer = "Month",
ServicingPayable = "Month",
Assume100Investment = false,
LateChargeSplit = 0.000f,
PrepaySplit = 0.000f,
DifferentialOnly = false,
LPDInterestRate = 8.500f,
AdditionalProvisions = "",
BehalfOfAnother = true,
PrincipalAsBorrower = false,
FundingAPortion = false,
MoreThanOneExpl = "",
BExplanation = "",
BrokerNotAgentRelation = ""
};
AddtlServicingModel addtl2 = new AddtlServicingModel
{
ID = Guid.Parse("c1e3c0b2-3f16-46c9-a871-3df59e016ad8"),
ServicingAmount = 10.00f,
ServicingPercent = 0.000f,
ServicingPer = "Month",
ServicingPayable = "Month",
Assume100Investment = false,
LateChargeSplit = 0.000f,
PrepaySplit = 0.000f,
DifferentialOnly = false,
LPDInterestRate = 8.500f,
AdditionalProvisions = "",
BehalfOfAnother = true,
PrincipalAsBorrower = false,
FundingAPortion = false,
MoreThanOneExpl = "",
BExplanation = "",
BrokerNotAgentRelation = ""
};
var broker1 = new
{
ID = Guid.Parse("b5d245b6-3c1e-43fb-8c85-a2ee6fa4edf7"),
BrokerCompany = "The Money Brokers, Inc.",
BrokerAddressID = moneyBrokersPO.ID,
BrokerEmail = "*****@*****.**",
BrokerPhoneID = moneyBrokersPhone.PhoneID,
DRELicense = "00798745",
CFLLicense = "",
NMLSID = "307433",
BrokerFee = 0.00f,
AdditionalComp = false,
CompensationAmt = 0.00f,
BorrowerRepName = "",
BorrowerRepDRE = "",
BorrowerRepNMLS = "",
LenderRepName = "Melinda D. Wood",
LenderRepDRE = "01479727",
LenderRepNMLS = "",
ServicingAddressID = moneyBrokersPO.ID,
ServicingPhoneID = moneyBrokersPhone.PhoneID
};
var broker2 = new
{
ID = Guid.Parse("5a59bc28-69a3-442e-9793-162e67684db8"),
BrokerCompany = "The Money Brokers, Inc.",
BrokerAddressID = moneyBrokersPO.ID,
BrokerEmail = "*****@*****.**",
BrokerPhoneID = moneyBrokersPhone.PhoneID,
DRELicense = "00798745",
CFLLicense = "",
NMLSID = "307433",
BrokerFee = 0.00f,
AdditionalComp = false,
CompensationAmt = 0.00f,
BorrowerRepName = "",
BorrowerRepDRE = "",
BorrowerRepNMLS = "",
LenderRepName = "Melinda D. Wood",
LenderRepDRE = "01479727",
LenderRepNMLS = "",
ServicingAddressID = moneyBrokersPO.ID,
ServicingPhoneID = moneyBrokersPhone.PhoneID
};
DeductionModel brokerDeduction1 = new DeductionModel
{
ID = Guid.Parse("2404938d-f2fa-42fe-bdb1-00d5ed8557ab"),
Desc = "Notary Fee",
RESPA = 0,
Amount = 0.00f,
PPF = true,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Notary Fee"
};
DeductionModel brokerDeduction2 = new DeductionModel
{
ID = Guid.Parse("287c3762-87a1-468a-9bf8-c833b1464a22"),
Desc = "Processing Fee",
RESPA = 810,
Amount = 500.00f,
PPF = true,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Processing Fee"
};
DeductionModel otherDeduction1 = new DeductionModel
{
ID = Guid.Parse("ccb11145-5699-4f25-af55-04394e3b741b"),
Desc = "Appraisal Fee",
RESPA = 804,
Amount = 0.00f,
PPF = false,
EST = false,
POE = false,
NET = true,
SEC32 = false,
RE882M = "Appraisal Fee"
};
DeductionModel otherDeduction2 = new DeductionModel
{
ID = Guid.Parse("52637c14-6aed-4238-8769-cef7f70593c0"),
Desc = "Recording Fees",
RESPA = 1201,
Amount = 0.00f,
PPF = false,
EST = false,
POE = false,
NET = false,
SEC32 = false,
RE882M = "Recording Fees"
};
DeductionModel brokerPayment1 = new DeductionModel
{
ID = Guid.Parse("0a263bd6-568a-46ae-b9d5-d001b1fa4fd5"),
Desc = "Home Owner's Insurance Premiums",
RESPA = 903,
Amount = 0.00f,
PPF = false,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Hazard"
};
DeductionModel brokerPayment2 = new DeductionModel
{
ID = Guid.Parse("e4a79270-a964-4b8c-aaca-9624ab7ef479"),
Desc = "Credit Life or Disability Premiums",
RESPA = 0,
Amount = 0.00f,
PPF = false,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Credit Life or Disability Premiums"
};
DeductionModel otherPayment1 = new DeductionModel
{
ID = Guid.Parse("baa28c91-ff8f-4afe-b229-a88eae5188d8"),
Desc = "Tax Service Fee",
RESPA = 809,
Amount = 67.00f,
PPF = true,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Tax Service Fee"
};
DeductionModel otherPayment2 = new DeductionModel
{
ID = Guid.Parse("3f90740c-0af0-4c54-9d77-f7c003685f8e"),
Desc = "Broker Opinion of Value",
RESPA = 1306,
Amount = 500.00f,
PPF = true,
EST = false,
POE = false,
NET = false,
SEC32 = true,
RE882M = "Broker Opinion of Value"
};
var costExpense1 = new
{
ID = Guid.Parse("1a131472-6c0c-43c7-a5ca-73b4f35d16c8"),
BrokerDeductions1ID = brokerDeduction1.ID,
BrokerDeductions2ID = brokerDeduction2.ID,
OtherDeductions1ID = otherDeduction1.ID,
OtherDeductions2ID = otherDeduction2.ID,
BrokerPayments1ID = brokerPayment1.ID,
BrokerPayments2ID = brokerPayment2.ID,
OtherPayments1ID = otherPayment1.ID,
OtherPayments2ID = otherPayment2.ID
};
var costExpense2 = new
{
ID = Guid.Parse("b6582c6a-b9c9-4051-a4db-4d5e9878166d"),
BrokerDeductions1ID = brokerDeduction1.ID,
BrokerDeductions2ID = brokerDeduction2.ID,
OtherDeductions1ID = otherDeduction1.ID,
OtherDeductions2ID = otherDeduction2.ID,
BrokerPayments1ID = brokerPayment1.ID,
BrokerPayments2ID = brokerPayment2.ID,
OtherPayments1ID = otherPayment1.ID,
OtherPayments2ID = otherPayment2.ID
};
var property1 = new
{
ID = Guid.Parse("62c0b988-caa2-4920-a4a8-2e03017486be"),
Subject = false,
UnincorporatedArea = false,
APN = "000-1233-012-0000",
ConstructionType = "Wood Framed",
ConstructionDescription = "SFR 2/2/1",
LegalDescription = "Lot 129, as shown on the \"Plat of Vienna Woods\", recorded in the office of the County Recorder of Sacramento County of July 19, 1946, in Book 23 of Maps, Map No. 47",
FireInsurancePolicyAmt = 100000.00f,
AnnualInsurancePremiumAmt = 0.00f,
LossPayableClause = "The Money Brokers, Inc., a California corporation",
AddressID = propertyAddr1.ID,
FireInsuranceAddressID = moneyBrokersPO.ID,
};
var property2 = new
{
ID = Guid.Parse("1e948fd2-336e-4c5f-8b46-bdaf796828dc"),
Subject = false,
UnincorporatedArea = false,
APN = "000-1233-012-0000",
ConstructionType = "Wood Framed",
ConstructionDescription = "SFR 6/4/1",
LegalDescription = "Lot 49, as shown on the \"Plat of Vienna Woods\", recorded in the office of the County Recorder of Sacramento County of August 29, 1968, in Book 29 of Maps, Map No. 84",
FireInsurancePolicyAmt = 100000.00f,
AnnualInsurancePremiumAmt = 0.00f,
LossPayableClause = "The Money Brokers, Inc., a California corporation",
AddressID = propertyAddr2.ID,
FireInsuranceAddressID = moneyBrokersPO.ID,
};
EscrowModel escrow = new EscrowModel
{
ID = Guid.Parse("5d65e683-d292-4817-901f-837d7226cd3b"),
CompanyCode = "",
EscrowCompany = "Stewart Title of Sacramento",
Address = "3461 Fair Oaks Blvd., Ste 150",
City = "Sacramento",
State = "CA",
ZipCode = "95864",
Phone = "916-484-6500",
Fax = "946-482-9391",
EscrowNumber = "",
EscrowOfficer = "Kristene Morse",
PolicyType = "ALTA/CLTA",
PolicyAmount = 100000.00f,
PercentLoan = 100.00f,
SpecialEndorsements = "100 AND 116",
Exceptions = "",
ItemElimination = "",
};
var loan = new
{
ID = Guid.Parse("C0141D0D-1413-4633-9256-98A56E33C0E9"),
LoanNumber = "N1234MW",
IntRateLockDate = DateTime.Parse("2020-12-25"),
PrincipalAmt = 100000.00f,
IntRate = 9.000f,
IntRateLender = 8.5000f,
PaymentsPerPeriod = 12,
TotalPaymentsInPeriods = 12,
PaymentsCollectedInAdvance = 0,
PaymentAmortizationPeriod = 999,
RegPaymentAmt = 750.00f,
LoanPoints = 4.00f,
MaturityDate = DateTime.Parse("2021-12-25"),
TotalLoanFee = 4000.00f,
Stage = 1,
TextNotesID = textNote.ID,
CreatedBy_id = user._id,
CreatedOn = DateTime.Parse("2020-10-13"),
LastChangedOn = DateTime.Parse("2020-10-13"),
LastChangedBy_id = user._id,
BorrowerID = borrower.ID,
BrokerRefID = broker1.ID,
NoteRefID = note1.ID,
AddtlRefID = addtl1.ID,
CostRefID = costExpense1.ID,
EscrowID = escrow.ID,
PropertyID = property1.ID,
};
var loan2 = new
{
ID = Guid.Parse("2e029a23-520e-4555-a3c6-77360bfdd2f9"),
LoanNumber = "N5678TB",
IntRateLockDate = DateTime.Parse("2020-12-25"),
PrincipalAmt = 100000.00f,
IntRate = 9.000f,
IntRateLender = 8.5000f,
PaymentsPerPeriod = 12,
TotalPaymentsInPeriods = 12,
PaymentsCollectedInAdvance = 0,
PaymentAmortizationPeriod = 999,
RegPaymentAmt = 750.00f,
LoanPoints = 4.00f,
MaturityDate = DateTime.Parse("2021-12-25"),
TotalLoanFee = 4000.00f,
Stage = 1,
TextNotesID = textNote2.ID,
CreatedBy_id = user2._id,
CreatedOn = DateTime.Parse("2020-10-13"),
LastChangedOn = DateTime.Parse("2020-10-13"),
LastChangedBy_id = user2._id,
BorrowerID = borrower2.ID,
BrokerRefID = broker2.ID,
NoteRefID = note2.ID,
AddtlRefID = addtl2.ID,
CostRefID = costExpense2.ID,
EscrowID = escrow.ID,
PropertyID = property2.ID,
};
var loanTrustee = new
{
ID = Guid.Parse("D876AFCA-27D8-4BC6-9B48-5C46A2AE30FA"),
LoanID = loan.ID,
TrusteeID = trustee.ID
};
var loanTrustee2 = new
{
ID = Guid.Parse("6680e123-12dc-4815-b19f-c6f77afcc715"),
LoanID = loan2.ID,
TrusteeID = trustee2.ID
};
modelBuilder.Entity <UserModel>().HasData(new [] { user, user2 });
modelBuilder.Entity <LoanModel>().HasData(new [] { loan, loan2 });
modelBuilder.Entity <NotesModel>().HasData(new[] { textNote, textNote2 });
modelBuilder.Entity <PhoneModel>().HasData(new[] { phone, phone2 });
modelBuilder.Entity <AddressModel>().HasData(new[] { address, address2, moneyBrokersPO, propertyAddr1, propertyAddr2 });
modelBuilder.Entity <BorrowerModel>().HasData(new[] { borrower, borrower2 });
modelBuilder.Entity <TrusteeModel>().HasData(new[] { trustee, trustee2 });
modelBuilder.Entity <LoanTrusteeModel>().HasData(new[] { loanTrustee, loanTrustee2 });
modelBuilder.Entity <NoteModel>().HasData(new[] { note1, note2 });
modelBuilder.Entity <AddtlServicingModel>().HasData(new[] { addtl1, addtl2 });
modelBuilder.Entity <DeductionModel>().HasData(new[] { brokerDeduction1, brokerDeduction2, otherDeduction1, otherDeduction2, brokerPayment1, brokerPayment2, otherPayment1, otherPayment2 });
modelBuilder.Entity <CostExpenseModel>().HasData(new[] { costExpense1, costExpense2 });
modelBuilder.Entity <BrokerServicingModel>().HasData(new[] { broker1, broker2 });
modelBuilder.Entity <EscrowModel>().HasData(new[] { escrow });
modelBuilder.Entity <PropertyModel>().HasData(new[] { property1, property2 });
}
