// update Asset internal static int updateApprovedAsset(String itemCode) { string sql = "SELECT update_asset( :item_code )"; string[] parameterNames = { "item_code" }; string[] parameterVals = { itemCode }; return(AWFPostgresDataLayer.updateTransaction(sql, parameterNames, parameterVals)); }
static internal int insertAauditRecordInDb(string assetId, string eventId, string updateInfo) { string sql = "INSERT INTO aaudit " + "VALUES (:asset_id, coalesce((select max(seq)+1 " + "FROM aaudit where id = :asset_id),1), :event_id, :update_info); "; string[] parameterNames = { "asset_id", "event_id", ":update_info" }; string[] parameterVals = { assetId, eventId, updateInfo }; return(AWFPostgresDataLayer.updateTransaction(sql, parameterNames, parameterVals)); }