private static void AddObjectiveAssessments(PTFilesDbContext context)
 {
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.ObjectiveAssessments ON");
     context.ObjectiveAssessments.AddRange(
         new ObjectiveAssessment
     {
         Id                = 1,
         ConsultationId    = 1,
         Observation       = "cautious movements. slow sit to stand.",
         Active            = "Standing flexion -fingertips to 1/2 thigh",
         Passive           = "",
         ResistedIsometric = "knee ext 4+/5",
         FunctionalTests   = "STS x10. pain at 7",
         NeurologicalTests = "sensation testing thigh and calf. -ve",
         SpecialTests      = "",
         Palpation         = "Slight tenderness in right lower back",
         Additional        = "poor posture"
     },
         new ObjectiveAssessment
     {
         Id                = 2,
         ConsultationId    = 2,
         Observation       = "swollen left knee. mild limp when walking",
         Active            = "L knee ext - 20 deg from full ext",
         Passive           = "L knee ext 15 from full ext",
         ResistedIsometric = "knee ext 4/5",
         FunctionalTests   = "step up x10. unable without arm assist. pain with arm assist",
         NeurologicalTests = "",
         SpecialTests      = "lachmans -ve. mcmurrays +ve",
         Palpation         = "Slight tenderness in all around knee. most tender medial knee joint line"
     });
     context.SaveChanges();
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.ObjectiveAssessments OFF");
 }
 private static void AddPractitioners(PTFilesDbContext context)
 {
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Practitioners ON");
     context.Practitioners.Add(new Practitioner
     {
         Id             = 1,
         Honorific      = Honorific.Mr,
         FirstName      = "Tim",
         LastName       = "Lee",
         DOB            = DateTime.Parse("1991-8-1"),
         Email          = "*****@*****.**",
         CountryCode    = "AUS",
         HomePhone      = "96498871",
         MobilePhone    = "0424991111",
         Gender         = Gender.Male,
         JobLevel       = "Senior",
         RegistrationID = "physio123"
     });
     context.SaveChanges();
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Practitioners OFF");
 }
        private static void AddSubjectiveAssessments(PTFilesDbContext context)
        {
            var now = DateTime.UtcNow;

            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SubjectiveAssessments ON");
            context.SubjectiveAssessments.AddRange(
                new SubjectiveAssessment
            {
                Id                 = 1,
                ConsultationId     = 1,
                MOI                = "stood up quickly from sitting",
                CurrentHistory     = "went to stand up at the end of the work yesterday and immediate pain show in lower back down to calf.",
                BodyChart          = "www.physiocharts.com/msk/123.jpg",
                AggravatingFactors = "predominantly forward flex motions. sometimes some turning motions, long sitting, long standing",
                EasingFactors      = "resting, hot shower, ice pack, sitting when standing, standing when sitting",
                VAS                = 5,
                PastHistory        = "had small aches in lower back in past but nothing as severe",
                SocialHistory      = "gym on and off. spends some time developing at home otherwise relaxes and watches netflix if not out with friends",
                Imaging            = "no xrays",
                GeneralHealth      = "nil"
            },
                new SubjectiveAssessment
            {
                Id                 = 2,
                ConsultationId     = 2,
                MOI                = "Changed direction to run back towards middle of court and knee gave way",
                CurrentHistory     = "Playing in a local tournament.",
                BodyChart          = "www.physiocharts.com/msk/345.jpg",
                AggravatingFactors = "walking long periods, running, completely straight knee",
                EasingFactors      = "rest, ice pack, flexed knee, compression",
                VAS                = 4,
                PastHistory        = "nil for left knee. right knee had acl tear as a teen 3 years ago",
                SocialHistory      = "trains 5-6x a week. jogs daily.",
                Imaging            = "MRI - moderate meniscal tear",
                GeneralHealth      = "nil"
            });
            context.SaveChanges();
            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SubjectiveAssessments OFF");
        }
        private static void AddConsultations(PTFilesDbContext context)
        {
            var now = DateTime.UtcNow;

            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Consultations ON");
            context.Consultations.AddRange(
                new Consultation
            {
                Id             = 1,
                CasefileId     = 1,
                Date           = now,
                PractitionerId = 1,
                SubjectiveId   = 1,
                ObjectiveId    = 1,
                Treatments     = "L1-5 PA mobs. Each level 3 x 20sec. grade 2 comfortable. easied into grade 3 by 3rd set"
                                 + "\nTrA activation - 5x5sec"
                                 + "\nHip Flexor stretch - 3x15sec. kneel on pillow"
                                 + "\nPlank 3x20sec",
                Plans = "rv by end of week. ease into hydrotherapy when able"
            },
                new Consultation
            {
                Id             = 2,
                CasefileId     = 2,
                Date           = now,
                PractitionerId = 1,
                SubjectiveId   = 2,
                ObjectiveId    = 2,
                Treatments     = "glut, quad and hamstring contractions. 3x10. short of pain"
                                 + "\ncompression bandage, 1x med size"
                                 + "\nleft knee distractions. 2x30sec in sitting"
                                 + "\nelevated I/T compression with ice pack. 5 min",
                Plans = "rv daily this week. gradual increase strength and reduce swelling."
            });
            context.SaveChanges();
            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Consultations OFF");
        }
        private static void AddCasefiles(PTFilesDbContext context)
        {
            var now = DateTime.UtcNow;

            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Casefiles ON");
            context.Casefiles.AddRange(
                new Casefile
            {
                Id        = 1,
                PatientId = 1,
                Name      = "Lower Back Injury",
                Created   = now
            },
                new Casefile
            {
                Id        = 2,
                PatientId = 2,
                Name      = "Left Knee Injury",
                Created   = now
            }
                );
            context.SaveChanges();
            context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Casefiles OFF");
        }
 private static void AddPatients(PTFilesDbContext context)
 {
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Patients ON");
     context.Patients.AddRange(
         new Patient
     {
         Id          = 1,
         Honorific   = Honorific.Mr,
         FirstName   = "Jay",
         LastName    = "Valentine",
         DOB         = DateTime.Parse("1991-9-7"),
         Email       = "*****@*****.**",
         CountryCode = "AUS",
         HomePhone   = "96498888",
         MobilePhone = "0424999999",
         Gender      = Gender.Male,
         Occupation  = "Software Developer"
     },
         new Patient
     {
         Id          = 2,
         Honorific   = Honorific.Miss,
         FirstName   = "Kay",
         LastName    = "Smith",
         DOB         = DateTime.Parse("1995-2-21"),
         Email       = "*****@*****.**",
         CountryCode = "AUS",
         HomePhone   = "96498877",
         MobilePhone = "0424999777",
         Gender      = Gender.Female,
         Occupation  = "Professional Tennis Player"
     }
         );
     context.SaveChanges();
     context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Patients OFF");
 }