public UnitOfWork(CharacterContext context, SpellsContext spellsContext, ItemsContext itemsContext, PlayableClassContext playableClassContext, RaceContext raceContext)
{
_context = context;
Characters = RepositoryFactory.GetCharacterRepository(context);
HealthRecords = RepositoryFactory.GetHealthRepository(context);
CurrencyRecords = RepositoryFactory.GetCurrencyRepository(context);
ProficiencyRecords = RepositoryFactory.GetIsProficientRepository(context);
Notes = RepositoryFactory.GetNotesRepository(context);
Stats = RepositoryFactory.GetStatsRepository(context);
_spellsContext = spellsContext;
Spells = RepositoryFactory.GetSpellsRepository(spellsContext);
_itemsContext = itemsContext;
Items = RepositoryFactory.GetItemsRepository(itemsContext);
_playableClassContext = playableClassContext;
Classes = RepositoryFactory.GetPlayableClassRepository(playableClassContext);
ClassAbilities = RepositoryFactory.GetClassAbilityRepository(playableClassContext);
Subclasses = RepositoryFactory.GetSubclassRepository(playableClassContext);
SubclassAbilities = RepositoryFactory.GetSubclassAbilityRepository(playableClassContext);
_raceContext = raceContext;
Races = RepositoryFactory.GetRacesRepository(raceContext);
}
private void Seed()
{
using var context = new ItemsContext(this.ContextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var one = new Item("ItemOne");
one.AddTag("Tag11");
one.AddTag("Tag12");
one.AddTag("Tag13");
var two = new Item("ItemTwo");
var three = new Item("ItemThree");
three.AddTag("Tag31");
three.AddTag("Tag31");
three.AddTag("Tag31");
three.AddTag("Tag32");
three.AddTag("Tag32");
context.AddRange(one, two, three);
context.SaveChanges();
}
public void Can_add_tag_when_already_existing_tag()
{
using (var context = new ItemsContext(this.ContextOptions))
{
var controller = new ItemsController(context);
var tag = controller.PostTag("ItemThree", "Tag32").Value;
Assert.Equal("Tag32", tag.Label);
Assert.Equal(3, tag.Count);
}
using (var context = new ItemsContext(this.ContextOptions))
{
var item = context.Items
.Include(e => e.Tags)
.Single(e => e.Name == "ItemThree");
Assert.Equal(2, item.Tags.Count);
Assert.Equal("Tag31", item.Tags[0].Label);
Assert.Equal(3, item.Tags[0].Count);
Assert.Equal("Tag32", item.Tags[1].Label);
Assert.Equal(3, item.Tags[1].Count);
}
}
private void Seed()
{
using (var context = new ItemsContext(ContextOptions))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Add(new Item {
Id = 1, Name = "El_1", Price = 5, Description = "Opis"
});
context.Add(new Item {
Id = 2, Name = "El_2", Price = 15, Description = "Opis - El_2"
});
context.Add(new Item {
Id = 3, Name = "A", Price = 35, Description = "Opis - A"
});
context.Add(new Item {
Id = 5, Name = "B", Price = 55, Description = "Opis - B"
});
context.Add(new Item {
Id = 6, Name = "C", Price = 11, Description = "Opis - C"
});
context.Add(new Item {
Id = 11, Name = "D", Price = 102, Description = "Opis - D"
});
context.Add(new Item {
Id = 12, Name = "D1", Price = 85, Description = "Opis - D1"
});
context.SaveChanges();
}
}
public void EntityFrameworkContextExceptionEventsInstrumentedTest()
{
var activityProcessor = new Mock <BaseProcessor <Activity> >();
using var shutdownSignal = Sdk.CreateTracerProviderBuilder()
.AddProcessor(activityProcessor.Object)
.AddEntityFrameworkCoreInstrumentation()
.Build();
using (var context = new ItemsContext(this.contextOptions))
{
try
{
context.Database.ExecuteSqlRaw("select * from no_table");
}
catch
{
}
}
Assert.Equal(3, activityProcessor.Invocations.Count);
var activity = (Activity)activityProcessor.Invocations[1].Arguments[0];
VerifyActivityData(activity, isError: true);
}
public BasketController(IMailService mailService)
{
this.mailService = mailService;
db = new ItemsContext();
sessionManager = new SessionManager();
basketManager = new BasketManager(sessionManager, db);
}
public IHttpController Create(HttpRequestMessage request, HttpControllerDescriptor controllerDescriptor, Type controllerType)
{
var itemContext = new ItemsContext();
var itemService = new ItemService(new Repository <Item>(itemContext));
if (controllerType == typeof(ItemController))
{
return(new ItemController(itemService));
}
if (controllerType == typeof(BasketController))
{
var mapperService = new MapperService();
var basketRepository = new Repository <Basket>(itemContext);
var invoiceRepository = new Repository <Invoice>(itemContext);
var invoiceItemRepository = new Repository <InvoiceItem>(itemContext);
var basketItemRepository = new Repository <BasketItem>(itemContext);
var basketService = new BasketService(basketRepository, invoiceRepository, invoiceItemRepository, basketItemRepository);
var userService = new UserService(new Repository <User>(itemContext));
return(new BasketController(itemService, mapperService, basketService, userService));
}
throw new ArgumentException("Unexpected type!", nameof(controllerType));
}
public IHttpActionResult getAllItems()
{
ItemsContext itemsContext = new ItemsContext();
List <Items> items = itemsContext.Items.ToList();
return(Ok(items));
}
public IHttpActionResult getItem(int id)
{
ItemsContext itemsContext = new ItemsContext();
Items items = itemsContext.Items.Single(t => t.ID == id);
return(Ok(items));
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
using (var client = new ItemsContext())
{
client.Database.EnsureCreated();
}
}
public void ItemsControllerGetElements_Test()
{
using (var context = new ItemsContext(ContextOptions))
{
ItemsController controller = new ItemsController(context);
var items = controller.GetAllElements();
Assert.AreEqual(7, items.Count());
}
}
public void Can_get_item()
{
using (var context = new ItemsContext(ContextOptions))
{
var controller = new ItemsController(context);
var item = controller.Get("ItemTwo");
Assert.Equal("ItemTwo", item.Name);
}
}
public ItemsContext CreateContext(DbTransaction transaction = null)
{
var context = new ItemsContext(new DbContextOptionsBuilder <ItemsContext>().UseSqlServer(Connection).Options);
if (transaction != null)
{
context.Database.UseTransaction(transaction);
}
return(context);
}
public void Can_get_items()
{
using var context = new ItemsContext(this.ContextOptions);
var controller = new ItemsController(context);
var items = controller.Get().ToList();
Assert.Equal(3, items.Count);
Assert.Equal("ItemOne", items[0].Name);
Assert.Equal("ItemThree", items[1].Name);
Assert.Equal("ItemTwo", items[2].Name);
}
public UnitOfWork(CharacterContext context, ItemsContext itemsContext)
{
_context = context;
Characters = RepositoryFactory.GetCharacterRepository(context);
HealthRecords = RepositoryFactory.GetHealthRepository(context);
CurrencyRecords = RepositoryFactory.GetCurrencyRepository(context);
ProficiencyRecords = RepositoryFactory.GetIsProficientRepository(context);
Notes = RepositoryFactory.GetNotesRepository(context);
Stats = RepositoryFactory.GetStatsRepository(context);
_itemsContext = itemsContext;
Items = RepositoryFactory.GetItemsRepository(itemsContext);
}
public CartsController(CartContext context, ItemsContext Goodcontext, UserManager <IdentityUser> userManager,
ApplicationDbContext context7, ICategoriesRepository categoryContext,
IGendersRepository gendersContext, IFeaturesRepository featuresContext, ItemsContext contextIt)
{
_itemcontext = Goodcontext;
_context = context;
_context7 = context7;
this.userManager = userManager;
_categoryContext = categoryContext;
_gendersContext = gendersContext;
_featuresContext = featuresContext;
_contextIt = contextIt;
}
public ItemsController(ItemsContext context, ItemsService contextSearch, ICategoriesRepository categoryContext, IWebHostEnvironment hostEnvironment, IGendersRepository gendersContext, IFeaturesRepository featuresContext,
ICommentsRepository commentsContext, CommentsContext comContext, UserManager <IdentityUser> userManager)
{
_categoryContext = categoryContext;
_context = context;
//_context2 = context2;
_commentsContext = commentsContext;
_gendersContext = gendersContext;
_featuresContext = featuresContext;
webHostEnvironment = hostEnvironment;
_comContext = comContext;
_contextSearch = contextSearch;
this.userManager = userManager;
}
public void ItemsControllerGetOneItem_Test()
{
using (var context = new ItemsContext(ContextOptions))
{
ItemsController controller = new ItemsController(context);
var item1 = controller.GetElement(1);
var obj = new Item()
{
Id = 1, Description = "Opis", Name = "El_1", Price = 5
};
Assert.AreEqual(obj, item1);
}
}
public void Can_remove_item_and_all_associated_tags()
{
using (var context = new ItemsContext(this.ContextOptions))
{
var controller = new ItemsController(context);
var item = controller.DeleteItem("ItemThree").Value;
Assert.Equal("ItemThree", item.Name);
}
using (var context = new ItemsContext(this.ContextOptions))
{
Assert.False(context.Items.Any(e => e.Name == "ItemThree"));
Assert.False(context.Tags.Any(e => e.Label.StartsWith("Tag3")));
}
}
public void Can_add_item_differing_only_by_case()
{
using (var context = new ItemsContext(ContextOptions))
{
var controller = new ItemsController(context);
var item = controller.PostItem("itemtwo").Value;
Assert.Equal("itemtwo", item.Name);
}
using (var context = new ItemsContext(ContextOptions))
{
var item = context.Set <Item>().Single(e => e.Name == "itemtwo");
Assert.Equal(0, item.Tags.Count);
}
}
public void ItemsSearch_DescriptionContainsFilter_DescriptionContainsGauntlets()
{
//Arrange
List <Item> items = CreateTestData.GetListOfItems();
var mockSet = new Mock <DbSet <Item> >()
.SetupData(items, o =>
{
return(items.Single(x => x.Item_id.CompareTo(o.First()) == 0));
});
List <Item> expected = new List <Item>();
Item TitanstoneKnuckles = new Item
{
Item_id = Guid.Parse("026a7dff-5e85-4e6d-94c6-6613828e5df6"),
Name = "Titanstone Knuckles",
Description = "Gauntlets fashioned from the Titan of Stone, enhancing your strength to rival that of the gods.",
isEquippable = true,
isConsumable = false,
requiresAttunement = true,
Value = 999
};
expected.Add(TitanstoneKnuckles);
using (var mockContext = AutoMock.GetLoose())
{
mockContext.Mock <ItemsContext>()
.Setup(x => x.Items).Returns(mockSet.Object);
mockContext.Mock <ItemsContext>()
.Setup(x => x.Set <Item>()).Returns(mockSet.Object);
ItemsContext context = mockContext.Create <ItemsContext>();
//Act
ItemSearchToDecorate baseObject = new ItemSearchToDecorate(context);
DescriptionContains toTest = new DescriptionContains("Gauntlets");
toTest.setToBeDecorated(baseObject);
var actual = toTest.GetItems().ToList();
//Assert
actual.Should().BeEquivalentTo(expected);
}
}
public void Can_add_item()
{
using (var context = new ItemsContext(ContextOptions))
{
var controller = new ItemsController(context);
var item = controller.PostItem("ItemFour").Value;
Assert.Equal("ItemFour", item.Name);
}
using (var context = new ItemsContext(ContextOptions))
{
var item = context.Set <Item>().Single(e => e.Name == "ItemFour");
Assert.Equal("ItemFour", item.Name);
Assert.Equal(0, item.Tags.Count);
}
}
protected override void Seed(ItemsContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
context.Items.AddOrUpdate(
p => p.Id,
new Item {
Name = "Apples", Description = "Fruit", Stock = 5, Price = 2.5
},
new Item {
Name = "Bread", Description = "Loaf", Stock = 5, Price = 1.35
},
new Item {
Name = "Oranges", Description = "Fruit", Stock = 5, Price = 2.99
},
new Item {
Name = "Milk", Description = "Milk", Stock = 5, Price = 2.07
},
new Item {
Name = "Chocolate", Description = "Bars", Stock = 5, Price = 1.79
}
);
context.Baskets.AddOrUpdate(
p => p.Id,
new Basket {
Id = 1, UserId = 1
}
);
context.Users.AddOrUpdate(
p => p.Id,
new User {
Id = 1, Name = "First User"
}
);
}
public void Can_add_tag()
{
using (var context = new ItemsContext(ContextOptions))
{
var controller = new ItemsController(context);
var tag = controller.PostTag("ItemTwo", "Tag21").Value;
Assert.Equal("Tag21", tag.Label);
Assert.Equal(1, tag.Count);
}
using (var context = new ItemsContext(ContextOptions))
{
var item = context.Set <Item>().Include(e => e.Tags).Single(e => e.Name == "ItemTwo");
Assert.Equal(1, item.Tags.Count);
Assert.Equal("Tag21", item.Tags[0].Label);
Assert.Equal(1, item.Tags[0].Count);
}
}
private void Seed()
{
using var context = new ItemsContext(this.contextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var one = new Item {
Name = "ItemOne"
};
var two = new Item {
Name = "ItemTwo"
};
var three = new Item {
Name = "ItemThree"
};
context.AddRange(one, two, three);
context.SaveChanges();
}
public void ItemsSearchFacade_GetByNameContainingKNUCKLES_ReturnPagedList()
{
//Arrange
List <Item> items = CreateTestData.GetListOfItems();
var mockSet = new Mock <DbSet <Item> >()
.SetupData(items, o =>
{
return(items.Single(x => x.Item_id.CompareTo(o.First()) == 0));
});
List <foundItemCM> expectedList = new List <foundItemCM>();
foundItemCM Knuckles = new foundItemCM
{
Item_id = Guid.Parse("026a7dff-5e85-4e6d-94c6-6613828e5df6"),
Name = "Titanstone Knuckles"
};
expectedList.Add(Knuckles);
IPagedList <foundItemCM> expected = expectedList.ToPagedList(1, 20);
using (var mockContext = AutoMock.GetLoose())
{
mockContext.Mock <ItemsContext>()
.Setup(x => x.Items).Returns(mockSet.Object);
mockContext.Mock <ItemsContext>()
.Setup(x => x.Set <Item>()).Returns(mockSet.Object);
ItemsContext context = mockContext.Create <ItemsContext>();
//Act
ItemSearchFacade toTest = new ItemSearchFacade(context);
var actual = toTest.searchItemsToPagedList("KNUCKLES", "Name", 1);
//Assert
actual.Should().BeEquivalentTo(expected);
}
}
public void EntityFrameworkContextEventsInstrumentedTest()
{
var activityProcessor = new Mock <BaseProcessor <Activity> >();
using var shutdownSignal = Sdk.CreateTracerProviderBuilder()
.AddProcessor(activityProcessor.Object)
.AddEntityFrameworkCoreInstrumentation().Build();
using (var context = new ItemsContext(this.contextOptions))
{
var items = context.Set <Item>().OrderBy(e => e.Name).ToList();
Assert.Equal(3, items.Count);
Assert.Equal("ItemOne", items[0].Name);
Assert.Equal("ItemThree", items[1].Name);
Assert.Equal("ItemTwo", items[2].Name);
}
Assert.Equal(3, activityProcessor.Invocations.Count);
var activity = (Activity)activityProcessor.Invocations[1].Arguments[0];
VerifyActivityData(activity);
}
public ItemsController(ItemsContext context) => _context = context;
public ItemSearchFacade(ItemsContext context)
{
_context = context;
}
public ProizvodiController()
{
_context = new ItemsContext();
}
static MyContext()
{
_items = new ItemsContext();
}
/// <summary>
/// Initializes static members of the <see cref="MyContext"/> class
/// </summary>
static MyContext()
{
ItemsInternal = new ItemsContext();
}
