/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(ProposedHousingExpenses proposedhousingexpenses, System.Data.DataSet data)
{
// Do nothing if we have nothing
if (data == null || data.Tables.Count == 0 || data.Tables[0].Rows.Count == 0)
{
return;
}
// Create a local variable for the new instance.
ProposedHousingExpense newobj = null;
// Create a local variable for the data row instance.
System.Data.DataRow dr = null;
// Iterate through the table rows
for (int i = 0; i < data.Tables[0].Rows.Count; i++)
{
// Get a reference to the data row
dr = data.Tables[0].Rows[i];
// Create a new object instance
newobj = System.Activator.CreateInstance(proposedhousingexpenses.ContainsType[0]) as ProposedHousingExpense;
// Let the instance set its own members
newobj.SetMembers(ref dr);
// Add the new object to the collection instance
proposedhousingexpenses.Add(newobj);
}
}
/// <summary>
/// Fill method for populating an entire collection of ProposedHousingExpenses
/// </summary>
public virtual void Fill(ProposedHousingExpenses proposedHousingExpenses)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(ProposedHousingExpense.GetConnectionString());
try
{
using (cnn)
{
// open the connection
cnn.Open();
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectProposedHousingExpenses");
// Send the collection and data to the object factory
CreateObjectsFromData(proposedHousingExpenses, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Gets the objects for the PROPOSED_HOUSING_EXPENSE relationship.
/// </summary>
public ProposedHousingExpenses GetProposedHousingExpenses()
{
ProposedHousingExpenses proposedhousingexpenses = new ProposedHousingExpenses();
ProposedHousingExpenseBase.ServiceObject.FillByHousingExpenseType(proposedhousingexpenses, _id);
return(proposedhousingexpenses);
}
/// <summary>
/// Gets all the available objects.
/// </summary>
public virtual ProposedHousingExpenses GetAll()
{
// create a new instance of the return object
ProposedHousingExpenses objects = new ProposedHousingExpenses();
// fill the objects
this.Fill(objects);
// return the filled object from the service
return(objects);
}
/// <summary>
/// Fill method for populating a collection by LOAN_APPLICATION
/// </summary>
public void FillByLoanApplication(ProposedHousingExpenses proposedHousingExpenses, System.Int64 id)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(ProposedHousingExpense.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(ProposedHousingExpense.GetConnectionString(), "gsp_SelectProposedHousingExpensesByLoanApplication");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@loanApplicationId"].Value = id;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectProposedHousingExpensesByLoanApplication", sqlparams);
// Send the collection and data to the object factory.
CreateObjectsFromData(proposedHousingExpenses, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(ProposedHousingExpenses proposedhousingexpenses, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
ProposedHousingExpense newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(proposedhousingexpenses.ContainsType[0]) as ProposedHousingExpense;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
proposedhousingexpenses.Add(newobj);
}
}
/// <summary>
/// Creates a new instance of an existing (persisted) loan application.
/// </summary>
/// <param name="appId">The identity of the loan application.</param>
public LoanApplication(long appId)
: base(appId)
{
// TODO: add additional fill methods for the rest of the loan object
// load up the data information
MISMO.BusinessObjects.DataInformationCollection dats = this.GetDataInformationCollection();
if (dats != null && dats.Count > 0)
{
_datainformation = new DataInformation();
MISMO.Entities.DataInformationBase datbase = dats[0];
_datainformation.SetMembers(ref datbase);
}
// load up the additional case data.
MISMO.BusinessObjects.AdditionalCaseDataCollection addcasecol = this.GetAdditionalCaseDataCollection();
if (addcasecol != null && addcasecol.Count > 0)
{
MISMO.Entities.AdditionalCaseDataBase addcasebase = addcasecol[0] as MISMO.Entities.AdditionalCaseDataBase;
_additionalcasedata = new AdditionalCaseData();
_additionalcasedata.SetMembers(ref addcasebase);
}
// load up the down payment information
_downpayments = this.GetDownPayments();
// load up the interviewer information
MISMO.BusinessObjects.InterviewerInformationCollection intvcol = this.GetInterviewerInformationCollection();
if (intvcol != null && intvcol.Count > 0)
_interviewer = intvcol[0];
// load up the loan product data
MISMO.BusinessObjects.LoanProductDataCollection loanproducts = this.GetLoanProductDataCollection();
if (loanproducts != null && loanproducts.Count > 0)
{
MISMO.Entities.LoanProductDataBase lpbase = loanproducts[0];
_loanproductdata = new LoanProductData();
_loanproductdata.SetMembers(ref lpbase);
}
// load up the loan purpose
MISMO.BusinessObjects.LoanPurposes purps = this.GetLoanPurposes();
if (purps != null && purps.Count > 0)
{
MISMO.Entities.LoanPurposeBase purpbase = purps[0];
_purpose = new LoanPurpose();
_purpose.SetMembers(ref purpbase);
}
// load up the loan qualification information
MISMO.BusinessObjects.LoanQualifications lqcol = this.GetLoanQualifications();
if (lqcol != null && lqcol.Count > 0)
{
MISMO.Entities.LoanQualificationBase lqbase = lqcol[0] as MISMO.Entities.LoanQualificationBase;
_loanqualification.SetMembers(ref lqbase);
}
// load up the mortgage terms.
MISMO.BusinessObjects.MortgageTermsCollection mtgterms = this.GetMortgageTermsCollection();
if (mtgterms != null && mtgterms.Count > 0)
_mortgageterms = mtgterms[0];
// loan up the property information
MISMO.BusinessObjects.Properties props = this.GetProperties();
if (props != null && props.Count > 0)
{
_prop = new AUS.Property();
MISMO.Entities.PropertyBase propbase = props[0];
_prop.SetMembers(ref propbase);
}
// load up the proposed housing expenses
_proposedHousingExpenses = this.GetProposedHousingExpenses();
// load up the REO properties
_reoProperties = this.GetREOProperties();
// load up the title holder objects
_titleholders = this.GetTitleHolders();
// load up the transaction details
MISMO.BusinessObjects.TransactionDetails trandets = this.GetTransactionDetails();
if (trandets != null && trandets.Count > 0)
{
MISMO.Entities.TransactionDetailBase trandbase = trandets[0];
_transdetail = new AUS.TransactionDetail();
_transdetail.SetMembers(ref trandbase);
}
// load up the borrower information
MISMO.BusinessObjects.Borrowers bws = this.GetBorrowers();
MISMO.Entities.BorrowerBase bwsbase = null;
for(int i = 0, j = bws.Count; i<j; i++)
{
MISMO.BusinessObjects.AUS.Borrower ausbw = new Borrower();
bwsbase = bws[i] as MISMO.Entities.BorrowerBase;
ausbw.SetMembers(ref bwsbase);
_borrowers.Add(ausbw);
}
// finally update the checksum if this constructor wasn't called from a descendant.
if (this.GetType() == typeof(MISMO.BusinessObjects.AUS.LoanApplication))
{
RecalculateChecksum();
}
}
