source: branches/UserManagement/HeuristicLab.Services.Authentication/AuthenticationService.cs @ 4962

using System;
using System.Collections.Generic;
using System.Linq;
using System.ServiceModel;
using HeuristicLab.Services.Authentication.DataTransfer;
using HeuristicLab.Services.Authentication.DataAccess;
using System.Data.Linq;
using System.Diagnostics;

namespace HeuristicLab.Services.Authentication
{
    [ServiceBehavior(IncludeExceptionDetailInFaults = true)]
    public class AuthenticationService : IAuthenticationService
    {

        #region User


        public DataTransfer.User GetUser(Guid id)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var user = db.aspnet_Users.Where(x => x.UserId == id).FirstOrDefault();
                var membership = db.aspnet_Memberships.Where(x => x.UserId == id).FirstOrDefault();


                return Convert.ToDataTransfer(user, membership);


            }
        }

        public IEnumerable<DataTransfer.User> GetUsers(Guid applicationId)
        {
            List<DataTransfer.User> userList = new List<DataTransfer.User>();
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var users = db.aspnet_Users.Where(x => x.ApplicationId == applicationId).ToList<aspnet_User>();

                foreach (aspnet_User user in users)
                {
                    var membership = db.aspnet_Memberships.Where(x => x.UserId == user.UserId).FirstOrDefault();

                    userList.Add(Convert.ToDataTransfer(user, membership));

                }



            }
            return userList;
        }

        public Guid InsertUser(User user)
        {
            if (user != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    aspnet_User eUser = new aspnet_User();
                    aspnet_Membership eMembership = new aspnet_Membership();

                    Convert.ToEntity(user, eUser, eMembership);
                    try
                    {
                        db.aspnet_Users.InsertOnSubmit(eUser);
                        db.aspnet_Memberships.InsertOnSubmit(eMembership);
                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return Guid.Empty;
                    }

                    return user.Id;


                }

            }
            return Guid.Empty;
        }

        public bool DeleteUser(Guid id)
        {

            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var user = db.aspnet_Users.Where(x => x.UserId == id).FirstOrDefault();
                var membership = db.aspnet_Memberships.Where(x => x.UserId == id).FirstOrDefault();
                var userinroles = db.aspnet_UsersInRoles.Where(x => x.UserId == id).ToList<aspnet_UsersInRole>();
                try
                {
                    db.aspnet_UsersInRoles.DeleteAllOnSubmit(userinroles);
                    db.aspnet_Memberships.DeleteOnSubmit(membership);
                    db.aspnet_Users.DeleteOnSubmit(user);
                    db.SubmitChanges();
                }
                catch (Exception ex)
                {
                    return false;
                }
                return true;

            }
            return false;
        }


        public bool UpdateUser(User user)
        {
            if (user != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    var eUser = db.aspnet_Users.Where(x => x.UserId == user.Id).FirstOrDefault();
                    var eMembership = db.aspnet_Memberships.Where(x => x.UserId == user.Id).FirstOrDefault();
                    Convert.ToEntity(user, eUser, eMembership);
                    try
                    {

                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return false;
                    }

                    return true;

                }

            }
            return false;
        }



        #endregion



        #region Role

        public Role GetRole(Guid id)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var role = db.aspnet_Roles.Where(x => x.RoleId == id).FirstOrDefault();
                return Convert.ToDataTransfer(role);
            }
        }

        public IEnumerable<Role> GetRoles(Guid applicationId)
        {
            List<DataTransfer.Role> roleList = new List<DataTransfer.Role>();
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var roles = db.aspnet_Roles.Where(x => x.ApplicationId == applicationId).ToList<aspnet_Role>();

                foreach (aspnet_Role role in roles)
                {
                    roleList.Add(Convert.ToDataTransfer(role));
                }

            }
            return roleList;
        }

        public Guid InsertRole(Role role)
        {

            if (role != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    aspnet_Role eRole = new aspnet_Role();

                    Convert.ToEntity(role, eRole);
                    try
                    {
                        db.aspnet_Roles.InsertOnSubmit(eRole);
                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return Guid.Empty;
                    }

                    return role.Id;
                }

            }
            return Guid.Empty;
        }

        public bool DeleteRole(Guid id)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var role = db.aspnet_Roles.Where(x => x.RoleId == id).FirstOrDefault();


                try
                {
                    db.aspnet_Roles.DeleteOnSubmit(role);
                    db.SubmitChanges();
                }
                catch (Exception ex)
                {
                    return false;
                }
                return true;


            }
        }

        public bool AddUserToRole(Guid roleId, Guid userId)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                try
                {
                    aspnet_UsersInRole r = new aspnet_UsersInRole();
                    r.RoleId = roleId;
                    r.UserId = userId;
                    db.aspnet_UsersInRoles.InsertOnSubmit(r);
                    db.SubmitChanges();
                    return true;
                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex.InnerException);
                    return false;
                }
            }
        }

        public bool RemoveUserFromRole(Guid roleId, Guid userId)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                try
                {
                    var role = db.aspnet_UsersInRoles.Where(x => x.RoleId == roleId && x.UserId == userId).FirstOrDefault();

                    db.aspnet_UsersInRoles.DeleteOnSubmit(role);
                    db.SubmitChanges();
                    return true;

                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex.InnerException);
                    return false;
                }
            }

        }

        public IEnumerable<Role> GetRolesForUser(Guid userId)
        {
            List<Role> roleList = new List<Role>();
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                try
                {
                    var roles = db.aspnet_UsersInRoles.Where(x => x.UserId == userId).ToList<aspnet_UsersInRole>();

                    foreach (aspnet_UsersInRole r in roles)
                    {
                        roleList.Add(GetRole(r.RoleId));

                    }

                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex.InnerException);
                    return new List<Role>();
                }
            }

            return roleList;
        }

        public IEnumerable<User> GetUsersInRole(Guid roleId)
        {
            List<User> userList = new List<User>();
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                try
                {
                    var users = db.aspnet_UsersInRoles.Where(x => x.RoleId == roleId).ToList<aspnet_UsersInRole>();

                    foreach (aspnet_UsersInRole u in users)
                    {
                        userList.Add(GetUser(u.UserId));

                    }

                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex.InnerException);
                    return new List<User>();
                }
            }

            return userList;
        }



        public bool UpdateRole(Role role)
        {
            if (role != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    var eRole = db.aspnet_Roles.Where(x => x.RoleId == role.Id).FirstOrDefault();

                    Convert.ToEntity(role, eRole);
                    try
                    {

                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return false;
                    }

                    return true;

                }

            }
            return false;
        }



        #endregion



        #region Application

        public Guid InsertApplication(Application application)
        {
            if (application != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    aspnet_Application eApplication = new aspnet_Application();

                    Convert.ToEntity(application, eApplication);
                    try
                    {
                        db.aspnet_Applications.InsertOnSubmit(eApplication);
                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return Guid.Empty;
                    }

                    return application.Id;

                }

            }
            return Guid.Empty;
        }

        public bool UpdateApplication(Application application)
        {
            if (application != null)
            {
                using (UserManagementDataContext db = new UserManagementDataContext())
                {

                    var eApplication = db.aspnet_Applications.Where(x => x.ApplicationId == application.Id).FirstOrDefault();

                    Convert.ToEntity(application, eApplication);
                    try
                    {

                        db.SubmitChanges();
                    }
                    catch (Exception ex)
                    {
                        return false;
                    }

                    return true;

                }

            }
            return false;
        }


        public bool DeleteApplication(Guid applicationId)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var users = db.aspnet_Users.Where(x => x.ApplicationId == applicationId).ToList<aspnet_User>();
                var memberships = db.aspnet_Memberships.Where(x => x.ApplicationId == applicationId).ToList<aspnet_Membership>();

                var roles = db.aspnet_Roles.Where(x => x.ApplicationId == applicationId).ToList<aspnet_Role>();
                var application = db.aspnet_Applications.Where(x => x.ApplicationId == applicationId).FirstOrDefault();

                try
                {
                    foreach (aspnet_User u in users)
                    {
                        var userinroles = db.aspnet_UsersInRoles.Where(x => x.UserId == u.UserId).ToList<aspnet_UsersInRole>();
                        db.aspnet_UsersInRoles.DeleteAllOnSubmit(userinroles);
                    }

                    db.aspnet_Memberships.DeleteAllOnSubmit(memberships);
                    db.aspnet_Users.DeleteAllOnSubmit(users);
                    db.aspnet_Roles.DeleteAllOnSubmit(roles);
                    db.aspnet_Applications.DeleteOnSubmit(application);
                    db.SubmitChanges();
                }
                catch (Exception ex)
                {
                    return false;
                }
                return true;


            }
            return false;
        }

        public Application GetApplication(Guid id)
        {
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var application = db.aspnet_Applications.Where(x => x.ApplicationId == id).FirstOrDefault();
                return Convert.ToDataTransfer(application);
            }
        }

        public IEnumerable<DataTransfer.Application> GetApplications()
        {
            List<DataTransfer.Application> applicationList = new List<DataTransfer.Application>();
            using (UserManagementDataContext db = new UserManagementDataContext())
            {
                var apps = db.aspnet_Applications.ToList<aspnet_Application>();

                foreach (aspnet_Application app in apps)
                {
                    applicationList.Add(Convert.ToDataTransfer(app));
                }

            }
            return applicationList;
        }

        #endregion
    }

}