/// <summary> /// Adds audit information to the data source using the new wrapper functionality. If the update fails /// an exception will be passed back to the calling routine /// </summary> /// <param name="passedUniqueID">The unique ID of the record</param> /// <param name="passedAction">The action taken on that record</param> /// <param name="connectionString">The string for connecting to the data source</param> public void AddToAudit(string passedUniqueID, string passedAction, string connectionString) { New_Wrapper.DataHandler MyHandler = new New_Wrapper.DataHandler(); DateTime dateT; string dateOf; dateT = DateTime.Parse(DateTime.Now.ToShortDateString()); dateOf = dateT.ToString("yyyyMMdd"); DateTime timeT; string timeOf; timeT = DateTime.Parse(DateTime.Now.ToShortTimeString()); timeOf = timeT.ToString("HH:mm:ss"); try { string tempId = Guid.NewGuid().ToString(); MyHandler.InsertData(connectionString, "INSERT INTO tblAudit (AuditID, AuditDate, AuditTime, PID, RequestID, AuditAction) VALUES ('" + tempId + "', '" + dateOf + "', '" + timeOf + "', '" + Environment.UserName.ToString() + "', '" + passedUniqueID + "', '" + passedAction + "')"); } catch (Exception ex) { throw new Exception("DMBT-GT01a - unable to store the audit information - " + ex.Message); } }