public static void Initialize(IServiceProvider serviceProvider)
{
// ContactUsContext registered as a scoped service and access it here outside
// of a scope, so first create a scope and then intialize database.
using (var scope = serviceProvider.CreateScope())
{
var Provider = scope.ServiceProvider;
try
{
context = (ContactAppContext)Provider.GetService(typeof(ContactAppContext));
//automatic update DB to latest migration
//context.Database.Migrate();
//Delete & create new database.
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
InitializeSchedules();
}
catch (Exception ex)
{
var logger = serviceProvider.GetRequiredService <ILogger <ContactAppDbInitializer> >();
logger.LogError(ex, $"{Environment.NewLine}An error occurred seeding the DB ==> { ex.Message}");
}
}
}
public void DeleteDetails(int id, ContactAppContext _context)
{
var contact = _context.Contact.FirstOrDefault(t => t.ContactId == id);
if (contact != null)
{
_context.Contact.Remove(contact);
_context.SaveChanges();
}
}
public void AddDetails(ContactAppContext _context, Contact item)
{
_context.Contact.Add(new Contact
{
Email = item.Email,
FirstName = item.FirstName,
LastName = item.LastName,
PhoneNumber = item.PhoneNumber,
StatusDetails = item.StatusDetails
});
_context.SaveChanges();
}
public void UpdateDetails(ContactAppContext _context, int id, Contact item)
{
var contact = _context.Contact.FirstOrDefault(t => t.ContactId == id);
if (contact != null)
{
contact.Email = item.Email;
contact.FirstName = item.FirstName;
contact.LastName = item.LastName;
contact.PhoneNumber = item.PhoneNumber;
contact.StatusDetails = item.StatusDetails;
_context.Contact.Update(contact);
_context.SaveChanges();
}
}
// initiate database context
public ContactController(ContactAppContext context)
{
_context = context;
}
// initiate database context
public EnlaceVisitContactController(ContactAppContext context)
{
_context = context;
}
public async Task <Contact> GetDetailsById(ContactAppContext _context, int id)
{
return(_context.Contact.FirstOrDefault(t => t.ContactId == id));
}
public ContactDetails(ContactAppContext contactAppContext, IConfiguration configuration, IContactDetailsBo contactDetailsBo)
{
_context = contactAppContext;
this.contactDetailsBo = contactDetailsBo;
}
// initiate database context
public UserController(ContactAppContext context)
{
_context = context;
}
public ApplicationController(ContactAppContext context)
{
_context = context;
}
