public ApprovalStateChangedEmailData Get(int dataCollectionId)
{
var queryString = string.Format(ConstSql, dataCollectionId, (int)DataCollectionRelationshipType.Manager);
Log.Info("[URDMS] Created query string: " + queryString);
var data = new ApprovalStateChangedEmailData();
try
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
data.DataCollectionTitle = (string)reader["DataCollectionTitle"];
data.ProjectTitle = (string)reader["ProjectTite"];
data.Manager = (string) reader["FullName"];
data.ManagerId = (string) reader["UserId"];
}
command.Dispose();
}
Log.Info("[URDMS] Call to Get completed.");
return data;
}
catch (Exception ex)
{
Log.Error("[URDMS] Error retrieving project information. Exception: " + ex);
throw;
}
}
public ApprovalStateChangedEmailData Get(int dataCollectionId)
{
var queryString = string.Format(ConstSql, dataCollectionId, (int)DataCollectionRelationshipType.Manager);
Log.Info("[URDMS] Created query string: " + queryString);
var data = new ApprovalStateChangedEmailData();
try
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
data.DataCollectionTitle = (string)reader["DataCollectionTitle"];
data.ProjectTitle = (string)reader["ProjectTite"];
data.Manager = (string)reader["FullName"];
data.ManagerId = (string)reader["UserId"];
}
command.Dispose();
}
Log.Info("[URDMS] Call to Get completed.");
return(data);
}
catch (Exception ex)
{
Log.Error("[URDMS] Error retrieving project information. Exception: " + ex);
throw;
}
}