public async Task Can_parseAllProductUrlsInsideCompanyPageAsync_productData() { //Arrange await using var context = new ApplicationDb(ContextOptions); var logger = Mock.Of <ILogger <ProductController> >(); Seed(); var productServiceMock = new Mock <IProductService>(); productServiceMock.Setup(service => service.InsertProductPageIntoDb("Url1")) .ReturnsAsync(() => context.Products.FirstOrDefault(p => p.Url == "Url1")); productServiceMock.Setup(service => service.InsertProductPageIntoDb("Url2")) .ReturnsAsync(() => context.Products.FirstOrDefault(p => p.Url == "Url2")); productServiceMock.Setup(service => service.InsertProductPageIntoDb("Url3")) .ReturnsAsync(() => context.Products.FirstOrDefault(p => p.Url == "Url3")); var controller = new ProductController(context, null, productServiceMock.Object, logger); //Act var result = await controller.ParseAllProductUrlsInsideCompanyPageAsync("One"); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as ProductData[]; Assert.NotNull(okResultValue); Assert.Equal("One", okResultValue[0].Title); Assert.Equal(1, okResultValue[0].Id); }
public async Task Can_insertProductPageIntoDbViaUrl_productData() { //Arrange await using var context = new ApplicationDb(ContextOptions); Seed(); var browsingContextServiceMock = new Mock <IBrowsingContextService>(); browsingContextServiceMock.Setup(service => service.OpenPageAsync("https://prom.ua/p1367019485-rozumni-smart-godinnik.html?")) .ReturnsAsync(await MockOpenPageAsync()); var controller = new ProductService(context, browsingContextServiceMock.Object); var targetProduct = context.Products.FirstOrDefault(); if (targetProduct != null) { targetProduct.Url = @"https://prom.ua/p1367019485-rozumni-smart-godinnik.html?"; } await context.SaveChangesAsync(); //Act var result = await controller.InsertProductPageIntoDb(targetProduct?.Url); //Assert Assert.NotNull(result); Assert.Equal("Розумні смарт годинник Smart watch DM08", result.Title); }
public string Get(string origin, string destination) { var originRow = ApplicationDb.RunQueryAndReturnFirstRow($"Select * from airports.csv where [IATA 3] = \"{origin}\""); var destinationRow = ApplicationDb.RunQueryAndReturnFirstRow($"Select * from airports.csv where [IATA 3] = \"{destination}\""); if (originRow == null) { return("Invalid Origin"); } if (destinationRow == null) { return("Invalid Destination"); } var logic = new Logic(); string path = logic.GetShortestPath(origin, destination); if (string.IsNullOrEmpty(path)) { return("No Route"); } else { return(path); } }
public HomeController(ApplicationDb _db) { this.db = _db; uRepository = new UserRepository(db); rRepository = new RoleRepository(db); urRepository = new UserRoleRepository(db); }
public AccountController(ApplicationDb db, UserManager <ApplicationUser> manager, SignInManager <ApplicationUser> signInManager, RoleManager <ApplicationRole> roleManager) { _db = db; _manager = manager; _signInManager = signInManager; _roleManager = roleManager; }
public SysSignalROnline GetById(Guid id) { using (var db = new ApplicationDb()) { return(db.SysSignalROnlines.Find(id)); } }
/// <summary> /// get a list of activities which don't have a TSS value but which do have a power meter so we can calculate TSS/IF /// </summary> private void GetActivities() { using (ApplicationDb db = new ApplicationDb()) { _activity = db.Activity.Where(a => a.TSS == null && a.HasPowerMeter).Select(a => a.Id).ToList(); } }
public async Task Can_addByUrlAsync_responseCompany() { //Arrange await using var context = new ApplicationDb(ContextOptions); var browsingContextServiceMock = new Mock <IBrowsingContextService>(); var logger = Mock.Of <ILogger <CompanyController> >(); var backgroundTaskQueueMock = new BackgroundCompaniesQueue(10); browsingContextServiceMock .Setup(service => service.OpenPageAsync("https://prom.ua/c3502019-toppoint-tvoj-internet.html")) .ReturnsAsync(await MockOpenPageAsync()); var controller = new CompanyController(context, null, new BrowsingContextService(), logger, backgroundTaskQueueMock, null); //Act var result = await controller.AddByUrlAsync("https://prom.ua/c3502019-toppoint-tvoj-internet.html"); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as ResponseCompany; Assert.NotNull(okResultValue); Assert.Equal("3502019", okResultValue.ExternalId); }
public async Task Can_getPagedProductsByCategoryIdAsync_responseProductList() { //Arrange await using var context = new ApplicationDb(ContextOptions); var logger = Mock.Of <ILogger <ProductController> >(); Seed(); var controller = new ProductController(context, null, null, logger); //Act var result = await controller.GetPagedProductsByCategoryIdAsync(1, 0, 1); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as IEnumerable <ResponseProduct>; Assert.NotNull(okResultValue); var responseProducts = okResultValue as ResponseProduct[] ?? okResultValue.ToArray(); Assert.Single(responseProducts); Assert.Equal("One", responseProducts.First().Title); }
public async Task Can_getPaged_categories() { //Arrange await using var context = new ApplicationDb(ContextOptions); var logger = Mock.Of <ILogger <CategoryController> >(); Seed(); var controller = new CategoryController(logger, null, null); //Act var result = await controller.GetPagedAsync(1, 1); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as IEnumerable <ResponseCategory>; Assert.NotNull(okResultValue); var responseCategories = okResultValue as ResponseCategory[] ?? okResultValue.ToArray(); Assert.Single(responseCategories); Assert.Equal("Two", responseCategories[0].Name); }
public async Task Can_getAllNested_categories() { //Arrange await using var context = new ApplicationDb(ContextOptions); var logger = Mock.Of <ILogger <CategoryController> >(); Seed(); var controller = new CategoryController(logger, null, null); //Act var result = await controller.GetAllNestedAsync(); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as ResponseNestedCategory; Assert.NotNull(okResultValue); var responseCategories = okResultValue; Assert.Equal("One", responseCategories.Name); Assert.Single(responseCategories.SubCategories); }
public IEnumerable <Patient> Get() { using (var db = new ApplicationDb()) { return(db.Patients.Include("Ailments").Include("Medications").ToList()); } }
public ApplicationDb Get() { _dataContext = _dataContext ?? (_dataContext = new ApplicationDb()); //_dataContext.Database.Log = log => Trace.Write(log); return _dataContext; }
public ApplicationDb Get() { _dataContext = _dataContext ?? (_dataContext = new ApplicationDb()); _dataContext.Database.Log = log => Trace.Write(log); return(_dataContext); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { var db = new ApplicationDb(); var login = new UserAcount { Name = model.Name, Email = model.Email, Age = model.Age, Phone = model.Phone, ApplicationUserId = user.Id }; db.UserAcounts.Add(login); db.SaveChanges(); await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Index", "Home")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public SysSignalROnline GetById(Guid id) { using (var db = new ApplicationDb()) { return db.SysSignalROnlines.Find(id); } }
public void SaveTransaction(TransactionData transactionData, ApplicationDb context, int ownerID) { TransactionDescription transDesc = new TransactionDescription(); transDesc.Type = transactionData.Type; transDesc.Description = transactionData.Description; transDesc.Date = DateTime.Now; transDesc.ownerID = ownerID; context.Add(transDesc); context.SaveChanges(); var id = transDesc.ID; foreach (ProductsViewModel product in transactionData.Products) { Transaction trans = new Transaction(); trans.TransactionDescriptionID = id; trans.ProductID = product.ID; trans.UnitNetPrice = product.NetPrice; trans.UnitGrossPrice = product.GrossPrice; trans.ProductUnits = product.Units; trans.GrossPrice = product.GrossPrice * product.Units; trans.NetPrice = product.NetPrice * product.Units; context.Add(trans); context.SaveChanges(); } UpdateProductUnits(transactionData, context); }
public AdminRepo(ApplicationDb db, UserManager <ApplicationUser> userManager, RoleManager <ApplicationRole> roleManager) { _db = db; _userManager = userManager; _roleManager = roleManager; }
private Athlete CreateAthlete(ApplicationDb context, Athlete athlete) { context.Athletes.Add(athlete); context.SaveChanges(); return(athlete); }
public async Task Can_getAll_responseCompanyList() { //Arrange await using var context = new ApplicationDb(ContextOptions); var logger = Mock.Of <ILogger <CompanyController> >(); var controller = new CompanyController(context, null, null, logger, null, null); //Act var result = await controller.GetAllAsync(); var okResult = result as OkObjectResult; //Assert Assert.NotNull(okResult); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var okResultValue = okResult.Value as IEnumerable <ResponseCompany>; Assert.NotNull(okResultValue); var responseCompanies = okResultValue as ResponseCompany[] ?? okResultValue.ToArray(); Assert.Single(responseCompanies); Assert.Equal("One", responseCompanies.First().Name); }
private void SetupContainer() { AutoMapperConfig.RegisterMappings(); var container = new Container(); container.RegisterSingle(() => new ApplicationDb()); container.RegisterSingle <IUserStore <ApplicationUser>, ApplicationUserStore>(); container.RegisterSingle <UserManager <ApplicationUser> >(); //Register all of our Command and Query handlers in the application IEnumerable <Type> commandHandlerTypes = typeof(CreateNewTeamCommandHandler).Assembly.GetTypes() .Where(x => typeof(ICommandHandler).IsAssignableFrom(x)); IEnumerable <Type> queryHandlerTypes = typeof(GetAllTeamsQueryHandler).Assembly.GetTypes() .Where(x => typeof(IQueryHandler).IsAssignableFrom(x)); container.RegisterAll <ICommandHandler>(commandHandlerTypes); container.RegisterAll <IQueryHandler>(queryHandlerTypes); //Register the command and query dispatcher container.Register <ICommandAndQueryDispatcher, CommandAndQueryDispatcher>(); container.Verify(); dispatcher = container.GetInstance <ICommandAndQueryDispatcher>(); db = container.GetInstance <ApplicationDb>(); userManager = container.GetInstance <UserManager <ApplicationUser> >(); context.TeamController = new TeamController(dispatcher); context.HomeController = new HomeController(dispatcher); context.Dispatcher = dispatcher; context.UserManager = userManager; context.Db = db; }
public AdminRepo(ApplicationDb db, UserManager <ApplicationUser> userManager, RoleManager <ApplicationRole> roleManager, IHostingEnvironment host) { _db = db; _userManager = userManager; _roleManager = roleManager; _host = host; }
public AuthController(IConfiguration configuration, ApplicationDb db) { _configuration = configuration; var d = User; _db = db; }
public IActionResult DeleteCategory(int key) { Category category = GetCategories().FirstOrDefault(x => x.CategoryId == key); ApplicationDb.Categories.Remove(category); ApplicationDb.SaveChanges(); return(Ok()); }
public void Add(SysSignalROnline item) { using (var db = new ApplicationDb()) { db.SysSignalROnlines.Add(item); db.SaveChanges(); } }
public void Add(SysLog item) { using (var db = new ApplicationDb()) { db.SysLogs.Add(item); db.SaveChangesAsync().Wait(); } }
public IActionResult DeleteRecurringTransfer(int key) { RecurringTransfer recurringTransfer = GetRecurringTransfers().FirstOrDefault(x => x.RecurringTransferId == key); ApplicationDb.RecurringTransfers.Remove(recurringTransfer); ApplicationDb.SaveChanges(); return(Ok()); }
public void Add(SysSignalR item) { using (var db = new ApplicationDb()) { db.SysSignalRs.Add(item); db.SaveChanges(); } }
private void CreateActivities(ApplicationDb context, List <Activity> activities) { foreach (var activity in activities) { context.Activities.Add(activity); } context.SaveChanges(); }
public IActionResult DeleteTransfer(int key) { Transfer transfer = GetTransfers().FirstOrDefault(x => x.TransferId == key); ApplicationDb.Transfers.Remove(transfer); ApplicationDb.SaveChanges(); return(Ok()); }
public AdminController(UserManager <ApplicationUser> secMgr, SignInManager <ApplicationUser> loginManager, ApplicationDb db, IHostingEnvironment environment, IHttpContextAccessor contextAccessor) { _contextAccessor = contextAccessor; _environment = environment; _securityManager = secMgr; _loginManager = loginManager; _db = db; }
public IActionResult RemoveData() { ApplicationDb.BalanceReports.RemoveRange(GetBalanceReports()); ApplicationDb.Transfers.RemoveRange(GetTransfers()); ApplicationDb.RecurringTransfers.RemoveRange(GetRecurringTransfers()); ApplicationDb.Categories.RemoveRange(GetCategories()); ApplicationDb.SaveChanges(); return(Ok()); }
private async Task BackgroundProcessing(CancellationToken stoppingToken, IProductService productService, ApplicationDb context) { while (!stoppingToken.IsCancellationRequested) { var dequeuedProduct = await TaskQueue.DequeueAsync(stoppingToken); await Task.Delay(TimeSpan.FromSeconds(5), stoppingToken); try { while (dequeuedProduct != null) { if (context.Products.Count(p => p.ProductState == ProductState.Idle) == 0) { continue; } if (context.Companies.Count(s => s.CompanyState == CompanyState.Processing || s.CompanyState == CompanyState.Idle) != 0) { continue; } if (dequeuedProduct == null) { _logger.LogError("Something went wrong with background product parser"); throw new NullReferenceException(); } try { await productService.InsertProductPageIntoDb(dequeuedProduct); } catch (TooManyRequestsException) { dequeuedProduct.ProductState = ProductState.Failed; _logger.LogError( $"Product with id \"{dequeuedProduct.Id}\" couldn't be updated. Blocked by service provider."); } await _productsHub.Clients.All.ReceiveMessage( $"Product with name id: {dequeuedProduct.ExternalId} was updated successfully"); _logger.LogInformation( $"Product with name id: {dequeuedProduct.ExternalId} was updated successfully"); dequeuedProduct = null; } } catch (Exception ex) { _logger.LogError(ex, "Error occurred in BackgroundProductControllerWorker."); } } }
public void Remove(Expression<Func<SysSignalROnline, bool>> where) { using (var db = new ApplicationDb()) { foreach (var item in db.SysSignalROnlines.Where(where)) { db.SysSignalROnlines.Remove(item); } db.SaveChanges(); } }
public void DeleteExpiredData() { using (var db = new ApplicationDb()) { //只保留一定数量的日志,根据web.config中的设置值,默认单位:天。 if (ConfigurationManager.AppSettings["LogValidity"] != null) { double logValidity = Convert.ToDouble(ConfigurationManager.AppSettings["LogValidity"]); DateTime createddatetime = DateTime.Now.AddDays(-logValidity); foreach (SysLog item in db.SysLogs.Where(a => a.CreatedDate < createddatetime)) { db.SysLogs.Remove(item); } } db.SaveChangesAsync().Wait(); } }
public ApplicationDb GetDbSession() { return _dataContext ?? (_dataContext = new ApplicationDb()); }
public IQueryable<SysSignalROnline> GetAll() { var db = new ApplicationDb(); return db.SysSignalROnlines; }
public IQueryable<SysLog> GetAll() { var db = new ApplicationDb(); return db.SysLogs.OrderByDescending(a => a.CreatedDate); }
public IQueryable<SysSignalR> GetAll(string groupId) { var db = new ApplicationDb(); return db.SysSignalRs.Where(a => a.EnterpriseId == _IUserInfo.EnterpriseId && a.GroupId.Equals(groupId) && (a.UserId == _IUserInfo.UserId || !a.UserId1.HasValue || a.UserId1 == _IUserInfo.UserId)).OrderByDescending(a => a.CreatedDate); }
public UnitOfWork(IDatabaseFactory databaseFactory) { _dataContext = databaseFactory.Get(); }