public List <ICustomer> GetAllCustomer(IProduct product) { var customers = new List <ICustomer>(); if (product?.Id != null) { var sql = $"SELECT Customer.[Id], Customer.[FirstName], Customer.[LastName]" + $"FROM CustomerLikesProduct " + $"INNER JOIN Customer ON CustomerLikesProduct.CustomerId = Customer.Id " + $"WHERE CustomerLikesProduct.ProductId = @ProductId"; Query(sql, (command) => { command.Parameters.Add(new SqlParameter("ProductId", product.Id)); var reader = command.ExecuteReader(); while (reader.Read()) { customers.Add(CustomerDbManager.CreateCustomerFromSqlReader(reader)); } }); } return(customers); }
public static void Main(string[] args) { MainWindow.Width = 115; MainWindow.Height = 25; MainWindow.StartRender(); string connectionString; var input = MainWindow.GetInputWithQuestion("Vill du koppla upp mot Azure?").ToLower(); if (input == "ja" || input == "azure") { connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Kundregister"] .ConnectionString; } else { connectionString = "Server = localdb/mssqllocaldb; Database=KundregisterAndreasOVictor; Trusted Connection = true; UID = CustomerWriter; PWD = 1234test_!"; } _customerDbManager = new CustomerDbManager(connectionString); _productDbManager = new ProductDbManager(connectionString); var customerGui = new CustomerGui(MainWindow); var productGui = new ProductGui(MainWindow); var running = true; var mainQuestion = new Question("Vad vill du göra", "Administrera en kund,Kund", "Administrera en produkt,Produkt", "Rensa skärmen,CLS", "Avsluta,Quit,Exit"); while (running) { try { input = MainWindow.GetInputWithQuestion(mainQuestion); if (input == "Administrera en kund") { customerGui.Administrate(); } else if (input == "Administrera en produkt") { productGui.Administrate(); } else if (input == "Rensa skärmen") { MainWindow.Clear(); } else if (input == "Avsluta") { running = false; } MainWindow.AddSeparator(); } catch (Exception e) { MainWindow.ErrorMessage(e.Message); } } MainWindow.PressAnyKeyToContinue(); MainWindow.Abort(); }