public void WhereClause_OptionalTestLike_ShouldFilter(string name, int count) { var applications = new ApplicationDto[] { new ApplicationDto { Name = "Name1", User = "******", DefName = "Def1" }, new ApplicationDto { Name = "Name2", User = "******", DefName = "Def2" }, new ApplicationDto { Name = "Name3", User = "******", DefName = "Def3" }, }; const string sqlInsert = "INSERT INTO application ([Name], [User], [DefName]) VALUES (@Name, @User, @DefName)"; using var connection = new MemoryDbConnection(); connection.GetMemoryDatabase().Clear(); connection.Execute(SqlStatements.SqlCreateTableApplication); connection.Execute(sqlInsert, applications); string sqlSelect = $"{SqlStatements.SqlSelectApplication} WHERE @name is NULL OR [Name] LIKE @name"; var appsQueried = connection.Query <ApplicationDto>(sqlSelect, new { name = name }).ToList(); appsQueried.Count.Should().Be(count); if (count == 1) { appsQueried.First().Name.Should().Be(name); } }
private ApplicationDto Convert(ApplicationEntity source) { var result = new ApplicationDto(); result.AppNavBarUrl = source.AppNavBarUrl; result.IsOnline = source.IsOnline; result.IsRegistered = source.IsRegistered; result.IsHealthy = source.IsHealthy; result.BackButtonUrl = source.BackButtonUrl; result.Branding = source.Branding; result.BreadcrumbsUrl = source.BreadcrumbsUrl; result.Description = source.Description; result.EntrypointUrl = source.EntrypointUrl; result.HealthCheckUrl = source.HealthCheckUrl; result.LayoutName = source.LayoutName; result.MainMenuText = source.MainMenuText; result.Name = source.Name; result.PersonalisationUrl = source.PersonalisationUrl; result.RequiresAuthorization = source.RequiresAuthorization; result.RootUrl = source.RootUrl; result.RouteName = source.RouteName; result.ShowSideBar = source.ShowSideBar; result.SidebarUrl = source.SidebarUrl; result.Title = source.Title; return(result); }
public void WhereClause_IntParameterWithCalculation_ShouldFilter( ) { var applications = new ApplicationDto[] { new ApplicationDto { Name = "Name1", User = "******", DefName = "Def1" }, new ApplicationDto { Name = "Name2", User = "******", DefName = "Def2" }, new ApplicationDto { Name = "Name3", User = "******", DefName = "Def3" }, }; const string sqlInsert = "INSERT INTO application ([Name], [User], [DefName]) VALUES (@Name, @User, @DefName)"; using var connection = new MemoryDbConnection(); connection.GetMemoryDatabase().Clear(); connection.Execute(SqlStatements.SqlCreateTableApplication); connection.Execute(sqlInsert, applications); string sqlSelect = $"{SqlStatements.SqlSelectApplication} WHERE Id = @id + 1"; int id = 0; var appsQueried = connection.Query <ApplicationDto>(sqlSelect, new { id }).ToList(); appsQueried.Count.Should().Be(1); appsQueried.First().Id.Should().Be(id + 1); }
public async Task <IActionResult> Edit(int id, ApplicationDto applicationDto) { var request = new UpdateApplicationCommand(id, applicationDto); var response = await _mediator.Send(request); return(Ok(response)); }
/// <summary> /// Gets list object of the table Application. /// </summary> /// <param name="lFilterApplication">List that contains the DTOs from Application table that filter the query.</param> /// <returns>List object of the table Application.</returns> /// <author>Mauricio Suárez.</author> public List <ApplicationDto> GetApplication(ApplicationDto dtoApplication) { List <ApplicationDto> listFilterApplication = new List <ApplicationDto>(); listFilterApplication.Add(dtoApplication); return(this.ExecuteGetApplication(null, listFilterApplication)); }
/// <summary> /// Save or update records for the table /// </summary> /// <param name="listDataApplication">List of data to store Application.</param> /// <returns>The result of processing the list.</returns> /// <author>Mauricio Suárez.</author> public bool SaveApplication(ApplicationDto dtoApplication) { List <ApplicationDto> listDataApplication = new List <ApplicationDto>(); listDataApplication.Add(dtoApplication); return(this.SaveApplication(listDataApplication)); }
public void TestInit() { _builder = new RandomBuilder(); _repository = Ioc.Create <IApplicationRepository>(); _service = Ioc.Create <IApplicationService>(); _dto = ApplicationDtoTest.Create2(Guid.Empty); }
// Update is called once per frame void Update() { // キャンセル以外の 何かボタンを押したらセレクト画面へ遷移 foreach (var player in PlayerIndexes.All) { // プレイヤーのキー押下状態を確認。 InputStateDto state = ApplicationDto.ReadInput(player); if (state.Lp.Pressing || state.Mp.Pressing || state.Hp.Pressing || state.Lk.Pressing || state.Mk.Pressing || state.Hk.Pressing || state.Pause.Pressing ) { Debug.Log($"Push key. human={player} input {state.ToDisplay()}"); CommonScript.computerFlags[player] = false; // * Configure scene. // * Click main menu [File] - [Build Settings...]. // * Double click [Assets] - [Scenes] - [Title] in project view. // * Click [Add Open Scenes] button. // * Double click [Assets] - [Scenes] - [Select] in project view. // * Click [Add Open Scenes] button. // * Double click [Assets] - [Scenes] - [Fight] in project view. // * Click [Add Open Scenes] button. // * Double click [Assets] - [Scenes] - [Result] in project view. // * Click [Add Open Scenes] button. // * Right click `Scenes/SampleScene` from `Build Settings/Scene In Build`. and Click [Remove Selection]. SceneManager.LoadScene(CommonScript.Scene_to_name[(int)SceneIndex.Select]); } } }
public async Task <IActionResult> Edit(int id, [FromBody] ApplicationDto applicationDto) { var updateApplicationCommand = new UpdateApplicationCommand(id, applicationDto); var response = await _mediator.Send(updateApplicationCommand); return(Ok(response)); }
public IActionResult Create([FromBody] ApplicationDto applicationDto) { // map dto to entity var application = _mapper.Map <Application>(applicationDto); _logger.LogInformation("Creating application: " + application.Title + " for the " + application.CandidateEmail); try { // Creates new application application.Id = Guid.NewGuid().ToString(); application.CandidateSecret = _applicationService.GetRandomNumber(1000, 9999).ToString(); application.Timestamp = DateTime.Now; application.Status = InterviuStatus.NotStarted.ToString(); application.StatusTimestamp = DateTime.Now; _applicationService.Create(application, applicationDto.TemplateId, applicationDto.UserId); return(Ok(application)); } catch (AppException ex) { // return error message if there was an exception return(BadRequest(new { message = ex.Message })); } }
public async Task WhenFindingExistingApplicationWithWrongPasswordThenNullIsReturned() { // Arrange ApplicationEntity application = new ApplicationEntity() { Id = 0, DisplayName = "TestApplicationDisplayName", PasswordHash = "TestPasswordHash", PasswordSalt = "TestPasswordSalt" }; IApplicationRepository fakeApplicationRepository = A.Fake <IApplicationRepository>(); A.CallTo(() => fakeApplicationRepository.TryGetByDisplayNameAsync("TestApplicationDisplayName")).Returns(Task.FromResult(application)); IUnitOfWork fakeUnitOfWork = A.Fake <IUnitOfWork>(); IPasswordWithSaltHasher fakePasswordHasher = A.Fake <IPasswordWithSaltHasher>(); A.CallTo(() => fakePasswordHasher.CheckPassword(A <string> .Ignored, A <string> .Ignored, A <string> .Ignored)).Returns(false); IApplicationService applicationService = new ApplicationService(fakeApplicationRepository, fakeUnitOfWork, fakePasswordHasher); // Act ApplicationDto applicationDto = await applicationService.FindApplicationAsync("TestApplicationDisplayName", "TestPassword"); // Assert Assert.IsNull(applicationDto); }
public ActionResult Edit(int id) { UpdateApplication ModelView = new UpdateApplication(); //Get the selected application from the database string url = "ApplicationData/FindApplication/" + id; HttpResponseMessage response = client.GetAsync(url).Result; if (response.IsSuccessStatusCode) { ApplicationDto SelectedApplication = response.Content.ReadAsAsync <ApplicationDto>().Result; ModelView.Application = SelectedApplication; url = "UserData/GetUsers"; response = client.GetAsync(url).Result; IEnumerable <ApplicationUserDto> SelectedUsers = response.Content.ReadAsAsync <IEnumerable <ApplicationUserDto> >().Result; ModelView.ApplicationUsers = SelectedUsers; url = "JobData/GetJobs"; response = client.GetAsync(url).Result; IEnumerable <JobDto> SelectedJobs = response.Content.ReadAsAsync <IEnumerable <JobDto> >().Result; ModelView.Jobs = SelectedJobs; return(View(ModelView)); } else { return(RedirectToAction("Error")); } }
public ActionResult Details(int id) { ShowApplication ModelView = new ShowApplication(); //Using the Show Application View Model //Find the application by Id from the database string url = "ApplicationData/FindApplication/" + id; HttpResponseMessage response = client.GetAsync(url).Result; //Response 200 code if it is ok if (response.IsSuccessStatusCode) { ApplicationDto SelectedApplication = response.Content.ReadAsAsync <ApplicationDto>().Result; ModelView.Application = SelectedApplication; //Errors n/a if it is null //Associated Application with User url = "ApplicationData/GetUserForApplication/" + id; response = client.GetAsync(url).Result; ApplicationUserDto SelectedUser = response.Content.ReadAsAsync <ApplicationUserDto>().Result; ModelView.ApplicationUser = SelectedUser; //Errors n/a if it is null //Associated application with Job url = "ApplicationData/GetJobForApplication/" + id; response = client.GetAsync(url).Result; JobDto SelectedJob = response.Content.ReadAsAsync <JobDto>().Result; ModelView.Job = SelectedJob; return(View(ModelView)); } else { return(RedirectToAction("Error")); } }
/// <summary> /// Gets list object of the table Application. /// </summary> /// <param name="paginationDto">Attributes to apply the pagination.</param> /// <param name="listFilterApplication">List that contains the DTOs from Application table that filter the query.</param> /// <returns>List object of the table Application.</returns> /// <author>Mauricio Suárez.</author> public List <ApplicationDto> GetApplication(PaginationDto paginationDto, ApplicationDto dtoApplication) { List <ApplicationDto> listFilterApplication = new List <ApplicationDto>(); listFilterApplication.Add(dtoApplication); return(this.ExecuteGetApplication(paginationDto, listFilterApplication)); }
public async Task <ActionResult <Application> > Create(ApplicationDto applicationDto) { var request = new CreateApplicationCommand(applicationDto); var response = await _mediator.Send(request); return(Ok(response)); }
public IHttpActionResult GetAllApplications() { //List of the Application from the database List <Application> Applications = db.Applications.ToList(); //Using the ShowApplication View Model List <ShowApplication> ApplicationDtos = new List <ShowApplication> { }; foreach (var Application in Applications) { ShowApplication application = new ShowApplication(); //Get the user from the OurUsers Database and link them with the application ApplicationUser ApplicationUser = db.Users .Where(c => c.Applications .Any(a => a.ApplicationId == Application.ApplicationId)) .FirstOrDefault(); ApplicationUserDto firstUser = new ApplicationUserDto { Id = ApplicationUser.Id, FirstName = ApplicationUser.FirstName, LastName = ApplicationUser.LastName, Email = ApplicationUser.Email, PhoneNumber = ApplicationUser.PhoneNumber, Address = ApplicationUser.Address, }; //Get the Job from Jobs Table and associate them with the application Job Job = db.Jobs .Where(j => j.Applications .Any(a => a.ApplicationId == Application.ApplicationId)) .FirstOrDefault(); JobDto job = new JobDto { Position = Job.Position, Category = Job.Category, Type = Job.Type, Requirement = Job.Requirement, Deadline = Job.Deadline }; ApplicationDto NewApplication = new ApplicationDto { ApplicationId = Application.ApplicationId, Comment = Application.Comment, JobId = Application.JobId, Id = Application.Id }; application.Application = NewApplication; application.Job = job; application.ApplicationUser = firstUser; ApplicationDtos.Add(application); } return(Ok(ApplicationDtos)); }
public async Task <Identity> ValidateRequestAsync(string jwt) { if (string.IsNullOrWhiteSpace(jwt)) { throw new ArgumentNullException("jwt"); } // Validate JWT JwtValidationResultDto fncConnectResult = await _jwtManager.ValidateJwtAsync(jwt).ConfigureAwait(false); ApplicationDto appInfo = fncConnectResult.JwtData.AppInfo; // check if Application is configured in EventPublisher Application application = await _repository.GetApplicationAsync(fncConnectResult.JwtData.AppInfo.ImmutableAppID).ConfigureAwait(false); if (application == null) { throw new NotAuthorizedException(string.Format("Application {0} is not configured.", appInfo.AppName)); } return(new Identity() { Id = appInfo.ImmutableAppID, Name = appInfo.AppName }); }
/// <summary> /// 转换为应用程序实体 /// </summary> /// <param name="dto">应用程序数据传输对象</param> public static Application ToEntity(this ApplicationDto dto) { if (dto == null) { return(new Application()); } return(dto.MapTo(new Application(dto.Id.ToGuid()))); }
public async Task <IActionResult> Create(ApplicationDto applicationDto) { var createApplicationCommand = new CreateApplicationCommand(applicationDto); var response = await _mediator.Send(createApplicationCommand); return(response.StatusCode == HttpStatusCode.NotFound ? (IActionResult)NotFound(response) : Ok(response)); }
public virtual void Update(String id, ApplicationDto model) { Tiantianquan.Privilege.Domain.Application application = this.ApplicationRepository.GetById(id); application.CreatedAt = model.CreatedAt; application.UpdatedAt = model.UpdatedAt; application.Name = model.Name; application.Description = model.Description; this.ApplicationRepository.Update(application); }
public async Task <FileDto> GetUsersToExcel() { try { //Below code is will fetch data for export which will change as per requirement var ApplicationList = _applicationRepository.GetAll().AsNoTracking().Include(x => x.project).ToList(); List <ApplicationDto> ApplicationDtoList = new List <ApplicationDto>(); if (ApplicationList.Count == 0) { ApplicationDto reportDto = new ApplicationDto(); ApplicationDtoList.Add(reportDto); } ApplicationDtoList = ObjectMapper.Map <List <ApplicationDto> >(ApplicationList); ApplicationDtoList.ForEach((x) => { x.ApplicationName = (x.Id != 0 && x.ApplicationName != null) ? x.ApplicationName : AppConsts.DashSymbol; x.ProjectName = (x.Id != 0 && x.project != null) ? x.project.Name : AppConsts.DashSymbol; x.Time = (x.CreationTime != null) ? x.CreationTime.ToShortDateString() : AppConsts.DashSymbol; }); var applicationSortedList = ApplicationDtoList.OrderBy(x => x.CreationTime).ToList(); // Below is File Generation code this will remain same for all export you just need to change parameter of createWorksheetForExcel method while calling. string fileName = AppConsts.ExportFilename; string path = Path.GetTempPath(); string outputFileName = _fileExportService.CreateFilePath(fileName); fileName = fileName + AppConsts.ExcelFileExtention; var file = new FileDto(fileName, AppConsts.ExcelFormat); using (SpreadsheetDocument package = SpreadsheetDocument.Create(outputFileName, SpreadsheetDocumentType.Workbook)) { _fileExportService.CreateWorksheetForExcel(package, applicationSortedList); } var memory = await _fileExportService.GenerateMemoryStream(path, fileName); _tempFileCacheManager.SetFile(file.FileToken, memory.ToArray()); //Delete generate file from server File.Delete(Path.Combine(path, fileName)); return(file); } catch { throw; } }
/// <summary> /// Creates application /// </summary> /// <param name="application">product</param> public async Task <Guid> CreateApplicationAsync(ApplicationDto application) { using (var uow = UnitOfWorkProvider.Create()) { var applicationId = applicationService.Create(application); await uow.Commit(); return(applicationId); } }
public virtual String Save(ApplicationDto model) { Tiantianquan.Privilege.Domain.Application application = new Tiantianquan.Privilege.Domain.Application(); application.Id = model.Id; application.CreatedAt = model.CreatedAt; application.UpdatedAt = model.UpdatedAt; application.Name = model.Name; application.Description = model.Description; return(this.ApplicationRepository.Save(application)); }
private async Task LoadRelatedApplicationOrDoNothing(string inGameName, CancellationToken cancellationToken) { if (!_isExistingApplicationChecked) { _existingApplication = await _mediator.Send(new ApplicationQuery { InGameName = inGameName }, cancellationToken); _isExistingApplicationChecked = true; } }
/// <summary> /// 修改应用程序 /// </summary> /// <param name="dto">应用程序参数</param> public async Task UpdateAsync(ApplicationDto dto) { var entity = dto.ToEntity(); await ValidateUpdateAsync(entity); await ApplicationRepository.UpdateAsync(entity); await UnitOfWork.CommitAsync(); }
public async Task <ActionResult> ApplicationCreate(Guid jobOfferId) { var jobOffer = await JobOfferFacade.GetJobOfferAsync(jobOfferId); var model = new ApplicationDto { JobOffer = jobOffer, JobOfferId = jobOfferId }; return(View(model)); }
/// <inheritdoc/> public Task <EmailContentDto> RenderNewApplicationContentAsync(ApplicationDto applicationDto, CancellationToken cancellationToken) { var content = new EmailContentDto() { Subject = "Система жалоб и предложений: Новая жалоба", Body = $"<p>Название: {applicationDto.Name}</p>" + $"<p>Описание: {applicationDto.Description}</p>" }; return(Task.FromResult(content)); }
public static AppPreviewViewModel MapToViewModelPreview(this ApplicationDto app) { return(new AppPreviewViewModel { Id = app.Id.ToString(), EGN = app.EGN, Name = app.Name, Phone = app.PhoneNumber, Status = app.Status }); }
public PlayStreamProxyDto(StreamProxyDto streamProxy, DomainDto domain, ApplicationDto application) : this() { this.StreamProxy = streamProxy; this.Domain = domain; this.Application = application; vHost = domain.DomainName; if (GloableCache.ZLMediaServerConfig.ContainsKey("general.enableVhost") && GloableCache.ZLMediaServerConfig["general.enableVhost"] != "1") { vHost = "__defaultVhost__"; } }
/// <summary> /// 获取 /// </summary> /// <param name="id"></param> public virtual ApplicationDto GetApplicationById(String id) { Tiantianquan.Privilege.Domain.Application application = this.ApplicationRepository.GetById(id); ApplicationDto model = new ApplicationDto(); model.Id = application.Id; model.CreatedAt = application.CreatedAt; model.UpdatedAt = application.UpdatedAt; model.Name = application.Name; model.Description = application.Description; return(model); }