public void Setup()
{
var options = new DbContextOptionsBuilder <MyFinanceContext>()
.UseInMemoryDatabase(databaseName: "MyFinanceDb")
.Options;
_myFinanceDbContext = new MyFinanceContext(options);
_expenseRepository = new ExpenseRepository(_myFinanceDbContext);
Seed(_myFinanceDbContext);
}
static void Main(string[] args)
{
MyFinanceContext ctx = new MyFinanceContext();
//Product p1 = new Product { Name = "Tomate",Description="Rouge",Quantity=2};
//ctx.Products.Add(p1);
Category c1 = new Category {
Name = "Ahmeed"
};
// ctx.Categories.Add(c1);
// ctx.SaveChanges();
Console.WriteLine("Base crée");
Console.ReadKey();
//Console du Gestionnaire de package
//generer a l'aide de Commande Enable-Migrations
//Pour Ajouter Migration : Add-Migration nom-migration
//exemple Add-Migration Adress
// Update DataBase update DataBase selon la derniére Migration
//Update DataBase TargetMigration
ServiceCategory sc = new ServiceCategory();
sc.addCategory(c1);
sc.Commit();
Console.WriteLine("Category Ajouter");
Console.ReadKey();
ServiceProduct sp = new ServiceProduct();
Product p1 = new Product();
p1.Name = "Delice";
p1.Quantity = 1;
p1.price = 1250;
p1.Category = c1;
sp.AddProduct(p1);
sc.Commit();
Console.WriteLine("Produit Ajouter");
Console.ReadKey();
}
private void Seed(MyFinanceContext context)
{
var jsonTestDataFileName = "TestData.json";
var absolutePathForDocs = Path.Combine(AppDomain.CurrentDomain.BaseDirectory + jsonTestDataFileName);
var json = File.ReadAllText(absolutePathForDocs);
var jObject = JObject.Parse(json);
var expenses = jObject["expenses"]?.ToObject <IEnumerable <Expense> >();
foreach (var expense in expenses)
{
context.Expenses.Add(expense);
}
context.SaveChanges();
foreach (var entity in context.ChangeTracker.Entries())
{
entity.State = EntityState.Detached;
}
}
public UnitOfWork(IDataBaseFactory dbfac)
{
this.dbfac = dbfac;
context = dbfac.DBcontext;
}
public MyFinanceContext Get()
{
return(dataContext ?? (dataContext = new MyFinanceContext()));
}
public ProductService()
{
ctx = new MyFinanceContext();
}
public DataBaseFactory()
{
this.context = new MyFinanceContext();
}
public ProviderRepository()
{
ctx = new MyFinanceContext();
}
public UnitOfWork(IDatabaseFactory dbFactory)
{
this.dbFactory = dbFactory;
dataContext = dbFactory.DataContext;
}
public ServiceProduct()
{
ctx = new MyFinanceContext();
}
public ProductRepository()
{
ctx = new MyFinanceContext();
}
public ProviderService()
{
ctx = new MyFinanceContext();
}
public UserService()
{
ctx = new MyFinanceContext();
}
public CategoryRepository()
{
ctx = new MyFinanceContext();
}
public RepositoryBase(MyFinanceContext ctx)
{
this._ctx = ctx;
dbset = ctx.Set <T>();
}
public CategoryService()
{
ctx = new MyFinanceContext();
}
public DatabaseFactory()
{
dataContext = new MyFinanceContext();
}
public BookService()
{
ctx = new MyFinanceContext();
}
