public async Task Add_New_Records() { var autoMapperConfig = new MapperConfiguration(cfg => { cfg.AddProfile <DtoProfile>(); }); var mapper = autoMapperConfig.CreateMapper(); var options = new DbContextOptionsBuilder <AppDataContext>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; using (var dataContext = new AppDataContext(options)) { var companyDs = new CompanyDataService(dataContext, mapper); var contactDs = new ContactDataService(dataContext, mapper); var service = new DataImportService(companyDs, contactDs); using (var stringReader = new StringReader(Csv_Contacts_3)) { await service.ImportContactsAsync(stringReader, 1); } var contacts = dataContext.Contacts.ToArray(); var companies = dataContext.Companies.ToArray(); Assert.True(contacts.Length == 3); Assert.True(companies.Length == 3); } }
//public Company(int companyId,string companyName, string phoneNumber, string street, string city, // string state, string zipcode, ManagerCollection managers) // : this(companyName,phoneNumber,street,city,state,zipcode) { // this._managers = managers; // this.CompnayId = companyId; // } #endregion #region Data Access Methods public void Insert() { try { CompanyDataService dataService = new CompanyDataService(); dataService.Insert(ref _companyId, _companyName, _phoneNumber, _address, _city, _state, _zipcode); } catch { throw; } }
public static Company Load(int companyId) { try { CompanyDataService dataService = new CompanyDataService(); DataSet ds = dataService.Load(companyId); Company obj = new Company(); return(obj.MapData(ds) ? obj : null); } catch { throw; } }
/// <summary> /// Loads a the Company Objects from the Database /// </summary> /// <returns></returns> public static CompanyCollection GetAll() { try { //Create a company data Service Object CompanyDataService dataService = new CompanyDataService(); // Excute the get All Method which returns a populated DataSet DataSet ds = dataService.GetAll(); //Create A company Collection object CompanyCollection obj = new CompanyCollection(); //Add Objects from the Data Set to collections obj.MapObjects(ds); return(obj); } catch { throw; } }
public async Task Execute(string csvPath, int userId, string dbProviderName, string connectionString) { // DB Context var optionsBuilder = new DbContextOptionsBuilder <AppDataContext>(); optionsBuilder.ConfigureDbContext(dbProviderName, connectionString); // Automapper var autoMapperConfig = new MapperConfiguration(cfg => { cfg.AddProfile <DtoProfile>(); }); var mapper = autoMapperConfig.CreateMapper(); // Start execution using (var dbContext = new AppDataContext(optionsBuilder.Options)) { var companyDataService = new CompanyDataService(dbContext, mapper); var contactDataService = new ContactDataService(dbContext, mapper); var dataImportService = new DataImportService(companyDataService, contactDataService); Console.WriteLine("Importing data..."); await ImportContactsAsync(dataImportService, csvPath, userId); Console.WriteLine("Done"); } }