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