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