예제 #1
0
 public static UsersDTO GetProfessionalById(int id)
 {
     using (RecommendationsEntities3 db = new RecommendationsEntities3())
     {
         var p = db.Users.Find(id);
         if (p.Professionals != null)
         {
             return(ProfessionalConvertion.ProfessionalToDTO(p.Professionals));
         }
         return(UsersConvertion.UserToDTO(p));
     }
 }
예제 #2
0
        /// <summary>
        /// function for user register
        /// add the user to users table in the DB
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        public static bool RegisterUser(UsersDTO user)
        {
            using (RecommendationsEntities3 db = new RecommendationsEntities3())
            {
                var prof = db.Professionals.Find(user.UserId);
                if (prof != null)
                {
                    prof.UserSearch.Clear();
                    prof.Recommendations.Clear();
                    prof.ProfessionForProfessional.Clear();
                    db.Professionals.Remove(prof);
                }
                if (user.CityName != null)
                {
                    user.City = SetCityId(user.CityName);
                }

                var u = db.Users.Find(user.UserId);
                if (u == null)
                {
                    db.Users.Add(UsersConvertion.UserToDal(user));
                }
                else
                {
                    u.UserName     = user.UserName;
                    u.UserPassword = user.UserPassword;
                    u.UserPhone    = user.UserPhone;
                    u.UserEmail    = user.UserEmail;
                    u.IsManager    = user.IsManager;
                    u.City         = user.City;
                }
                try
                {
                    db.SaveChanges();
                    return(true);
                }
                catch  { return(false); }
            }
        }