/// <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();
}
