public static Suggestion SaveSuggestion(Suggestion suggestion) { try { entities.Suggestions.Add(suggestion); entities.SaveChanges(); return(suggestion); } catch (Exception ex) { return(null); } }
public static bool UpdateTraveler(Traveler traveler) { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { Traveler tt = entities.Travelers.First(t => t == traveler); tt = traveler; entities.SaveChanges(); } return(true); } catch { return(false); } }
public static Suggestion UpdateSuggestion(Suggestion suggestion) { try { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { var ss = entities.Suggestions.First(s => s.SuggestionID == suggestion.SuggestionID); DbEntityEntry <Suggestion> ee = entities.Entry(ss); ee.CurrentValues.SetValues(suggestion); entities.SaveChanges(); return(suggestion); } } catch (Exception ex1) { int id = suggestion.SuggestionID; using (YMprojectEntities1 entities = new YMprojectEntities1()) { //Suggestion ss; var ss = entities.Suggestions.First(s => s.SuggestionID == suggestion.SuggestionID); // ss = suggestion; } using (YMprojectEntities1 entities = new YMprojectEntities1()) { suggestion.Host = null; ManageSuggestion.DeleteSuggestion(id); } using (YMprojectEntities1 entities = new YMprojectEntities1()) { Suggestion spdt = ManageSuggestion.SaveSuggestion(suggestion); entities.SaveChanges(); // Suggestion pdt = entities.Suggestions.Where(spdt => id== spdt.SuggestionID).First(); return(spdt); } } } catch (Exception ex) { return(null); } }
public static bool DeleteHost(User userHost) { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { entities.Users.Remove(userHost); entities.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public static bool DeleteTraveler(Traveler traveler) { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { entities.Travelers.Remove(traveler); entities.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public static Traveler SaveTraveler(User traveler) { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { entities.Users.Add(traveler); entities.SaveChanges(); return(traveler.Traveler); } } catch (Exception ex) { return(null); } }
public static Suggestion SaveSuggestion(Suggestion suggestion) { using (YMprojectEntities1 entities = new YMprojectEntities1()) { try { entities.Suggestions.Add(suggestion); entities.SaveChanges(); return(suggestion); } catch (Exception ex) { return(null); } } }
public static Host UpdateHost(Host userHost) { try { using (YMprojectEntities1 entities = new YMprojectEntities1()) { Host hh = entities.Hosts.First(h => h == userHost); if (hh != null) { hh = userHost; } entities.SaveChanges(); return(hh); } } catch { return(null); } }
public static Host SaveHost(User userhost) { try { int x; using (YMprojectEntities1 entities = new YMprojectEntities1()) { entities.Users.Add(userhost); entities.SaveChanges(); x = userhost.UserId; return(userhost.Host); } } catch (Exception ex) { return(null); } }
public static bool DeleteSuggestion(int id) { using (YMprojectEntities1 entities = new YMprojectEntities1()) { try { Suggestion suggestion = entities.Suggestions.Where(s => s.SuggestionID == id) .Include(ss => ss.ServiceTypesToSuggestions) .Include(ss => ss.bookedDates) .First(); if (suggestion.Address != null) { entities.Addresses.Remove(suggestion.Address); } if (suggestion.ageRange != null) { entities.ageRanges.Remove(suggestion.ageRange); } if (suggestion.HoursRange != null) { entities.HoursRanges.Remove(suggestion.HoursRange); } if (suggestion.ServiceTypesToSuggestions != null) { entities.ServiceTypesToSuggestions.RemoveRange(suggestion.ServiceTypesToSuggestions); } if (suggestion.bookedDates != null) { entities.bookedDates.RemoveRange(suggestion.bookedDates); } // suggestion.ServiceTypesToSuggestions.Clear(); entities.Suggestions.Remove(suggestion); entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
public static SuggestionTraveler SaveSuggestionTraveler(SuggestionTraveler suggestionTraveler) { using (YMprojectEntities1 entities = new YMprojectEntities1()) { try { SuggestionTraveler st = entities.SuggestionTravelers.FirstOrDefault(s => s.SuggestionId == suggestionTraveler.SuggestionId && s.TravelerId == suggestionTraveler.TravelerId); if (st == null) { entities.SuggestionTravelers.Add(suggestionTraveler); } else { st.Status = suggestionTraveler.Status; } entities.SaveChanges(); return(suggestionTraveler); } catch (Exception ex) { return(null); } } }