private long AddBatchEntry(BatchControlConstant.BatchType batchType, string description, string batchParameters, SqlConnection conn) { if (logger.IsDebugEnabled) { logger.Debug(string.Format("AddBatchEntry( {0}, {1}, {2}, {3} )", batchType,description,batchParameters,conn)); } long batchControlLogId = 0; string batchParams = batchParameters; if (batchParameters.Length > 255) { batchParams = batchParameters.Substring(0, 254); } using (SqlCommand cmd = new SqlCommand(BatchControlConstant.ADD_BATCH_ENTRY, conn)) { cmd.Parameters.AddWithValue("@batchType", batchType); cmd.Parameters.AddWithValue("@batchStatus", BatchControlConstant.BatchStatus.InProgress); cmd.Parameters.AddWithValue("@batchParameters", batchParams != null ? (object)batchParams : System.DBNull.Value); cmd.Parameters.AddWithValue("@runDescription", description != null ? (object)description : System.DBNull.Value); batchControlLogId = (Int32)cmd.ExecuteScalar(); } if (logger.IsDebugEnabled) { logger.Debug(string.Format("AddBatchEntry({0}, {1}) => returns: {2}", batchType, batchParameters, batchControlLogId)); } return batchControlLogId; }
private void UpdateBatchStatus(long batchControlLogId, BatchControlConstant.BatchStatus batchStatus, BatchControlConstant.CompletionStatus? completionStatus, SqlConnection conn) { if (logger.IsDebugEnabled) { logger.Debug(string.Format("UpdateBatchStatus( {0}, {1}, {2} )", batchControlLogId, batchStatus, completionStatus)); } string sql; switch (batchStatus) { case BatchControlConstant.BatchStatus.InProgress: sql = BatchControlConstant.UPDATE_BATCH_STATUS_RUN_START; break; case BatchControlConstant.BatchStatus.Completed: sql = BatchControlConstant.UPDATE_BATCH_STATUS_RUN_END; break; default: sql = BatchControlConstant.UPDATE_BATCH_STATUS; break; } using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@batchControlLogId", batchControlLogId); cmd.Parameters.AddWithValue("@batchStatus", batchStatus); if (batchStatus == BatchControlConstant.BatchStatus.InProgress || batchStatus == BatchControlConstant.BatchStatus.Completed) { cmd.Parameters.AddWithValue("@runTime", DateTime.Now); } cmd.Parameters.AddWithValue("@completionStatus", completionStatus != null ? (object)completionStatus : DBNull.Value); cmd.ExecuteNonQuery(); } }
private long AddErrorLog(long batchControlLogId, BatchControlConstant.MessageLevel messageLevel, string message, string messageAlias, SqlConnection conn) { if (logger.IsDebugEnabled) { logger.Debug(string.Format("AddErrorLog({0}, {1}, {2}, {3})", batchControlLogId, messageLevel, message, messageAlias)); } long id = 0; message = message.Substring(0, Math.Min(255, message.Length)); using (SqlCommand cmd = new SqlCommand("AddErrorLog", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@batchControlLogId", batchControlLogId); cmd.Parameters.AddWithValue("@messageLevel", messageLevel); cmd.Parameters.AddWithValue("@message", message); cmd.Parameters.AddWithValue("@messageAlias", messageAlias); id = (Int32)cmd.ExecuteScalar(); } if (logger.IsDebugEnabled) { logger.Debug(string.Format("AddErrorLog({0}, {1}, {2}, {3}) => returns {4}", batchControlLogId, messageLevel, message, messageAlias, id)); } return id; }