/// <summary>
/// Fill method for populating an entire collection of VABorrowers
/// </summary>
public virtual void Fill(VABorrowers vABorrowers)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(VABorrower.GetConnectionString());
try
{
using (cnn)
{
// open the connection
cnn.Open();
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectVABorrowers");
// Send the collection and data to the object factory
CreateObjectsFromData(vABorrowers, 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(VABorrower deleteObject)
{
// create a new instance of the connection
SqlConnection cnn = new SqlConnection(VABorrower.GetConnectionString());
// create local variable array for the sql parameters
SqlParameterHash sqlparams = null;
try
{
// discover the parameters
sqlparams = SqlHelperParameterCache.GetSpParameterSet(VABorrower.GetConnectionString(), "gsp_DeleteVABorrower");
// Store the parameter for the BorrowerId attribute.
sqlparams["@borrowerId"].Value = deleteObject.BorrowerId;
using (cnn)
{
// open the connection
cnn.Open();
// Execute the stored proc to perform the delete on the instance.
SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_DeleteVABorrower", 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 BORROWER
/// </summary>
public void FillByBorrower(VABorrowers vABorrowers, System.Int64 id)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(VABorrower.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(VABorrower.GetConnectionString(), "gsp_SelectVABorrowersByBorrower");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@borrowerId"].Value = id;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectVABorrowersByBorrower", sqlparams);
// Send the collection and data to the object factory.
CreateObjectsFromData(vABorrowers, 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(VABorrower vaborrower, System.Int64 borrowerId)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(VABorrower.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(VABorrower.GetConnectionString(), "gsp_SelectVABorrower");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@borrowerId"].Value = borrowerId;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectVABorrower", sqlparams);
if (datareader.Read())
{
vaborrower.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(VABorrower 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(VABorrower.GetConnectionString());
}
try
{
// discover the parameters
if (persistObject.Persisted)
{
sqlparams = SqlHelperParameterCache.GetSpParameterSet(VABorrower.GetConnectionString(), "gsp_UpdateVABorrower");
}
else
{
sqlparams = SqlHelperParameterCache.GetSpParameterSet(VABorrower.GetConnectionString(), "gsp_CreateVABorrower");
}
// Store the parameter for the VACoBorrowerNonTaxableIncomeAmount attribute.
if (!persistObject.VACoBorrowerNonTaxableIncomeAmountIsNull)
{
sqlparams["@vACoBorrowerNonTaxableIncomeAmount"].Value = persistObject.VACoBorrowerNonTaxableIncomeAmount;
}
// Store the parameter for the VACoBorrowerTaxableIncomeAmount attribute.
if (!persistObject.VACoBorrowerTaxableIncomeAmountIsNull)
{
sqlparams["@vACoBorrowerTaxableIncomeAmount"].Value = persistObject.VACoBorrowerTaxableIncomeAmount;
}
// Store the parameter for the VAFederalTaxAmount attribute.
if (!persistObject.VAFederalTaxAmountIsNull)
{
sqlparams["@vAFederalTaxAmount"].Value = persistObject.VAFederalTaxAmount;
}
// Store the parameter for the VALocalTaxAmount attribute.
if (!persistObject.VALocalTaxAmountIsNull)
{
sqlparams["@vALocalTaxAmount"].Value = persistObject.VALocalTaxAmount;
}
// Store the parameter for the VAPrimaryBorrowerNonTaxableIncomeAmount attribute.
if (!persistObject.VAPrimaryBorrowerNonTaxableIncomeAmountIsNull)
{
sqlparams["@vAPrimaryBorrowerNonTaxableIncomeAmount"].Value = persistObject.VAPrimaryBorrowerNonTaxableIncomeAmount;
}
// Store the parameter for the VAPrimaryBorrowerTaxableIncomeAmount attribute.
if (!persistObject.VAPrimaryBorrowerTaxableIncomeAmountIsNull)
{
sqlparams["@vAPrimaryBorrowerTaxableIncomeAmount"].Value = persistObject.VAPrimaryBorrowerTaxableIncomeAmount;
}
// Store the parameter for the VASocialSecurityTaxAmount attribute.
if (!persistObject.VASocialSecurityTaxAmountIsNull)
{
sqlparams["@vASocialSecurityTaxAmount"].Value = persistObject.VASocialSecurityTaxAmount;
}
// Store the parameter for the VAStateTaxAmount attribute.
if (!persistObject.VAStateTaxAmountIsNull)
{
sqlparams["@vAStateTaxAmount"].Value = persistObject.VAStateTaxAmount;
}
// Store the parameter for the BorrowerId attribute.
sqlparams["@borrowerId"].Value = persistObject.BorrowerId;
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_CreateVABorrower", sqlparams);
}
else
{
SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_UpdateVABorrower", 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_CreateVABorrower", sqlparams);
}
else
{
SqlHelper.ExecuteNonQuery(sqlTrans, CommandType.StoredProcedure, "gsp_UpdateVABorrower", sqlparams);
}
}
}
catch (SqlException sqlex)
{
throw sqlex;
}
}