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