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 static List<ref_States> GetStates()
{
ObjectCache cache = MemoryCache.Default;
List<ref_States> states = (List<ref_States>)cache[CacheKey.States];
if (states == null)
{
CacheItemPolicy policy = new CacheItemPolicy();
policy.AbsoluteExpiration = DateTime.Now.AddHours(double.Parse("24"));
using (avDemoEntities context = new avDemoEntities())
{
states = context.ref_States.ToList();
}
cache.Set(CacheKey.States, states, policy);
}
return states;
}
public Student GetStudentById(Guid id)
{
using (avDemoEntities context = new avDemoEntities())
{
return (from u in context.Users.Where(q => q.Id == id && q.DeletedDate == null)
join a in context.Addresses.Where(q => q.DeletedDate == null) on u.AddressId equals a.Id
join p in context.Phones.Where(q => q.DeletedDate == null) on u.PhoneId equals p.Id
select new Student()
{
Id = u.Id,
FirstName = u.FirstName,
MiddleName = u.MiddleName,
LastName = u.LastName,
Suffix = u.Suffix,
DateOfBirth = u.DateOfBirth,
Street = a.Street,
StateId = a.StateId,
City = a.City,
ZipCode = a.ZipCode,
PhoneNumber = p.PhoneNumber
}).FirstOrDefault();
}
}
public async Task DeleteStudent(Guid id)
{
if (id != null)
{
using (avDemoEntities context = new avDemoEntities())
{
User u = context.Users.FirstOrDefault(q => q.Id == 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.DeletedDate = DateTime.Now;
if (a != null)
a.DeletedDate = DateTime.Now;
if (p != null)
p.DeletedDate = DateTime.Now;
await context.SaveChangesAsync();
}
}
}
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();
}
}
}
