public ActionResult TourForm(string tourName, string summary, string tourDescription, string url, string bookNowUrl, string duration, string cost, string groupSize, string additionalInfo, Guid organGuid) { var tourGuid = System.Guid.NewGuid(); var context = new TravelContentManagerEntities(); var tour = new TOUR() { TOUR_GUID = tourGuid, TOUR_NAME = tourName, TOUR_SUMMARY = summary, TOUR_DESC = tourDescription, URL = url, BOOK_NOW_URL = bookNowUrl, DURATION = duration, COST = cost, GROUP_SIZE = groupSize, ADDITIONAL_INFO = additionalInfo, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; var orgToItem = new TOUR_ORGANIZATION_TO_ITEM { ORGANIZATION_TO_ITEM_ID = 1, ORGANIZATION_TO_ITEM_GUID = System.Guid.NewGuid(), ORGANIZATION_GUID = organGuid, ITEM_GUID = tourGuid, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; context.TOURs.Add(tour); context.TOUR_ORGANIZATION_TO_ITEM.Add(orgToItem); context.SaveChanges(); return(RedirectToAction("Tours", "Home", new { id = organGuid })); }
public ActionResult EventForm(string eventTitle, string description, DateTime startDate, DateTime endDate, string venue, double latitude, double longitude, string website, string ageRestriction, string cost, string contactName, string contactEmail, string ContactPhone) { var context = new TravelContentManagerEntities(); var tourEvent = new TOUR_EVENT() { EVENT_GUID = System.Guid.NewGuid(), EVENT_TITLE = eventTitle, EVENT_DESC = description, END_DATE = endDate, START_DATE = startDate, VENUE = venue, LATITUDE = latitude, LONGITUDE = longitude, WEBSITE = website, AGE_RESTRICTION = ageRestriction, COST = cost, CONTACT_NAME = contactName, CONTACT_EMAIL = contactEmail, CONTACT_PHONE = ContactPhone, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; context.TOUR_EVENT.Add(tourEvent); context.SaveChanges(); return(RedirectToAction("Events", "Home")); }
public ActionResult PlaceForm(string placeName, string summary, string placeDescription, string address, string phoneNumber, string website, double lattitude, double longitude, Guid organGuid) { var placeGuid = System.Guid.NewGuid(); var context = new TravelContentManagerEntities(); var place = new TOUR_PLACE() { PLACE_GUID = placeGuid, IS_DEFAULT_PLACE = true, PLACE_NAME = placeName, PLACE_SUMMARY = summary, PLACE_DESC = placeDescription, ADDRESS = address, PHONE = phoneNumber, WEBSITE = website, LATITUDE = lattitude, LONGITUDE = longitude, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; var orgToItem = new TOUR_ORGANIZATION_TO_ITEM { ORGANIZATION_TO_ITEM_ID = 1, ORGANIZATION_TO_ITEM_GUID = System.Guid.NewGuid(), ORGANIZATION_GUID = organGuid, ITEM_GUID = placeGuid, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; context.TOUR_PLACE.Add(place); context.TOUR_ORGANIZATION_TO_ITEM.Add(orgToItem); context.SaveChanges(); return(RedirectToAction("Places", "Home", new { id = organGuid })); }
public ActionResult PlaceToTourForm(string tour, string place, Guid organGuid) { using (var context = new TravelContentManagerEntities()) { var targetTourRecord = context.TOURs .Where(b => b.TOUR_NAME == tour) .FirstOrDefault(); var targetPlaceRecord = context.TOUR_PLACE .Where(b => b.PLACE_NAME == place) .FirstOrDefault(); var placeToTour = new TOUR_PLACE_TO_TOUR() { PLACE_TO_TOUR_ID = targetPlaceRecord.PLACE_ID, PLACE_TO_TOUR_GUID = System.Guid.NewGuid(), TOUR_GUID = targetTourRecord.TOUR_GUID, PLACE_GUID = targetPlaceRecord.PLACE_GUID, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now, PLACE_SUMMARY_OVERRIDE = targetPlaceRecord.PLACE_SUMMARY, PLACE_DESC_OVERRIDE = targetPlaceRecord.PLACE_DESC }; context.TOUR_PLACE_TO_TOUR.Add(placeToTour); context.SaveChanges(); } return(RedirectToAction("editTour", "Home", new { id = organGuid })); }
public ActionResult OrganizationForm(string organizationName, string description, string location, string url, string joinCode, string contactName, string contactEmail, string contactPhone, string groupSize, string additionalInfo) { var context = new TravelContentManagerEntities(); var organization = new TOUR_ORGANIZATION() { ORGANIZATION_GUID = System.Guid.NewGuid(), ORGANIZATION_NAME = organizationName, ORGANIZATION_DESC = description, LOCATION = location, URL = url, JOIN_CODE = joinCode, CONTACT_NAME = contactName, CONTACT_EMAIL = contactEmail, CONTACT_PHONE = contactPhone, ENTERED_BY = System.Guid.NewGuid(), ENTERED_DATE_TIME = DateTime.Now }; context.TOUR_ORGANIZATION.Add(organization); context.SaveChanges(); return(RedirectToAction("Organizations", "home")); }
public ActionResult EditTourForm(string tourName, string summary, string tourDescription, string url, string bookNowUrl, string duration, string cost, string groupSize, string additionalInfo, Guid organGuid) { using (var db = new TravelContentManagerEntities()) { var result = db.TOURs .Where(b => b.TOUR_NAME == tourName) .FirstOrDefault(); if (result != null) { result.TOUR_SUMMARY = summary; result.TOUR_DESC = tourDescription; result.URL = url; result.DURATION = duration; result.BOOK_NOW_URL = bookNowUrl; result.COST = cost; result.GROUP_SIZE = groupSize; result.ADDITIONAL_INFO = additionalInfo; db.SaveChanges(); } return(RedirectToAction("Tours", "home", new { id = organGuid })); } }