/// <summary> /// Loads the PageSize into CurrentPageItems /// </summary> /// <param name="dbAccess"></param> void IDataPager <T> .LoadPage(DbAccessLayer dbAccess) { SyncHelper(CurrentPageItems.Clear); TotalItemCount = CommandQuery.CountInt().FirstOrDefault(); MaxPage = (int)Math.Ceiling((decimal)TotalItemCount / PageSize); RaiseNewPageLoading(); var elements = CommandQuery.AsPagedQuery(CurrentPage, PageSize).ToArray(); //var elements = new SelectQuery<T>(dbAccess.Query() // .WithCte(new ElementProducer<T>(CommandQuery // .AsPagedQuery(CurrentPage, PageSize)), // out var commandCte) // .Select // .Identifier<T>(commandCte)) // .ToArray(); foreach (var item in elements) { var item1 = item; SyncHelper(() => CurrentPageItems.Add(item1)); } RaiseNewPageLoaded(); }
public async Task SearchSessions(CommandContext ctx, [RemainingText] CommandQuery query) { string account = query.GetString("account", null); string character = query.GetString("character", null); string uuid = query.GetString("uuid", null); string ip = query.GetString("ip", null); await SearchSessions(ctx, account, character, ip, uuid); }
public void SuccessUpdateCustomer() { var vm = new UpdateCustomerCommandEx().GetExamples(); ICommandQuery commandQuery = new CommandQuery(_appSettings); var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <UpdateCustomerCommand>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); var result = new CustomerController(mediator.Object, _mapper).UpdateCustomer(vm); Assert.IsType <OkObjectResult>(result.Result); }
public void SuccessAuthenticateUser() { var vm = new AuthenticateUserCommandEx().GetExamples(); ICommandQuery commandQuery = new CommandQuery(_appSettings); var customer = new Customer(1, 1, "MY NAME", "MY ADDRESS"); //customer.SetUser(new User(1, vm.Email, vm.Password, true)); commandQuery.SetData(customer); var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <AuthenticateUserCommand>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); var result = new UserController(mediator.Object, _mapper).AuthenticateUser(vm); Assert.IsType <OkObjectResult>(result.Result); }
public void SuccessPizzasCalculatingValuesPizza() { var vm = new RequestGetQueryEx().GetExamples(); ICommandQuery commandQuery = new CommandQuery(_appSettings); var request = new Request(1, DateTime.Now, Guid.NewGuid(), 1, 50, 1, "MY ADDRESS", true); request.AddRequestPizza(new RequestPizza(1, 1, 1, 1, 1, 10, true)); commandQuery.SetData(request); var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <RequestGetQuery>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); var result = new RequestController(mediator.Object, _mapper).GetRequest(vm); Assert.IsType <OkObjectResult>(result.Result); }
public void SuccessRequestHistory() { ICommandQuery commandQuery = new CommandQuery(_appSettings); var requests = new List <RequestHistoryPizza>(); var pizza1 = new RequestHistoryPizzaInfo("PIZZA FIRST HALF", 25); var pizza2 = new RequestHistoryPizzaInfo("PIZZA SECOND HALF", 35); requests.Add(new RequestHistoryPizza(pizza1, pizza2, 5, 35)); commandQuery.SetData(requests); var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <RequestHistoryQuery>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); var result = new RequestController(mediator.Object, _mapper).GetHistory(1); Assert.IsType <OkObjectResult>(result.Result); }
public void SuccessGetPizzas() { var vm = new PizzaGetQueryEx().GetExamples(); ICommandQuery commandQuery = new CommandQuery(_appSettings); var pizza = new Pizza(1, "SOME PIZZA", 50, true); var pizzas = new List <Pizza>(); pizzas.Add(pizza); commandQuery.SetData(pizzas); var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <PizzaGetQuery>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); var result = new PizzaController(mediator.Object, _mapper).GetPizza(vm); Assert.IsType <OkObjectResult>(result.Result); }
public void SuccessCreateCustomer() { var vm = new CreateCustomerCommandEx().GetExamples(); #region MOCKS RESULT ICommandQuery commandQuery = new CommandQuery(_appSettings); var customer = new Customer(1, 1, vm.Name, vm.Address); //customer.SetUser(new User(1, vm.Email, vm.Password, true)); commandQuery.SetData(customer); #endregion #region MOCKS REQUEST var mediator = new Mock <IMediator>(); mediator.Setup(s => s.Send(It.IsAny <CreateCustomerCommand>(), It.IsAny <CancellationToken>())) .Returns(Task.FromResult(commandQuery)); #endregion var result = new CustomerController(mediator.Object, _mapper).CreateCustomer(vm); Assert.IsType <OkObjectResult>(result.Result); }
public BasicLuisDialog(Activity activity) : base(new LuisService(new LuisModelAttribute( ConfigurationManager.AppSettings["LuisAppId"], ConfigurationManager.AppSettings["LuisAPIKey"], domain: ConfigurationManager.AppSettings["LuisAPIHostName"]))) { channel = activity.ChannelId; convID = activity.Conversation.Id; DbAccess db = DbAccess.GetInstanceOfDbAccess(); db.OpenConnection(); CommandQuery command = CommandQuery.GetInstanceCommandQuery(); if (command.InsertNewUser(convID, db.GetConnection())) { Debug.Print($"Inserimento dell'utente {convID} andato a buon fine!"); } else { Debug.Print($"Utente già presente!"); } db.CloseConnection(); }
public static async Task <string> InvokeRequestResponseRecommendationService(string convID) { using (var client = new HttpClient()) { var scoreRequest = new { Inputs = new Dictionary <string, List <Dictionary <string, string> > >() { }, GlobalParameters = new Dictionary <string, string>() { { "Database query", "select * " + "from users left join movie_rating on users.id_user=movie_rating.id_user " + "left join movie on movie_rating.id_movie=movie.id_movie " + "left join director_rating on director_rating.id_user=users.id_user " + "left join genre_rating on genre_rating.id_user=users.id_user " + "left join actor_rating on actor_rating.id_user=users.id_user " }, } }; const string apiKey = "WHYLuugnhW0ufiSqxPu/0ldypGKY5jMnAAfMi3ZaRm3J9VPvguR/OZpesbNPDetXofDlRG+dvfjDaWbp7JSmRg=="; // Replace this with the API key for the web service client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", apiKey); client.BaseAddress = new Uri("https://uswestcentral.services.azureml.net/subscriptions/dba37ecf66f64b7e825abc8cbd365998/services/22d1ccd130d24cb2a05dff0790245912/execute?api-version=2.0&format=swagger"); HttpResponseMessage response = await client.PostAsJsonAsync("", scoreRequest); if (response.IsSuccessStatusCode) { string result = await response.Content.ReadAsStringAsync(); Debug.Print("Result: {0}", result); //parserizzo il contenuto di result DbAccess db = DbAccess.GetInstanceOfDbAccess(); db.OpenConnection(); CommandQuery cm = CommandQuery.GetInstanceCommandQuery(); int idUser = Convert.ToInt32(cm.GetIdUserFromIdChat(convID, db.GetConnection())); string checkString = ($"{{\"User\":\"{idUser}\",\"Item 1\":\""); int indexItem = result.IndexOf(checkString); char[] arrayCharResult = result.ToCharArray(); Debug.Print($"ITEM CONSIGLIATO {arrayCharResult[indexItem+checkString.Length]}"); string suggest = cm.GetMovieNameFromId(Convert.ToInt32(arrayCharResult[indexItem + checkString.Length]), db.GetConnection()); db.CloseConnection(); return(suggest); } else { Debug.Print(string.Format("The request failed with status code: {0}", response.StatusCode)); Debug.Print(response.Headers.ToString()); string responseContent = await response.Content.ReadAsStringAsync(); Debug.Print(responseContent); } } return(null); }
public static string InsertIntoDbVlutation(Dictionary <EntityRecommendation, double?> entityScore, Dictionary <EntityRecommendation, List <string> > entityType, string convID) { DbAccess db = DbAccess.GetInstanceOfDbAccess(); db.OpenConnection(); string insert = "ok"; CommandQuery command = CommandQuery.GetInstanceCommandQuery(); if (entityType != null) { Dictionary <EntityRecommendation, List <string> > .Enumerator key = entityType.GetEnumerator(); while (key.MoveNext() && insert.Equals("ok")) { Dictionary <EntityRecommendation, double?> .Enumerator entityEnumerator = entityScore.GetEnumerator(); List <string> entityConsidered = new List <string>(); while (entityEnumerator.MoveNext()) { if (key.Current.Key.Entity.Equals(entityEnumerator.Current.Key.Entity) && !entityConsidered.Contains(entityEnumerator.Current.Key.Entity))//quando trovo l'entità { entityConsidered.Add(entityEnumerator.Current.Key.Entity); List <string> .Enumerator enumList = key.Current.Value.GetEnumerator(); string type = string.Empty; while (enumList.MoveNext()) { int rating = 0; if (entityEnumerator.Current.Value > 0.5) { rating = 1; } switch (enumList.Current) { case "movie": insert = command.InsertPreferencesMovie(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetMovieIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "actor": insert = command.InsertPrferencesActor(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetActorIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "director": insert = command.InsertPreferencesDirector(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetDirectorIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "genre": insert = command.InsertPrferencesGenre(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetGenreIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; } } enumList.Dispose(); } } } key.Dispose(); } else { Dictionary <EntityRecommendation, double?> .Enumerator entityEnumerator = entityScore.GetEnumerator(); while (entityEnumerator.MoveNext()) { int rating = 0; if (entityEnumerator.Current.Value > 0.5) { rating = 1; } switch (entityEnumerator.Current.Key.Type) { case "movie": insert = command.InsertPreferencesMovie(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetMovieIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "actor": insert = command.InsertPrferencesActor(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetActorIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "director": insert = command.InsertPreferencesDirector(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetDirectorIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; case "genre": insert = command.InsertPrferencesGenre(Convert.ToInt32(command.GetIdUserFromIdChat(convID, db.GetConnection())), Convert.ToInt32(command.GetGenreIdFromName(entityEnumerator.Current.Key.Entity, db.GetConnection())), rating, db.GetConnection()); break; } } entityEnumerator.Dispose(); } db.CloseConnection(); return(insert); }
public List <Command> GetAllCommands() { CommandQuery cq = new CommandQuery(context); return(cq.GetAll().ToList()); }
public Command GetCommand(int id) { CommandQuery cq = new CommandQuery(context); return(cq.GetById(id).FirstOrDefault()); }
private void InitializeCommandController() { _commandQuery = new CommandQuery(); }