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