public async virtual Task <CallPerson> Create(CallPerson item) { this.Context.Set <CallPerson>().Add(item); await this.Context.SaveChangesAsync(); this.Context.Entry(item).State = EntityState.Detached; return(item); }
public async virtual Task Delete( int id) { CallPerson record = await this.GetById(id); if (record == null) { return; } else { this.Context.Set <CallPerson>().Remove(record); await this.Context.SaveChangesAsync(); } }
public async virtual Task Update(CallPerson item) { var entity = this.Context.Set <CallPerson>().Local.FirstOrDefault(x => x.Id == item.Id); if (entity == null) { this.Context.Set <CallPerson>().Attach(item); } else { this.Context.Entry(entity).CurrentValues.SetValues(item); } await this.Context.SaveChangesAsync(); }
public async void Create() { Mock <ILogger <CallPersonRepository> > loggerMoc = CallPersonRepositoryMoc.GetLoggerMoc(); ApplicationDbContext context = CallPersonRepositoryMoc.GetContext(); var repository = new CallPersonRepository(loggerMoc.Object, context); var entity = new CallPerson(); entity.SetProperties(default(int), "B", 1, 1); await repository.Create(entity); var records = await context.Set <CallPerson>().ToListAsync(); records.Count.Should().Be(2); }
public async void Get() { Mock <ILogger <CallPersonRepository> > loggerMoc = CallPersonRepositoryMoc.GetLoggerMoc(); ApplicationDbContext context = CallPersonRepositoryMoc.GetContext(); var repository = new CallPersonRepository(loggerMoc.Object, context); CallPerson entity = new CallPerson(); entity.SetProperties(default(int), "B", 1, 1); context.Set <CallPerson>().Add(entity); await context.SaveChangesAsync(); var record = await repository.Get(entity.Id); record.Should().NotBeNull(); }
public async void Update_Entity_Is_Not_Tracked() { Mock <ILogger <CallPersonRepository> > loggerMoc = CallPersonRepositoryMoc.GetLoggerMoc(); ApplicationDbContext context = CallPersonRepositoryMoc.GetContext(); var repository = new CallPersonRepository(loggerMoc.Object, context); CallPerson entity = new CallPerson(); entity.SetProperties(default(int), "B", 1, 1); context.Set <CallPerson>().Add(entity); await context.SaveChangesAsync(); context.Entry(entity).State = EntityState.Detached; await repository.Update(entity); var records = await context.Set <CallPerson>().ToListAsync(); records.Count.Should().Be(2); }
public virtual async Task Migrate() { var addressItem1 = new Address(); addressItem1.SetProperties(1, "A", "A", "A", "A", "A"); this.Context.Addresses.Add(addressItem1); var callItem1 = new Call(); callItem1.SetProperties(1, 1, 1, 1, "A", 1, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1); this.Context.Calls.Add(callItem1); var callAssignmentItem1 = new CallAssignment(); callAssignmentItem1.SetProperties(1, 1, 1); this.Context.CallAssignments.Add(callAssignmentItem1); var callDispositionItem1 = new CallDisposition(); callDispositionItem1.SetProperties(1, "A"); this.Context.CallDispositions.Add(callDispositionItem1); var callPersonItem1 = new CallPerson(); callPersonItem1.SetProperties(1, "A", 1, 1); this.Context.CallPersons.Add(callPersonItem1); var callStatusItem1 = new CallStatus(); callStatusItem1.SetProperties(1, "A"); this.Context.CallStatus.Add(callStatusItem1); var callTypeItem1 = new CallType(); callTypeItem1.SetProperties(1, "A"); this.Context.CallTypes.Add(callTypeItem1); var noteItem1 = new Note(); noteItem1.SetProperties(1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"), "A", 1); this.Context.Notes.Add(noteItem1); var offCapabilityItem1 = new OffCapability(); offCapabilityItem1.SetProperties(1, "A"); this.Context.OffCapabilities.Add(offCapabilityItem1); var officerItem1 = new Officer(); officerItem1.SetProperties(1, "A", "A", "A", "A", "A"); this.Context.Officers.Add(officerItem1); var officerCapabilitiesItem1 = new OfficerCapabilities(); officerCapabilitiesItem1.SetProperties(1, 1, 1); this.Context.OfficerCapabilities.Add(officerCapabilitiesItem1); var personItem1 = new Person(); personItem1.SetProperties(1, "A", "A", "A", "A"); this.Context.People.Add(personItem1); var personTypeItem1 = new PersonType(); personTypeItem1.SetProperties(1, "A"); this.Context.PersonTypes.Add(personTypeItem1); var unitItem1 = new Unit(); unitItem1.SetProperties(1, "A"); this.Context.Units.Add(unitItem1); var unitDispositionItem1 = new UnitDisposition(); unitDispositionItem1.SetProperties(1, "A"); this.Context.UnitDispositions.Add(unitDispositionItem1); var unitOfficerItem1 = new UnitOfficer(); unitOfficerItem1.SetProperties(1, 1, 1); this.Context.UnitOfficers.Add(unitOfficerItem1); var vehCapabilityItem1 = new VehCapability(); vehCapabilityItem1.SetProperties(1, "A"); this.Context.VehCapabilities.Add(vehCapabilityItem1); var vehicleItem1 = new Vehicle(); vehicleItem1.SetProperties(1, "A"); this.Context.Vehicles.Add(vehicleItem1); var vehicleCapabilitiesItem1 = new VehicleCapabilities(); vehicleCapabilitiesItem1.SetProperties(1, 1, 1); this.Context.VehicleCapabilities.Add(vehicleCapabilitiesItem1); var vehicleOfficerItem1 = new VehicleOfficer(); vehicleOfficerItem1.SetProperties(1, 1, 1); this.Context.VehicleOfficers.Add(vehicleOfficerItem1); await this.Context.SaveChangesAsync(); }