public GroupResult Edit(int id, BGroup bGroup)
{
var groupResult = new GroupResult();
using (_context = new GroupsManagementDbEntities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
Group group = _context.Groups.Find(id);
group.Name = bGroup.Name;
_context.SaveChanges();
transaction.Commit();
groupResult.bGroups.Add(new BGroup
{
GroupId = group.GroupId,
Name = group.Name
});
}
catch (Exception e)
{
groupResult.IsValid = false;
groupResult.ErrorMessages.Add(e.Message);
}
}
}
return(groupResult);
}
public RoleResult Add(BRole bRole)
{
RoleResult roleResult = new RoleResult();
using (_context = new GroupsManagementDbEntities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
Role role = new Role()
{
RoleName = bRole.Name
};
_context.Roles.Add(role);
_context.SaveChanges();
transaction.Commit();
roleResult.bRoles.Add(Conversions.ConvertRoleToBRole(role));
}
catch (Exception e)
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add(e.Message);
}
}
}
return(roleResult);
}
public RoleResult Edit(int id, BRole bRole)
{
RoleResult roleResult = new RoleResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
Role role = _context.Roles.FirstOrDefault(r => r.RoleId == id);
if (role != null)
{
role.RoleName = bRole.Name;
_context.SaveChanges();
roleResult.bRoles.Add(Conversions.ConvertRoleToBRole(role));
}
else
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add("This role doesn't exist.");
}
}
catch (Exception e)
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add(e.Message);
}
}
return(roleResult);
}
public RoleResult Get(int id)
{
var roleResult = new RoleResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
Role role = _context.Roles.FirstOrDefault(r => r.RoleId == id);
if (role != null)
{
roleResult.bRoles.Add(Conversions.ConvertRoleToBRole(role));
}
else
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add("Role not found");
}
}
catch (Exception e)
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add(e.Message);
}
}
return(roleResult);
}
public UserResult Delete(int id)
{
UserResult userResult = new UserResult();
using (_context = new GroupsManagementDbEntities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
User user = _context.Users.Include("Group").FirstOrDefault(u => u.UserId == id);
BUser bUser = Conversions.ConvertUserToBUser(user);
bUser.GroupName = user.Group.Name;
userResult.bUsers.Add(bUser);
_context.Users.Remove(user);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
userResult.IsValid = false;
userResult.ErrorMessages.Add(e.Message);
}
}
}
return(userResult);
}
public UserResult Edit(int id, BUser bUser)
{
UserResult userResult = new UserResult();
using (_context = new GroupsManagementDbEntities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
User user = _context.Users.Find(id);
user.UserName = bUser.Name;
user.Email = bUser.Email;
user.GroupId = bUser.GroupId;
_context.SaveChanges();
transaction.Commit();
userResult.bUsers.Add(Conversions.ConvertUserToBUser(user));
}
catch (Exception e)
{
userResult.IsValid = false;
userResult.ErrorMessages.Add(e.Message);
}
}
}
return(userResult);
}
public bool UserHasRole(string email, string roleName)
{
UserResult userResult = GetByEmail(email);
using (_context = new GroupsManagementDbEntities())
{
if (userResult.IsValid)
{
BUser bUser = userResult.bUsers.Single();
// get the user group
Group group = _context.Groups.FirstOrDefault(g => g.GroupId == bUser.GroupId);
if (group != null)
{
var groupRole = _context.GroupsRoles.
Where(gr => gr.GroupId == group.GroupId).
Where(gr => gr.Role.RoleName == roleName).FirstOrDefault();
if (groupRole != null)
{
return(true);
}
}
}
}
return(false);
}
public UserResult GetByEmail(string email)
{
UserResult userResult = new UserResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
User user = _context.Users.FirstOrDefault(u => u.Email == email);
if (user != null)
{
userResult.bUsers.Add(Conversions.ConvertUserToBUser(user));
}
else
{
userResult.IsValid = false;
userResult.ErrorMessages.Add("There is no user with this email");
}
}
catch (Exception e)
{
userResult.IsValid = false;
userResult.ErrorMessages.Add(e.Message);
}
}
return(userResult);
}
public RoleResult GetAll()
{
var roleResult = new RoleResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
var roles = _context.Roles.ToList().Select(r => Conversions.ConvertRoleToBRole(r));
roleResult.bRoles = roles.ToList();
}
catch (Exception e)
{
roleResult.IsValid = false;
roleResult.ErrorMessages.Add(e.Message);
}
}
return(roleResult);
}
public bool CheckPasswork(int userId, string password)
{
using (_context = new GroupsManagementDbEntities())
{
try
{
var user = _context.Users.First(u => u.UserId == userId);
if (user.Password == password)
{
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
return(false);
}
public UserResult GetAll()
{
UserResult userResult = new UserResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
IEnumerable <BUser> users = _context.Users.ToList().Select(u => Conversions.ConvertUserToBUser(u));
userResult.bUsers = users.ToList();
}
catch (Exception e)
{
userResult.IsValid = false;
userResult.ErrorMessages.Add(e.Message);
}
}
return(userResult);
}
public GroupResult GetAll()
{
var groupReslut = new GroupResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
IList <BGroup> groups = _context.Groups.Select(g => new BGroup {
GroupId = g.GroupId, Name = g.Name
}).ToList();
groupReslut.bGroups = groups;
}
catch (Exception e)
{
groupReslut.IsValid = false;
groupReslut.ErrorMessages.Add(e.Message);
}
}
return(groupReslut);
}
public GroupResult Get(int id)
{
GroupResult groupResult = new GroupResult();
using (_context = new GroupsManagementDbEntities())
{
try
{
Group group = _context.Groups.Find(id);
groupResult.bGroups.Add(new BGroup()
{
GroupId = group.GroupId,
Name = group.Name
});
}
catch (Exception e)
{
groupResult.IsValid = false;
groupResult.ErrorMessages.Add(e.Message);
}
}
return(groupResult);
}
public UserResult Add(BUser bUser)
{
UserResult userResult = new UserResult();
using (_context = new GroupsManagementDbEntities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
// check if group exists
Group group = _context.Groups.FirstOrDefault(g => g.GroupId == bUser.GroupId);
if (group != null)
{
User user = _context.Users.Add(Conversions.ConvertBUserToUser(bUser));
_context.SaveChanges();
transaction.Commit();
_context.Entry(user).Reference(u => u.Group).Load();
BUser newBUser = Conversions.ConvertUserToBUser(user);
userResult.bUsers.Add(newBUser);
}
else
{
throw new Exception("Can't create the user because this group doesn't exist");
}
}
catch (Exception e)
{
userResult.IsValid = false;
userResult.ErrorMessages.Add(e.Message);
}
}
}
return(userResult);
}