//===================== Apartments CSV Import======================= public async Task<ActionResult> ProcessCsv(EventItem[] model) { int BuildingID = (int)Session["BuildingID"]; if (ModelState.IsValid) //if(User.Identity.IsAuthenticated) { { foreach (var item in model) { var apartment = new Apartment { ApartmentNumber = item.AparmentNumber, BuildingID = BuildingID, FloorNumber = item.Floor }; 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 = "84a4092e-0bcc-4e4f-b007-c87a99eccae3", DateOfEvent = DateTime.Now, FunctionPerformed = "Added apartment", Message = "Apartment # "+ item.AparmentNumber +" was added by " + myUser.UserName }; db.UserActivityLog.Add(newActivity); await db.SaveChangesAsync(); } } } return RedirectToAction("BuildingProfile", "Building"); }
public ActionResult deleteApartment(Apartment model, int id) { if (ModelState.IsValid) { var b = db.Apartment.Find(id); db.Apartment.Remove(b); db.SaveChanges(); } return RedirectToAction("BuildingProfile", new { BuildingID = model.BuildingID }); }
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}); }