/// <summary> /// Insert a new record. /// </summary> /// <param name="oLog">Log class</param> /// <returns>True if it is successful, false if it is failure</returns> public bool Insert(LogEntity oLog) { try { using (SqlConnection oConnection = new SqlConnection(ConnectionString)) { oConnection.Open(); using (SqlCommand oCommand = new SqlCommand("upsInsertLog", oConnection)) { oCommand.CommandType = System.Data.CommandType.StoredProcedure; oCommand.Parameters.Clear(); oCommand.Parameters.Add("@LogMessage", SqlDbType.VarChar, 500).Value = oLog.LogMessage; oCommand.Parameters.Add("@LogType", SqlDbType.Char, 1).Value = oLog.LogType; oCommand.ExecuteNonQuery(); } } // Here we use "using" to make Dispose to the clases such as "SqlConnection" and "SqlCommand", // Also we use store procedure to avoid sql injection. return true; } catch (Exception) { return false; } }
private static void LogToDatabase(string message, Enums.MessageType messageType) { try { LogEntity oLog = new LogEntity() { LogMessage = message, LogType = ((int)messageType).ToString() }; var result = LogDomain.Instance.Insert(oLog); } catch (Exception ex) { throw new Exception(Constants.ErrorDB, ex); } }
public bool Insert(LogEntity oLog) { return repository.Insert(oLog); }