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)); } }
/// <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); } } }