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