public void DataService_UpdateScopeType_Updates_Record_On_Valid_ScopeType()
{
//Arrange
int rowCount = DataUtil.GetRecordCount(DataTestHelper.ConnectionString,
ContentDataTestHelper.ScopeTypesTableName);
DataUtil.AddDatabaseObject(virtualScriptFilePath, upateScopeType);
ScopeType scopeType = ContentTestHelper.CreateValidScopeType();
scopeType.ScopeTypeId = Constants.SCOPETYPE_UpdateScopeTypeId;
scopeType.ScopeType = Constants.SCOPETYPE_UpdateScopeType;
DataService ds = new DataService();
//Act
ds.UpdateScopeType(scopeType);
//Assert
using (SqlConnection connection = new SqlConnection(DataTestHelper.ConnectionString))
{
connection.Open();
DatabaseAssert.RecordCountIsEqual(connection, ContentDataTestHelper.ScopeTypesTableName, rowCount);
//Check Values are updated
IDataReader dataReader = DataUtil.GetRecordsByField(connection,
ContentDataTestHelper.ScopeTypesTableName, keyField,
Constants.SCOPETYPE_UpdateScopeTypeId.ToString());
while (dataReader.Read())
{
DatabaseAssert.ReaderColumnIsEqual(dataReader, "ScopeType", Constants.SCOPETYPE_UpdateScopeType);
}
dataReader.Close();
}
}
