Inheritance: DbContext
        public void Initialise(dynamic viewBag, SceneCRM context, IEnumerable<VolunteerAllocation> currentVolunteers)
        {
            var volunteers = context.Volunteers
                .ToArray()
                .OrderBy(v => v.IsEligible)
                .Select(v => new { Id = v.VolunteerId.ToString(), Name = string.Format("{0}, {1}{2}", v.Surname, v.FirstName, v.IsEligible ? string.Empty : " (NOT ELIGIBLE)") })
                .ToDictionary(v => v.Id, v => v.Name);

            var jobs = context.Jobs
                .Select(j => new { Id = j.JobId, Name = j.Description })
                .ToDictionary(j => j.Id.ToString(), j => j.Name);

            var currentVolunteerModel = currentVolunteers
                .Select(cv => new { jobId = cv.JobId.ToString(), volunteerId = cv.VolunteerId.ToString(), notes = cv.Notes })
                .OrderBy(cv => cv.jobId);

            viewBag.CurrentVolunteers = currentVolunteerModel;
            viewBag.PossibleVolunteers = volunteers;
            viewBag.PossibleJobs = jobs;
        }
Ejemplo n.º 2
0
 static void WipeDatabase(SceneCRM context)
 {
     throw new NotImplementedException("Needs chaning over to context.*.Remove");
     /*
     context.Courses.ToList().ForEach(context.Courses.DeleteObject);
     context.CourseAttendances.ToList().ForEach(context.CourseAttendances.DeleteObject);
     context.CourseTypes.ToList().ForEach(context.CourseTypes.DeleteObject);
     context.CourseVolunteers.ToList().ForEach(context.CourseVolunteers.DeleteObject);
     context.CrbChecks.ToList().ForEach(context.CrbChecks.DeleteObject);
     context.Jobs.ToList().ForEach(context.Jobs.DeleteObject);
     context.Performances.ToList().ForEach(context.Performances.DeleteObject);
     context.Plays.ToList().ForEach(context.Plays.DeleteObject);
     context.PlayVolunteers.ToList().ForEach(context.PlayVolunteers.DeleteObject);
     context.Productions.ToList().ForEach(context.Productions.DeleteObject);
     context.ProductionVolunteers.ToList().ForEach(context.ProductionVolunteers.DeleteObject);
     context.Students.ToList().ForEach(context.Students.DeleteObject);
     context.Terms.ToList().ForEach(context.Terms.DeleteObject);
     context.Volunteers.ToList().ForEach(context.Volunteers.DeleteObject);
      */
     context.SaveChanges();
 }
Ejemplo n.º 3
0
 static void PopulateJobTypes(SceneCRM context)
 {
     context.Jobs.FindOrMake(Jobs.Actor, context);
     context.Jobs.FindOrMake(Jobs.Class, context);
     context.Jobs.FindOrMake(Jobs.Costume, context);
     context.Jobs.FindOrMake(Jobs.CostumePropMaker, context);
     context.Jobs.FindOrMake(Jobs.CourseLeader, context);
     context.Jobs.FindOrMake(Jobs.Designer, context);
     context.Jobs.FindOrMake(Jobs.Director, context);
     context.Jobs.FindOrMake(Jobs.Dramaturg, context);
     context.Jobs.FindOrMake(Jobs.Mailout, context);
     context.Jobs.FindOrMake(Jobs.ProdAsst, context);
     context.Jobs.FindOrMake(Jobs.SoundDesigner, context);
     context.Jobs.FindOrMake(Jobs.StageMan, context);
     context.Jobs.FindOrMake(Jobs.TechAsst, context);
     context.Jobs.FindOrMake(Jobs.Technician, context);
 }
