public void AddReleaseNote(ReleaseNoteDTO dto)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
var sqlCommand = new SqlCommand
{
Connection = sqlConnection,
CommandText = @"INSERT INTO ReleaseNotes
(ProgramId, Major, Minor, Build, Revision, Notes, Date)
VALUES
(@ProgramId, @Major, @Minor, @Build, @Revision, @Notes, GETDATE())"
};
sqlCommand.Parameters.AddWithValue("@ProgramId", dto.ProgramId);
sqlCommand.Parameters.AddWithValue("@Major", dto.Major);
sqlCommand.Parameters.AddWithValue("@Minor", dto.Minor);
sqlCommand.Parameters.AddWithValue("@Build", dto.Build);
sqlCommand.Parameters.AddWithValue("@Revision", dto.Revision);
sqlCommand.Parameters.AddWithValue("@Notes", dto.Notes);
UsageLogger.LogThis(sqlCommand);
sqlCommand.ExecuteNonQuery();
}
}
public List<ReleaseNoteDTO> GetReleaseNotes()
{
var noteList = new List<ReleaseNoteDTO>();
using (var sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
var sqlCommand = new SqlCommand
{
Connection = sqlConnection,
CommandText = @"SELECT r.ProgramId, p.ProgramName, Major, Minor, Build, Revision, r.Notes, [Date]
FROM ReleaseNotes r
JOIN Programs p
ON r.ProgramId = p.ProgramId
ORDER BY [Date] DESC"
};
var reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
var dto = new ReleaseNoteDTO()
{
ProgramId = reader["ProgramId"] != DBNull.Value ? Convert.ToInt32(reader["ProgramId"]) : 0,
ProgramName = reader["ProgramName"].ToString(),
Major = reader["Major"] != DBNull.Value ? Convert.ToInt32(reader["Major"]) : 0,
Minor = reader["Minor"] != DBNull.Value ? Convert.ToInt32(reader["Minor"]) : 0,
Build = reader["Build"] != DBNull.Value ? Convert.ToInt32(reader["Build"]) : 0,
Revision = reader["Revision"] != DBNull.Value ? Convert.ToInt32(reader["Revision"]) : 0,
Notes = reader["Notes"].ToString(),
Date = reader["Date"] != DBNull.Value ? Convert.ToDateTime(reader["Date"]) : DateTime.MinValue
};
noteList.Add(dto);
}
}
return noteList;
}
private void InitializeReleaseNote()
{
ReleaseNote = new ReleaseNoteDTO()
{
Major = 0,
Minor = 0,
Build = 0,
Revision = 0
};
ReleaseNoteId = ProgramList.OrderBy(d => d.Value).FirstOrDefault();
}
