public RevisionHistoryDto FetchRevisionHistory(int id)
{
RevisionHistoryDto result = null;
using (var ctx = ConnectionManager<SqlConnection>.GetManager(Database.VeyronMeta, false))
{
var connection = ctx.Connection;
const string commandText = @"
SELECT
[Id]
,[Date]
,[ProcessId]
,[Body]
,[ModifiedBy]
FROM [dbo].[ProcessRevisionHistory]
WHERE [id] = @p_id;
";
using (var cmd = new SqlCommand(commandText, connection))
{
cmd.Parameters.AddWithValue("@p_id", id);
using (var reader = new SafeDataReader(cmd.ExecuteReader()))
{
if (reader.Read())
{
result = new RevisionHistoryDto
{
Id = id,
Date = reader.GetDateTime(1),
ProcessId = reader.GetInt32(2),
Body = reader.GetString(3),
ModifiedBy = reader.GetString(4)
};
}
}
}
}
return result;
}
public IEnumerable<RevisionHistoryDto> FetchRevisionHistoryList(int processId)
{
using (var ctx = ConnectionManager<SqlConnection>.GetManager(Database.VeyronMeta, false))
{
var connection = ctx.Connection;
const string commandText = @"
SELECT
[Id]
,[Date]
,[ProcessId]
,[ModifiedBy]
FROM [dbo].[ProcessRevisionHistory]
WHERE [ProcessId] = @processId
ORDER BY Date DESC
";
var result = new List<RevisionHistoryDto>();
using (var cmd = new SqlCommand(commandText, connection))
{
cmd.Parameters.AddWithValue("@processId", processId);
using (var reader = new SafeDataReader(cmd.ExecuteReader()))
{
while (reader.Read())
{
var revisionHistoryInfo = new RevisionHistoryDto
{
Id = reader.GetInt32(0),
Date = reader.GetDateTime(1),
ProcessId = reader.GetInt32(2),
ModifiedBy = reader.GetString(3)
};
result.Add(revisionHistoryInfo);
}
}
}
return result;
}
}
