public ActionResult Create([Bind(Include = "PrimaryTechnologyID,AudienceTypes,LearningResourceTypeID,RSSLink")] LearningResourceFeed learningResourceFeed, List <string> AudienceTypeNames) { if (ModelState.IsValid) { learningResourceFeed.AudienceTypes = new List <AudienceType>(); if (AudienceTypeNames != null) { foreach (var audienceTypeName in AudienceTypeNames) { //add new audience type to learning resource. var audienceType = db.AudienceTypes.FirstOrDefault(a => a.TypeOfAudience == audienceTypeName); if (audienceType != null) { learningResourceFeed.AudienceTypes.Add(audienceType); } } } //add new learning resource. db.LearningResourceFeeds.Add(learningResourceFeed); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(learningResourceFeed)); }
public ActionResult Create([Bind(Include = "SpeakerID,SpeakerName,Profile,PicUrl,Affiliation,Title,Email,MobilePhone,TwitterHandle,FacebookLink,LinkedInLink,BlogLink,Type,RecommendedBy,SpeakerLevel,Location")] Speaker speaker) { if (ModelState.IsValid) { db.Speakers.Add(speaker); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(speaker)); }
public ActionResult Create([Bind(Include = "ThemeID,FY,ThemeName")] Theme theme) { if (ModelState.IsValid) { db.Themes.Add(theme); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(theme)); }
public ActionResult Create([Bind(Include = "AudienceTypeID,TypeOfAudience")] AudienceType audienceType) { if (ModelState.IsValid) { db.AudienceTypes.Add(audienceType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(audienceType)); }
public ActionResult Create([Bind(Include = "FeedbackID,TrackAgendaID,NameToken,ContentRating,SpeakerRating,OverallRating,LTRRating,Review")] Feedback feedback) { if (ModelState.IsValid) { db.Feedbacks.Add(feedback); db.SaveChanges(); return(RedirectToAction("Index")); } // ViewBag.TrackAgendaID = new SelectList(db.TrackAgendas, "TrackAgendaID", "Event_Track_Session_Speakers", feedback.TrackAgendaID); return(View(feedback)); }
public ActionResult Create([Bind(Include = "AudienceOrgID,AudOrg,AudienceTypeID")] AudienceOrg audienceOrg) { if (ModelState.IsValid) { db.AudienceOrgs.Add(audienceOrg); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AudienceTypeID = new SelectList(db.AudienceTypes, "AudienceTypeID", "TypeOfAudience", audienceOrg.AudienceTypeID); return(View(audienceOrg)); }
public ActionResult Create(int id, [Bind(Include = "SessionID,SessionNo,Title,Abstract,TechLevel,PrimaryTechnologyID,SecondaryTechnologyID,Product,InfraNeeds,PreRequisites,PostRequisites,TrackID")] Session session) { if (ModelState.IsValid) { db.Sessions.Add(session); db.SaveChanges(); return(RedirectToAction("Browse", new { id = session.TrackID })); } ViewBag.TrackID = new SelectList(db.Tracks.Where(e => e.TrackID == id), "TrackID", "TrackDisplayName", session.TrackID); ViewBag.PrimaryTechnologyID = new SelectList(db.PrimaryTechnologies, "PrimaryTechnologyID", "PrimaryTech"); return(View(session)); }
public ActionResult Create([Bind(Include = "EventTrackID,EventID,TrackID,TrackVenue,TrackDate,TrackStartTime,TrackEndTime,TrackSeating,TrackOwner")] EventTrack eventTrack) { if (ModelState.IsValid) { db.EventTracks.Add(eventTrack); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EventID = new SelectList(db.Events, "EventID", "EventName", eventTrack.EventID); ViewBag.TrackID = new SelectList(db.Tracks, "TrackID", "TrackDisplayName", eventTrack.TrackID); return(View(eventTrack)); }
public ActionResult Create([Bind(Include = "TrackID,TrackDisplayName,TrackAbstract,AudienceTypeID,InternalTrackName,Format,ThemeID")] Track track) { if (ModelState.IsValid) { db.Tracks.Add(track); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ThemeID = new SelectList(db.Themes, "ThemeID", "ThemeName", track.ThemeID); ViewBag.AudienceTypeID = new SelectList(db.AudienceTypes, "AudienceTypeID", "TypeOfAudience", track.AudienceTypeID); return(View(track)); }
public ActionResult Create([Bind(Include = "EventID,EventName,EventAbstract,EventFromDate,EventToDate,EventVenue,RegLink,MaxCapacity,ScEligibility,RegCapacity,PubtoMSCOM,PostRegistered,PostAttended,PostManualOverallRating,EventOwner,EventVisibility,EventType,CityName")] Event @event) { if (ModelState.IsValid) { //@event.EventStatus = 1 ; //See how to assign to Enum db.Events.Add(@event); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CityName = new SelectList(db.Cities, "CityName", "State", @event.CityName); return(View(@event)); }
public ActionResult Create(int id, [Bind(Include = "TrackAgendaID,EventTrackID,SpeakerID,SessionID,Event_Track_Session_Speakers,StartTime,EndTime,FavCount,QRCode")] TrackAgenda trackAgenda) { trackAgenda.EventTrackID = id; if (ModelState.IsValid) { db.TrackAgendas.Add(trackAgenda); db.SaveChanges(); return(RedirectToAction("DisplaySession", new { id = trackAgenda.EventTrackID })); } ViewBag.EventTrackID = new SelectList(db.EventTracks, "EventTrackID", "Event_TrackCombination", trackAgenda.EventTrackID); var tid = db.EventTracks.Where(e => e.EventTrackID == id).Select(e => e.TrackID).FirstOrDefault(); ViewBag.SessionID = new SelectList(db.Sessions.Where(e => e.TrackID == tid), "SessionID", "Title"); ViewBag.SpeakerID = new SelectList(db.Speakers, "SpeakerID", "SpeakerName", trackAgenda.SpeakerID); return(View(trackAgenda)); }
public ActionResult Create([Bind(Include = "PrimaryTechnologyID,PrimaryTech")] PrimaryTechnology primaryTechnology) { if (ModelState.IsValid) { if (!db.PrimaryTechnologies.Any(x => x.PrimaryTech == primaryTechnology.PrimaryTech)) { db.PrimaryTechnologies.Add(primaryTechnology); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("PrimaryTechnology", "Duplicate values are not allowed"); return(View()); } } return(View(primaryTechnology)); }
public ActionResult Create([Bind(Include = "CityName,State,Zone")] City city) { if (ModelState.IsValid) { if (!db.Cities.Any(x => x.CityName == city.CityName)) { db.Cities.Add(city); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("City", "Duplicate values are not allowed"); return(View()); } } return(View(city)); }
public ActionResult Create([Bind(Include = "SecondaryTechnologyID,SecondaryTech,PrimaryTechnologyID")] SecondaryTechnology secondaryTechnology) { if (ModelState.IsValid) { if (!db.SecondaryTechnologies.Any(x => x.SecondaryTech == secondaryTechnology.SecondaryTech)) { db.SecondaryTechnologies.Add(secondaryTechnology); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("SecondaryTechnology", "Duplicate values are not allowed"); ViewBag.PrimaryTechnologyID = new SelectList(db.PrimaryTechnologies, "PrimaryTechnologyID", "PrimaryTech", secondaryTechnology.PrimaryTechnologyID); return(View()); } } ViewBag.PrimaryTechnologyID = new SelectList(db.PrimaryTechnologies, "PrimaryTechnologyID", "PrimaryTech", secondaryTechnology.PrimaryTechnologyID); return(View(secondaryTechnology)); }
// Please set the following connection strings in app.config for this WebJob to run: // AzureWebJobsDashboard and AzureWebJobsStorage private static void Main() { using (TechReadyDbContext ctx = new TechReadyDbContext()) { var feedsToCheck = (from c in ctx.LearningResourceFeeds select c).ToList(); foreach (var feedType in feedsToCheck) { XmlReader reader = XmlReader.Create(feedType.RSSLink, new XmlReaderSettings() { }); SyndicationFeed feed = SyndicationFeed.Load(reader); foreach (SyndicationItem i in feed.Items) { var link = i.Links[0].Uri.ToString(); if (ctx.LearningResources.FirstOrDefault(x => x.ContentURL == link) == null) { try { XmlSyndicationContent content = i.Content as XmlSyndicationContent; LearningResource lr = new LearningResource(); lr.Title = i.Title.Text; lr.AudienceTypes = new List <AudienceType>(); foreach (AudienceType a in feedType.AudienceTypes) { lr.AudienceTypes.Add(a); } lr.ContentURL = i.Links[0].Uri.ToString(); lr.LearningResourceTypeID = feedType.LearningResourceTypeID; lr.PrimaryTechnologyID = feedType.PrimaryTechnologyID; lr.PublicationTime = i.PublishDate.UtcDateTime; if (feedType.LearningResourceTypeID == 1) { lr.Description = GetExtensionElementValue <string>(i, "summary"); lr.ThumbnailURL = GetThumbnailChannel9(i); } else { lr.Description = i.Summary.Text; lr.ThumbnailURL = ""; } ctx.LearningResources.Add(lr); } catch { } } } } ctx.SaveChanges(); } }
//[ValidateAntiForgeryToken] public String CreateEvent(EventInfoModel eventInfo) { if (eventInfo.Event.EventTypeObj != null) { eventInfo.Event.EventType = (EventType)eventInfo.Event.EventTypeObj.Key; // map key to enum type. } if (eventInfo.Event.EventStatusObj != null) { eventInfo.Event.EventStatus = (EventStatus)eventInfo.Event.EventStatusObj.Key; // map key to enum type. } if (eventInfo.Event.EventVisibilityObj != null) { eventInfo.Event.EventVisibility = (EventVisibility)eventInfo.Event.EventVisibilityObj.Key; // map key to from enum type. } if (eventInfo.Event.EventScEligibilityObj != null) { eventInfo.Event.ScEligibility = (scEligibility)eventInfo.Event.EventScEligibilityObj.Key; // map key to enum type. } if (ModelState.IsValid) { if (eventInfo.Event.EventID == 0) //if new event. { db.Events.Add(eventInfo.Event); //add new event. if (eventInfo.EventTracks == null && (eventInfo.EventTechnologTags == null || eventInfo.EventAudienceTypeTags == null)) //event technolog tags does not exist and event tracks are also empty. { return(JsonConvert.SerializeObject(new { responseCode = 003 })); } db.SaveChanges(); if (eventInfo.EventTracks != null) //event tracks if exists. { foreach (var eventTrack in eventInfo.EventTracks) { eventTrack.EventID = eventInfo.Event.EventID; db.EventTracks.Add(eventTrack); } if (eventInfo.EventTechnologTags != null) //event log tags in event if exist. { var @event = db.Events.Where(x => x.EventID == eventInfo.Event.EventID).FirstOrDefault(); foreach (var eventLog in eventInfo.EventTechnologTags) { @event.EventTechnologTags.Remove(eventLog); } } if (eventInfo.EventAudienceTypeTags != null) { var @event = db.Events.Where(x => x.EventID == eventInfo.Event.EventID).FirstOrDefault(); foreach (var eventLog in eventInfo.EventAudienceTypeTags) { @event.EventAudienceTypeTags.Remove(eventLog); } } } else { var @event = db.Events.Where(x => x.EventID == eventInfo.Event.EventID).FirstOrDefault(); @event.EventTechnologTags = new List <PrimaryTechnology>(); foreach (var eventLog in eventInfo.EventTechnologTags) //event techno log tags exist. { var existingEventLog = db.PrimaryTechnologies.Where(x => x.PrimaryTechnologyID == eventLog.PrimaryTechnologyID).FirstOrDefault(); @event.EventTechnologTags.Add(existingEventLog); //add to event. } @event.EventAudienceTypeTags = new List <AudienceType>(); foreach (var eventLog in eventInfo.EventAudienceTypeTags) //event techno log tags exist. { var existingEventLog = db.AudienceTypes.Where(x => x.AudienceTypeID == eventLog.AudienceTypeID).FirstOrDefault(); @event.EventAudienceTypeTags.Add(existingEventLog); //add to event. } } } else { var existingEvent = db.Events .Where(p => p.EventID == eventInfo.Event.EventID) .Include("EventTracks.TrackAgendas") .SingleOrDefault(); if (existingEvent != null) //event already exist. { db.Entry(existingEvent).CurrentValues.SetValues(eventInfo.Event); //update existing event values. // Delete children foreach (var existingChild in existingEvent.EventTracks.ToList()) { if (eventInfo.EventTracks == null || !eventInfo.EventTracks.Any(c => c.EventTrackID == existingChild.EventTrackID)) { existingChild.TrackAgendas.ToList().ForEach(p => db.TrackAgendas.Remove(p)); db.EventTracks.Remove(existingChild); } } if (eventInfo.EventTracks != null) { // Update and Insert children foreach (var childModel in eventInfo.EventTracks) { var existingChild = existingEvent.EventTracks .Where(c => c.EventTrackID == childModel.EventTrackID) .SingleOrDefault(); if (existingChild != null) { // Update child db.Entry(existingChild).CurrentValues.SetValues(childModel); // Delete children foreach (var existingGrandChild in existingChild.TrackAgendas.ToList()) { if (!existingChild.TrackAgendas.Any(c => c.TrackAgendaID == existingGrandChild.TrackAgendaID)) { db.TrackAgendas.Remove(existingGrandChild); } } // Update and Insert children foreach (var grandChildModel in existingChild.TrackAgendas) { var existingGrandChild = existingChild.TrackAgendas .Where(c => c.TrackAgendaID == grandChildModel.TrackAgendaID) .SingleOrDefault(); if (existingGrandChild != null) { // Update child db.Entry(existingGrandChild).CurrentValues.SetValues(grandChildModel); } else { // Insert child var newChild = new TrackAgenda() { EndTime = grandChildModel.EndTime, SpeakerID = grandChildModel.SpeakerID, EventTrackID = grandChildModel.EventTrackID, FavCount = grandChildModel.FavCount, QRCode = grandChildModel.QRCode, SessionID = grandChildModel.SessionID, StartTime = grandChildModel.StartTime }; existingChild.TrackAgendas.Add(newChild); } } } else { // Insert child var newChild = new EventTrack() { EventID = childModel.EventID, TrackEndTime = childModel.TrackEndTime, TrackID = childModel.TrackID, TrackOwner = childModel.TrackOwner, TrackSeating = childModel.TrackSeating, TrackVenue = childModel.TrackVenue, TrackStartTime = childModel.TrackStartTime, TrackAgendas = childModel.TrackAgendas }; existingEvent.EventTracks.Add(newChild); } } if (existingEvent.EventTechnologTags != null) { var existingTags = existingEvent.EventTechnologTags.ToList(); foreach (var eventLog in existingTags) { existingEvent.EventTechnologTags.Remove( existingEvent.EventTechnologTags.FirstOrDefault( x => x.PrimaryTechnologyID == eventLog.PrimaryTechnologyID)); } } if (existingEvent.EventAudienceTypeTags != null) { var existingTags = existingEvent.EventAudienceTypeTags.ToList(); foreach (var eventLog in existingTags) { existingEvent.EventAudienceTypeTags.Remove( existingEvent.EventAudienceTypeTags.FirstOrDefault( x => x.AudienceTypeID == eventLog.AudienceTypeID)); } } } else { if (eventInfo.EventTechnologTags == null) { return(JsonConvert.SerializeObject(new { responseCode = 003 })); } else { if (existingEvent.EventTechnologTags != null) { var existingTags = existingEvent.EventTechnologTags.ToList(); foreach (var eventLog in existingTags) { existingEvent.EventTechnologTags.Remove(eventLog); } } existingEvent.EventTechnologTags = new List <PrimaryTechnology>(); foreach (var eventLog in eventInfo.EventTechnologTags) { var existingEventLog = db.PrimaryTechnologies.Where(x => x.PrimaryTechnologyID == eventLog.PrimaryTechnologyID).FirstOrDefault(); existingEvent.EventTechnologTags.Add(existingEventLog); //add new techno log tags of event. } } if (eventInfo.EventAudienceTypeTags == null) { return(JsonConvert.SerializeObject(new { responseCode = 003 })); } else { if (existingEvent.EventAudienceTypeTags != null) { var existingTags = existingEvent.EventAudienceTypeTags.ToList(); foreach (var eventLog in existingTags) { existingEvent.EventAudienceTypeTags.Remove(eventLog); } } existingEvent.EventAudienceTypeTags = new List <AudienceType>(); foreach (var eventLog in eventInfo.EventAudienceTypeTags) { var existingEventLog = db.AudienceTypes.Where(x => x.AudienceTypeID == eventLog.AudienceTypeID).FirstOrDefault(); existingEvent.EventAudienceTypeTags.Add(existingEventLog); //add new techno log tags of event. } } } } } db.SaveChanges(); return(JsonConvert.SerializeObject(new { responseCode = 001 })); } return(JsonConvert.SerializeObject(new { responseCode = 002 })); }