/// <summary> /// Recupere les 5 meilleurs recettes du meilleur cdr /// </summary> /// <param name="nb"></param> /// <returns></returns> private List <Recipe> GetTop5RecipesOfBestCdr(int nb = 5, bool ofWeek = false) { RecipeCreator bestCdr = GetTop5BestCDR(1, ofWeek).First(); // recupere le meilleur cdr DDB ddb = new DDB(User.DataBase, User.Username, User.Password); BestCDRAllTB.Text = ddb.SelectClient(new string[] { "numero" }, new string[] { $"'{bestCdr.Id}'" })[0].Name; List <Recipe> recipes = GetTop5Recipes(-1); // recupere les meilleurs recettes List <Recipe> top5RecipesOfBestCdr = new List <Recipe>(); ddb.Close(); nb = (nb == -1) ? recipes.Count() : nb; int cpt = 0; while (top5RecipesOfBestCdr.Count < nb && cpt < recipes.Count) // recupre les nb premieres { if (recipes[cpt].NumberCreator.Equals(bestCdr.Id)) { top5RecipesOfBestCdr.Add(recipes[cpt]); } cpt++; } return(top5RecipesOfBestCdr); }
private void View() { DDB ddb = new DDB(User.DataBase, User.Username, User.Password); answerTextBlock.Text = ddb.SelectClient().Count().ToString(); ddb.Close(); }
private void FillCDROfTheWeek() { RecipeCreator bestCdrOfWeek = GetTop5BestCDR(1, true).First(); DDB ddb = new DDB(); CDRWeekTB.Text = ddb.SelectClient(new string[] { "numero" }, new string[] { $"'{bestCdrOfWeek.Id}'" }).First().Name; ddb.Close(); }
private Client GetClient(string numberCreator) { DDB ddb = new DDB(User.DataBase, User.Username, User.Password); Client client = ddb.SelectClient(new string[] { "numero" }, new string[] { $"'{numberCreator}'" })[0]; ddb.Close(); return(client); }
public void ClientSelect() { DDB ddb = new DDB(User.DataBase, User.Username, User.Password); List <Client> clients = ddb.SelectClient(); ddb.Close(); Assert.AreEqual(0, clients.Count); }
/// <summary> /// Pay the creator of the recipe /// </summary> /// <param name="recipe"></param> private static void PayingCDR(Recipe recipe) { DDB ddB = new DDB(User.DataBase, User.Username, User.Password); RecipeCreator recipeCreator = ddB.SelectRecipeCreator(new string[] { "numero" }, new string[] { $"'{recipe.NumberCreator}'" })[0]; Client client = ddB.SelectClient(new string[] { "numero" }, new string[] { $"'{recipeCreator.Id}'" })[0]; client.Money += recipe.IsTrending ? 4 : 2; ddB.UpdateClient(client, new string[] { "nom" }, new string[] { $"'{client}'" }); ddB.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { //Check if password is right DDB ddb = new DDB(User.DataBase, User.Username, User.Password); if (clientPasswordBox.Password == ddb.SelectClient(new string[] { "email" }, new string[] { $"'{this._email}'" })[0].Password) { User.ConnectedClient = ddb.SelectClient(new string[] { "email" }, new string[] { $"'{this._email}'" })[0]; MainWindow mainWindow = Application.Current.Windows.OfType <MainWindow>().FirstOrDefault(); if (User.ConnectedClient.UserType == Models.Enums.UserType.admin) { mainWindow.DataContext = new Admin(); } else { mainWindow.DataContext = new MainMenu(); } } }
private void LoadCDRComboBox() { DDB ddb = new DDB(User.DataBase, User.Username, User.Password); List <Client> clients = new List <Client>(); List <RecipeCreator> recipeCreators = ddb.SelectRecipeCreator(); foreach (RecipeCreator recipeCreator in recipeCreators) { clients.Add(ddb.SelectClient(new string[] { "numero" }, new string[] { $"'{recipeCreator.Id}'" })[0]); } if (clients.Count > 0) { cdrCB.ItemsSource = clients; cdrCB.SelectedIndex = 0; } ddb.Close(); }
private void LoadCDR() { DDB ddb = new DDB(User.DataBase, User.Username, User.Password); List <RecipeCreator> recipeCreators = ddb.SelectRecipeCreator(); foreach (RecipeCreator recipeCreator in recipeCreators) { string value = ddb.SelectClient(new string[] { "numero" }, new string[] { $"'{recipeCreator.Id}'" })[0].Name; List <Recipe> recipes = ddb.SelectRecipe(new string[] { "numeroCreateur" }, new string[] { $"'{recipeCreator.Id}'" }); int count = 0; foreach (Recipe recipe in recipes) { List <Order> orders = ddb.SelectOrder(new string[] { "nomRecette" }, new string[] { $"'{recipe.Name}'" }); count += orders.Count; } value += $" {count}"; contentStackPanel.Children.Add(GetTextBlock(value, new SolidColorBrush(Colors.Green), FontWeights.Bold)); } ddb.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { //check if email exists bool isExisting = false; DDB ddb = new DDB(User.DataBase, User.Username, User.Password); List <Client> clients = ddb.SelectClient(new string[] { "email" }, new string[] { $"'{EmailTextBox.Text}'" }); if (clients != null) { if (clients.Count != 0) { isExisting = true; } } if (isExisting) { this._registerOrLogin.DataContext = new Login(EmailTextBox.Text); } else { this._registerOrLogin.DataContext = new Register(EmailTextBox.Text); } }