public AudittingLogResponse InsertAudittingLog(AudittingLogEntity audittingLogEntity) { var response = new AudittingLogResponse { Acknowledge = AcknowledgeType.Success }; try { if (!audittingLogEntity.Validate()) { foreach (string error in audittingLogEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } audittingLogEntity.EventId = Guid.NewGuid().ToString(); response.Message = AudittingLogDao.InsertAudittingLog(audittingLogEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.EventId = audittingLogEntity.EventId; return(response); } catch (Exception ex) { response.Acknowledge = AcknowledgeType.Failure; response.Message = ex.Message; return(response); } }
/// <summary> /// Deletes the auditting log. /// </summary> /// <param name="audittingLog">The auditting log.</param> /// <returns></returns> public string DeleteAudittingLog(AudittingLogEntity audittingLog) { const string sql = @"uspDelete_AudittingLog"; object[] parms = { "@EventID", audittingLog.EventId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified auditting log. /// </summary> /// <param name="audittingLog">The auditting log.</param> /// <returns></returns> private static object[] Take(AudittingLogEntity audittingLog) { return(new object[] { "@ComponentName", audittingLog.ComponentName, "@EventAction", audittingLog.EventAction, "@Reference", audittingLog.Reference, "@Amount", audittingLog.Amount, "@LoginName", audittingLog.LoginName }); }
/// <summary> /// Inserts the auditting log. /// </summary> /// <param name="audittingLog">The auditting log.</param> /// <returns></returns> public int InsertAudittingLog(AudittingLogEntity audittingLog) { const string sql = @"uspAudittingLog"; return(Db.Insert(sql, true, Take(audittingLog))); }