Ejemplo n.º 4
0
        static void Main(string[] args)
        {
            HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize();

            using (var context = new SceneCRM()) {
                WipeDatabase(context);

                oneOnOne = context.CourseTypes.FindOrMake("OO", "One on One", context);
                pm1 = context.CourseTypes.FindOrMake("PM1", "Playmaking One", context);
                rp = context.CourseTypes.FindOrMake("RP", "Replay", context);
                s1 = context.CourseTypes.FindOrMake("S1", "Stage One", context);
                pb = context.CourseTypes.FindOrMake("PB", "Playback", context);

                PopulateJobTypes(context);

                var ss = new ChildrenProductionsSpreadsheet(@"C:\Users\dylan.beattie\Documents\Scene & Heard\Children and Productions.xls");

                foreach (var row in ss.Rows) {
                    var student = context.Students.FindOrMake(row.MembershipNumber, row.Forename, row.Surname, context);
                    student.QuestionnaireResponse = row.QuestionnaireResponses;
                    ImportPlaymakingOne(context, student, row);
                    ImportPlayback(context, student, row);
                    ImportReplay(context, student, row);
                    ImportStageOne(context, student, row);
                    ImportOneOnOne(context, student, row);
                    Console.WriteLine("Added " + student.Forename + " " + student.Surname);
                    context.SaveChanges();
                }
                ImportVolunteerDataFromAccessDatabase(context, @"C:\Users\dylan.beattie\Documents\Scene & Heard\Volunteers.mdb", "giraffe");
            }
            Console.ReadKey(false);
        }
Ejemplo n.º 5
0
 static void ImportVolunteerDataFromAccessDatabase(SceneCRM context, string fullPathToMdbFile, string databasePassword)
 {
     AccessVolunteers av = new AccessVolunteers();
     var adapter = new LegacyData.AccessVolunteersTableAdapters.AddressTableAdapter();
     var data = adapter.GetData();
     foreach (LegacyData.AccessVolunteers.AddressRow row in data.Rows) {
         var volunteer = context.Volunteers.FindOrMake(row.First_Name, row.Last_Name, context);
         Console.WriteLine("Volunteer {0} {1} (#{2})", volunteer.FirstName, volunteer.Surname, volunteer.VolunteerId);
         volunteer.AccessPersonId = row.Person_ID;
         var address = row.IsAddressNull() ? String.Empty : row.Address;
         if (!(row.IsAddress_1Null() || String.IsNullOrWhiteSpace(row.Address_1))) address += Environment.NewLine + row.Address_1;
         if (!(row.IsAddress_2Null() || String.IsNullOrWhiteSpace(row.Address_2))) address += Environment.NewLine + row.Address_2;
         volunteer.PerformanceAttended = "(imported from Access DB)";
         volunteer.Address = address;
         volunteer.AgentName = row.IsAgent_NameNull() ? null : row.Agent_Name;
         volunteer.CvWebUrl = row.IsCVNull() ? null : row.CV;
         volunteer.Deadwood = row.IsDeadwoodNull() ? false : row.Deadwood;
         volunteer.EEDirectDebit = row.Is_E_E_Direct_DebitNull() ? false : row._E_E_Direct_Debit;
         volunteer.EmailAddress = row.IsEmail_AddressNull() ? null : row.Email_Address;
         volunteer.EmailAddress2 = row.IsEmail_Address_2Null() ? null : row.Email_Address_2;
         volunteer.EyesEars = row.Is_Eyes___EarsNull() ? false : row._Eyes___Ears;
         volunteer.MobilePhone = row.IsMobile_telephoneNull() ? null : row.Mobile_telephone;
         volunteer.NoMailout = row.IsNo_MailoutNull() ? false : row.No_Mailout;
         volunteer.Notes = row.IsNotesNull() ? null : row.Notes;
         volunteer.Organisation = row.IsOrganisationNull() ? null : row.Organisation;
         volunteer.OtherProfession = row.IsOther_ProfessionNull() ? null : row.Other_Profession;
         volunteer.PartnerFirstName = row.IsSecond_Person_1st_NameNull() ? null : row.Second_Person_1st_Name;
         volunteer.PartnerSurname = row.IsSecond_Person_Last_NameNull() ? null : row.Second_Person_Last_Name;
         volunteer.Postcode = row.IsPostcodeNull() ? null : row.Postcode;
         volunteer.SpotlightNumber = row.IsSpotlight_NumberNull() ? false : row.Spotlight_Number;
         volunteer.Trustee = row.Is_Trustee_Board_MemberNull() ? false : row._Trustee_Board_Member;
         volunteer.CrbChecks.Clear();
         if (!(row.IsCRB_NumberNull() && row.IsDate_applied_CRBNull() && row.IsCRB_appliedNull() && row.IsCRB_ApprovedNull())) {
             volunteer.CrbChecks.Add(new CrbCheck() {
                 Volunteer = volunteer,
                 CrbNumber = row.IsCRB_NumberNull() ? null : row.CRB_Number,
                 ApplicationDate = row.IsDate_applied_CRBNull() ? (DateTime?)null : row.Date_applied_CRB,
                 ApplicationSent = row.IsCRB_appliedNull() ? false : row.CRB_applied,
                 Approved = row.IsCRB_ApprovedNull() ? false : row.CRB_Approved,
                 ApprovalDate = row.IsCRB_DateNull() ? (DateTime?)null : row.CRB_Date
             });
         }
         volunteer.Jobs.Clear();
         AddJob(context, volunteer, ((!(row.IsActorNull())) && row.Actor), Jobs.Actor);
         AddJob(context, volunteer, ((!(row.IsDirectorNull())) && row.Director), Jobs.Director);
         AddJob(context, volunteer, ((!(row.IsTechnicianNull())) && row.Technician), Jobs.Technician);
         AddJob(context, volunteer, ((!(row.Is_Costume_Prop_MakerNull())) && row._Costume_Prop_Maker), Jobs.CostumePropMaker);
     }
 }
