static void CreateSampleConference(ThripEntities dataContext)
{
var _conference = new Conference();
_conference.Id = Guid.NewGuid();
_conference.Name = "MVC Springboard";
_conference.StartDate = DateTime.Parse("9/3/2010");
_conference.EndDate = DateTime.Parse("9/5/2010");
_conference.Description = "A really great conference! Come and see.";
_conference.URL = "http://www.mvcspringboard.org";
dataContext.Conferences.AddObject(_conference);
}
static void CreateSampleFacilitators(ThripEntities dataContext)
{
var _conference = dataContext.Conferences.SingleOrDefault(c => c.Name == "MVC Springboard");
var _facilitator1 = dataContext.People.Where(p => p.LastName == "Wynia").SingleOrDefault();
_conference.Facilitators.Add(_facilitator1);
var _facilitator2 = dataContext.People.Where(p => p.LastName == "Lozano").SingleOrDefault();
_conference.Facilitators.Add(_facilitator2);
var _facilitator3 = dataContext.People.Where(p => p.LastName == "LaTourelle").SingleOrDefault();
_conference.Facilitators.Add(_facilitator3);
var _facilitator4 = dataContext.People.Where(p => p.LastName == "Tucker").SingleOrDefault();
_conference.Facilitators.Add(_facilitator4);
}
static void CreateSampleData(ThripEntities dataContext)
{
CreateSampleConference(dataContext);
dataContext.SaveChanges();
CreateSamplePeople(dataContext);
dataContext.SaveChanges();
CreateSampleSessions(dataContext);
dataContext.SaveChanges();
CreateSampleLocations(dataContext);
dataContext.SaveChanges();
CreateSampleTimeSlots(dataContext);
dataContext.SaveChanges();
CreateSampleScheduledSessions(dataContext);
dataContext.SaveChanges();
CreateSampleSponsors(dataContext);
dataContext.SaveChanges();
CreateSampleFacilitators(dataContext);
dataContext.SaveChanges();
}
static void CreateSampleLocations(ThripEntities dataContext)
{
var _location = new Location();
_location.Id = Guid.NewGuid();
_location.Name = "Main Ballroom";
_location.Description = "";
dataContext.Locations.AddObject(_location);
_location = new Location();
_location.Id = Guid.NewGuid();
_location.Name = "Franklin Room";
_location.Description = "";
dataContext.Locations.AddObject(_location);
_location = new Location();
_location.Id = Guid.NewGuid();
_location.Name = "Washington Room";
_location.Description = "";
dataContext.Locations.AddObject(_location);
_location = new Location();
_location.Id = Guid.NewGuid();
_location.Name = "Jefferson Room";
_location.Description = "";
dataContext.Locations.AddObject(_location);
_location = new Location();
_location.Id = Guid.NewGuid();
_location.Name = "Lincoln Room";
_location.Description = "";
dataContext.Locations.AddObject(_location);
}
public BaseController()
{
DataContext = new ThripEntities();
}
static void Main(string[] args)
{
ThripEntities _dataContext = new ThripEntities();
CreateSampleData(_dataContext);
}
static void CreateSampleTimeSlots(ThripEntities dataContext)
{
var _timeSlot = new TimeSlot();
_timeSlot.Id = Guid.NewGuid();
_timeSlot.Name = "Welcome Session";
_timeSlot.StartDate = DateTime.Now; // DateTime.Parse("9/3/2010 08:00");
_timeSlot.EndDate = DateTime.Now.AddHours(1); // DateTime.Parse("9/3/2010 09:00");
dataContext.TimeSlots.AddObject(_timeSlot);
dataContext.SaveChanges();
_timeSlot = new TimeSlot();
_timeSlot.Id = Guid.NewGuid();
_timeSlot.Name = "Friday Morning";
_timeSlot.StartDate = DateTime.Parse("9/3/2010 09:15");
_timeSlot.EndDate = DateTime.Parse("9/3/2010 11:00");
dataContext.TimeSlots.AddObject(_timeSlot);
dataContext.SaveChanges();
_timeSlot = new TimeSlot();
_timeSlot.Id = Guid.NewGuid();
_timeSlot.Name = "Friday Midday";
_timeSlot.StartDate = DateTime.Parse("9/3/2010 11:15");
_timeSlot.EndDate = DateTime.Parse("9/3/2010 12:45");
dataContext.TimeSlots.AddObject(_timeSlot);
dataContext.SaveChanges();
_timeSlot = new TimeSlot();
_timeSlot.Id = Guid.NewGuid();
_timeSlot.Name = "Friday Afternoon";
_timeSlot.StartDate = DateTime.Parse("9/3/2010 13:00");
_timeSlot.EndDate = DateTime.Parse("9/3/2010 16:00");
dataContext.TimeSlots.AddObject(_timeSlot);
dataContext.SaveChanges();
_timeSlot = new TimeSlot();
_timeSlot.Id = Guid.NewGuid();
_timeSlot.Name = "Satuday Wake-up";
_timeSlot.StartDate = DateTime.Parse("9/4/2010 08:00");
_timeSlot.EndDate = DateTime.Parse("9/4/2010 09:00");
dataContext.TimeSlots.AddObject(_timeSlot);
dataContext.SaveChanges();
}
static void CreateSampleSponsors(ThripEntities dataContext)
{
var _conference = dataContext.Conferences.SingleOrDefault(c => c.Name == "MVC Springboard");
var _sponsor = new Sponsor();
_sponsor.Id = Guid.NewGuid();
_sponsor.Name = "DevExpress";
_sponsor.Description = "DevExpress engineers the most advanced IDE tools and feature-complete visual components to supercharge your .NET development, as well as application frameworks to tie everything together. Our technologies help you build your best, see complex software with clarity, increase your productivity and create stunning .NET applications in the shortest possible time. All of our products come with a 60 day unconditional money back guarantee and fully functional evaluation versions are available for download at www.devexpress.com.";
_sponsor.URL = "DevExpress.com";
_sponsor.Conferences.Add(_conference);
dataContext.Sponsors.AddObject(_sponsor);
_sponsor = new Sponsor();
_sponsor.Id = Guid.NewGuid();
_sponsor.Name = "Telerik";
_sponsor.Description = "Telerik is the leading vendor of User Interface (UI) components for ASP.NET and Windows Forms, and .NET Reporting solutions. Building on our expertise in interface development and Microsoft technologies, Telerik helps customers build applications with unparalleled richness, responsiveness and interactivity. Check out the latest release featuring our RadControls for ASP.NET, ASP.NET AJAX controls, Silverlight tools, RadControls for WinForms, and Telerik Reporting: Telerik.com";
_sponsor.URL = "Telerik.com";
_sponsor.Conferences.Add(_conference);
dataContext.Sponsors.AddObject(_sponsor);
}
static void CreateSampleSessions(ThripEntities dataContext)
{
var _conference = dataContext.Conferences.SingleOrDefault(c => c.Name == "MVC Springboard");
var _session = new Session();
_session.Id = Guid.NewGuid();
_session.Name = "MVC 101";
_session.Description = "From A to MVC in no time flat!";
_session.Tags = "mvc,intro";
var _facilitator = dataContext.People.Where(p => p.LastName == "Wynia").SingleOrDefault();
_session.Facilitators.Add(_facilitator);
_session.Conferences.Add(_conference);
dataContext.Sessions.AddObject(_session);
_session = new Session();
_session.Id = Guid.NewGuid();
_session.Name = "Breakfast and Keynote";
_session.Description = "";
_session.Tags = "keynote";
_session.Facilitators.Add(dataContext.People.Where(p => p.LastName == "Lozano").SingleOrDefault());
_session.Conferences.Add(_conference);
dataContext.Sessions.AddObject(_session);
_session = new Session();
_session.Id = Guid.NewGuid();
_session.Name = "Spark and MVC";
_session.Description = "From Web forms to Spark forms ";
_session.Tags = "mvc,Spark";
_session.Facilitators.Add(dataContext.People.Where(p => p.LastName == "LaTourelle").SingleOrDefault());
_session.Conferences.Add(_conference);
dataContext.Sessions.AddObject(_session);
_session = new Session();
_session.Id = Guid.NewGuid();
_session.Name = "Entity Framework and MVC";
_session.Description = "Getting MVC hooked up to EF";
_session.Tags = "mvc,Entity Framework";
_session.Facilitators.Add(dataContext.People.Where(p => p.LastName == "Tucker").SingleOrDefault());
_session.Conferences.Add(_conference);
dataContext.Sessions.AddObject(_session);
}
static void CreateSampleScheduledSessions(ThripEntities dataContext)
{
var _scheduledSession = new ScheduledSession();
_scheduledSession.Id = Guid.NewGuid();
_scheduledSession.SessionId = dataContext.Sessions.Where(s => s.Name == "Breakfast and Keynote").SingleOrDefault().Id;
_scheduledSession.TimeSlotId = dataContext.TimeSlots.Where(ts => ts.Name == "Welcome Session").SingleOrDefault().Id;
_scheduledSession.LocationId = dataContext.Locations.Where(l => l.Name == "Main Ballroom").SingleOrDefault().Id;
dataContext.ScheduledSessions.AddObject(_scheduledSession);
_scheduledSession = new ScheduledSession();
_scheduledSession.Id = Guid.NewGuid();
_scheduledSession.SessionId = dataContext.Sessions.Where(s => s.Name == "MVC 101").SingleOrDefault().Id;
_scheduledSession.TimeSlotId = dataContext.TimeSlots.Where(ts => ts.Name == "Friday Morning").SingleOrDefault().Id;
_scheduledSession.LocationId = dataContext.Locations.Where(l => l.Name == "Franklin Room").SingleOrDefault().Id;
dataContext.ScheduledSessions.AddObject(_scheduledSession);
_scheduledSession = new ScheduledSession();
_scheduledSession.Id = Guid.NewGuid();
_scheduledSession.SessionId = dataContext.Sessions.Where(s => s.Name == "Spark and MVC").SingleOrDefault().Id;
_scheduledSession.TimeSlotId = dataContext.TimeSlots.Where(ts => ts.Name == "Friday Afternoon").SingleOrDefault().Id;
_scheduledSession.LocationId = dataContext.Locations.Where(l => l.Name == "Lincoln Room").SingleOrDefault().Id;
dataContext.ScheduledSessions.AddObject(_scheduledSession);
}
static void CreateSamplePeople(ThripEntities dataContext)
{
var _person = new Person();
_person.Id = Guid.NewGuid();
_person.FirstName = "Tom";
_person.LastName = "LaTourelle";
_person.Email = "*****@*****.**";
dataContext.People.AddObject(_person);
_person = new Person();
_person.Id = Guid.NewGuid();
_person.FirstName = "J";
_person.LastName = "Wynia";
_person.Email = "*****@*****.**";
dataContext.People.AddObject(_person);
_person = new Person();
_person.Id = Guid.NewGuid();
_person.FirstName = "Javier";
_person.LastName = "Lozano";
_person.Email = "*****@*****.**";
dataContext.People.AddObject(_person);
_person = new Person();
_person.Id = Guid.NewGuid();
_person.FirstName = "Dedrick";
_person.LastName = "Tucker";
_person.Email = "*****@*****.**";
dataContext.People.AddObject(_person);
}
