public void ReturnNewCeases()
{
var mobileBuilder = new MobileBuilder();
var newCease1 = mobileBuilder
.WithMobileState(Mobile.MobileState.ProcessingCease)
.WithOrderType(Order.OrderType.Cease)
.WithOrderState(Order.State.New)
.Build();
var newProvision1 = mobileBuilder
.WithMobileState(Mobile.MobileState.New)
.WithOrderType(Order.OrderType.Provision)
.WithOrderState(Order.State.New)
.Build();
var newCease2 = mobileBuilder
.WithMobileState(Mobile.MobileState.ProcessingCease)
.WithOrderType(Order.OrderType.Cease)
.WithOrderState(Order.State.New)
.Build();
fixture.DataAccess.Add(newCease1);
fixture.DataAccess.Add(newProvision1);
fixture.DataAccess.Add(newCease2);
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNewCeasesQuery(context, new DateTimeCreator());
var actual = sut.Get().ToList();
actual.ElementAt(0).Should().BeEquivalentTo(newCease1);
actual.ElementAt(1).Should().BeEquivalentTo(newCease2);
actual.Count.Should().Be(2);
}
public void ReturnMobiles()
{
var customerId = Guid.NewGuid();
var mobileBuilder = new MobileBuilder();
var mobile1 = mobileBuilder
.WithCustomerId(customerId)
.WithMobileState(Mobile.MobileState.New)
.WithOrderType(Order.OrderType.Provision)
.WithOrderState(Order.State.New)
.Build();
var mobile2 = mobileBuilder
.WithCustomerId(customerId)
.WithMobileState(Mobile.MobileState.New)
.WithOrderType(Order.OrderType.Provision)
.WithOrderState(Order.State.New)
.Build();
using var context = new MobilesContext(fixture.ContextOptions);
fixture.DataAccess.Add(mobile1);
fixture.DataAccess.Add(mobile2);
var sut = new GetMobilesByCustomerIdQuery(context, new DateTimeCreator());
var actual = sut.Get(customerId).ToList();
actual.ElementAt(0).Should().BeEquivalentTo(mobile1);
actual.ElementAt(1).Should().BeEquivalentTo(mobile2);
}
public void ReturnAllCustomers()
{
var expectedCustomer1 = new Customer
{
GlobalId = Guid.NewGuid(),
Name = "Neil Armstrong"
};
var expectedCustomer2 = new Customer
{
GlobalId = Guid.NewGuid(),
Name = "Buzz Aldrin"
};
var expectedCustomer3 = new Customer
{
GlobalId = Guid.NewGuid(),
Name = "Michael Collins"
};
customers.Add(expectedCustomer1);
customers.Add(expectedCustomer2);
customers.Add(expectedCustomer3);
using var context = new MobilesContext(fixture.ContextOptions);
sut = new CustomerRepository(context);
sut.Add(expectedCustomer1);
sut.Add(expectedCustomer2);
sut.Add(expectedCustomer3);
var actual = sut.GetAll();
actual.ElementAt(0).Should().BeEquivalentTo(expectedCustomer1);
actual.ElementAt(1).Should().BeEquivalentTo(expectedCustomer2);
actual.ElementAt(2).Should().BeEquivalentTo(expectedCustomer3);
}
public void ReturnEmpty_WhenNoCustomers()
{
using var context = new MobilesContext(fixture.ContextOptions);
sut = new CustomerRepository(context);
var actual = sut.GetAll();
actual.Should().BeEmpty();
}
public void ReturnEmpty_WhenNoMobiles()
{
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNewCeasesQuery(context, new DateTimeCreator());
var actual = sut.Get();
actual.Should().BeEmpty();
}
public void ReturnOne_WhenNoOrders()
{
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNextMobileIdQuery(context);
var actual = sut.Get();
actual.Should().Be(1);
}
public ActionResult Details(int id)
{
WebApplication1Entities db = new WebApplication1Entities();
MobilesContext pc = new MobilesContext();
List <Mobile> plist = db.Mobiles.ToList();
return(View(plist));
}
public void ReturnNull_WhenNotFound()
{
var notFoundGlobalId = Guid.NewGuid();
using var context = new MobilesContext(fixture.ContextOptions);
sut = new MobileRepository(context, new EnumConverter(), new DateTimeCreator());
var actual = sut.GetById(notFoundGlobalId);
actual.Should().BeNull();
}
public void ReturnNull_WhenNotFound()
{
var notFoundGlobalId = Guid.NewGuid();
using var context = new MobilesContext(fixture.ContextOptions);
sut = new CustomerRepository(context);
var actual = sut.GetById(notFoundGlobalId);
actual.Should().BeNull();
}
public void ReturnNull_WhenNotFound()
{
var notFoundOrderId = Guid.NewGuid();
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetMobileByOrderIdQuery(context, new DateTimeCreator());
var actual = sut.Get(notFoundOrderId);
actual.Should().BeNull();
}
public void ReturnEmpty_WhenNoMobiles()
{
var notFoundCustomerId = Guid.NewGuid();
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetMobilesByCustomerIdQuery(context, new DateTimeCreator());
var actual = sut.Get(notFoundCustomerId);
actual.Should().BeEmpty();
}
public string GetNextPhoneNumber()
{
var prefix = "07001";
using var mobilesContext = new MobilesContext(contextOptions);
var sql = $"select PhoneNumber from Mobiles.Mobiles where PhoneNumber like '{prefix}%';";
using var conn = new SqlConnection(connectionString);
var dbRows = conn.Query(sql);
var phoneNumbers = dbRows.Select(dbRow =>
{
var phoneNumberString = ((string)dbRow.PhoneNumber)[prefix.Length..];
public void Add(Mobile mobile)
{
var contextOptions = new DbContextOptionsBuilder <MobilesContext>()
.UseSqlServer(ConfigurationData.ConnectionString)
.Options;
using var context = new MobilesContext(contextOptions);
var mobilesRepository = new MobileRepository(context, new EnumConverter(), new DateTimeCreator());
mobilesRepository.Add(mobile);
mobilesAdded.Add(mobile);
}
public void DoesNotReturnMobilesWhichHaveNoOrders()
{
var newProvision1 = mobileBuilder
.WithMobileState(Mobile.MobileState.New)
.BuildWithoutOrder();
fixture.DataAccess.Add(newProvision1);
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNewProvisionsQuery(context, new DateTimeCreator());
var actual = sut.Get().ToList();
actual.Should().BeEmpty();
}
public void ReturnMobile()
{
var mobileBuilder = new MobileBuilder();
var expectedMobile = mobileBuilder
.WithMobileState(Mobile.MobileState.New)
.BuildWithoutOrder();
mobiles.Add(expectedMobile);
using var context = new MobilesContext(fixture.ContextOptions);
sut = new MobileRepository(context, new EnumConverter(), new DateTimeCreator());
sut.Add(expectedMobile);
var actual = sut.GetById(expectedMobile.GlobalId);
actual.Should().BeEquivalentTo(expectedMobile);
}
public void AddCustomer()
{
expectedCustomer = new Customer
{
GlobalId = Guid.NewGuid(),
Name = "Neil Armstrong"
};
using var context = new MobilesContext(fixture.ContextOptions);
sut = new CustomerRepository(context);
sut.Add(expectedCustomer);
var actual = sut.GetById(expectedCustomer.GlobalId);
actual.Should().BeEquivalentTo(expectedCustomer);
}
public void DoesNotReturnMobilesWhichAreNotNew(string stateString)
{
var state = new EnumConverter().ToEnum <Mobile.MobileState>(stateString);
var newProvision1 = mobileBuilder
.WithMobileState(state)
.WithOrderType(Order.OrderType.Provision)
.WithOrderState(Order.State.New)
.Build();
fixture.DataAccess.Add(newProvision1);
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNewProvisionsQuery(context, new DateTimeCreator());
var actual = sut.Get().ToList();
actual.Should().BeEmpty();
}
public void ReturnMobile()
{
var mobileBuilder = new MobileBuilder();
var expectedMobile = mobileBuilder
.WithMobileState(Mobile.MobileState.New)
.WithOrderType(Order.OrderType.Provision)
.WithOrderState(Order.State.New)
.Build();
fixture.DataAccess.Add(expectedMobile);
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetMobileByOrderIdQuery(context, new DateTimeCreator());
var actual = sut.Get(expectedMobile.Orders.First().GlobalId);
actual.Should().BeEquivalentTo(expectedMobile);
}
public void ReturnNextMobileId()
{
var mobileBuilder = new MobileBuilder();
var mobile = mobileBuilder
.WithMobileState(Mobile.MobileState.Live)
.WithOrderType(Order.OrderType.Activate)
.WithOrderState(Order.State.Completed)
.Build();
fixture.DataAccess.Add(mobile);
using var context = new MobilesContext(fixture.ContextOptions);
var sut = new GetNextMobileIdQuery(context);
var actual = sut.Get();
actual.Should().Be(mobile.Id + 1);
}
public void AddMobile()
{
var mobileBuilder = new MobileBuilder();
expectedMobile = mobileBuilder
.WithMobileState(Mobile.MobileState.Live)
.WithOrderType(Order.OrderType.Activate)
.WithOrderState(Order.State.Completed)
.Build();
using var context = new MobilesContext(fixture.ContextOptions);
sut = new MobileRepository(context, new EnumConverter(), new DateTimeCreator());
sut.Add(expectedMobile);
var actual = sut.GetById(expectedMobile.GlobalId);
actual.Should().BeEquivalentTo(expectedMobile);
}
public void AddMobile()
{
var mobileBuilder = new MobileBuilder();
expectedMobile = mobileBuilder
.WithMobileState(Mobile.MobileState.New)
.BuildWithoutOrder();
using var context = new MobilesContext(fixture.ContextOptions);
sut = new MobileRepository(context, new EnumConverter(), new DateTimeCreator());
sut.Add(expectedMobile);
expectedMobile.Provision();
sut.Update(expectedMobile);
var actual = sut.GetById(expectedMobile.GlobalId);
actual.State.Should().Be(Mobile.MobileState.ProcessingProvision);
}
public void UpdateCustomer()
{
var expectedCustomer = new Customer
{
GlobalId = Guid.NewGuid(),
Name = "Neil Armstrong"
};
customers.Add(expectedCustomer);
using var context = new MobilesContext(fixture.ContextOptions);
sut = new CustomerRepository(context);
sut.Add(expectedCustomer);
expectedCustomer.Name = "Tim Peake";
sut.Update(expectedCustomer);
var actual = sut.GetById(expectedCustomer.GlobalId);
actual.Name.Should().Be("Tim Peake");
}
public MobileRepository()
{
_ctx = new MobilesContext();
}