Ejemplo n.º 6
0
 static void ImportStageOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
 {
     if (row.AttendedStageOne) {
         ImportPlay(context, student, s1, row.StageOneTerm, row.StageOneYear, String.Empty, String.Empty, String.Empty, String.Empty, row.StageOneActor);
     }
 }
Ejemplo n.º 7
0
 static void ImportReplay(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
 {
     if (row.AttendedReplay) {
         ImportPlay(context, student, rp, row.ReplayTerm, row.ReplayYear, row.ReplayProduction, row.ReplayPlay, row.ReplayDramaturg, row.ReplayDirector, row.ReplayActor1,
             row.ReplayActor2, row.ReplayActor3);
     }
 }
Ejemplo n.º 8
0
        static void ImportPlaymakingOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
        {
            if (row.AttendedPm1) {
                ImportPlay(context, student, pm1, row.PlaymakingOneTerm, row.PlaymakingOneYear, row.PlaymakingOneProduction, row.PlaymakingOnePlay, row.PlaymakingOneDramaturg, row.PlaymakingOneDirector,
                    row.PlaymakingOneActor1, row.PlaymakingOneActor2, row.PlaymakingOneActor3);

                //var term = context.Terms.FindOrMake(row.PlaymakingOneTerm);
                //var course = context.Courses.FindOrMake(pm1, term, row.PlaymakingOneYear);
                //if (course != null) {
                //    var attendance = new CourseAttendance() {
                //        Student = student,
                //        Course = course,
                //        Completed = true
                //    };
                //    Production production = context.Productions.FindOrMake(row.PlaymakingOneProduction);

                //    if (!String.IsNullOrWhiteSpace(row.PlaymakingOnePlay)) {
                //        var play = new Play() {
                //            Student = student,
                //            Title = row.PlaymakingOnePlay
                //        };
                //        if (production != null) play.Production = production;
                //        attendance.Play = play;
                //        student.Plays.Add(play);
                //        AddPlayVolunteer(context, play, row.PlaymakingOneDramaturg, Jobs.Dramaturg);
                //        AddPlayVolunteer(context, play, row.PlaymakingOneDirector, Jobs.Director);
                //        AddPlayVolunteer(context, play, row.PlaymakingOneActor1, Jobs.Actor);
                //        AddPlayVolunteer(context, play, row.PlaymakingOneActor2, Jobs.Actor);
                //        AddPlayVolunteer(context, play, row.PlaymakingOneActor3, Jobs.Actor);
                //    } else {
                //        AddCourseVolunteer(context, course, row.PlaymakingOneDramaturg, Jobs.Dramaturg);
                //        AddCourseVolunteer(context, course, row.PlaymakingOneActor1, Jobs.Actor);
                //        AddCourseVolunteer(context, course, row.PlaymakingOneActor2, Jobs.Actor);
                //        AddCourseVolunteer(context, course, row.PlaymakingOneActor3, Jobs.Actor);
                //        AddCourseVolunteer(context, course, row.PlaymakingOneDirector, Jobs.Director);
                //    }
                //    student.CourseAttendances.Add(attendance);
            }
        }
Ejemplo n.º 9
0
 static void ImportPlayback(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
 {
     if (row.AttendedPlayback) {
         ImportPlay(context, student, pb, "Playback", row.PlaybackYear, row.PlaybackProduction, row.PlaybackPlay, row.PlaybackDramaturg, row.PlaybackDirector,
                 row.PlaybackActor
                 );
     }
 }
Ejemplo n.º 10
0
        static object ImportPlay(SceneCRM context, Student student, CourseType courseType, string termName, string termYear, string productionName, string playName,
            string dramaturg, string director, params string[] actors)
        {
            object returnValue = null;
            var term = context.Terms.FindOrMake(termName, context);
            var course = context.Courses.FindOrMake(courseType, term, termYear, context);
            if (course != null) {
                var attendance = new CourseAttendance() {
                    Student = student,
                    Course = course,
                    Completed = true
                };
                Production production = context.Productions.FindOrMake(productionName, context);

                if (!String.IsNullOrWhiteSpace(playName)) {
                    var play = new Play() {
                        Student = student,
                        Title = playName
                    };
                    if (production != null) play.Production = production;
                    attendance.Play = play;
                    student.Plays.Add(play);
                    AddPlayVolunteer(context, play, dramaturg, Jobs.Dramaturg);
                    AddPlayVolunteer(context, play, director, Jobs.Director);
                    foreach (var actor in actors) {
                        AddPlayVolunteer(context, play, actor, Jobs.Actor);
                    }
                    returnValue = play;
                } else {
                    AddCourseVolunteer(context, course, dramaturg, Jobs.Dramaturg);
                    AddCourseVolunteer(context, course, director, Jobs.Director);
                    foreach (var actor in actors) {
                        AddCourseVolunteer(context, course, actor, Jobs.Actor);
                    }
                    returnValue = course;
                }
                student.CourseAttendances.Add(attendance);
            }
            return(returnValue);
        }
Ejemplo n.º 11
0
 static void ImportOneOnOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
 {
     if (row.AttendedOneOnOne) {
         ImportPlay(context, student, oneOnOne, row.OneonOneTerm, row.OneonOneYear, row.OneonOneProduction, row.OneonOnePlay, row.OneonOneWriter, row.OneonOneDirector, row.OneonOneActor);
     }
 }
Ejemplo n.º 12
0
 static void AddPlayVolunteer(SceneCRM context, Play play, string volunteerName, string jobTitle)
 {
     var vol = context.Volunteers.FindOrMake(volunteerName, context);
     if (vol == null) return;
     var job = context.Jobs.FindOrMake(jobTitle, context);
     if (!vol.PlayVolunteers.Any(cv => cv.Job == job && cv.Play == play)) {
         context.PlayVolunteers.Add(new PlayVolunteer() {
             Play = play,
             Volunteer = vol,
             Job = job
         });
     }
     context.SaveChanges();
 }
Ejemplo n.º 13
0
 static void AddJob(SceneCRM context, Volunteer volunteer, bool condition, string jobTitle)
 {
     if (!condition) return;
     var job = context.Jobs.FindOrMake(jobTitle, context);
     if (!volunteer.Jobs.Contains(job)) {
         Console.WriteLine("Marking {0} as a {1}", volunteer.Name, job.Description);
         volunteer.Jobs.Add(job);
     }
     context.SaveChanges();
 }
Ejemplo n.º 14
0
 static void AddCourseVolunteer(SceneCRM context, Course course, string volunteerName, string jobTitle)
 {
     var vol = context.Volunteers.FindOrMake(volunteerName, context);
     if (vol == null) return;
     var job = context.Jobs.FindOrMake(jobTitle, context);
     if (!vol.CourseVolunteers.Any(cv => cv.Job == job && cv.Course == course)) {
         context.CourseVolunteers.Add(new CourseVolunteer() {
             Course = course,
             Volunteer = vol,
             Job = job
         });
     }
     context.SaveChanges();
 }
 public void Initialise(dynamic viewBag, SceneCRM context)
 {
     Initialise(viewBag, context, new VolunteerAllocation[0]);
 }