public async Task <int> SeedRetailerEntitiesFromJson(string filePath)
{
if (string.IsNullOrWhiteSpace(filePath))
{
throw new ArgumentException($"Value of {filePath} must be supplied to {nameof(SeedRetailerEntitiesFromJson)}");
}
if (!File.Exists(filePath))
{
throw new ArgumentException($"The file '{filePath}' does not exist");
}
var dataSet = File.ReadAllText(filePath);
var seedData = JsonConvert.DeserializeObject <List <RetailerDbo> >(dataSet, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
// When seeding objects with links to a reference table, we need to ensure we can pass in just the id of the referenced table (in this instance: ExternalSystemId)
// Creating an object of the referenced entity will unsurprisingly create a new record in the database, breaking our intended references.
_context.Retailers.AddRange(seedData);
return(await _context.SaveChangesAsync());
}
public async Task <RequestDbo> AddOrUpdate(RequestDbo request)
{
try
{
Log.Debug($"{nameof(AddOrUpdate)} called on {nameof(RequestRepository)}");
_context.Requests.Update(request);
request.Id = await _context.SaveChangesAsync();
Log.Debug($"Request saved in method {nameof(AddOrUpdate)} called on {nameof(RequestRepository)}");
}
catch (Exception ex)
{
Debug.WriteLine(ex);
Log.Error($"Error in method {nameof(AddOrUpdate)} in {nameof(RequestRepository)}");
}
return(request);
}
public async Task <ExternalSystemDbo> AddOrUpdate(ExternalSystemDbo externalSystem)
{
try
{
Log.Debug($"{nameof(AddOrUpdate)} called on {nameof(ExternalSystemRepository)}");
_context.ExternalSystems.Update(externalSystem);
externalSystem.Id = await _context.SaveChangesAsync();
Log.Debug($"ExternalSystem saved in method {nameof(AddOrUpdate)} called on {nameof(ExternalSystemRepository)}");
}
catch (Exception ex)
{
Debug.WriteLine(ex);
Log.Error($"Error in method {nameof(AddOrUpdate)} in {nameof(ExternalSystemRepository)}");
}
return(externalSystem);
}
public async Task <StaffMemberDbo> AddOrUpdate(StaffMemberDbo staffMember)
{
try
{
Log.Debug($"{nameof(AddOrUpdate)} called on {nameof(StaffMemberRepository)}");
_context.StaffMembers.Update(staffMember);
staffMember.Id = await _context.SaveChangesAsync();
Log.Debug($"StaffMember saved in method {nameof(AddOrUpdate)} called on {nameof(StaffMemberRepository)}");
}
catch (Exception ex)
{
Debug.WriteLine(ex);
Log.Error($"Error in method {nameof(AddOrUpdate)} in {nameof(StaffMemberRepository)}");
}
return(staffMember);
}
public async Task <AreaManagerDbo> AddOrUpdate(AreaManagerDbo areaManager)
{
try
{
Log.Debug($"{nameof(AddOrUpdate)} called on {nameof(AreaManagerRepository)}");
_context.AreaManagers.Update(areaManager);
areaManager.Id = await _context.SaveChangesAsync();
Log.Debug($"AreaManager saved in method {nameof(AddOrUpdate)} called on {nameof(AreaManagerRepository)}");
}
catch (Exception ex)
{
Debug.WriteLine(ex);
Log.Error($"Error in method {nameof(AddOrUpdate)} in {nameof(AreaManagerRepository)}");
}
return(areaManager);
}
public async Task <BrandDbo> AddOrUpdate(BrandDbo brand)
{
try
{
Log.Debug($"{nameof(AddOrUpdate)} called on {nameof(BrandRepository)}");
_context.Brands.Update(brand);
brand.Id = await _context.SaveChangesAsync();
Log.Debug($"Brand saved in method {nameof(AddOrUpdate)} called on {nameof(BrandRepository)}");
}
catch (Exception ex)
{
Debug.WriteLine(ex);
Log.Error($"Error in method {nameof(AddOrUpdate)} in {nameof(BrandRepository)}");
}
return(brand);
}