public void TestThatDeltagereGetAppointmentUsersWhenMapDataHasBeenCalledAndMapRelationsHasNotBeenCalled()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
MySqlDataReader dataReader = CreateMySqlDataReader(systemNo, calId, subject: _fixture.Create <string>());
ISystemProxy systemProxyMock = MockRepository.GenerateMock <ISystemProxy>();
systemProxyMock.Stub(m => m.Nummer)
.Return(systemNo)
.Repeat.Any();
IEnumerable <BrugeraftaleProxy> appointmentUserCollection = _fixture.CreateMany <BrugeraftaleProxy>(_random.Next(3, 7)).ToList();
IMySqlDataProvider dataProvider = CreateMySqlDataProvider(systemProxyMock, appointmentUserCollection);
sut.MapData(dataReader, dataProvider);
IEnumerable <IBrugeraftale> result = sut.Deltagere;
// ReSharper disable PossibleMultipleEnumeration
Assert.That(result, Is.Not.Null);
Assert.That(result, Is.Not.Empty);
Assert.That(result, Is.EqualTo(appointmentUserCollection));
// ReSharper restore PossibleMultipleEnumeration
IDbCommandTestExecutor commandTester = new DbCommandTestBuilder("SELECT cm.SystemNo,cm.CalId,cm.UserId,cm.Properties,ca.Date,ca.FromTime,ca.ToTime,ca.Properties AS AppointmentProperties,ca.Subject,ca.Note,cu.UserName,cu.Name AS UserFullname,cu.Initials AS UserInitials,s.Title AS SystemTitle,s.Properties AS SystemProperties FROM Calmerge AS cm INNER JOIN Calapps AS ca ON ca.SystemNo=cm.SystemNo AND ca.CalId=cm.CalId INNER JOIN Calusers AS cu ON cu.SystemNo=cm.SystemNo AND cu.UserId=cm.UserId INNER JOIN Systems AS s ON s.SystemNo=cm.SystemNo WHERE cm.SystemNo=@systemNo AND cm.CalId=@calId")
.AddSmallIntDataParameter("@systemNo", systemNo, 2)
.AddIntDataParameter("@calId", calId, 8)
.Build();
dataProvider.AssertWasCalled(m => m.GetCollection <BrugeraftaleProxy>(Arg <MySqlCommand> .Matches(cmd => commandTester.Run(cmd))), opt => opt.Repeat.Once());
}
public void TestAtCreateUpdateCommandReturnererSqlCommand(bool hasNote)
{
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
DateTime fromDateTime = DateTime.Today.AddDays(_random.Next(1, 30)).AddHours(_random.Next(8, 16)).AddMinutes(_random.Next(0, 3) * 15);
DateTime toDateTime = fromDateTime.AddMinutes(_random.Next(1, 3) * 15);
string subject = _fixture.Create <string>();
int properties = _fixture.Create <int>();
string note = hasNote ? _fixture.Create <string>() : null;
IAftaleProxy sut = CreateSut(systemNo, calId, fromDateTime, toDateTime, subject, properties, note);
Assert.That(sut, Is.Not.Null);
new DbCommandTestBuilder("UPDATE Calapps SET Date=@date,FromTime=@fromTime,ToTime=@toTime,Properties=@properties,Subject=@subject,Note=@note WHERE SystemNo=@systemNo AND CalId=@calId")
.AddSmallIntDataParameter("@systemNo", systemNo, 2)
.AddIntDataParameter("@calId", calId, 8)
.AddDateParameter("@date", fromDateTime)
.AddTimeParameter("@fromTime", fromDateTime)
.AddTimeParameter("@toTime", toDateTime)
.AddSmallIntDataParameter("@properties", properties, 3, true)
.AddVarCharDataParameter("@subject", subject, 255, true)
.AddTextDataParameter("@note", note, true)
.Build()
.Run(sut.CreateUpdateCommand());
}
public void TestThatMapRelationsMapsAppointmentUsers()
{
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
IAftaleProxy sut = CreateSut(systemNo, calId);
Assert.That(sut, Is.Not.Null);
IEnumerable <BrugeraftaleProxy> appointmentUserCollection = _fixture.CreateMany <BrugeraftaleProxy>(_random.Next(3, 7)).ToList();
IMySqlDataProvider dataProvider = CreateMySqlDataProvider(appointmentUserCollection: appointmentUserCollection);
sut.MapRelations(dataProvider);
Assert.That(sut.Deltagere, Is.Not.Null);
Assert.That(sut.Deltagere, Is.Not.Empty);
Assert.That(sut.Deltagere, Is.EqualTo(appointmentUserCollection));
IDbCommandTestExecutor commandTester = new DbCommandTestBuilder("SELECT cm.SystemNo,cm.CalId,cm.UserId,cm.Properties,ca.Date,ca.FromTime,ca.ToTime,ca.Properties AS AppointmentProperties,ca.Subject,ca.Note,cu.UserName,cu.Name AS UserFullname,cu.Initials AS UserInitials,s.Title AS SystemTitle,s.Properties AS SystemProperties FROM Calmerge AS cm INNER JOIN Calapps AS ca ON ca.SystemNo=cm.SystemNo AND ca.CalId=cm.CalId INNER JOIN Calusers AS cu ON cu.SystemNo=cm.SystemNo AND cu.UserId=cm.UserId INNER JOIN Systems AS s ON s.SystemNo=cm.SystemNo WHERE cm.SystemNo=@systemNo AND cm.CalId=@calId")
.AddSmallIntDataParameter("@systemNo", systemNo, 2)
.AddIntDataParameter("@calId", calId, 8)
.Build();
dataProvider.AssertWasCalled(m => m.GetCollection <BrugeraftaleProxy>(Arg <MySqlCommand> .Matches(cmd => commandTester.Run(cmd))), opt => opt.Repeat.Once());
}
public void TestThatCreateThrowsArgumentNullExceptionWhenDataProviderIsNull()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
ArgumentNullException result = Assert.Throws <ArgumentNullException>(() => sut.Create(CreateMySqlDataReader(), null, "SystemNo", "Title", "Properties"));
TestHelper.AssertArgumentNullExceptionIsValid(result, "dataProvider");
}
public void TestThatMapRelationsThrowArgumentNullExceptionWhenDataProviderIsNull()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
ArgumentNullException result = Assert.Throws <ArgumentNullException>(() => sut.MapRelations(null));
TestHelper.AssertArgumentNullExceptionIsValid(result, "dataProvider");
}
public void TestAtMapDataKasterArgumentNullExceptionHvisDataProviderErNull()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
ArgumentNullException result = Assert.Throws <ArgumentNullException>(() => sut.MapData(CreateMySqlDataReader(), null));
TestHelper.AssertArgumentNullExceptionIsValid(result, "dataProvider");
}
public void TestThatCreateThrowsArgumentNullExceptionWhenColumnNameCollectionIsNull()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
ArgumentNullException result = Assert.Throws <ArgumentNullException>(() => sut.Create(CreateMySqlDataReader(), CreateMySqlDataProvider(), null));
TestHelper.AssertArgumentNullExceptionIsValid(result, "columnNameCollection");
}
public void TestThatMapRelationsCallsCloneOnDataProvider()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
IMySqlDataProvider dataProvider = CreateMySqlDataProvider();
sut.MapRelations(dataProvider);
dataProvider.AssertWasCalled(m => m.Clone(), opt => opt.Repeat.Once());
}
public void TestAtUniqueIdReturnererIdentifikation()
{
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
IAftaleProxy sut = CreateSut(systemNo, calId);
Assert.That(sut, Is.Not.Null);
string uniqueId = sut.UniqueId;
Assert.That(uniqueId, Is.Not.Null);
Assert.That(uniqueId, Is.EqualTo($"{Convert.ToString(systemNo)}-{Convert.ToString(calId)}"));
}
/// <summary>
/// Gets the appointment users for a given appointment.
/// </summary>
/// <param name="appointment">The appointment for which to get the appointment users.</param>
/// <param name="dataProvider">The data provider which should be used to get the appointment users.</param>
/// <returns>The appointment users.</returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="appointment"/> or <paramref name="dataProvider"/>is null.</exception>
internal static IEnumerable <IBrugeraftaleProxy> GetAppointmentUsers(IAftaleProxy appointment, IDataProviderBase <MySqlDataReader, MySqlCommand> dataProvider)
{
ArgumentNullGuard.NotNull(appointment, nameof(appointment))
.NotNull(dataProvider, nameof(dataProvider));
using (IMySqlDataProvider subDataProvider = (IMySqlDataProvider)dataProvider.Clone())
{
MySqlCommand command = new CalenderCommandBuilder("SELECT cm.SystemNo,cm.CalId,cm.UserId,cm.Properties,ca.Date,ca.FromTime,ca.ToTime,ca.Properties AS AppointmentProperties,ca.Subject,ca.Note,cu.UserName,cu.Name AS UserFullname,cu.Initials AS UserInitials,s.Title AS SystemTitle,s.Properties AS SystemProperties FROM Calmerge AS cm INNER JOIN Calapps AS ca ON ca.SystemNo=cm.SystemNo AND ca.CalId=cm.CalId INNER JOIN Calusers AS cu ON cu.SystemNo=cm.SystemNo AND cu.UserId=cm.UserId INNER JOIN Systems AS s ON s.SystemNo=cm.SystemNo WHERE cm.SystemNo=@systemNo AND cm.CalId=@calId")
.AddSystemNoParameter(appointment.System.Nummer)
.AddAppointmentIdParameter(appointment.Id)
.Build();
return(subDataProvider.GetCollection <BrugeraftaleProxy>(command));
}
}
public void TestAtCreateGetCommandReturnererSqlCommand()
{
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
IAftaleProxy sut = CreateSut(systemNo, calId);
Assert.That(sut, Is.Not.Null);
new DbCommandTestBuilder("SELECT ca.SystemNo,ca.CalId,ca.Date,ca.FromTime,ca.ToTime,ca.Properties,ca.Subject,ca.Note,s.Title AS SystemTitle,s.Properties AS SystemProperties FROM Calapps AS ca INNER JOIN Systems AS s ON s.SystemNo=ca.SystemNo WHERE ca.SystemNo=@systemNo AND ca.CalId=@calId")
.AddSmallIntDataParameter("@systemNo", systemNo, 2)
.AddIntDataParameter("@calId", calId, 8)
.Build()
.Run(sut.CreateGetCommand());
}
public void TestAtCreateDeleteCommandReturnererSqlCommand()
{
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
IAftaleProxy sut = CreateSut(systemNo, calId);
Assert.That(sut, Is.Not.Null);
new DbCommandTestBuilder("DELETE FROM Calapps WHERE SystemNo=@systemNo AND CalId=@calId")
.AddSmallIntDataParameter("@systemNo", systemNo, 2)
.AddIntDataParameter("@calId", calId, 8)
.Build()
.Run(sut.CreateDeleteCommand());
}
public void TestAtConstructorInitiererAftaleProxy()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
Assert.That(sut.System, Is.Not.Null);
Assert.That(sut.System.Nummer, Is.EqualTo(0));
Assert.That(sut.Id, Is.EqualTo(0));
Assert.That(sut.FraTidspunkt, Is.EqualTo(DateTime.MinValue));
Assert.That(sut.TilTidspunkt, Is.EqualTo(DateTime.MaxValue));
Assert.That(sut.Emne, Is.Not.Null);
Assert.That(sut.Emne, Is.EqualTo(typeof(Aftale).Name));
Assert.That(sut.Properties, Is.EqualTo(0));
Assert.That(sut.Deltagere, Is.Not.Null);
Assert.That(sut.Deltagere, Is.Empty);
}
public void TestThatDeltagereCallsCloneOnDataProviderWhenMapDataHasBeenCalledAndMapRelationsHasNotBeenCalled()
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
MySqlDataReader dataReader = CreateMySqlDataReader(systemNo, calId, subject: _fixture.Create <string>());
IMySqlDataProvider dataProvider = CreateMySqlDataProvider();
sut.MapData(dataReader, dataProvider);
IEnumerable <IBrugeraftale> result = sut.Deltagere;
Assert.That(result, Is.Not.Null);
dataProvider.AssertWasCalled(m => m.Clone(), opt => opt.Repeat.Once());
}
/// <summary>
/// Creates a mockup for the data provider which uses MySQL.
/// </summary>
/// <returns>Mockup for the data provider which uses MySQL.</returns>
private IMySqlDataProvider CreateMySqlDataProvider(ISystemProxy systemProxy = null, IAftaleProxy appointmentProxy = null, IBrugerProxy calenderUserProxy = null)
{
IMySqlDataProvider dataProviderMock = MockRepository.GenerateMock <IMySqlDataProvider>();
dataProviderMock.Stub(m => m.Create(Arg <ISystemProxy> .Is.TypeOf, Arg <MySqlDataReader> .Is.Anything, Arg <string[]> .Is.Anything))
.Return(systemProxy ?? MockRepository.GenerateMock <ISystemProxy>())
.Repeat.Any();
dataProviderMock.Stub(m => m.Create(Arg <IAftaleProxy> .Is.TypeOf, Arg <MySqlDataReader> .Is.Anything, Arg <string[]> .Is.Anything))
.Return(appointmentProxy ?? MockRepository.GenerateMock <IAftaleProxy>())
.Repeat.Any();
dataProviderMock.Stub(m => m.Create(Arg <IBrugerProxy> .Is.TypeOf, Arg <MySqlDataReader> .Is.Anything, Arg <string[]> .Is.Anything))
.Return(calenderUserProxy ?? MockRepository.GenerateMock <IBrugerProxy>())
.Repeat.Any();
return(dataProviderMock);
}
public void TestAtMapDataMapperBrugeraftaleProxy(bool hasProperties)
{
IBrugeraftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
int userId = _fixture.Create <int>();
int? properties = hasProperties ? _fixture.Create <int>() : (int?)null;
MySqlDataReader dataReader = CreateMySqlDataReader(systemNo, calId, userId, properties);
ISystemProxy systemProxy = MockRepository.GenerateMock <ISystemProxy>();
IAftaleProxy appointmentProxy = MockRepository.GenerateMock <IAftaleProxy>();
IBrugerProxy calenderUserProxy = MockRepository.GenerateMock <IBrugerProxy>();
IMySqlDataProvider dataProvider = CreateMySqlDataProvider(systemProxy, appointmentProxy, calenderUserProxy);
sut.MapData(dataReader, dataProvider);
Assert.That(sut.System, Is.Not.Null);
Assert.That(sut.System, Is.EqualTo(systemProxy));
Assert.That(sut.Aftale, Is.Not.Null);
Assert.That(sut.Aftale, Is.EqualTo(appointmentProxy));
Assert.That(sut.Bruger, Is.Not.Null);
Assert.That(sut.Bruger, Is.EqualTo(calenderUserProxy));
if (hasProperties)
{
Assert.That(sut.Properties, Is.EqualTo(properties));
}
else
{
Assert.That(sut.Properties, Is.EqualTo(0));
}
dataReader.AssertWasCalled(m => m.GetOrdinal(Arg <string> .Is.Equal("Properties")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.IsDBNull(Arg <int> .Is.Equal(3)), opt => opt.Repeat.Once());
if (hasProperties)
{
dataReader.AssertWasCalled(m => m.GetInt32(Arg <string> .Is.Equal("Properties")), opt => opt.Repeat.Once());
}
else
{
dataReader.AssertWasNotCalled(m => m.GetInt32(Arg <string> .Is.Equal("Properties")));
}
dataProvider.AssertWasCalled(m => m.Create(
Arg <ISystemProxy> .Is.TypeOf,
Arg <MySqlDataReader> .Is.Equal(dataReader),
Arg <string[]> .Matches(e => e != null && e.Length == 3 &&
e[0] == "SystemNo" &&
e[1] == "SystemTitle" &&
e[2] == "SystemProperties")),
opt => opt.Repeat.Once());
dataProvider.AssertWasCalled(m => m.Create(
Arg <IAftaleProxy> .Is.TypeOf,
Arg <MySqlDataReader> .Is.Equal(dataReader),
Arg <string[]> .Matches(e => e != null && e.Length == 10 &&
e[0] == "CalId" &&
e[1] == "Date" &&
e[2] == "FromTime" &&
e[3] == "ToTime" &&
e[4] == "AppointmentProperties" &&
e[5] == "Subject" &&
e[6] == "Note" &&
e[7] == "SystemNo" &&
e[8] == "SystemTitle" &&
e[9] == "SystemProperties")),
opt => opt.Repeat.Once());
dataProvider.AssertWasCalled(m => m.Create(
Arg <IBrugerProxy> .Is.TypeOf,
Arg <MySqlDataReader> .Is.Equal(dataReader),
Arg <string[]> .Matches(e => e != null && e.Length == 7 &&
e[0] == "UserId" &&
e[1] == "UserInitials" &&
e[2] == "UserFullname" &&
e[3] == "UserName" &&
e[4] == "SystemNo" &&
e[5] == "SystemTitle" &&
e[6] == "SystemProperties")),
opt => opt.Repeat.Once());
}
public void TestThatCreateCreatesCalenderUserProxy(bool hasProperties, bool hasNote)
{
IAftaleProxy sut = CreateSut();
Assert.That(sut, Is.Not.Null);
int systemNo = _fixture.Create <int>();
int calId = _fixture.Create <int>();
DateTime fromDateTime = DateTime.Today.AddDays(_random.Next(1, 30)).AddHours(_random.Next(8, 16)).AddMinutes(_random.Next(0, 3) * 15);
TimeSpan duration = new TimeSpan(0, 0, _random.Next(1, 3) * 15, 0);
int? properties = hasProperties ? _fixture.Create <int>() : (int?)null;
string subject = _fixture.Create <string>();
string note = hasNote ? _fixture.Create <string>() : null;
MySqlDataReader dataReader = CreateMySqlDataReader(systemNo, calId, fromDateTime, duration, properties, subject, note);
ISystemProxy systemProxy = MockRepository.GenerateMock <ISystemProxy>();
IMySqlDataProvider dataProvider = CreateMySqlDataProvider(systemProxy);
IAftaleProxy result = sut.Create(dataReader, dataProvider, "CalId", "Date", "FromTime", "ToTime", "Properties", "Subject", "Note", "SystemNo", "SystemTitle", "SystemProperties");
Assert.That(result.System, Is.Not.Null);
Assert.That(result.System, Is.EqualTo(systemProxy));
Assert.That(result.Id, Is.EqualTo(calId));
Assert.That(result.FraTidspunkt, Is.EqualTo(fromDateTime));
Assert.That(result.TilTidspunkt, Is.EqualTo(fromDateTime.Add(duration)));
if (hasProperties)
{
Assert.That(result.Properties, Is.EqualTo(properties));
}
else
{
Assert.That(result.Properties, Is.EqualTo(0));
}
Assert.That(result.Emne, Is.Not.Null);
Assert.That(result.Emne, Is.Not.Empty);
Assert.That(result.Emne, Is.EqualTo(subject));
if (hasNote)
{
Assert.That(result.Notat, Is.Not.Null);
Assert.That(result.Notat, Is.Not.Empty);
Assert.That(result.Notat, Is.EqualTo(note));
}
else
{
Assert.That(result.Notat, Is.Null);
}
dataReader.AssertWasCalled(m => m.GetInt32(Arg <string> .Is.Equal("CalId")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetMySqlDateTime(Arg <string> .Is.Equal("Date")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetTimeSpan(Arg <string> .Is.Equal("FromTime")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetTimeSpan(Arg <string> .Is.Equal("ToTime")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetOrdinal(Arg <string> .Is.Equal("Properties")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.IsDBNull(Arg <int> .Is.Equal(5)), opt => opt.Repeat.Once());
if (hasProperties)
{
dataReader.AssertWasCalled(m => m.GetInt32(Arg <string> .Is.Equal("Properties")), opt => opt.Repeat.Once());
}
else
{
dataReader.AssertWasNotCalled(m => m.GetInt32(Arg <string> .Is.Equal("Properties")));
}
dataReader.AssertWasCalled(m => m.GetOrdinal(Arg <string> .Is.Equal("Subject")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.IsDBNull(Arg <int> .Is.Equal(6)), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetString(Arg <string> .Is.Equal("Subject")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.GetOrdinal(Arg <string> .Is.Equal("Note")), opt => opt.Repeat.Once());
dataReader.AssertWasCalled(m => m.IsDBNull(Arg <int> .Is.Equal(7)), opt => opt.Repeat.Once());
if (hasNote)
{
dataReader.AssertWasCalled(m => m.GetString(Arg <string> .Is.Equal("Note")), opt => opt.Repeat.Once());
}
else
{
dataReader.AssertWasNotCalled(m => m.GetString(Arg <string> .Is.Equal("Note")));
}
dataProvider.AssertWasCalled(m => m.Create(
Arg <ISystemProxy> .Is.TypeOf,
Arg <MySqlDataReader> .Is.Equal(dataReader),
Arg <string[]> .Matches(e => e != null && e.Length == 3 &&
e[0] == "SystemNo" &&
e[1] == "SystemTitle" &&
e[2] == "SystemProperties")),
opt => opt.Repeat.Once());
dataProvider.AssertWasNotCalled(m => m.Clone());
}
