private static SqlCommand BuildEndApprovedAssetOffer_Read(int legalEntityId, string assetCode)
        {
            var paraLegalEntityId = new SqlParameter("LegalEntityId", legalEntityId);
            var paraAssetCode     = new SqlParameter("AssetCode", assetCode);

            return(AdoService.BuildSqlCommand(
                       "EndApprovedAssetOffer.Read",
                       paraLegalEntityId,
                       paraAssetCode
                       ));
        }
        private static SqlCommand BuildEndApprovedAssetOffer_Update(int legalEntityId, string assetCode, DateTime?endDate)
        {
            var paraEndDate = new SqlParameter("EndDate", SqlDbType.DateTime);

            paraEndDate.Value = (object)endDate ?? DBNull.Value;
            var paraAssetCode     = new SqlParameter("AssetCode", assetCode);
            var paraLegalEntityId = new SqlParameter("LegalEntityId", legalEntityId);

            return(AdoService.BuildSqlCommand(
                       "EndApprovedAssetOffer.Update",
                       paraEndDate,
                       paraAssetCode,
                       paraLegalEntityId
                       ));
        }