public async Task<ActionResult> AddApartment(ApartmentVM apartmentvm, int buildingID) { if (ModelState.IsValid) { //if (User.Identity.IsAuthenticated) //{ var apartment = new Apartment { ApartmentNumber = apartmentvm.ApartmentNumber, BuildingID =buildingID, FloorNumber = apartmentvm.FloorNumber }; db.Apartment.Add(apartment); await db.SaveChangesAsync(); //======================insert Add Building Activity================ //var UserID = User.Identity.GetUserId();// gets logged user ID //AspNetUsers myUser = await db.AspNetUsers.FirstOrDefaultAsync(c => c.Id == UserID);select from db where logged use match //var newActivity = new UserActivityLog //{ // BuildingID = BuildingID, // UserID = User.Identity.GetUserId(), // DateOfEvent = DateTime.Now, // FunctionPerformed = "Added apartment", // Message = "Apartment # " + apartmentvm.ApartmentNumber + " was added by " + myUser.UserName //}; //db.UserActivityLog.Add(newActivity); //await db.SaveChangesAsync(); } //} return RedirectToAction("BuildingProfile", "Building", new { BuildingID = buildingID}); }
public async Task<ActionResult> ApartmentProfile(int? ApartmentID, int BuildingID) { var buildinginfo = await db.Buildings .Join(db.Apartment, b => b.ID, c => c.BuildingID, (b, c) => new BuildingInfoVM { ID = c.ID, BuildingID = b.ID, BuildingName = b.BuildingName, BuildingPhone = b.BuildingPhone, Address = b.Address, City = b.City, ZipCode = b.Zipcode, Manager = b.Manager, NumberOfApart = (int)b.NumberOfApartment, States = b.State, AptID = c.ID }) .Where(cb => cb.AptID == ApartmentID) .FirstAsync(); Session["Building"] = buildinginfo; var apartmentinfo = new ApartmentVM(); var apartmentprofile = await db.Apartment .Where(a => a.ID == ApartmentID) .Select(c => new ApartmentVM { ApartmentNumber = c.ApartmentNumber, FloorNumber = c.FloorNumber, BuildingID = (int)c.BuildingID, ID = c.ID }).ToListAsync(); var tenant = await db.Tenant .Where(t => t.aptID == ApartmentID).ToListAsync(); ViewBag.tenant = tenant; return View(apartmentprofile); }
public ActionResult AddApartment(int buildingID) { var apartment = new ApartmentVM(); apartment.BuildingID = buildingID; return View(apartment); }