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