public void InsertThenUpdate_ShouldReflectChanges()
        {
            // Arrange
            var dummyId = 7;
            var dbModel = new ReportLinesModel()
            {
                ReportId   = dummyId,
                OssIndexId = _OssIndexId,
            };

            // Act
            var newId = new ReportLinesRepository(AppState.ConnectionString)
                        .Insert(dbModel);

            dummyId = 8;
            var dbModel2 = new ReportLinesRepository(AppState.ConnectionString)
                           .Select(newId);

            dbModel2.ReportId = dummyId;

            new ReportLinesRepository(AppState.ConnectionString)
            .Update(dbModel2);
            var actualValue = new ReportLinesRepository(AppState.ConnectionString)
                              .Select(newId)
                              .ReportId;

            // Assert
            Assert.AreEqual(dummyId, actualValue);
        }
        public int Insert(ReportLinesModel obj)
        {
            var storedProc = "sp_insert_report_lines";
            var insertObj  = new
            {
                report_id    = obj.ReportId,
                oss_index_id = obj.OssIndexId
            };

            return(Insert(storedProc, insertObj));
        }
        public void Update(ReportLinesModel obj)
        {
            var storedProc = "sp_update_report_lines";
            var updateObj  = new
            {
                id           = obj.Id,
                report_id    = obj.ReportId,
                oss_index_id = obj.OssIndexId
            };

            Update(storedProc, updateObj);
        }
        public void InsertAndSelect_ShouldEqualInserted()
        {
            // Arrange
            var dbModel = new ReportLinesModel()
            {
                ReportId   = 7,
                OssIndexId = _OssIndexId,
            };
            var expectedValue = new ReportLinesRepository(AppState.ConnectionString)
                                .Insert(dbModel);

            // Act
            var actualValue = new ReportLinesRepository(AppState.ConnectionString)
                              .Select(expectedValue)
                              .Id;

            // Assert
            Assert.AreEqual(expectedValue, actualValue);
        }
        public void InsertAndDelete_ShouldNoLongerExistAfterDelete()
        {
            // Arrange
            var expectedValue = 0;
            var dbModel       = new ReportLinesModel()
            {
                ReportId   = 7,
                OssIndexId = _OssIndexId,
            };

            // Act
            var newId = new ReportLinesRepository(AppState.ConnectionString).Insert(dbModel);

            new ReportLinesRepository(AppState.ConnectionString).Delete(newId);
            var actualValue = new ReportLinesRepository(AppState.ConnectionString)
                              .Select(newId)
                              .Id;

            // Assert
            Assert.AreEqual(expectedValue, actualValue);
        }