public ActionResult EditDays(int id) { AddressDateViewModel model = new AddressDateViewModel(); model.DaysOfWeek = context.Day.ToList(); model.userAddresses = (from data in context.UserAddresses.Include("User").Include("Address.City.State").Include("Address.Zip") where data.Address.ID == id select data).ToList(); var ID = model.userAddresses.FirstOrDefault().ID; model.Days = (from data in context.UserAddressDay.Include("UserAddress").Include("Day") where data.UserAddress.ID == ID select data).ToList(); return(View(model)); }
public ActionResult Account() { var username = User.Identity.GetUserName(); var user = (from data in context.Users where data.UserName == username select data).First(); var userAddresses = (from data in context.UserAddresses.Include("Address") where data.User.Id == user.Id select data).ToList(); AddressDateViewModel Pickups = new AddressDateViewModel(); foreach (var address in userAddresses) { var days = (from data in context.UserAddressDay.Include("Day") where data.UserAddress.ID == address.ID select data).ToList(); if (days.Count > 0) { Pickups.Days.AddRange(days); } } Pickups.userAddresses = userAddresses; foreach (var address in userAddresses) { Pickups.addresses.Add((from data in context.Address.Include("City").Include("Zip").Include("City.State") where address.Address.ID == data.ID select data).First()); } return(View(Pickups)); }