public UserDTO Get(int id)
        {
            UserDTO retValue = null;

            using (var context = new DataAccessContext())
            {
                User user = (from n in context.Users
                             where n.ID == id
                             select n).FirstOrDefault();

                retValue = retValue.DTOConvert(user);
            }

            return(retValue);
        }
        public UserDTO VerifyUser(LoginDTO user)
        {
            UserDTO retValue       = null;
            string  hashedPassword = user.Password.MD5Encrypt();

            using (var context = new DataAccessContext())
            {
                User verifiedUser = null;

                verifiedUser = (from n in context.Users
                                where n.Email == user.Email &&
                                n.Password == hashedPassword
                                select n).FirstOrDefault();

                if (verifiedUser != null)
                {
                    retValue = retValue.DTOConvert(verifiedUser);
                }
            }

            return(retValue);
        }