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