public void DataFromFileToDb(string filePath)
{
using var dbContext = new AppDbContext();
using IRepository <Client> clientRepository = new ClientRepository(dbContext, SyncObjContainer.ClientsLocker);
using IRepository <Manager> managerRepository = new ManagerRepository(dbContext, SyncObjContainer.ManagersLocker);
using IRepository <Product> productRepository = new ProductRepository(dbContext, SyncObjContainer.ProductsLocker);
ISalesRepository salesRepository = new SalesRepository(dbContext, SyncObjContainer.SalesLocker);
var csvDataContainer = CsvParcer.GetDataFromCsv(filePath);
var manager = managerRepository.Get(CsvParcer.GetManagerSurname(filePath));
var sales = new List <Sales>();
foreach (var item in csvDataContainer)
{
var sale = new Sales()
{
Product = productRepository.Get(item.Product),
Client = clientRepository.Get(item.Client),
Manager = manager,
SaleCost = item.SaleSum,
SaleDate = item.SaleDate
};
sales.Add(sale);
}
salesRepository.AddSales(sales);
}
public bool AddSales(Sales sales)
{
return(_salesRepository.AddSales(sales));
}
