// Details for Customer, through MyProfile navigation link public ActionResult ShowCustomerProfile() { var userId = User.Identity.GetUserId(); if (userId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Customer customer = db.Customers.FirstOrDefault(c => c.AspNetUsersId == userId); var address = db.Addresses.FirstOrDefault(a => a.ID == customer.AddressID); var city = db.Cities.FirstOrDefault(c => c.ID == address.CityID); var region = db.Regions.FirstOrDefault(r => r.ID == address.RegionID); var country = db.Countries.FirstOrDefault(c => c.ID == address.CountryID); var telephone = db.TelephoneNumbers.FirstOrDefault(t => t.ID == customer.TelephoneNumberID); var viewModel = new SingleCustomerAddressTelephoneViewModel() { Customer = customer, Address = customer.Address, City = city, Region = region, Country = country, TelephoneNumber = telephone }; if (customer == null) { return(HttpNotFound()); } return(View("Details", "_Layout", viewModel)); }
//GET: CheckOut public ActionResult CheckOutAndPayment() { var userId = User.Identity.GetUserId(); if (userId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var customers = db.Customers.ToList(); var customer = customers.Find(c => c.AspNetUsersId == userId); var customerID = customers.Where(c => c.AspNetUsersId == userId).Select(c => c.ID).FirstOrDefault(); var addresses = db.Addresses.ToList(); var customerAddressID = customers.Where(c => c.ID == customerID).Select(c => c.AddressID).FirstOrDefault(); var address = addresses.Find(a => a.ID == customerAddressID); var telephones = db.TelephoneNumbers.ToList(); var customerTelephoneID = customers.Where(c => c.ID == customerID).Select(c => c.TelephoneNumberID).FirstOrDefault(); var telephone = telephones.Find(t => t.ID == customerTelephoneID); var cities = db.Cities.ToList(); var customerAddressCityID = addresses.Where(a => a.ID == customerAddressID).Select(a => a.CityID).FirstOrDefault(); var city = cities.Find(c => c.ID == customerAddressCityID); var countries = db.Countries.ToList(); var customerAddressCountryID = addresses.Where(a => a.ID == customerAddressID).Select(a => a.CountryID).FirstOrDefault(); var country = countries.Find(c => c.ID == customerAddressCountryID); var regions = db.Regions.ToList(); var customerAddressRegionID = addresses.Where(c => c.ID == customerAddressID).Select(a => a.RegionID).FirstOrDefault(); var region = regions.Find(r => r.ID == customerAddressRegionID); var viewModel = new SingleCustomerAddressTelephoneViewModel() { Customer = customer, Address = address, City = city, Region = region, Country = country, TelephoneNumber = telephone }; return(View(viewModel)); }