public void DeleteCollege(int id)
{
AddToKeylessTable.DeleteFromTable_Departments(id);
_context.Colleges.Remove(_context.Colleges.SingleOrDefault(c => c.IdCollege == id));
_context.SaveChanges();
}
public void AddUsersForElection(ObjectForUsersFilter objectForUsersFilter, int IdElectoralRoom)
{
var filteredUsers = ElectionFilter.GetFilteredUsersForElection(objectForUsersFilter);
foreach (User user in filteredUsers)
{
AddToKeylessTable.AddToTable_Election_Users(IdElectoralRoom, user.IdUser);
}
}
//cascade delete,votes,user-election,cadidates
public void DeleteUserForAdmin(int id)
{
var user_role = _context.Users_Roles;
var user_dep = _context.Users_Departments;
var user = _context.Users;
AddToKeylessTable.DeleteFromTable_Users_Roles(id);
AddToKeylessTable.DeleteFromTable_Users_Departments(id);
AddToKeylessTable.DeleteFromTable_Candidates(id);
AddToKeylessTable.DeleteFromTable_Elections_Users(id);
_context.Users.Remove(user.SingleOrDefault(d => d.IdUser == id));
_context.SaveChanges();
}
public IActionResult Vote([FromBody] VotesDto voteDto)
{
// map dto to entity
var vote = Mapper.Map <Vote>(voteDto);
try
{
// save
AddToKeylessTable.AddToTable_Vote(vote.IdUser, vote.IdCandidate);
return(Ok());
}
catch (Exception ex)
{
// return error message if there was an exception
return(BadRequest(new { message = ex.Message }));
}
}
//poate sa faca upd daca userul nu si a activat contul,daca e activat pate sa mod facultatea,dep,rol
public void UpdateUsersForAdmin(UserAdminView userAdminView)
{
_userRepo.Update(new User(userAdminView.User.IdUser, userAdminView.User.Username, userAdminView.User.FirstName,
userAdminView.User.LastName, userAdminView.User.NrMatricol,
userAdminView.User.Email, false));
//poate mai avea si mai multe roluri
AddToKeylessTable.UpdateTable_User_Role(userAdminView.User.IdUser, userAdminView.Role.IdRole);
foreach (var department in userAdminView.Departments)
{
AddToKeylessTable.UpdateTable_User_Department(userAdminView.User.IdUser, department.IdDepartment);
}
_context.SaveChanges();
}
//poate sa adauge si numele,prenumele etc...
public void AddUsers(UserAdminView userAdminView)
{
User user = new User(userAdminView.User.Username, userAdminView.User.FirstName,
userAdminView.User.LastName, userAdminView.User.NrMatricol, userAdminView.User.Email, false);
_userRepo.Insert(user);
AddToKeylessTable.AddToTable_User_Role(user.IdUser, userAdminView.Role.IdRole);
foreach (var department in userAdminView.Departments)
{
//User_Department user_Department = new User_Department(user.IdUser,department.IdDepartment);
AddToKeylessTable.AddToTable_User_Department(user.IdUser, department.IdDepartment);
}
_context.SaveChanges();
}
public void Vote(int IdCandidate, int IdUser)
{
AddToKeylessTable.AddToTable_Vote(IdCandidate, IdUser);
}
