// GET: Tutors/Edit/5 public async Task <IActionResult> Edit(int?id, TutorCreateViewModel model) { if (id == null) { return(NotFound()); } var tutor = await _context.Tutor .Include(t => t.Staff) .ThenInclude(s => s.Person) .Include(t => t.Staff) .ThenInclude(s => s.Contact) .FirstOrDefaultAsync(m => m.TutorId == id); model.FirstName = tutor.Staff.Person.FirstName; model.LastName = tutor.Staff.Person.LastName; model.Dob = tutor.Staff.Person.Dob; model.Address = tutor.Staff.Person.Address; model.Email = tutor.Staff.Contact.Email; model.Phone = tutor.Staff.Contact.Phone; model.Hours = tutor.Staff.Hours; return(View(model)); }
// GET: Tutors/Details/5 public async Task <IActionResult> Details(int?id, TutorCreateViewModel model) { if (id == null) { return(NotFound()); } Tutor tut = await _context.Tutor .Include(t => t.Staff) .ThenInclude(a => a.Person) .Include(b => b.Staff).ThenInclude(c => c.Contact) .FirstAsync(m => m.TutorId == id); model.FirstName = tut.Staff.Person.FirstName; model.LastName = tut.Staff.Person.LastName; model.Address = tut.Staff.Person.Address; model.Email = tut.Staff.Contact.Email; model.Phone = tut.Staff.Contact.Phone; model.Hours = tut.Staff.Hours; var canteach = _context.TutorType .Include(tt => tt.Tutor) .ThenInclude(t => t.Staff) .ThenInclude(s => s.Contact) .ThenInclude(tt => tt.Staff) .ThenInclude(s => s.Person) .Include(tt => tt.Instrument) .Where(m => m.TutorId == id).ToList(); var details = canteach.FirstOrDefault(); model.InstrumentsCanTeach = new List <string>(); foreach (var item in canteach) { Instrument instrument = await _context.Instrument.FirstOrDefaultAsync(e => e.InstrumentId == item.InstrumentId); model.InstrumentsCanTeach.Add(instrument.Instrument1); } var teaching = await _context.EnrollmentMusicClass .Include(emc => emc.MusicClass) .Include(emc => emc.Enrollment) .ThenInclude(e => e.Instrument) .FirstOrDefaultAsync(mc => mc.MusicClass.TutorId == id); if (teaching != null) { model.InstrumentsTeaching = new List <string>(); foreach (var item in teaching.MusicClass.EnrollmentMusicClass) { Instrument instrument = await _context.Instrument.FirstOrDefaultAsync(e => e.InstrumentId == item.Enrollment.Instrument.InstrumentId); model.InstrumentsTeaching.Add(instrument.Instrument1); } } return(View(model)); }
public async Task <IActionResult> Create(TutorCreateViewModel model) { //Person Person person = new Person(); person.FirstName = model.FirstName; person.LastName = model.LastName; person.Dob = model.Dob; person.Address = model.Address; _context.Person.Add(person); _context.SaveChanges(); int latestPerson = person.PersonId; //Contact Contact contact = new Contact(); contact.Email = model.Email; contact.Phone = model.Phone; _context.Contact.Add(contact); _context.SaveChanges(); int latestContact = contact.ContactId; //Staff Staff staff = new Staff(); staff.PersonId = latestPerson; staff.ContactId = latestContact; staff.StartDate = model.StartDate; //Change to null staff.LeftDate = new DateTime(04 / 07 / 2020); staff.Hours = model.Hours; _context.Staff.Add(staff); _context.SaveChanges(); int latestStaff = staff.StaffId; //Tutor Tutor tutor = new Tutor(); tutor.StaffId = latestStaff; tutor.Atcl = model.Atcl; _context.Tutor.Add(tutor); _context.SaveChanges(); return(RedirectToAction("Details", new { id = tutor.TutorId })); }
public async Task <IActionResult> Edit(int id, TutorCreateViewModel model) { var tutor = await _context.Tutor .Include(t => t.Staff) .ThenInclude(s => s.Person) .Include(t => t.Staff) .ThenInclude(s => s.Contact) .FirstOrDefaultAsync(m => m.TutorId == id); tutor.Staff.Person.FirstName = model.FirstName; tutor.Staff.Person.LastName = model.LastName; tutor.Staff.Person.Dob = model.Dob; tutor.Staff.Person.Address = model.Address; tutor.Staff.Contact.Email = model.Email; tutor.Staff.Contact.Phone = model.Phone; tutor.Staff.Hours = model.Hours; _context.Update(tutor); _context.SaveChanges(); return(RedirectToAction("Details", new { id = tutor.TutorId })); }
public async Task <IActionResult> Create(TutorCreateViewModel model) { //Contact Contact contact = new Contact(); contact.Email = model.Email; contact.Phone = model.Phone; _context.Contact.Add(contact); _context.SaveChanges(); int latestContact = contact.ContactId; LocalMusicians localMusicians = new LocalMusicians(); localMusicians.ContactId = latestContact; localMusicians.FirstName = model.FirstName; localMusicians.LastName = model.LastName; _context.LocalMusicians.Add(localMusicians); _context.SaveChanges(); return(RedirectToAction("Details", new { id = localMusicians.LocalMusiciansId })); }