//Remove Absence by Id public void remove(int id) { var obj = _context.ABSENCE.Find(id); _context.ABSENCE.Remove(obj); //Confirm Alter _context.SaveChanges(); }
//Method to insert Incharger public void Insert(Incharge incharge) { int lastId = _context.INCHARGE.Select(obj => obj.ID).Last(); //Load last incharge Id //Increment new Incharge id to the last one incharge.IncrementId(lastId); _context.Add(incharge); //Add new incharge _context.SaveChanges(); //Save changes }
//Method to insert Loan public void Insert(Loan loan) { //int lastId = _context.LOAN.Select(obj => obj.ID).Last(); //Load last loan Id //Increment new Loan id to the last one loan.IncrementId(); _context.Add(loan); //Add new loan _context.SaveChanges(); //Save changes }
//Method to insert Team public void Insert(Team team) { int lastId = _context.TEAM.Select(obj => obj.ID).Last(); //Load last incharge Id //Increment new Team id to the last one team.IncrementId(lastId); _context.Add(team); //Add new team _context.SaveChanges(); //Save changes }
//Method to insert new Schedule public void Insert(Schedule schedule) { int lastId = _context.SCHEDULE.Select(obj => obj.ID).Last(); //Load last Schedule Id //Increment new Team id to the last one schedule.IncrementId(lastId); _context.Add(schedule); //Add new team _context.SaveChanges(); //Save changes }
//Method to insert Employee public void Insert(Employee employee) { int lastId = _context.EMPLOYS.Select(obj => obj.ID).Last(); //Load last Employee Id //Increment new employee id to the last one employee.IncrementId(lastId); _context.Add(employee); //Add new employee _context.SaveChanges(); //Save changes }
//Method to insert Presence public void Insert(Presence presence) { int lastId = _context.PRESENCE.Select(obj => obj.ID).Last(); //Load last presence Id //Increment new Presence id to the last one presence.IncrementId(lastId); _context.Add(presence); //Add new presence _context.SaveChanges(); //Save changes }
//Metodo para inserir novo utilizador public void Insert(User user) { int lastId = _context.USERS.Select(obj => obj.ID).Last();//Load Last Id //Increment new user id to the last one user.IncrementId(lastId); //Add new object _context.Add(user); //Save changes _context.SaveChanges(); }
//Update Loans public void Update(LoanForEmploy obj) { //Test if id exists if (!_context.LOAN_FOR_EMPLOY.Any(x => x.ID == obj.ID)) { throw new NotFoundException("Id not Found"); } //Update Loan _context.Update(obj); //Save changes _context.SaveChanges(); }