public async Task <IActionResult> CompleteMaintenance(int id) { var maintenance = await _context.TblRoomMaintenance.FindAsync(id); maintenance.EndDatetime = DateTime.Now; _context.Update(maintenance); await _context.SaveChangesAsync(); return(Redirect("~/Maintenance")); }
public async Task <IActionResult> EditReservation(ReservationModel reservationModel) { if (ModelState.IsValid) { TblPerson tblPerson = new TblPerson { PersonId = reservationModel.PersonID, FirstName = reservationModel.FirstName, LastName = reservationModel.LastName, City = reservationModel.City, Country = reservationModel.Country, EmailAddress = reservationModel.EmailAddress, PhoneNumber = reservationModel.PhoneNumber, PostalCode = reservationModel.PostalCode, StreetName = reservationModel.StreetName, StreetNumber = reservationModel.StreetNumber, }; TblReservation tblReservation = new TblReservation { ReservationId = reservationModel.ReservationID, PersonId = tblPerson.PersonId, ExpectedArriveDate = reservationModel.ExpectedArrivalDate, ExpectedLeaveDate = reservationModel.ExpectedLeaveDate, RoomNumber = reservationModel.RoomNumber, ReservationNotes = reservationModel.Notes }; _context.Update(tblPerson); _context.Update(tblReservation); await _context.SaveChangesAsync(); return(Redirect("~/Concierge/Reservations")); } ViewData["RoomNumber"] = new SelectList(_context.TblRooms.Where(s => s.RoomStatus == 0), "RoomNumber", "RoomNumber"); return(View(reservationModel)); }
public async Task <IActionResult> UpdateEmployee(int?id, EmployeeModel employeeModel) { if (id != employeeModel.PersonID) { return(NotFound()); } if (ModelState.IsValid) { TblPerson tblPerson = new TblPerson { PersonId = employeeModel.PersonID, FirstName = employeeModel.FirstName, LastName = employeeModel.LastName, EmailAddress = employeeModel.EmailAddress, PhoneNumber = employeeModel.PhoneNumber, StreetNumber = employeeModel.StreetNumber, StreetName = employeeModel.StreetName, City = employeeModel.City, PostalCode = employeeModel.PostalCode, Country = employeeModel.Country, }; TblEmployee tblEmployee = new TblEmployee { EmployeeId = employeeModel.PersonID, EmergencyContactName = employeeModel.EmergencyContactName, EmergencyContactNumber = employeeModel.EmergencyContactNumber, }; _context.Update(tblPerson); _context.Update(tblEmployee); await _context.SaveChangesAsync(); var position = _context.TblPosition.Where(x => x.EmployeeId == employeeModel.PersonID && x.EndDate == null).ToList(); var positionID = 0; var previousRecordID = 0; foreach (var x in position) { previousRecordID = x.Id; positionID = x.PositionId; } if (positionID != employeeModel.Position) { var previousRecord = _context.TblPosition.Find(previousRecordID); previousRecord.EndDate = DateTime.Now; _context.Update(previousRecord); TblPosition tblPosition = new TblPosition { EmployeeId = employeeModel.PersonID, PositionId = employeeModel.Position, StartDate = DateTime.Now, }; await _context.TblPosition.AddAsync(tblPosition); var user = _userManager.Users.Where(x => x.UserName == employeeModel.EmailAddress).ToList(); foreach (var x in user) { var previousUser = _dbContext.Users.Find(x.Id); var removeUser = await _userManager.RemoveFromRoleAsync(previousUser, _context.LkpPositionTypes.Find(positionID).Description.ToString()); if (removeUser.Succeeded) { await _userManager.AddToRoleAsync(previousUser, _context.LkpPositionTypes.Find(employeeModel.Position).Description.ToString()); } } await _context.SaveChangesAsync(); } return(Redirect("/Admin/Employee")); } ViewData["Position"] = new SelectList(_context.LkpPositionTypes.Where(s => s.IsActive == true), "PositionId", "Description"); return(View(employeeModel)); }