// 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 }));
}