public static bool SetProfessionsToProfessional(ProfessionalDTO professional) { using (RecommendationsEntities3 db = new RecommendationsEntities3()) { db.ProfessionForProfessional.AddRange(professional.professions.Select(p => new ProfessionForProfessional { Profession = p.ProfessionId, Professional = professional.UserId })); try { db.SaveChanges(); return(true); } catch { return(false); } } }
public static bool RegisterProfessional(ProfessionalDTO professional)//??????profession { using (RecommendationsEntities3 db = new RecommendationsEntities3()) { if (professional.CityName != null) { professional.City = SetCityId(professional.CityName); } var prof = db.Professionals.Find(professional.ProfessionalId); var user = db.Users.Find(professional.UserId); //ProfessionsService.SetProfessionsToProfessional(professional);הוספת מקצועות לבעל מקצוע if (prof == null) { if (user == null) { db.Professionals.Add(ProfessionalConvertion.ProfessionalToDal(professional)); } else { db.Professionals.Add(ProfessionalConvertion.ProfessionalWithoutUserToDal(professional)); } } else { prof.FirstName = professional.FirstName; prof.LastName = professional.LastName; prof.BussName = professional.BussName; prof.NumHouse = professional.NumHouse; prof.Street = professional.Street; prof.DescriptionOn = professional.DescriptionOn; prof.Users.City = professional.City; prof.Users.IsManager = professional.IsManager; prof.Users.UserPassword = professional.UserPassword; prof.Users.UserPhone = professional.UserPhone; prof.Users.UserName = professional.UserName; //prof.ProfessionForProfessional.Add.AddRange(professional.professions.Select(p => new ProfessionForProfessional { Profession = p.ProfessionId, Professional = professional.UserId })); //לעשות הוספת מקצועות לבעל מקצוע בשתי האפשרויות :יצירה ועדכון } try { db.SaveChanges(); return(true); } catch { return(false); } } }
/// <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); } } }
/// <summary> /// function for create a recommendation /// if the ratings is null- put 50 on it /// take the date of today /// </summary> /// <param name="recommendation"></param> /// <returns></returns> public static bool CreateRecommendation(RecommendationsDTO recommendation) { using (RecommendationsEntities3 db = new RecommendationsEntities3()) { var rec = db.Recommendations.FirstOrDefault(r => r.Professional == recommendation.Professional && r.UserId == recommendation.UserId); if (rec != null) { return(false); } recommendation.RateArrival = recommendation.RateArrival == null ? 50 : recommendation.RateArrival; recommendation.RatePrice = recommendation.RatePrice == null ? 50 : recommendation.RatePrice; recommendation.RateProfessionalism = recommendation.RateProfessionalism == null ? 50 : recommendation.RateProfessionalism; recommendation.RecommendationDate = DateTime.Now; db.Recommendations.Add(RecommendationConvertion.RecommendationToDal(recommendation)); try { db.SaveChanges(); return(true); } catch { return(false); } } }