public List <ProfessorContract> CreateProfessorContract(ProfessorContract professorContract) { using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options); _context.Add(professorContract); _context.SaveChanges(); return(_context.ProfessorContracts.Where(x => x.ProfessorContractId == _context.ProfessorContracts.Max(x => x.ProfessorContractId)).ToList()); }
public List <ProfessorContract> EditProfessorContract(ProfessorContract professorContract) { using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options); var tmpProfessorContract = _context.ProfessorContracts.First(x => x.ProfessorContractId == professorContract.ProfessorContractId); _context.Entry(tmpProfessorContract).CurrentValues.SetValues(professorContract); _context.SaveChanges(); return(_context.ProfessorContracts.Where(x => x.ProfessorContractId == professorContract.ProfessorContractId).ToList()); }
public List <ProfessorContract> DeleteProfessorContract(ProfessorContract professorContract) { using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options); try { _context.ProfessorContracts.Attach(professorContract); _context.ProfessorContracts.Remove(professorContract); _context.SaveChanges(); } catch (Exception e) { // ignored } return(_context.ProfessorContracts.ToList()); }