public void TestCategoryFinder() { int categoryId = 6; CategoryFinder categoryFinder = new CategoryFinder(); CategoryGateway categoryGateway = categoryFinder.FindCategoryGatewayById(categoryId); Assert.AreEqual(categoryId, categoryGateway.CategoryID); Assert.AreEqual("Meat/Poultry", categoryGateway.CategoryName); Assert.AreEqual("Prepared meats", categoryGateway.Description); }
protected override async Task OnInitializedAsync() { var result = await CategoryGateway.GetCategoriesWithIdNameAndDescription(); if (result.IsValid) { Categories = result.Success; } IsValid = result.IsValid; }
public async Task can_create_find_update_delete_a_budget() { BudgetGateway sut = new BudgetGateway(TestHelpers.ConnectionString); int categoryId = 0; DateTime date1 = TestHelpers.RandomBirthDate(1); DateTime date2 = TestHelpers.RandomBirthDate(2); int amount = 50; int collocId = 0; Result <int> budgetResult = await sut.CreateBudget(categoryId, date1, date2, amount); Assert.That(budgetResult.Status, Is.EqualTo(Status.Created)); int budgetId = budgetResult.Content; Result <BudgetData> budgetData; { budgetData = await sut.FindBudgetById(budgetId); checkBudget(budgetData, categoryId, date1, date2, amount, collocId); } { CategoryGateway categoryGateway = new CategoryGateway(TestHelpers.ConnectionString); Result <int> result = await categoryGateway.CreateCategory(TestHelpers.RandomTestName(), TestHelpers.RandomTestName(), 0); categoryId = result.Content; CollocGateway collocGateway = new CollocGateway(TestHelpers.ConnectionString); Result <int> result1 = await collocGateway.CreateColloc(TestHelpers.RandomTestName(), 0); collocId = result.Content; amount = 100; date1 = TestHelpers.RandomBirthDate(2); date2 = TestHelpers.RandomBirthDate(3); await sut.UpdateBudget(budgetId, categoryId, date1, date2, amount, collocId); budgetData = await sut.FindBudgetById(budgetId); checkBudget(budgetData, categoryId, date1, date2, amount, collocId); } { Result r = await sut.DeleteBudget(budgetId); Assert.That(r.Status, Is.EqualTo(Status.Ok)); budgetData = await sut.FindBudgetById(budgetId); Assert.That(budgetData.Status, Is.EqualTo(Status.NotFound)); } }
public IHttpActionResult LoadSubCategory(int categoryType, int parentId) { try { var data = new CategoryGateway().GetSubCategory(categoryType, parentId); if (data == null) { return(InternalServerError(exception: new ApplicationException(message: "Server temporarily unavailable."))); } return(Ok(data)); } catch (Exception ex) { return(InternalServerError(exception: ex)); } }
public void TestIdentityMapOfCategoryFinder() { int categoryId = 6; int anotherCategoryId = 8; CategoryFinder categoryFinder = new CategoryFinder(); CategoryGateway categoryGateway1 = categoryFinder.FindCategoryGatewayById(categoryId); CategoryGateway categoryGateway2 = categoryFinder.FindCategoryGatewayById(categoryId); Assert.AreEqual(categoryGateway1, categoryGateway2); CategoryGateway categoryGateway3 = categoryFinder.FindCategoryGatewayById(anotherCategoryId); Assert.AreNotEqual(categoryGateway1, categoryGateway3); Assert.AreNotEqual(categoryGateway2, categoryGateway3); }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <DAL_EF.EF.RetailContext>(); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["RetailContext"].ConnectionString); StandardKernel kernel = new StandardKernel( new UIModule(optionsBuilder.Options)); IProductService product = kernel.Get <IProductService>(); ICategoryService category = kernel.Get <ICategoryService>(); ISupplierService supplier = kernel.Get <ISupplierService>(); var cat = new CategoryDTO() { Name = "smth43242" }; /*prod.Category=cat; * prod1.Category=cat; * prod2.Category=cat;*/ /*category.Create(cat); * * var prod = new ProductDTO () {Name= "smth", CategoryId=1, Price = 10}; * var prod1 = new ProductDTO () {Name= "smth1", CategoryId=1, Price= 20}; * * * var sup = new SupplierDTO () {Name="sm", Products= new List<ProductDTO> {prod, prod1}}; * supplier.Create(sup);*/ //Console.WriteLine(product.GetWithMaxPrice().ProductId); //Console.WriteLine(product.GetWithMinPrice().ProductId); ProductGateway prod = new ProductGateway(new SqlContext()); CategoryGateway categ = new CategoryGateway(new SqlContext()); categ.Create(new ADOCategory() { Name = "Category" }); prod.Create(new ADOProduct() { Name = "oof", Price = 10, CategoryId = 1 }); }
protected async Task HandleSubmit() { if (!EditContext.Validate()) { return; } if (MicroId == Guid.Empty) { await CategoryGateway.CreateCategory(Category); } else { await CategoryGateway.UpdateCategory(MicroId, Category); } NavigationManager.NavigateTo("/categories"); }
public ActionResult AddSubCategory(Category categroy) { ViewBag.CategoryType = CategoryType(); if (ModelState.IsValid) { int rowAffected = new CategoryGateway().SaveSubCategory(categroy); if (rowAffected > 0) { ModelState.Clear(); ViewBag.Success = "Sub Sub Category Added Successful."; } else { ViewBag.Error = "Sorry! Something get error!"; } } return(View()); }
public async Task can_create_find_update_delete_category() { CategoryGateway sut = new CategoryGateway(TestHelpers.ConnectionString); string categoryName = TestHelpers.RandomTestName(); string icon = TestHelpers.RandomTestName(); int collocId = 0; Result <int> categoryResult = await sut.CreateCategory(categoryName, icon, collocId); Assert.That(categoryResult.Status, Is.EqualTo(Status.Created)); int categoryId = categoryResult.Content; Result <CategoryData> categoryData; { categoryData = await sut.FindCategoryId(categoryId); CheckCategory(categoryData, categoryName, icon, collocId); } { categoryName = TestHelpers.RandomTestName(); icon = TestHelpers.RandomTestName(); CollocGateway coGateway = new CollocGateway(TestHelpers.ConnectionString); var colloc = await coGateway.CreateColloc(TestHelpers.RandomTestName(), 0); collocId = colloc.Content; await sut.UpdateCategory(categoryId, categoryName, icon, collocId); categoryData = await sut.FindCategoryId(categoryId); CheckCategory(categoryData, categoryName, icon, collocId); } { Result r = await sut.DeleteCategory(categoryId); Assert.That(r.Status, Is.EqualTo(Status.Ok)); categoryData = await sut.FindCategoryId(categoryId); Assert.That(categoryData.Status, Is.EqualTo(Status.NotFound)); } }
protected override async Task OnInitializedAsync() { if (MicroId == Guid.Empty) { Category = new Category(); EditContext = new EditContext(Category); IsValid = true; return; } var result = await CategoryGateway.GetCategoryById(MicroId); if (result.IsValid) { Category = result.Success; EditContext = new EditContext(Category); } IsValid = result.IsValid; }
public CategoryManager() { CategoryGateway = new CategoryGateway(); }
protected override AbstractGateway CreateGateway(IDataRecord reader) { return(CategoryGateway.Load(reader)); }
public CategoryManeger() { setupCategoryGateway = new CategoryGateway(); }
public ItemManager() { itemGateway = new ItemGateway(); companyGateway = new CompanyGateway(); categoryGateway = new CategoryGateway(); }
public CategoryController(CategoryGateway categoryGateway) { _categoryGateway = categoryGateway; }