// update aaudit internal static int updateAaudit(AWF myAWF, string actionString, string eventId, int itemSequence, RBA_Variables variables) { asset myAsset = getAsset(myAWF, itemSequence, variables); switch (getProductType(myAWF, itemSequence, variables)) { case productType.Static: AWF_DB_Log.insertAauditRecordInDb(myAsset.Id, eventId, string.Format("{0}: {1} | Job Number: {2}", actionString, myAWF.Products.Item[itemSequence].ItemCode, myAWF.JobNumber.ToString())); break; case productType.Variable: AWF_DB_Log.insertAauditRecordInDb(myAsset.Id, eventId, string.Format("{0}: {1}", actionString, myAsset.Name)); break; } string sql = "UPDATE asset " + "SET tlc=(SELECT DISTINCT tc " + "FROM aaudit WHERE id = :asset_id " + "AND seq = (SELECT DISTINCT MAX(seq) " + "FROM aaudit WHERE id = :asset_id ) LIMIT 1) " + (actionString.Contains("DESTROY/CANCEL") ? ", status = 3" : String.Empty) + "WHERE id = :asset_id; "; string[] parameterNames = { "asset_id" }; string[] parameterVals = { myAsset.Id }; return(AWFPostgresDataLayer.ExecuteNonQuery(sql, parameterNames, parameterVals)); }
// updateItemRecordInDb for variable item only!!! AWFAWFBD static class contains combined method for static and variable static internal int updateItemRecordInDb(string assetId, string updateInfo, string eventId) { string sql = "UPDATE asset " + "SET tlc=(SELECT DISTINCT tc " + "FROM aaudit WHERE id = :asset_id " + "AND seq = (SELECT DISTINCT MAX(seq) " + "FROM aaudit WHERE id = :asset_id ) LIMIT 1) " + (updateInfo.Contains("DESTROY/CANCEL") ? ", status = 3" : String.Empty) + "WHERE id = :asset_id; "; string[] parameterNames = { "asset_id" }; string[] parameterVals = { assetId }; insertAauditRecordInDb(assetId, eventId, updateInfo); return(AWFPostgresDataLayer.ExecuteNonQuery(sql, parameterNames, parameterVals)); }