public List <Tenure> CreateTenure(Tenure tenure)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(tenure);
_context.SaveChanges();
return(_context.Tenures.Where(x => x.TenureId == _context.Tenures.Max(x => x.TenureId)).ToList());
}
public List <Tenure> EditTenure(Tenure tenure)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
var tmpTenure = _context.Tenures.First(x => x.TenureId == tenure.TenureId);
_context.Entry(tmpTenure).CurrentValues.SetValues(tenure);
_context.SaveChanges();
return(_context.Tenures.Where(x => x.TenureId == tenure.TenureId).ToList());
}
public List <Tenure> DeleteTenure(Tenure tenure)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
try
{
_context.Tenures.Attach(tenure);
_context.Tenures.Remove(tenure);
_context.SaveChanges();
}
catch (Exception e)
{
// ignored
}
return(_context.Tenures.ToList());
}
