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