public void InsertData() { CliniqueDbContextFactory cliniqueDbContextFactory = new CliniqueDbContextFactory("Data Source=(localdb)\\MSSQLlocalDB;Integrated Security=True;Database=Clinic;"); using (CliniqueDbContext context = new CliniqueDbContextFactory().CreateDbContext()) { IDataService <Specialite> dataService = new GenericDataService <Specialite>(cliniqueDbContextFactory); dataService.Create(new Specialite { Titre = "Cardiologie", Description = "Traite les troubles du cœur" }).Wait(); dataService.Create(new Specialite { Titre = "Dermatologie", Description = "Traite la peau, les muqueuses et les phanères" }).Wait(); dataService.Create(new Specialite { Titre = "Gastroentérologie", Description = "Traite le système digestif et ses maladies" }).Wait(); dataService.Create(new Specialite { Titre = "Gériatrie", Description = "Traite les personnes agées" }).Wait(); dataService.Create(new Specialite { Titre = "Hématologie", Description = "Traite le sang et ses maladies" }).Wait(); dataService.Create(new Specialite { Titre = "Neurochirurgie", Description = "Chirurgie du système nerveux" }).Wait(); dataService.Create(new Specialite { Titre = "Ophtalmologie", Description = "Traite les maladies de l'œil et de ses annexes" }).Wait(); dataService.Create(new Specialite { Titre = "Pédiatrie", Description = "Traite le développement physiologique de l'enfant" }).Wait(); dataService.Create(new Specialite { Titre = "Pneumologie", Description = "Traite les pathologies respiratoires" }).Wait(); dataService.Create(new Specialite { Titre = "Rhumatologie", Description = "Traite les maladies de l'appareil locomoteur" }).Wait(); dataService.Create(new Specialite { Titre = "Stomatologie", Description = "Traite les troubles bucaux dentaires" }).Wait(); dataService.Create(new Specialite { Titre = "Orthopédie", Description = "Traite les troubles du squelette, des muscles et des tendons" }).Wait(); dataService.Create(new Specialite { Titre = "Gynécologie", Description = "Traite les troubles liés aux organes génitaux" }).Wait(); dataService.Create(new Specialite { Titre = "Urologie", Description = "Traite les troubles de l'appareil urinaire" }).Wait(); dataService.Create(new Specialite { Titre = "Obstétrie", Description = "Traite les troubles liés à la grossesse et à l'accouchement" }).Wait(); dataService.Create(new Specialite { Titre = "Traumatologie", Description = "Traite les blessures et les suites d'accidents" }).Wait(); dataService.Create(new Specialite { Titre = "Otorhinolaryngologie", Description = "Traite les troubles liés aux maladies de l'oreille, du nez et de la gorge" }).Wait(); } }
protected override void OnModelCreating(ModelBuilder modelBuilder) { var assembly = GenericDataService.GetGenericAssembly(); var mainEntityTypes = assembly .GetTypes() .Where(x => x.BaseType is { } && x.BaseType == typeof(AbstractEntity));
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new DbContextOptionsFactory()); Console.WriteLine(userService.Delete(2)); Console.ReadLine(); }
static void DatabaseTest() { IDataService <User> svc = new GenericDataService <User>(new EF.SimpleTraderDbContextFactory()); Console.WriteLine(svc.Create(new User { Username = "******", Email = "*****@*****.**", //Password = "******", DateJoined = DateTime.Now } )); Console.WriteLine(svc.Create(new User { Username = "******", Email = "*****@*****.**", //Password = "******", DateJoined = DateTime.Now } )); //GET ONE Console.WriteLine(svc.GetOne(1).Result); //GET ALL Console.WriteLine(svc.GetAll().Result); //UPDATE //REMOVE Console.ReadKey(); }
public void Add_AddSingleProduct(string productName) { //Arrange var options = new DbContextOptionsBuilder <OnlineFishShopDbContext>() .UseInMemoryDatabase(databaseName: "Add_writes_to_database") .Options; Product product = new Product(); product.Name = productName; // Act using (var context = new OnlineFishShopDbContext(options)) { context.Database.EnsureDeleted(); var service = new GenericDataService <Product>(context); service.Add(product); } // Assert using (var context = new OnlineFishShopDbContext(options)) { Assert.Equal(1, context.Products.Count()); Assert.Equal(productName, context.Products.Single().Name); } }
/*public bool LoginUser() * { * IDataService<User> users = new GenericDataService<User>(new StoreDbContextFactory()); * User user = users.Get((u) => u.UserName.Equals(_UserName) && u.Password.Equals(Incoder(_Password, _UserName))); * if (user == null) * return false; * else * { * Globals.Session.Instance.User = user; * return true; * } * * * }*/ public void LoginUser() { if (!string.IsNullOrEmpty(_UserName) && !string.IsNullOrEmpty(_Password)) { IDataService <User> users = new GenericDataService <User>(new StoreDbContextFactory()); User user = users.Get((u) => u.UserName.Equals(_UserName) && u.Password.Equals(Incoder(_Password, _UserName))); if (user == null) { ValidationMessage = "Wrong Password or Username !"; } else { CustomPrincipal customPrincipal = Thread.CurrentPrincipal as CustomPrincipal; if (customPrincipal == null) { throw new ArgumentException("The application's default thread principal must be set to a CustomPrincipal object on startup."); } customPrincipal.CustomIdentity = new CustomIdentity(user.UserName, user); MainWindow main = new MainWindow(); main.Show(); //return true; } } else { ValidationMessage = "Empty Password or Username !"; } }
private void DeleteTaskButton_Click(object sender, RoutedEventArgs e) { var taskModel = (TaskModel)this.DataContext; if (taskModel != null) { IDataService <TaskModel> taskService = new TaskDataService(new TodoAppDbContextFactory()); GenericDataService <Tag> tagService = new GenericDataService <Tag>(new TodoAppDbContextFactory()); GenericDataService <TaskTag> taskTagService = new GenericDataService <TaskTag>(new TodoAppDbContextFactory()); taskService.Delete(taskModel.Id); TodoAppMainWindow window = (TodoAppMainWindow)Application.Current.MainWindow; if (window.DataContext is TasksViewModel) { TasksViewModel vm = (TasksViewModel)window.DataContext; vm.Navigator.UpdateCurrentViewModelCommand.Execute(ViewType.Tasks); Window current = Window.GetWindow(this); current.Close(); } } }
public void ShouldUpdateItems() { var db = VashiteKinti.Tests.Tests.GetDatabase(); var item1 = new Bank() { Name = "ProCreditBank", }; var item2 = new Bank() { Name = "DSK", }; var items = new GenericDataService <Bank>(db); items.Add(item1, item2); item1.Name = "Updated"; items.Update(item1); var editItem = db.Banks.FirstOrDefault(x => x.Name == item1.Name); Assert.Equal(item1.Name, editItem.Name); }
public void ShouldSearchDeposit() { var db = VashiteKinti.Tests.Tests.GetDatabase(); var item = new Bank() { Name = "ProCredit" }; var item1 = new Deposit() { Name = "ProCreditDeposit", CreditOpportunity = YesNoDoesntMatter.YES, Bank = item, Currency = Currency.BGN, ExtraMoneyPayIn = YesNoDoesntMatter.DOESNT_MATTER, InterestType = InterestType.FIXED, Size = 2, Period = 6, Holder = DepositHolder.INDIVIDUAL, OverdraftOpportunity = YesNoDoesntMatter.YES, }; var items = new GenericDataService <Bank>(db); db.Deposits.Add(item1); db.Banks.Add(item); var result = items.SearchDepositsByCriterias(2, "BGN", "6", "10", "INDIVIDUAL", "FIXED", "DOESNT_MATTER", "YES", "YES"); Assert.NotNull(result.Result); }
private async void FuncToCall5(object context) { if (NewSeriesName == null || NewSeriesName == "") { MessageBox.Show("You must enter a series name."); } else { TestSeries checkTestSeries = Context.TestSeries.Where(t => t.TestSeriesName == NewSeriesName).FirstOrDefault(); if (checkTestSeries == null) { IDataService <TestSeries> service = new GenericDataService <TestSeries>(); await service.Create(new TestSeries() { TestSeriesName = NewSeriesName }); _ = GetAllTestSeries(); NewSeriesName = null; } else { MessageBox.Show("A test series by this name already exists."); } } }
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new CashMachineDbContextFactory()); //userService.Create(new User {Name="Dmytro", Email="*****@*****.**", NameInUkrainianLanguage="Дмитро", Password="******" }).Wait(); //Console.WriteLine(userService.Update(2,new User {Id=1, Name = "Dmytro", Email = "*****@*****.**", NameInUkrainianLanguage = "Дмитро", Password ="******" }).Result); //Console.WriteLine(userService.Get(2).ToString()); }
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new SimpleTraderDbContextFactory()); Console.WriteLine(userService.Delete(1).Result); //userService.Create(new User { Username = "******" }).Wait(); Console.ReadLine(); }
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new SimpleTraderDbContextFactory()); userService.Create(new User { Username = "******" }).Wait(); }
static void Main(string[] args) { IDataService <User> usersService = new GenericDataService <User>(new SimpleTraderDbContextFactory()); Console.WriteLine(usersService.Update(3, new User { Username = "******" }).Result); Console.ReadKey(); }
public void UpdateTagsList() { GenericDataService <Tag> tagService = new GenericDataService <Tag>(new TodoAppDbContextFactory()); Tags = tagService.GetAllItems(); Console.WriteLine(Tags.Count); }
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new TaskManagementDbContext()); Console.WriteLine(userService.Create(new User { Username = "******" }).Result); Console.ReadLine(); }
public void UpdateTest() { IDataService <BaseAccount> accountService = new GenericDataService <BaseAccount>(new ChatClientDbContextFactory()); accountService.Update(2, new BaseAccount() { PublicId = 421, Username = "******" }); }
static async Task Main(string[] args) { DbContextOptionsBuilder options = new DbContextOptionsBuilder <InventoryManagerDbContext>(); options.UseSqlite(@"Data Source=InventoryManager.db;"); using (InventoryManagerDbContext context = new InventoryManagerDbContext(options.Options)) { context.Database.Migrate(); } Action <DbContextOptionsBuilder> configureDbContext = o => o.UseSqlite(@"Data Source=InventoryManager.db;"); InventoryManagerDbContextFactory contextFactory = new InventoryManagerDbContextFactory(configureDbContext); IDataService <Container> dataService = new GenericDataService <Container>(contextFactory); ItemDefinition item1 = new ItemDefinition() { id = CreateGuid(), Name = "Test Item of Valor", Weight = 1 }; ItemDefinition item2 = new ItemDefinition() { id = CreateGuid(), Name = "Test Item of Valor", Weight = 1 }; ItemDefinition item3 = new ItemDefinition() { id = CreateGuid(), Name = "Test Item of Valor", Weight = 1 }; List <StorableItem> containerItems = new List <StorableItem>(); containerItems.Add(new ContainerItem() { id = CreateGuid(), ItemDefinition = item1, Quantity = 3 }); containerItems.Add(new ContainerItem() { id = CreateGuid(), ItemDefinition = item2, Quantity = 5 }); containerItems.Add(new ContainerItem() { id = CreateGuid(), ItemDefinition = item3, Quantity = 1 }); Container container = new Container() { id = CreateGuid(), Inventory = containerItems }; container.ItemDefinition.Name = "Test Container"; container.ItemDefinition.Weight = 3; var thing = await dataService.Create(container); var newthing = await dataService.Get(thing.id); Console.WriteLine("Great success!"); }
static void BuyStockTest() { IStockService stockPriceService = new StockService(); IDataService <Account> accountService = new GenericDataService <Account>(new EF.SimpleTraderDbContextFactory()); IBuyStockService buyStockService = new BuyStockService(stockPriceService, accountService); Account account = accountService.GetOne(1).Result; // x账户 买 AAPL 股票 2份 buyStockService.BuyStock(account, "AAPL", 2); }
public void CreateTest() { IDataService <BaseAccount> accountService = new GenericDataService <BaseAccount>(new ChatClientDbContextFactory()); accountService.Create(new BaseAccount() { PublicId = 421, Username = "******" }).Wait(); //Assert.AreNotEqual(accountService.Delete(2), true); }
public bool IsInRole(string RoleName) { IDataService <UserRoles> Table = new GenericDataService <UserRoles>(new StoreDbContextFactory()); UserRoles userRole = Table.Get((r) => r.UserId.Equals(User.Id) && r.Role.RoleName.Equals(RoleName)); if (userRole == null) { return(false); } return(true); }
public User AuthenticateUser(string _UserName, string _Password) { IDataService <User> users = new GenericDataService <User>(new StoreDbContextFactory()); User user = users.Get((u) => u.UserName.Equals(_UserName) && u.Password.Equals(CalculateHash(_Password, _UserName))); if (user == null) { throw new UnauthorizedAccessException("Access denied. Please provide some valid credentials."); } return(user); }
static void Main(string[] args) { IDataService <User> userService = new GenericDataService <User>(new CookieShopDbContextFactory()); //Console.WriteLine(userService.GetAll().Result.Count()); Console.WriteLine(userService.Update(1, new User() { Username = "******" }).Result); Console.ReadLine(); }
static void Main(string[] args) { var dbContext = new SimpleTraderDbContextFactory(); var userService = new GenericDataService <User>(dbContext); Task.Run(() => { User user = userService.Create(new User { UserName = "******" }).Result; Console.WriteLine(user.Id); Console.ReadKey(); }).Wait(); }
static void Main(string[] args) { IDataService <User> userTesting = new GenericDataService <User>(new DBContextOptionsFactory()); for (int id = 1; id < 10; id++) { CreateUserTestMethod(userTesting, "NewUser" + id); } Console.WriteLine(userTesting.Get(2).Result); GetUserTestMethod(userTesting, 4); UpdateUserTestMethod(userTesting, 6, "RandomName"); DeleteUserTestMethod(userTesting, 4); Console.ReadKey(); }
static void Main(string[] args) { IData <User> userService = new GenericDataService <User>(new DesingTimeDbContextFactory()); //Console.WriteLine( userService.GetAll().Result.Count()); //userService.Create(new User { username = "******" }).Wait(); //Console.WriteLine(userService.GetByID(1).Result); //Console.WriteLine(userService.Update(1, new User() { email ="*****@*****.**", username ="******" }).Result); Console.WriteLine(userService.Delete(1).Result); Console.ReadLine(); }
private void TaskSaverButtonClick(object sender, RoutedEventArgs e) { IDataService <TaskItem> taskItem = new GenericDataService <TaskItem>(new ToDoAppDbContextFactory()); taskItem.Create(new TaskItem { TaskName = this.taskNameTextBox.Text, TaskDescription = this.taskDescriptionTextBox.Text, TaskDate = this.TaskDataPicker.SelectedDate }); MainWindow.DataContext = new TaskListView(); MainWindow.UpdateTasksList(); this.Close(); MainWindow.UpdateTasksList(); }
public void InsertData4() { CliniqueDbContextFactory cliniqueDbContextFactory = new CliniqueDbContextFactory("Data Source=(localdb)\\MSSQLlocalDB;Integrated Security=True;Database=Clinic;"); using (CliniqueDbContext context = new CliniqueDbContextFactory().CreateDbContext()) { IDataService <Docteur> dataServiceDocteur = new GenericDataService <Docteur>(cliniqueDbContextFactory); dataServiceDocteur.Create(new Docteur { NomM = "Montoya", PrenomM = "Nicole", IdSpecialite = 1, Ville = "Québec", Adresse = "833-4306 Est Av.", Niveau = Niveau.Docteur, NbrPatients = 40 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Miles", PrenomM = "Danielle", IdSpecialite = 2, Ville = "Montréal", Adresse = "P.O. Box 465, 5736 Aenean Av.", Niveau = Niveau.Docteur, NbrPatients = 50 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Shannon", PrenomM = "Blaze", IdSpecialite = 3, Ville = "Mascouche", Adresse = "1731 Cras St.", Niveau = Niveau.Docteur, NbrPatients = 43 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Barrera", PrenomM = "Lareina", IdSpecialite = 4, Ville = "Montréal", Adresse = "517-1700 Sem, Street", Niveau = Niveau.Interne, NbrPatients = 44 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Anderson", PrenomM = "Sonny", IdSpecialite = 5, Ville = "Trois-Rivière", Adresse = "Ap #340-4959 Quisque Road", Niveau = Niveau.Interne, NbrPatients = 65 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Wallas", PrenomM = "Cody", IdSpecialite = 6, Ville = "Laval", Adresse = "1914 Sollicitudin St.", Niveau = Niveau.Interne, NbrPatients = 68 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Stevenson", PrenomM = "Laith", IdSpecialite = 7, Ville = "Montréal", Adresse = "Ap #566-2023 Tincidunt, St.", Niveau = Niveau.Interne, NbrPatients = 89 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Lang", PrenomM = "Illi", IdSpecialite = 8, Ville = "Rosemère", Adresse = "P.O. Box 631, 9962 Arcu Avenue", Niveau = Niveau.Interne, NbrPatients = 23 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Coleman", PrenomM = "Julia", IdSpecialite = 9, Ville = "Québec", Adresse = "567-8654 Tellus Av.", Niveau = Niveau.Etudiant, NbrPatients = 42 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Nixon", PrenomM = "Porter", IdSpecialite = 10, Ville = "Montréal", Adresse = "Ap #564-9965 Suspendisse Ave", Niveau = Niveau.Etudiant, NbrPatients = 44 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Osborn", PrenomM = "Gregory", IdSpecialite = 11, Ville = "Terrebonne", Adresse = "901 Morbi Avenue", Niveau = Niveau.Etudiant, NbrPatients = 32 }).Wait(); dataServiceDocteur.Create(new Docteur { NomM = "Bonner", PrenomM = "Kevyn", IdSpecialite = 12, Ville = "Boisbriand", Adresse = "Ap #579-9669 Tempor St.", Niveau = Niveau.Etudiant, NbrPatients = 18 }).Wait(); } }
public void Add_AddMultipleProductsAtOnce() { //Arrange var options = new DbContextOptionsBuilder <OnlineFishShopDbContext>() .UseInMemoryDatabase(databaseName: "Add_writes_to_database") .Options; Product product1 = new Product(); product1.Name = "First"; Product product2 = new Product(); product2.Name = "Second"; Product product3 = new Product(); product3.Name = "Third"; List <Product> all = new List <Product>(); all.Add(product1); all.Add(product2); all.Add(product3); // Act using (var context = new OnlineFishShopDbContext(options)) { context.Database.EnsureDeleted(); var service = new GenericDataService <Product>(context); service.Add(all.ToArray()); } // Assert using (var context = new OnlineFishShopDbContext(options)) { Product first = context.Products.Where(p => p.Name == "First").FirstOrDefault(); Product second = context.Products.Where(p => p.Name == "Second").FirstOrDefault(); Product third = context.Products.Where(p => p.Name == "Third").FirstOrDefault(); Assert.Equal(3, context.Products.Count()); Assert.NotNull(first); Assert.NotNull(second); Assert.NotNull(third); } }
static void Main(string[] args) { // It testing Services and // DB testing IDataService <User> service = new GenericDataService <User>(new TraderDbContext()); // service.Create(new User() { UserName = "******" }).Wait(); service.Delete(3).Wait(); service.Delete(2).Wait(); var res = service.GetAll(); foreach (var item in res.Result) { Console.WriteLine("UserName: {0}", item.Id); } Console.WriteLine("Hello World!"); }