/// <summary>
/// Fill method for populating an entire collection of LoanFeaturesCollection
/// </summary>
public virtual void Fill(LoanFeaturesCollection loanFeaturesCollection)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(LoanFeatures.GetConnectionString());
try
{
using (cnn)
{
// open the connection
cnn.Open();
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectLoanFeaturesCollection");
// Send the collection and data to the object factory
CreateObjectsFromData(loanFeaturesCollection, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Deletes the object.
/// </summary>
public virtual void Delete(LoanFeatures deleteObject)
{
// create a new instance of the connection
SqlConnection cnn = new SqlConnection(LoanFeatures.GetConnectionString());
// create local variable array for the sql parameters
SqlParameterHash sqlparams = null;
try
{
// discover the parameters
sqlparams = SqlHelperParameterCache.GetSpParameterSet(LoanFeatures.GetConnectionString(), "gsp_DeleteLoanFeatures");
// Store the parameter for the LoanApplicationId attribute.
sqlparams["@loanApplicationId"].Value = deleteObject.LoanApplicationId;
using (cnn)
{
// open the connection
cnn.Open();
// Execute the stored proc to perform the delete on the instance.
SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_DeleteLoanFeatures", sqlparams);
// close the connection after usage
cnn.Close();
}
// nullify the connection var
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
// nullify the reference
deleteObject = null;
}
/// <summary>
/// Fill method for populating a collection by ServicingTransferStatusType
/// </summary>
public void FillByServicingTransferStatusType(LoanFeaturesCollection loanFeaturesCollection, System.Int16 id)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(LoanFeatures.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(LoanFeatures.GetConnectionString(), "gsp_SelectLoanFeaturesCollectionByServicingTransferStatusType");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@servicingTransferStatusType"].Value = id;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectLoanFeaturesCollectionByServicingTransferStatusType", sqlparams);
// Send the collection and data to the object factory.
CreateObjectsFromData(loanFeaturesCollection, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Fills a single instance with data based on its primary key values.
/// </summary>
public virtual void Fill(LoanFeatures loanfeatures, System.Int64 loanApplicationId)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(LoanFeatures.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(LoanFeatures.GetConnectionString(), "gsp_SelectLoanFeatures");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@loanApplicationId"].Value = loanApplicationId;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectLoanFeatures", sqlparams);
if (datareader.Read())
{
loanfeatures.SetMembers(ref datareader);
}
cnn.Close(); // close the connection
}
// nullify the connection var
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Persists the object.
/// </summary>
public virtual void Persist(LoanFeatures persistObject, SqlTransaction sqlTrans)
{
// create local variable array for the sql parameters
SqlParameterHash sqlparams = null;
// Create a local variable for the connection
SqlConnection cnn = null;
// Use the parameter overload or create a new instance
if (sqlTrans == null)
{
cnn = new SqlConnection(LoanFeatures.GetConnectionString());
}
try
{
// discover the parameters
if (persistObject.Persisted)
{
sqlparams = SqlHelperParameterCache.GetSpParameterSet(LoanFeatures.GetConnectionString(), "gsp_UpdateLoanFeatures");
}
else
{
sqlparams = SqlHelperParameterCache.GetSpParameterSet(LoanFeatures.GetConnectionString(), "gsp_CreateLoanFeatures");
}
// Store the parameter for the AssumabilityIndicator attribute.
sqlparams["@assumabilityIndicator"].Value = persistObject.AssumabilityIndicator;
// Store the parameter for the BalloonIndicator attribute.
sqlparams["@balloonIndicator"].Value = persistObject.BalloonIndicator;
// Store the parameter for the BalloonLoanMaturityTermMonths attribute.
if (!persistObject.BalloonLoanMaturityTermMonthsIsNull)
{
sqlparams["@balloonLoanMaturityTermMonths"].Value = persistObject.BalloonLoanMaturityTermMonths;
}
// Store the parameter for the BuydownTemporarySubsidyIndicator attribute.
sqlparams["@buydownTemporarySubsidyIndicator"].Value = persistObject.BuydownTemporarySubsidyIndicator;
// Store the parameter for the CounselingConfirmationIndicator attribute.
sqlparams["@counselingConfirmationIndicator"].Value = persistObject.CounselingConfirmationIndicator;
// Store the parameter for the EscrowWaiverIndicator attribute.
sqlparams["@escrowWaiverIndicator"].Value = persistObject.EscrowWaiverIndicator;
// Store the parameter for the FREOfferingIdentifier attribute.
if (!persistObject.FREOfferingIdentifierIsNull)
{
sqlparams["@fREOfferingIdentifier"].Value = persistObject.FREOfferingIdentifier;
}
// Store the parameter for the FNMProductPlanIdentifier attribute.
if (!persistObject.FNMProductPlanIdentifierIsNull)
{
sqlparams["@fNMProductPlanIdentifier"].Value = persistObject.FNMProductPlanIdentifier;
}
// Store the parameter for the FNMProductPlanIndentifier attribute.
if (!persistObject.FNMProductPlanIndentifierIsNull)
{
sqlparams["@fNMProductPlanIndentifier"].Value = persistObject.FNMProductPlanIndentifier;
}
// Store the parameter for the HELOCMaximumBalanceAmount attribute.
if (!persistObject.HELOCMaximumBalanceAmountIsNull)
{
sqlparams["@hELOCMaximumBalanceAmount"].Value = persistObject.HELOCMaximumBalanceAmount;
}
// Store the parameter for the HELOCInitialAdvanceAmount attribute.
if (!persistObject.HELOCInitialAdvanceAmountIsNull)
{
sqlparams["@hELOCInitialAdvanceAmount"].Value = persistObject.HELOCInitialAdvanceAmount;
}
// Store the parameter for the InterestOnlyTerm attribute.
if (!persistObject.InterestOnlyTermIsNull)
{
sqlparams["@interestOnlyTerm"].Value = persistObject.InterestOnlyTerm;
}
// Store the parameter for the LenderSelfInsuredIndicator attribute.
sqlparams["@lenderSelfInsuredIndicator"].Value = persistObject.LenderSelfInsuredIndicator;
// Store the parameter for the LoanScheduledClosingDate attribute.
if (!persistObject.LoanScheduledClosingDateIsNull)
{
sqlparams["@loanScheduledClosingDate"].Value = persistObject.LoanScheduledClosingDate;
}
// Store the parameter for the MICoveragePercent attribute.
if (!persistObject.MICoveragePercentIsNull)
{
sqlparams["@mICoveragePercent"].Value = persistObject.MICoveragePercent;
}
// Store the parameter for the NegativeAmortizationLimitPercent attribute.
if (!persistObject.NegativeAmortizationLimitPercentIsNull)
{
sqlparams["@negativeAmortizationLimitPercent"].Value = persistObject.NegativeAmortizationLimitPercent;
}
// Store the parameter for the PrepaymentPenaltyIndicator attribute.
sqlparams["@prepaymentPenaltyIndicator"].Value = persistObject.PrepaymentPenaltyIndicator;
// Store the parameter for the PrepaymentPenaltyTermMonths attribute.
if (!persistObject.PrepaymentPenaltyTermMonthsIsNull)
{
sqlparams["@prepaymentPenaltyTermMonths"].Value = persistObject.PrepaymentPenaltyTermMonths;
}
// Store the parameter for the PrepaymentRestrictionIndicator attribute.
sqlparams["@prepaymentRestrictionIndicator"].Value = persistObject.PrepaymentRestrictionIndicator;
// Store the parameter for the ProductDescription attribute.
if (!persistObject.ProductDescriptionIsNull)
{
sqlparams["@productDescription"].Value = persistObject.ProductDescription;
}
// Store the parameter for the ProductName attribute.
if (!persistObject.ProductNameIsNull)
{
sqlparams["@productName"].Value = persistObject.ProductName;
}
// Store the parameter for the ScheduledFirstPaymentDate attribute.
if (!persistObject.ScheduledFirstPaymentDateIsNull)
{
sqlparams["@scheduledFirstPaymentDate"].Value = persistObject.ScheduledFirstPaymentDate;
}
// Store the parameter for the NameDocumentsDrawnInType attribute.
if (!persistObject.NameDocumentsDrawnInTypeIsNull)
{
sqlparams["@nameDocumentsDrawnInType"].Value = persistObject.NameDocumentsDrawnInType;
}
// Store the parameter for the GSEProjectClassificationType attribute.
if (!persistObject.GSEProjectClassificationTypeIsNull)
{
sqlparams["@gSEProjectClassificationType"].Value = persistObject.GSEProjectClassificationType;
}
// Store the parameter for the GSEPropertyType attribute.
if (!persistObject.GSEPropertyTypeIsNull)
{
sqlparams["@gSEPropertyType"].Value = persistObject.GSEPropertyType;
}
// Store the parameter for the LienPriorityType attribute.
if (!persistObject.LienPriorityTypeIsNull)
{
sqlparams["@lienPriorityType"].Value = persistObject.LienPriorityType;
}
// Store the parameter for the LoanDocumentationType attribute.
if (!persistObject.LoanDocumentationTypeIsNull)
{
sqlparams["@loanDocumentationType"].Value = persistObject.LoanDocumentationType;
}
// Store the parameter for the LoanRepaymentType attribute.
if (!persistObject.LoanRepaymentTypeIsNull)
{
sqlparams["@loanRepaymentType"].Value = persistObject.LoanRepaymentType;
}
// Store the parameter for the MICertificationStatusType attribute.
if (!persistObject.MICertificationStatusTypeIsNull)
{
sqlparams["@mICertificationStatusType"].Value = persistObject.MICertificationStatusType;
}
// Store the parameter for the MICompanyNameType attribute.
if (!persistObject.MICompanyNameTypeIsNull)
{
sqlparams["@mICompanyNameType"].Value = persistObject.MICompanyNameType;
}
// Store the parameter for the PaymentFrequencyType attribute.
if (!persistObject.PaymentFrequencyTypeIsNull)
{
sqlparams["@paymentFrequencyType"].Value = persistObject.PaymentFrequencyType;
}
// Store the parameter for the FullPrepaymentPenaltyOptionType attribute.
if (!persistObject.FullPrepaymentPenaltyOptionTypeIsNull)
{
sqlparams["@fullPrepaymentPenaltyOptionType"].Value = persistObject.FullPrepaymentPenaltyOptionType;
}
// Store the parameter for the LoanClosingStatusType attribute.
if (!persistObject.LoanClosingStatusTypeIsNull)
{
sqlparams["@loanClosingStatusType"].Value = persistObject.LoanClosingStatusType;
}
// Store the parameter for the ServicingTransferStatusType attribute.
if (!persistObject.ServicingTransferStatusTypeIsNull)
{
sqlparams["@servicingTransferStatusType"].Value = persistObject.ServicingTransferStatusType;
}
// Store the parameter for the LoanApplicationId attribute.
sqlparams["@loanApplicationId"].Value = persistObject.LoanApplicationId;
if (!persistObject.Persisted)
{
// store the create only (historical fixed) values
}
else
{
// store the update only (historical changeable) values
}
if (sqlTrans == null)
{
// Process using the isolated connection
using (cnn)
{
// open the connection
cnn.Open();
if (!persistObject.Persisted)
{
SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_CreateLoanFeatures", sqlparams);
}
else
{
SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_UpdateLoanFeatures", sqlparams);
}
// close the connection after usage
cnn.Close();
}
// nullify the connection var
cnn = null;
}
else
{
// Process using the shared transaction
if (!persistObject.Persisted)
{
SqlHelper.ExecuteNonQuery(sqlTrans, CommandType.StoredProcedure, "gsp_CreateLoanFeatures", sqlparams);
}
else
{
SqlHelper.ExecuteNonQuery(sqlTrans, CommandType.StoredProcedure, "gsp_UpdateLoanFeatures", sqlparams);
}
}
}
catch (SqlException sqlex)
{
throw sqlex;
}
}