public void Add_Should_Work_As_Expected()
{
//Arrange
TestEntity entity = new TestEntity();
//Act
_repository.Add(entity);
_testDbContext.SaveChanges();
//Assert
Assert.NotNull(_testDbContext.TestEntities.FirstOrDefault());
}
public JsonResult Upload(HttpPostedFileBase file)
{
if (_repository.GetAll().Any(x => x.FileName == file.FileName && x.ContentLength == file.ContentLength))
{
return(Json(_repository.GetAll().Count()));
}
using (var b = new BinaryReader(file.InputStream))
{
var binData = b.ReadBytes(file.ContentLength);
_repository.Add(new Document
{
ContentLength = binData.Count(),
ContentType = file.ContentType,
CreatedTime = DateTime.Now,
Data = binData,
Description = String.Empty,
FileName = file.FileName,
Owner = _accountRepository.FindByName(User.Identity.Name)
});
}
return(Json(_repository.GetAll().Count()));
}
public IHttpActionResult PostAddUser(User user)
{
EmailService emailservice = new ShoppingCore.Service.EmailService();
user.Password = new PasswordService().GeneratePassword(10);
emailservice.SendRegisterMail("Shopping Cart User Registration", user.Email, user.Name, user.Password, "http://localhost:4200/Login");
return(Ok(_efr.Add(user)));
}
public void TestCourseAddWithoutRequiredFK()
{
var courses = new EntityFrameworkRepository <Course>(context);
var newCourse = new Course {
Name = "Testowe zajecia"
};
courses.Add(newCourse);
courses.SaveChanges();
}
public void TestAdd_ShouldCallDbContextSetAdded()
{
// Arrange
var mockedDbContext = new Mock <ILogsDbContext>();
var repository = new EntityFrameworkRepository <FakeGenericRepositoryType>(mockedDbContext.Object);
var entity = new Mock <FakeGenericRepositoryType>();
// Act
repository.Add(entity.Object);
// Assert
mockedDbContext.Verify(c => c.SetAdded(entity.Object), Times.Once);
}
public void TestCourseAddWithRequiredFK()
{
var courses = new EntityFrameworkRepository <Course>(context);
var owner = users.GetById(1);
var newCourse = new Course {
Name = "Testowe zajecia", Owner = owner
};
courses.Add(newCourse);
courses.SaveChanges();
var addedCourse = courses.GetByOwner(owner).Where(t => t.Name == newCourse.Name).First();
Assert.IsNotNull(addedCourse);
Assert.AreEqual(newCourse.Owner.Id, addedCourse.Owner.Id);
}
public void CreateCustomerTest()
{
IRepository <Customer> customersRepository = new EntityFrameworkRepository <Customer>("InventoryContext");
Customer customer = new Customer()
{
FName = "Dave",
LName = "Richardson",
Address1 = "605 Sharview Cir",
Address2 = "#1735",
State = "NC",
Country = "USA",
Zipcode = "28217",
Phone = "1234567890",
Email = "*****@*****.**"
};
var response = customersRepository.Add(customer);
customersRepository.SaveChanges();
}
public void Test_DoubleTest_InsertToDatabase()
{
var configuration = new EntitySetupConfiguration();
// const string connectionString = "Data Source=(local); Database=easyERP_test; User ID=sa; Password=; MultipleActiveResultSets=True";
// EntityFrameworkDbContext dbContext = new EntityFrameworkDbContext(connectionString, configuration);
// DbConnection dbConnection = new SqlConnection();
var dbContext = new EntityFrameworkDbContext("easyERP_test");
IUnitOfWork unitOfWork = new EntityFrameworkUnitOfWork(dbContext);
var testRepository = new EntityFrameworkRepository <TestDoubles>(dbContext, unitOfWork);
var testModel = new TestDoubles
{
Name = "test description"
};
testRepository.Add(testModel);
unitOfWork.Commit();
}
public IHttpActionResult PostAddProduct(Product product)
{
return(Ok(_efr.Add(product)));
}
public IHttpActionResult PostAddWishList(WishList wishlist)
{
return(Ok(_efr.Add(wishlist)));
}
public IHttpActionResult PostAddProductCategory(ProductCategory productCategory)
{
return(Ok(_efr.Add(productCategory)));
}
public IHttpActionResult PostItem(LineItem item)
{
erf.Add(item);
return(Ok("LineItem Added..."));
}
public IHttpActionResult PostAddProduct(Address address)
{
return(Ok(_efr.Add(address)));
}
public IHttpActionResult PostUser(User user)
{
erf.Add(user);
return(Ok("Data Added"));
}
public IHttpActionResult PostOrder(Order order)
{
erf.Add(order);
return(Ok("Order Added..."));
}
public IHttpActionResult PostAddLineItem(LineItem lineitem)
{
return(Ok(_efr.Add(lineitem)));
}
public async Task GivenRepository_WhenFullCRUDFlowIsRun_ThenSucceed()
{
var builder = new DbContextOptionsBuilder <UsersDbContext>();
builder.UseNpgsql(ConnectionString,
x => x.MigrationsHistoryTable(
HistoryRepository.DefaultTableName,
SchemaName));
User user;
await using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
await dbContext.Database.MigrateAsync();
user = new User {
Id = 0, UserName = "******", FullName = null
};
//1. Add
var result = await repository.Add(user);
await repository.SaveChanges();
result.Should().NotBe(null);
result.Id.Should().BeGreaterThan(0);
result.UserName.Should().Be("*****@*****.**");
result.FullName.Should().BeNull();
}
//2. GetById
await using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
var recordFromDb = await repository.FindById(user.Id);
recordFromDb.Should().BeEquivalentTo(user);
}
//3. Update
await using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
var userToUpdate = new User {
Id = user.Id, UserName = "******", FullName = "Tom Smith"
};
repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
var result = await repository.Update(userToUpdate);
await repository.SaveChanges();
result.Should().NotBe(null);
result.Id.Should().Be(user.Id);
result.UserName.Should().Be("*****@*****.**");
result.FullName.Should().Be("Tom Smith");
var recordFromDb = await repository.FindById(userToUpdate.Id);
recordFromDb.Should().BeEquivalentTo(result);
}
//4. Remove
await using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
var result = await repository.DeleteById(user.Id);
await repository.SaveChanges();
result.Should().BeTrue();
var recordFromDb = await repository.FindById(user.Id);
recordFromDb.Should().Be(null);
}
//5. Add Range
await using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext, new NulloAggregateEventsPublisher());
var results = (await repository.AddAll(
public IHttpActionResult PostWishlist(Wishlist wishlist)
{
erf.Add(wishlist);
return(Ok("wishlist Added..."));
}
public IHttpActionResult PostProduct(Product product)
{
erf.Add(product);
return(Ok("Product Added"));
}
public IHttpActionResult PostAddress(Address address)
{
erf.Add(address);
return(Ok("Address Added"));
}
public void GivenRepository_WhenFullCRUDFlowIsRun_ThenSucceed()
{
var builder = new DbContextOptionsBuilder <UsersDbContext>();
builder.UseNpgsql(ConnectionString,
x => x.MigrationsHistoryTable(
HistoryRepository.DefaultTableName,
SchemaName));
User user = null;
using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
dbContext.Database.Migrate();
user = new User {
Id = 0, UserName = "******", FullName = null
};
//1. Add
var result = repository.Add(user);
repository.SaveChanges();
result.Should().NotBe(null);
result.Id.Should().BeGreaterThan(0);
result.UserName.Should().Be("*****@*****.**");
result.FullName.Should().BeNull();
}
//2. GetById
using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
var recordFromDb = repository.FindById(user.Id);
recordFromDb.Should().BeEquivalentTo(user);
}
//3. Update
using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
var userToUpdate = new User {
Id = user.Id, UserName = "******", FullName = "Tom Smith"
};
repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
var result = repository.Update(userToUpdate);
repository.SaveChanges();
result.Should().NotBe(null);
result.Id.Should().Be(user.Id);
result.UserName.Should().Be("*****@*****.**");
result.FullName.Should().Be("Tom Smith");
var recordFromDb = repository.FindById(userToUpdate.Id);
recordFromDb.Should().BeEquivalentTo(result);
}
//4. Remove
using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
var result = repository.DeleteById(user.Id);
repository.SaveChanges();
result.Should().BeTrue();
var recordFromDb = repository.FindById(user.Id);
recordFromDb.Should().Be(null);
}
//5. Add Range
using (var dbContext = new UsersDbContext(builder.Options))
{
var repository = new EntityFrameworkRepository <UsersDbContext, User>(dbContext);
var results = repository.AddAll(
new User {
UserName = "******"
},
new User {
UserName = "******"
},
new User {
UserName = "******"
}
)?.ToList();
repository.SaveChanges();
results.Should().NotBeNull();
results.Should().HaveCount(3);
results[0].Id.Should().BeGreaterThan(0);
results[0].UserName.Should().Be("*****@*****.**");
results[0].FullName.Should().BeNull();
results[1].Id.Should().BeGreaterThan(0);
results[1].UserName.Should().Be("*****@*****.**");
results[1].FullName.Should().BeNull();
results[2].Id.Should().BeGreaterThan(0);
results[2].UserName.Should().Be("*****@*****.**");
results[2].FullName.Should().BeNull();
//6. Query
var queryResults = repository.Query().ToList();
queryResults.Should().Contain(x => results.Select(u => u.Id).Contains(x.Id));
queryResults = repository.Query().ToList().Where(x => x.UserName == results[1].UserName).ToList();
queryResults.Should().HaveCountGreaterOrEqualTo(1);
queryResults.First(x => x.Id == results[1].Id).Should().BeEquivalentTo(results[1]);
}
}
public IHttpActionResult PostAddProduct(Order order)
{
return(Ok(_efr.Add(order)));
}