public async Task SaveNewStudent(Student user) { if (user != null) { using (avDemoEntities context = new avDemoEntities()) { Guid userId = Guid.NewGuid(); Guid addressId = Guid.NewGuid(); Guid phoneId = Guid.NewGuid(); context.Users.Add(new User() { Id = userId, FirstName = user.FirstName, MiddleName = user.MiddleName, LastName = user.LastName, Suffix = user.Suffix, DateOfBirth = user.DateOfBirth, AddressId = addressId, PhoneId = phoneId, CreatedDate = DateTime.Now }); context.Addresses.Add(new Address() { Id = addressId, Street = user.Street, City = user.City, StateId = user.StateId, ZipCode = user.ZipCode, CreatedDate = DateTime.Now }); context.Phones.Add(new Phone() { Id = phoneId, PhoneNumber = user.PhoneNumber, CreatedDate = DateTime.Now }); await context.SaveChangesAsync(); } } }
public async Task<IHttpActionResult> UpdateStudent(Student student) { try { if (!ModelState.IsValid) { return BadRequest(ModelState); } using (StudentLogic sl = new StudentLogic()) { await sl.UpdateStudent(student); return Ok(); } } catch (Exception ex) { Helper.ErrorLogging.LogError(ex); return InternalServerError(ex); } }
public async Task UpdateStudent(Student user) { if (user != null) { using (avDemoEntities context = new avDemoEntities()) { User u = context.Users.FirstOrDefault(q => q.Id == user.Id && q.DeletedDate == null); Address a = context.Addresses.FirstOrDefault(q => q.Id == u.AddressId && q.DeletedDate == null); Phone p = context.Phones.FirstOrDefault(q => q.Id == u.PhoneId && q.DeletedDate == null); if (u != null) { u.FirstName = user.FirstName; u.MiddleName = user.MiddleName; u.LastName = user.LastName; u.Suffix = user.Suffix; u.DateOfBirth = user.DateOfBirth; u.UpdatedDate = DateTime.Now; } if (a != null) { a.Street = user.Street; a.City = user.City; a.StateId = user.StateId; a.ZipCode = user.ZipCode; a.UpdatedDate = DateTime.Now; } if (p != null) { p.PhoneNumber = user.PhoneNumber; p.UpdatedDate = DateTime.Now; } await context.SaveChangesAsync(); } } }