public static void InsertUpdateSeedData(string connectionString)
{
using (var context = new EyeAssetDbContext(connectionString))
{
context.Database.EnsureCreated();
var apps = context.Apps.ToList();
if (apps == null)
{
context.Apps.AddRange(AppData);
}
else
{
for (int i = 0; i < AppData.Count; i++)
{
var existing = apps.FirstOrDefault(x => x.Id == AppData[i].Id);
if (existing == null)
{
context.Apps.Add(AppData[i]);
}
else
{
if (existing.Name != AppData[i].Name)
{
existing.Name = AppData[i].Name;
context.Entry(existing).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
}
}
}
var operators = context.MobileOperators.ToList();
if (operators == null)
{
context.MobileOperators.AddRange(Operators);
}
else
{
for (int i = 0; i < Operators.Count; i++)
{
var existing = operators.FirstOrDefault(x => x.Id == Operators[i].Id);
if (existing == null)
{
context.MobileOperators.Add(Operators[i]);
}
else
{
if (existing.Name != Operators[i].Name)
{
existing.Name = Operators[i].Name;
context.Entry(existing).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
}
}
}
context.SaveChanges();
}
}
public MobileOperatorPackagesRepository(EyeAssetDbContext context)
{
_context = context;
}
public AppRepository(EyeAssetDbContext context)
{
_context = context;
}
public SimCardRepository(EyeAssetDbContext context)
{
_context = context;
}
public UserRepository(EyeAssetDbContext context)
{
_context = context;
}
public AttachmentLogRepository(EyeAssetDbContext context)
{
_context = context;
}
public AttachmentRepository(EyeAssetDbContext context, IAttachmentLogRepository logRepository)
{
_context = context;
_logRepository = logRepository;
}
