public Guid Post([FromBody] Person personToSave) { using (var context = new SSWUGDemoContext()) { var person = context.Person.FirstOrDefault(p => p.Id == personToSave.Id); if (person == null) { person = new Person(); context.Person.Add(person); } person.Id = personToSave.Id; person.FirstName = personToSave.FirstName; person.LastName = personToSave.LastName; person.Email = personToSave.Email; person.Phone = personToSave.Phone; if (personToSave.Id == Guid.Empty) { person.Id = Guid.NewGuid(); } context.SaveChanges(); return(person.Id); } }
public int GetCountWhereEmailContains(string emailDomain) { using (var context = new SSWUGDemoContext()) { var count = context.Person.Where(p => p.Email.Contains(emailDomain)).Count(); return(count); } }
public Person Get(Guid id) { using (var context = new SSWUGDemoContext()) { var person = context.Person.AsNoTracking().FirstOrDefault(p => p.Id == id); return(person); } }
public IEnumerable <Person> Get(string searchString) { using (var context = new SSWUGDemoContext()) { var people = context.Person.AsNoTracking().Where(p => p.FirstName.StartsWith(searchString) || p.LastName.StartsWith(searchString) || p.Email.StartsWith(searchString) || p.Phone.StartsWith(searchString)) .ToList(); return(people); } }
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, SSWUGDemoContext dbContext) { loggerFactory.AddConsole(); app.UseCors(builder => builder.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod()); app.UseMvc(); }