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