public List <Professorship> CreateProfessorship(Professorship vehicle)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(vehicle);
_context.SaveChanges();
return(_context.Professorships.Where(x => x.ProfessorShipId == _context.Professorships.Max(x => x.ProfessorShipId)).ToList());
}
public List <Professorship> EditProfessorship(Professorship professorship)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
var tmpProfessorship = _context.Professorships.First(x => x.ProfessorShipId == professorship.ProfessorShipId);
_context.Entry(tmpProfessorship).CurrentValues.SetValues(professorship);
_context.SaveChanges();
return(_context.Professorships.Where(x => x.ProfessorShipId == professorship.ProfessorShipId).ToList());
}
public List <Professorship> DeleteProfessorship(Professorship professorship)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
try
{
_context.Professorships.Attach(professorship);
_context.Professorships.Remove(professorship);
_context.SaveChanges();
}
catch (Exception e)
{
// ignored
}
return(_context.Professorships.ToList());
}
