public ContractDomain GetContractByQuoteId(int id)
{
ContractDomain singleContract = null;
try
{
DataProvider.ExecuteCmd(GetConnection, "dbo.Contract_GetByQuoteId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@quoteId", id);
},
map : delegate(IDataReader reader, short set)
{
singleContract = new ContractDomain();
int startingIndex = 0; //startingOrdinal
singleContract.ContractId = reader.GetSafeInt32(startingIndex++);
singleContract.ContractTerms = reader.GetSafeString(startingIndex++);
singleContract.QuoteRequestId = reader.GetSafeInt32(startingIndex++);
singleContract.QuoteId = reader.GetSafeInt32(startingIndex++);
singleContract.StateId = reader.GetSafeInt32(startingIndex++);
singleContract.CreateDate = reader.GetSafeDateTime(startingIndex++);
singleContract.URL = reader.GetSafeString(startingIndex++);
});
}
catch (Exception ex)
{
throw ex;
}
return(singleContract);
}
public ContractController()
{
_contractDomain = new ContractDomain();
}
