public void LoadProfileData_WhenCalled_FillsForm()
{
// Arrange
var dataRowValues = GetDataRowDictionary();
var shimDataRow = new ShimDataRow();
shimDataRow.ItemGetString = (colName) => { return(dataRowValues[colName]); };
var dataRows = new DataRow[1];
dataRows[0] = shimDataRow.Instance;
var shimDataRowCollection = new ShimDataRowCollection();
shimDataRowCollection.GetEnumerator = () => { return(dataRows.GetEnumerator()); };
var shimDataTable = new ShimDataTable();
shimDataTable.RowsGet = () => { return(shimDataRowCollection.Instance); };
ShimDataFunctions.GetDataTableString = (sqlQuery) => { return(shimDataTable.Instance); };
// Act
_emailProfileBasePrivateObject.Invoke(LoadProfileDataMethodName, EmailIdValue, EmailAddressValue, GroupIdValue);
// Assert
AssertPageControlValuesForLoadProfileData();
}
public void AddORRemoveForeignKey_AddOperationFalse_ExecutesCorrectly()
{
// Arrange
var expectedCommands = new List <string>
{
"BEGIN TRY " +
"WHILE EXISTS(select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where CONSTRAINT_NAME " +
"like 'FK_EPMLIVE_%' AND TABLE_NAME=@tableName) BEGIN DECLARE @cName nvarchar(Max) " +
"SELECT @cName = (SELECT TOP 1 [CONSTRAINT_NAME] FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE " +
"WHERE CONSTRAINT_NAME LIKE 'FK_EPMLIVE_%' AND TABLE_NAME=@tableName) " +
"DECLARE @sql nvarchar(Max) SELECT @sql = 'ALTER TABLE ' + @tableName + ' DROP CONSTRAINT ' + @cName " +
"EXEC sp_executesql @sql END END TRY BEGIN CATCH PRINT 'Error Detected' END CATCH",
"BEGIN TRY " +
"WHILE EXISTS(select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where CONSTRAINT_NAME like" +
" 'FK_EPMLIVE_%' AND TABLE_NAME=@tableName) BEGIN DECLARE @cName nvarchar(Max) " +
"SELECT @cName = (SELECT TOP 1 [CONSTRAINT_NAME] FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE " +
"WHERE CONSTRAINT_NAME LIKE 'FK_EPMLIVE_%' AND TABLE_NAME=@tableName) " +
"DECLARE @sql nvarchar(Max) SELECT @sql = 'ALTER TABLE ' + @tableName + ' DROP CONSTRAINT ' + @cName " +
"EXEC sp_executesql @sql END END TRY BEGIN CATCH PRINT 'Error Detected' END CATCH"
};
var executedCommands = new List <string>();
var dao = new ShimEPMData
{
ExecuteNonQuerySqlConnection = _ => true,
GetClientReportingConnectionGet = () => new SqlConnection(),
Dispose = () => { },
CommandSetString = command => executedCommands.Add(command)
};
ShimReportBiz.AllInstances.GetAllForeignKeysEPMData = (_, epmData) => new ShimDataTable
{
RowsGet = () => new ShimDataRowCollection
{
GetEnumerator = () => new List <DataRow>
{
new ShimDataRow
{
ItemGetString = name => DummyGuid
}
}.GetEnumerator()
}
};
var foreignKey = new ShimDataRow
{
ItemGetString = name => DummyString
};
// Act
var result = reportBiz.AddORRemoveForeignKey(dao, foreignKey, false);
// Assert
result.ShouldSatisfyAllConditions(
() => result.ShouldBeTrue(),
() => expectedCommands.All(p => executedCommands.Contains(p)).ShouldBeTrue());
}
public void AddORRemoveForeignKey_AddOperation_ExecutesCorrectly()
{
// Arrange
var expectedCommands = new List <string>
{
DummyString
};
var executedCommands = new List <string>();
var dao = new ShimEPMData
{
ExecuteNonQuerySqlConnection = _ => true,
GetClientReportingConnectionGet = () => new SqlConnection(),
Dispose = () => { },
CommandSetString = command => executedCommands.Add(command)
};
ShimReportBiz.AllInstances.GetAllForeignKeysEPMData = (_, epmData) => new ShimDataTable
{
RowsGet = () => new ShimDataRowCollection
{
GetEnumerator = () => new List <DataRow>
{
new ShimDataRow
{
ItemGetString = name => DummyGuid
}
}.GetEnumerator()
}
};
var foreignKey = new ShimDataRow
{
ItemGetString = name => DummyString
};
// Act
var result = reportBiz.AddORRemoveForeignKey(dao, foreignKey, true);
// Assert
result.ShouldSatisfyAllConditions(
() => result.ShouldBeTrue(),
() => expectedCommands.All(p => executedCommands.Contains(p)).ShouldBeTrue());
}
