public async Task <IActionResult> PutPerson(int id, Person person) { if (id != person.Id) { return(BadRequest()); } _context.Entry(person).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <PersonRecord> CreateAsync(PersonRecord entity) { _context.People.Add(entity); await _context.SaveChangesAsync(); return(entity); }
public async Task <IHttpActionResult> PutPerson(int id, Person person) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != person.Id) { return(BadRequest()); } db.Entry(person).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IActionResult> Create([Bind("Id,FirstName,LastName,Title,Age,Address,City,Phone,Email")] Person person) { if (ModelState.IsValid) { _context.Add(person); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(person)); }
public async Task <IActionResult> Create([Bind("PId,PName,PAge")] Person person) { if (ModelState.IsValid) { _context.Add(person); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(person)); }
public async Task <IActionResult> Create([Bind("PersonId,FirstName,LastName,BirthDate,IsApproved,Role")] Person person) { if (ModelState.IsValid) { _context.Add(person); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(person)); }
public async Task <IActionResult> PutPerson(int id, PersonDTO personDTO) { if (id != personDTO.Id) { return(BadRequest()); } var person = await _context.People .Include(p => p.Address) .Include(p => p.Interests) .FirstOrDefaultAsync(p => p.Id == id); person.FirstName = personDTO.FirstName; person.MiddleName = personDTO.MiddleName; person.LastName = personDTO.LastName; person.Address = personDTO.Address; person.PersonAddressId = personDTO.PersonAddressId; person.DOB = new DateTime(personDTO.DOB.Year, personDTO.DOB.Month, personDTO.DOB.Day); person.PathToAvatar = personDTO.PathToAvatar; person.IsFavorite = personDTO.IsFavorite; _context.Entry(person).State = EntityState.Modified; if (personDTO.Address != null) { _context.Entry(personDTO.Address).State = EntityState.Modified; } if (personDTO.Interests != null) { foreach (var interest in personDTO.Interests) { _context.Entry(interest).State = EntityState.Modified; } } try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public override async Task <AddressAdditionResponse> AddUserAddress(AddressAdditionRequest request, ServerCallContext context) { // var userAddress = new AddressData { Name = request.Name, Address = request.Address, Enrollment = request.Enrollment }; var userAddress = GetAddressData(request); _personDbContext.Add(userAddress); await _personDbContext.SaveChangesAsync(); var results = new AddressAdditionResponse { Message = "Address Save Successfully." }; return(results); }
public override async Task <HealthResponse> AddPersonHealthData(HealthRequest request, ServerCallContext context) { var healthData = new HealthData { Name = request.Name, HealthParameter1 = request.HealthParameter1, HealthParameter2 = request.HealthParameter2 }; _personDbContext.Health.Add(healthData); await _personDbContext.SaveChangesAsync(); var results = new HealthResponse { Message = "Health Data Save Successfully." }; return(results); }
public static void Initialize(PersonDbContext context) { if (context.People.Any()) { return; } var people = new List <PersonRecord> { new PersonRecord { FirstName = "Bill", LastName = "Gates", DateOfBirth = new DateTime(1955, 10, 28), Street = "Microsoft way", City = "Seattle", State = "Washington", PostalCode = "98134", PictureName = "a4759609-0051-4cd5-a84b-1d4efa743c97.jpg" }, new PersonRecord { FirstName = "Mark", LastName = "Zuckerberg", DateOfBirth = new DateTime(1984, 5, 14), Street = "Facebook street", City = "White Plains", State = "New York", PostalCode = "10016", PictureName = "4dc720fc-cb7b-4f94-a004-21101c1a64e7.jpg" }, new PersonRecord { FirstName = "Jeff", LastName = "Bezos", DateOfBirth = new DateTime(1964, 1, 12), Street = "Amazon Prime way", City = "Albuquerque", State = "New Mexico", PostalCode = "87110", PictureName = "f1c1d561-a45d-4d8c-bb37-4641de13a64e.jpg" }, new PersonRecord { FirstName = "Steve", LastName = "Jobs", DateOfBirth = new DateTime(1955, 02, 24), Street = "Apple Parkway", City = "San Francisco", State = "California", PostalCode = "90201", PictureName = "bc3b154e-135c-4fd3-aee0-e9dfceee8286.jpg" }, new PersonRecord { FirstName = "Elon", LastName = "Musk", DateOfBirth = new DateTime(1971, 6, 28), Street = "Tesla street way", City = "Pretoria", State = "South Africa", PostalCode = "Unknown", PictureName = "2702f7df-bce7-4f3b-8741-efe32215435b.jpg" }, new PersonRecord { FirstName = "Tim", LastName = "Cook", DateOfBirth = new DateTime(1960, 11, 1), Street = "Apple Parkway", City = "Mobile", State = "Alabama", PostalCode = "36611", PictureName = "3271aeb1-2db7-470f-acac-b375a9002cc4.jpg" }, }; people.ForEach(p => context.People.Add(p)); context.SaveChangesAsync(); }
public async Task <IActionResult> AddPersonToDB([FromBody] Person personWithPresent) { personWithPresent.ID = _context.Persons.Max(p => p.ID) + 1; _context.Persons.Add(personWithPresent); await _context.SaveChangesAsync(); return(Ok()); }
public async Task <ActionResult <Person> > Post([FromBody] Person persone) { if (int.TryParse(Request.Headers["X-UserId"], out int userId)) { if (PersoneExists(userId)) { return(BadRequest("Persone already exists.")); } persone.UserId = userId; await _context.Persons.AddAsync(persone); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(Post), new { id = persone.Id }, persone)); } return(BadRequest()); }
public async Task Update(PersonUpdateDTO updateDTO) { var personFromDb = _db.Person.FirstOrDefault(p => p.id == updateDTO.id); personFromDb.name = updateDTO.name; personFromDb.state = updateDTO.state; personFromDb.streetAddress = updateDTO.streetAddress; personFromDb.city = updateDTO.city; personFromDb.postalCode = updateDTO.postalCode; await _db.SaveChangesAsync(); }
public async Task <IActionResult> AddPerson([FromBody] Person person) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } await db.AddAsync(person); await db.SaveChangesAsync(); return(Ok(person.Id)); }
public override async Task <AddressAdditionResponse> AddUserAddress(AddressAdditionRequest request, ServerCallContext context) { var userAddress = GetAddressData(request); try { if (userAddress.Enrollment == "Bank") { var trailer = new Metadata() { { "BadValue", "Enrollment type is Bank" }, { "Field", "Enrollment" }, { "Message", "Bank enrollment is stopped temporarily" } }; throw new RpcException(new Status(StatusCode.Cancelled, "Bank enrollment is stopped temporarily"), trailer); } _personDbContext.Add(userAddress); await _personDbContext.SaveChangesAsync(); } catch (InvalidOperationException) { var trailer = new Metadata() { { "CorelationId", Guid.NewGuid().ToString() }, { "Message", "Unable to save the Data inside Database." } }; throw new RpcException(new Status(StatusCode.Internal, "Internal Error"), trailer); } catch (RpcException rpcError) { throw rpcError; } var results = new AddressAdditionResponse { Message = "Address Save Successfully." }; return(results); }
public async Task <IActionResult> PutPerson(int id, Person person) { if (id != person.Id) { return(BadRequest()); } person.IsActive = true; var local = _context.Set <Person>() .Local .FirstOrDefault(entry => entry.Id.Equals(id)); if (local != null) { // detach _context.Entry(local).State = EntityState.Detached; } _context.Entry(person).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutPersonInterest(int id, PersonInterest personInterest) { personInterest.Id = id; _context.Entry(personInterest).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonInterestExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private async void btn_delete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are Yor Sure to Delete this Record?", "EF Crud Operation,", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (PersonDbContext db = new PersonDbContext()) { var entry = db.Entry(people); if (entry.State == EntityState.Detached) { db.People.Attach(people); } db.People.Remove(people); await db.SaveChangesAsync(); DataLoad(); Clear(); MessageBox.Show("Deleted Successfully"); } } }
public async Task UpdateItem(Person item) { try { var personToUpdate = _personDbContext.People .Where(p => p.PersonId == item.PersonId).FirstOrDefault(); if (personToUpdate != null) { _personDbContext.Entry(personToUpdate).CurrentValues.SetValues(item); } await _personDbContext.SaveChangesAsync(); _logger.LogInformation($"Updated details for item with id {item.PersonId}"); } catch (Exception ex) { _logger.LogError($"An error occured while updating item with Id {item.PersonId}. Exception details :{ex.Message}"); } }
private async void btn_save_Click(object sender, EventArgs e) { people.Name = txbx_name.Text.Trim(); people.Surname = txbx_surname.Text.Trim(); people.Email = txbx_email.Text.Trim(); people.Password = txbx_password.Text.Trim(); List <ValidationResult> validationResults = new List <ValidationResult>(); ValidationContext validationContext = new ValidationContext(people); if (!Validator.TryValidateObject(people, validationContext, validationResults, true)) { lbl_errors.Text = string.Empty; foreach (ValidationResult item in validationResults) { lbl_errors.Text += item.ErrorMessage + "\n"; } } else { using (PersonDbContext db = new PersonDbContext()) { if (people.Id == 0) //insert { db.People.Add(people); } else //update { db.Entry(people).State = EntityState.Modified; } await db.SaveChangesAsync(); } Clear(); DataLoad(); MessageBox.Show("Submitted Successfully"); } }
public async Task <int> SaveChanges() { return(await Db.SaveChangesAsync()); }