public bool CreateUserProfile(UserProfileDAO s)
        {
            UserProfile userProfile = new UserProfile
            {
                UserId = s.UserId,
                UserName = s.UserName
            };

            using (AESDatabaseDataContext db = new AESDatabaseDataContext())
            {
                db.UserProfiles.InsertOnSubmit(userProfile);

                try
                {
                    db.SubmitChanges();
                }
                catch (Exception e)
                {
                    throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
                }
            }

            return true;
        }
        public IList<UserProfileDAO> GetUserProfiles()
        {
            try
            {
                using (AESDatabaseDataContext db = new AESDatabaseDataContext())
                {
                    IList<UserProfile> userProfiles = (from userProfile in db.UserProfiles select userProfile).OrderBy(o => o.UserId).ToList();
                    List<UserProfileDAO> result = new List<UserProfileDAO>();

                    foreach (var userProfile in userProfiles)
                    {
                        UserProfileDAO temp = new UserProfileDAO
                        {
                            ID = userProfile.UserId,
                            UserId = userProfile.UserId,
                            UserName = userProfile.UserName
                        };

                        result.Add(temp);
                    }

                    return (result != null ? result : null);
                }
            }
            catch (Exception e)
            {
                throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
            }
        }
        public bool UpdateUserProfile(UserProfileDAO newUserProfile)
        {
            using (AESDatabaseDataContext db = new AESDatabaseDataContext())
            {
                UserProfile userProfile = db.UserProfiles.Single(s => s.UserId == newUserProfile.UserId);
                userProfile.UserId = newUserProfile.UserId;
                userProfile.UserName = newUserProfile.UserName;

                try
                {
                    db.SubmitChanges();
                }
                catch (Exception e)
                {
                    throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
                }
            }

            return true;
        }
 public UserProfileDAO GetUserProfileByID(int id)
 {
     try
     {
         using (AESDatabaseDataContext db = new AESDatabaseDataContext())
         {
             UserProfile userProfile = (from uspro in db.UserProfiles where uspro.UserId == id select uspro).FirstOrDefault();
             UserProfileDAO result = new UserProfileDAO
             {
                 ID = userProfile.UserId,
                 UserId = userProfile.UserId,
                 UserName = userProfile.UserName
             };
             return (result != null ? result : null);
         }
     }
     catch (Exception e)
     {
         throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
     }
 }