public static void LogAction(ActionTypes at, int ClaimID, int CallID, string AdditionalNotes) { user_action_log toInsert = new user_action_log(); toInsert.user_id = UserObject.id; toInsert.order_id = toInsert.GetNextOrderID(); toInsert.action_taken_time = DateTime.Now; toInsert.action_id = (int)at; toInsert.additional_notes = AdditionalNotes; if (ClaimID > 0) { toInsert.claim_id = ClaimID; } if (CallID > 0) { toInsert.call_id = CallID; } toInsert.Save(); }
/// <summary> /// Finds and returns the most recent View Claim action for a given claim id and user id /// </summary> /// <param name="claimID"></param> /// <param name="p"></param> /// <returns></returns> internal static user_action_log FindMostRecent(int claimID, int userID) { user_action_log toReturn = new user_action_log(); DataTable matches = toReturn.Search("SELECT TOP 1 * FROM user_action_log WHERE action_id = " + (int)C_DentalClaimTracker.ActiveUser.ActionTypes.ViewClaim + " AND user_id = " + userID + " AND claim_id = " + claimID + " ORDER BY order_id desc"); if (matches.Rows.Count > 0) { toReturn.Load(matches.Rows[0]); } else { toReturn.user_id = userID; toReturn.order_id = toReturn.GetNextOrderID(); toReturn.action_taken_time = DateTime.Now; toReturn.action_id = (int)C_DentalClaimTracker.ActiveUser.ActionTypes.ReviewClaim; toReturn.additional_notes = ""; toReturn.claim_id = claimID; } return(toReturn); }