public void CreateUser(CreateUserViewModel createUserViewModel, int userId)
{
createUserViewModel.User.CreatedDate = DateTime.Now;
createUserViewModel.User.CreatedBy = userId;
createUserViewModel.User.IsVarified = 0;
createUserViewModel.User.IsActive = 1;
CapInnovativeIdiaDbContext.User.Add(createUserViewModel.User);
CapInnovativeIdiaDbContext.SaveChanges();
foreach (var role in createUserViewModel.RoleIds)
{
var assignRole = new UserRoleMapping
{
RoleId = role,
UserId = createUserViewModel.User.Id,
CreatedBy = userId,
CreatedDate = DateTime.Now,
IsActive = 1
};
CapInnovativeIdiaDbContext.UserRoleMapping.Add(assignRole);
}
CapInnovativeIdiaDbContext.SaveChanges();
}
public void UpdateUser(CreateUserViewModel createUserViewModel, int userId)
{
var user = CapInnovativeIdiaDbContext.User.Where(x => x.Id == createUserViewModel.User.Id).SingleOrDefault();
if (user != null)
{
user.FirstName = createUserViewModel.User.FirstName;
user.LastName = createUserViewModel.User.LastName;
user.Email = createUserViewModel.User.Email;
user.Gender = createUserViewModel.User.Gender;
user.ModifiedBy = userId;
user.ModifiedDate = DateTime.Now;
CapInnovativeIdiaDbContext.User.Update(user);
CapInnovativeIdiaDbContext.SaveChanges();
foreach (var role in createUserViewModel.RoleIds)
{
var currentRole = CapInnovativeIdiaDbContext.UserRoleMapping.Where(x => x.RoleId == role && x.UserId == createUserViewModel.User.Id).SingleOrDefault();
if (currentRole != null)
{
if (currentRole.IsActive == 1)
{
continue;
}
else
{
currentRole.IsActive = 1;
currentRole.ModifiedBy = userId;
currentRole.ModifiedDate = DateTime.Now;
CapInnovativeIdiaDbContext.UserRoleMapping.Update(currentRole);
CapInnovativeIdiaDbContext.SaveChanges();
}
}
var newRole = new UserRoleMapping
{
RoleId = role,
UserId = createUserViewModel.User.Id,
CreatedBy = userId,
CreatedDate = DateTime.Now,
IsActive = 1
};
CapInnovativeIdiaDbContext.UserRoleMapping.Add(newRole);
CapInnovativeIdiaDbContext.SaveChanges();
}
var removeRoles = CapInnovativeIdiaDbContext.UserRoleMapping.Where(x => x.UserId == createUserViewModel.User.Id && !createUserViewModel.RoleIds.Contains(x.RoleId)).ToList();
if (removeRoles != null)
{
removeRoles.ForEach(x => x.IsActive = 0);
CapInnovativeIdiaDbContext.SaveChanges();
}
}
}
public void DeleteUser(int id)
{
var userDetails = CapInnovativeIdiaDbContext.User.Where(u => u.Id == id).SingleOrDefault();
if (userDetails != null)
{
CapInnovativeIdiaDbContext.User.Remove(userDetails);
CapInnovativeIdiaDbContext.SaveChanges();
var userRoles = CapInnovativeIdiaDbContext.UserRoleMapping.Where(r => r.UserId == id).ToList();
CapInnovativeIdiaDbContext.UserRoleMapping.RemoveRange(userRoles);
CapInnovativeIdiaDbContext.SaveChanges();
}
}
public ControllerActionRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
public UserRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
public AccountRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
public IdiaStatusRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
public IdiaProposalRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
public IdiaCategoryRepository(CapInnovativeIdiaDbContext capInnovativeIdiaDbContext) : base(capInnovativeIdiaDbContext)
{
}
