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