/// <summary>
/// Takes the specified budgetSourceCategory.
/// </summary>
/// <param name="estimateDetailStatementFixedAsset">The estimate detail statement part b.</param>
/// <returns></returns>
private static object[] Take(EstimateDetailStatementFixedAssetEntity estimateDetailStatementFixedAsset)
{
return(new object[]
{
"@EstimateDetailStatementFixedAssetID", estimateDetailStatementFixedAsset.EstimateDetailStatementFixedAssetId,
"@OrderNumber", estimateDetailStatementFixedAsset.OrderNumber,
"@PurchasedYear", estimateDetailStatementFixedAsset.PurchasedYear,
"@OrgPriceUSD", estimateDetailStatementFixedAsset.OrgPriceUsd,
"@PurchasedOrgPriceUSD", estimateDetailStatementFixedAsset.PurchasedOrgPriceUsd,
"@Department", estimateDetailStatementFixedAsset.Department,
"@ReplacementReason", estimateDetailStatementFixedAsset.ReplacementReason,
"@IsActive", estimateDetailStatementFixedAsset.IsActive
});
}
/// <summary>
/// Updates the estimate detail statement.
/// </summary>
/// <param name="EstimateDetailStatementFixedAsset">The estimate detail statement part b.</param>
/// <returns></returns>
public string UpdateEstimateDetailStatementFixedAsset(EstimateDetailStatementFixedAssetEntity EstimateDetailStatementFixedAsset)
{
const string sql = @"uspUpdate_EstimateDetailStatementFixedAsset";
return(Db.Update(sql, true, Take(EstimateDetailStatementFixedAsset)));
}
/// <summary>
/// Inserts the estimateDetailStatement.
/// </summary>
/// <param name="estimateDetailStatement">The estimateDetailStatement.</param>
/// <returns></returns>
public int InsertEstimateDetailStatementFixedAsset(EstimateDetailStatementFixedAssetEntity estimateDetailStatement)
{
const string sql = @"uspInsert_EstimateDetailStatementFixedAsset";
return(Db.Insert(sql, true, Take(estimateDetailStatement)));
}