/// <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))); }