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!");
}
