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;
}
