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