public static void Seed(OMCS.DAL.Model.OMCSDBContext _db) { Doctor bsNguyenVanA = _db.Doctors.Where(d => d.Email.Equals("*****@*****.**")).FirstOrDefault(); Patient sutran = _db.Patients.Where(p => p.Email.Equals("*****@*****.**")).FirstOrDefault(); Conversation suTranVsBacSiA = new Conversation { Doctor = bsNguyenVanA, Patient = sutran }; ConversationDetail line1 = new ConversationDetail { Conversation = suTranVsBacSiA, Content = "Chào bác sĩ", User = sutran, CreatedDate = new DateTime(2014, 6, 1, 8, 20, 12) }; ConversationDetail line2 = new ConversationDetail { Conversation = suTranVsBacSiA, Content = "Chào bạn", User = bsNguyenVanA, CreatedDate = new DateTime(2014, 6, 1, 8, 20, 40) }; ConversationDetail line3 = new ConversationDetail { Conversation = suTranVsBacSiA, Content = "Em xin hỏi, nếu đau đầu mà tai và mắt cứ giật liên hồi, " + "sau mỗi lần giật lại càng đau đầu hơn, kèm theo sốt, thì nguyên nhân do đâu?", User = sutran, CreatedDate = new DateTime(2014, 6, 1, 8, 22, 12) }; ConversationDetail line4 = new ConversationDetail { Conversation = suTranVsBacSiA, Content = "Đau đầu là một trong những triệu chứng thường gặp "+ "nhất của nhiều bệnh, có nhiều nguyên nhân khác nhau gây đau đầu, "+ "cảm giác đau ở một trong những điểm như: đau ở ngay phía trên 2 mắt, "+ "2 tai, đau ở phía sau gáy, vùng trên của cổ.", User = bsNguyenVanA, CreatedDate = new DateTime(2014, 6, 1, 8, 25, 12) }; ConversationDetail line5 = new ConversationDetail { Conversation = suTranVsBacSiA, Content = "Đau đầu là một trong những triệu chứng thường gặp " + "nhất của nhiều bệnh, có nhiều nguyên nhân khác nhau gây đau đầu, " + "cảm giác đau ở một trong những điểm như: đau ở ngay phía trên 2 mắt, " + "2 tai, đau ở phía sau gáy, vùng trên của cổ.", User = sutran, CreatedDate = new DateTime(2014, 6, 1, 8, 27, 12) }; _db.ConversationDetails.Add(line1); _db.ConversationDetails.Add(line2); _db.ConversationDetails.Add(line3); _db.ConversationDetails.Add(line4); _db.ConversationDetails.Add(line5); _db.SaveChanges(); }
public static void Seed(OMCS.DAL.Model.OMCSDBContext _db) { #region HospitalInformation var hopsital = new HospitalInformation { Name = "FPT Hospital", Address = "Công viên phần mềm Quang Trung", Email = "*****@*****.**", Fax = "08.53453465", Phone = "08.423423434", Logo = "" }; _db.HospitalInformations.AddOrUpdate(p => p.Name, hopsital); _db.SaveChanges(); #endregion HospitalInformation #region Role var roles = new List<Role> { new Role { RoleName = "Admin" }, new Role { RoleName = "User" }, new Role { RoleName = "Doctor" } }; roles.ForEach(s => _db.Roles.AddOrUpdate(p => p.RoleName, s)); _db.SaveChanges(); Role roleAdmin = _db.Roles.Where(x => x.RoleName == "Admin").Single(); Role roleUser = _db.Roles.Where(x => x.RoleName == "User").Single(); Role roleDoctor = _db.Roles.Where(x => x.RoleName == "Doctor").Single(); #endregion Role #region SpecialtyField var specialtyFieldParents = new List<SpecialtyField> { new SpecialtyField { Name = "Ngoại khoa" }, new SpecialtyField { Name = "Nội khoa" }, new SpecialtyField { Name = "Nhi Khoa" } }; specialtyFieldParents.ForEach(s => _db.SpecialtyFields.AddOrUpdate(p => p.Name, s)); _db.SaveChanges(); SpecialtyField NgoaiKhoa = _db.SpecialtyFields.Where(x=>x.Name=="Ngoại khoa").Single(); SpecialtyField NoiKhoa = _db.SpecialtyFields.Where(x => x.Name == "Nội khoa").Single(); var specialtyFields = new List<SpecialtyField> { new SpecialtyField { Name = "Ngoại tim mạch", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Ngoại lồng ngực", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Ngoại tiêu hóa", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Phẫu thuật mắt", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Ngoại tổng quát", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Ngoại thần kinh", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Phẫu thuật miệng & hàm mặt", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Chấn thương chỉnh hình", ParentId = NgoaiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Dị ứng", ParentId = NoiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Miễn dịch học", ParentId = NoiKhoa.SpecialtyFieldId }, new SpecialtyField { Name = "Nội tim mạch", ParentId = NoiKhoa.SpecialtyFieldId } }; specialtyFields.ForEach(s => _db.SpecialtyFields.AddOrUpdate(p => p.Name, s)); _db.SaveChanges(); var NhiKhoa = _db.SpecialtyFields.Where(x=>x.Name=="Nhi Khoa").Single(); #endregion SpecialtyField #region User var users = new List<User> { new User { Email = "*****@*****.**", FirstName = "Admin", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {roleAdmin}, ProfilePicture = "photo.jpg" } }; users.ForEach(s => _db.Users.AddOrUpdate(p => p.Email, s)); _db.SaveChanges(); var doctors = new List<Doctor> { new Doctor { Email = "*****@*****.**", FirstName = "Doctor 1", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, SpecialtyField = NhiKhoa, Roles = new List<Role>() {roleDoctor}, ProfilePicture = "photo.jpg" }, new Doctor { Email = "*****@*****.**", FirstName = "A", LastName = "Nguyễn Văn", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, SpecialtyField = NhiKhoa, Roles = new List<Role>() {roleDoctor}, ProfilePicture = "photo.jpg" }, new Doctor { Email = "*****@*****.**", FirstName = "Tùng", LastName = "Tôn Thất", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, SpecialtyField = NhiKhoa, Roles = new List<Role>() {roleDoctor}, ProfilePicture = "photo.jpg" }, new Doctor { Email = "*****@*****.**", FirstName = "Di", LastName = "Hồ Đắc", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, SpecialtyField = NhiKhoa, Roles = new List<Role>() {roleDoctor}, ProfilePicture = "photo.jpg" }, new Doctor { Email = "*****@*****.**", FirstName = "Ngữ", LastName = "Đặng Văn", Password = "******", IsActive = true, Birthday = DateTime.UtcNow, CreatedDate = DateTime.UtcNow, SpecialtyField = NhiKhoa, Roles = new List<Role>() {roleDoctor}, ProfilePicture = "photo.jpg" } }; foreach (var doctor in doctors) { var existOne = _db.Doctors.Where(x => x.Email.Equals(doctor.Email)).FirstOrDefault(); if (existOne == null) _db.Doctors.Add(doctor); } _db.SaveChanges(); #endregion User }
public static void Seed(OMCS.DAL.Model.OMCSDBContext _db) { var rolePatient = _db.Roles.Where(role => role.RoleName.Equals("User")).FirstOrDefault(); var patients = new List<Patient> { new Patient { FirstName = "Su", LastName = "Tran", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "M", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Thôn 1, xa CuEbur, Buôn Ma Thuột", SecondaryAddress = "201/9 Đường Số 9, Gò Vấp", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Lập trình viên", WhereToWork = "39B Trường Sơn, Tân Bình", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "Su.JPG" }, new Patient { FirstName = "Danh", LastName = "Trần Cao", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "M", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Tiền gian", SecondaryAddress = "Quận 12", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Lập trình viên", WhereToWork = "FPT Software", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "photo.jpg" }, new Patient { FirstName = "Tuấn", LastName = "Mai Anh", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "M", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Tiền gian", SecondaryAddress = "Quận 12", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Lập trình viên", WhereToWork = "FPT Software", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "photo.jpg" }, new Patient { FirstName = "Nguồn", LastName = "Nguyễn Hồng Ngọc", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "F", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Tiền gian", SecondaryAddress = "Quận 12", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Sinh Vien", WhereToWork = "Hoa Sen", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "photo.jpg" }, new Patient { FirstName = "Nhân", LastName = "Nguyễn Toàn", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "F", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Tiền gian", SecondaryAddress = "Quận 12", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Sinh Vien", WhereToWork = "Hoa Sen", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "photo.jpg" }, new Patient { FirstName = "Lịnh", LastName = "Nguyễn Nhật", Email = "*****@*****.**", Password = "******", IsActive = true, CreatedDate = DateTime.UtcNow, Roles = new List<Role>() {rolePatient}, Gender = "M", Birthday = new DateTime(1992, 2, 19), Phone = "0933056722", PrimaryAddress = "Quảng Ngãi", SecondaryAddress = "Quận 12", Ethnicity = "Kinh", Nationality = "Việt Nam", Job = "Sinh Vien", WhereToWork = "F Soft", ContactPerson = "Mỹ Linh", ContactPersonAddress = "1 Lý Thường Kiệt", HealthInsuranceId = "234234VSD", HealthInsuranceIssued = new DateTime(2013, 1, 1), HealthInsuranceDateExpired = new DateTime(2014, 1, 1), ProfilePicture = "photo.jpg" } }; patients.ForEach(s => _db.Patients.AddOrUpdate(p => (p.Email), s)); _db.SaveChanges(); Patient suTran = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); Patient danhtran = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); Patient tuanMai = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); Patient nguonNguyen = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); Patient nhanNguyen = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); Patient linhNguyen = _db.Patients.Where(x => x.Email == "*****@*****.**").Single(); var personalHealthRecords = new List<PersonalHealthRecord> { new PersonalHealthRecord { PatientId = suTran.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Đá banh", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 }, new PersonalHealthRecord { PatientId = danhtran.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Đá banh", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 }, new PersonalHealthRecord { PatientId = tuanMai.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Đá banh", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 }, new PersonalHealthRecord { PatientId = nguonNguyen.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Cầu Lông", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 }, new PersonalHealthRecord { PatientId = nhanNguyen.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Cầu Lông", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 }, new PersonalHealthRecord { PatientId = linhNguyen.UserId, Height = 170, Weight = 70.5, EyeColor = "Đen", HairColor = "Đen", BloodType = "B", AlcoholPerWeek = 1.2, AlcoholNumOfYear = 4, IsBeer = true, SmokePackPerWeek = 1, SmokeNumOfYear = 2, SportName = "Cầu Lông", SportPerWeek = 4, ExerciseType = "Yoga", ExercisePerWeek = 2 } }; personalHealthRecords.ForEach(s => _db.PersonalHealthRecords.AddOrUpdate(p => (p.PatientId), s)); _db.SaveChanges(); }
public static void Seed(OMCS.DAL.Model.OMCSDBContext _db) { Patient suTran = _db.Patients.Where(pt => pt.Email.Equals("*****@*****.**")).Single(); Doctor doctor1 = _db.Doctors.Where(pt => pt.Email.Equals("*****@*****.**")).Single(); MedicalProfile suTranMedicalProfile = _db.MedicalProfiles.Where( mp => mp.MedicalProfileKey.Equals("OMCS.0000001.01")).FirstOrDefault(); #region TreatmentHistory var treatmentHistories = new List<TreatmentHistory> { new TreatmentHistory { DateCreated = DateTime.Now, DoctorId = doctor1.UserId, MedicalProfileId = suTranMedicalProfile.MedicalProfileId, Note = "Bệnh năng", OnSetDate = new DateTime(2014, 5, 1, 8, 20, 40) }, new TreatmentHistory { DateCreated = DateTime.Now, DoctorId = doctor1.UserId, MedicalProfileId = suTranMedicalProfile.MedicalProfileId, Note = "Bệnh tiến triển bình thường", OnSetDate = new DateTime(2014, 6, 1, 8, 20, 40) } }; treatmentHistories.ForEach(s => _db.TreatmentHistories.AddOrUpdate(p => p.DateCreated, s)); _db.SaveChanges(); #endregion TreatmentHistory var treatmentOne = treatmentHistories.ElementAt(0); #region FilmType var filmTypes = new List<FilmType> { new FilmType { Name = "Webcam" }, new FilmType { Name = "X-quang" }, new FilmType { Name = "CT-Scanner" }, new FilmType { Name = "Siêu âm" }, new FilmType { Name = "Nội soi" }, new FilmType { Name = "Xét nghiệm" }, new FilmType { Name = "Khác" } }; filmTypes.ForEach(s => _db.FilmTypes.AddOrUpdate(p => p.Name, s)); var filmTypeOne = filmTypes.ElementAt(0); _db.SaveChanges(); #endregion FilmType #region FilmDocument var filmDocuments = new List<FilmDocument> { new FilmDocument { TreatmentHistory = treatmentOne, FilmTypeId = filmTypeOne.FilmTypeId, ImagePath = "viemphoidotucau.gif", Conclusion = "Viêm phổi tụ cầu", DoctorId = doctor1.UserId, DateCreated = DateTime.Now, Description = "Hình ảnh viêm phổi" }, new FilmDocument { TreatmentHistory = treatmentOne, FilmTypeId = filmTypeOne.FilmTypeId, ImagePath = "viem_amydal_cap.jpg", Conclusion = "Viêm amydal cấp", DoctorId = doctor1.UserId, DateCreated = DateTime.Now, Description = "Bệnh nhân bị amydal" } }; filmDocuments.ForEach(s => _db.FilmDocuments.AddOrUpdate(p => p.ImagePath, s)); #endregion FilmDocument _db.SaveChanges(); }
public static void Seed(OMCS.DAL.Model.OMCSDBContext _db) { #region MedicalProfile List<MedicalProfileTemplate> medicalProfileTemplates = new List<MedicalProfileTemplate>{ //Default medical profile new MedicalProfileTemplate { MedicalProfileTemplateName = "Bệnh Án Mẫu" }, new MedicalProfileTemplate { MedicalProfileTemplateName = "Bệnh Án Nội Khoa" }, new MedicalProfileTemplate { MedicalProfileTemplateName = "Bệnh Án Truyền Nhiễm" }, new MedicalProfileTemplate { MedicalProfileTemplateName = "Bệnh Án Ngoài Da - BV Da Liễu" }, }; medicalProfileTemplates.ForEach(s => _db.MedicalProfileTemplates. AddOrUpdate(p => (p.MedicalProfileTemplateName), s)); _db.SaveChanges(); #endregion MedicalProfile Patient suTran = _db.Patients.Where(pt => pt.Email.Equals("*****@*****.**")).Single(); Patient caodanh = _db.Patients.Where(pt => pt.Email.Equals("*****@*****.**")).Single(); Doctor doctor1 = _db.Doctors.Where(pt => pt.Email.Equals("*****@*****.**")).Single(); MedicalProfileTemplate benhAnMau = _db.MedicalProfileTemplates.Find(1); MedicalProfileTemplate benhAnNoiKhoa = _db.MedicalProfileTemplates.Find(2); List<MedicalProfile> medicalProfiles = new List<MedicalProfile>{ new MedicalProfile { PatientId = suTran.UserId, DoctorId = doctor1.UserId, CreatedDate = DateTime.UtcNow, MedicalProfileTemplateId = benhAnMau.MedicalProfileTemplateId, MedicalProfileKey = "OMCS.0000001.01" }, new MedicalProfile { PatientId = caodanh.UserId, DoctorId = doctor1.UserId, CreatedDate = DateTime.Today.AddDays(-10), MedicalProfileTemplateId = benhAnNoiKhoa.MedicalProfileTemplateId, MedicalProfileKey = "OMCS.0000002.02" }, new MedicalProfile { PatientId = caodanh.UserId, DoctorId = doctor1.UserId, CreatedDate = DateTime.Today.AddDays(-5), MedicalProfileTemplateId = benhAnMau.MedicalProfileTemplateId, MedicalProfileKey = "OMCS.0000001.03" }, new MedicalProfile { PatientId = suTran.UserId, DoctorId = doctor1.UserId, CreatedDate = DateTime.Today.AddDays(-5), MedicalProfileTemplateId = benhAnNoiKhoa.MedicalProfileTemplateId, MedicalProfileKey = "OMCS.0000001.03" } }; medicalProfiles.ForEach(s => _db.MedicalProfiles.AddOrUpdate(p => (p.MedicalProfileKey), s)); _db.SaveChanges(); var suTranMedicalProfile = medicalProfiles.ElementAt(0); #region Immunization var imunizations = new List<Immunization> { new Immunization { BoosterTime = 1, MedicalProfileId = suTranMedicalProfile.MedicalProfileId, DateImmunized = new DateTime(1992, 3, 15), Name = "Sởi" } }; imunizations.ForEach(s => _db.Immunizations.AddOrUpdate(p => (p.Name), s)); _db.SaveChanges(); #endregion Immunization #region Allergy var allergyTypes = new List<AllergyType> { new AllergyType { Name = "Thuốc", Description = "Dị ứng với các loại thuốc" }, new AllergyType { Name = "Thức Ăn" }, new AllergyType { Name = "Môi Trường" }, new AllergyType { Name = "Khác" } }; allergyTypes.ForEach(s => _db.AllergyTypes.AddOrUpdate(p => (p.Name), s)); _db.SaveChanges(); var allergyTypeThuoc = allergyTypes.Where(x => x.Name == "Thuốc").Single(); var allergies = new List<Allergy> { new Allergy { Name = "Thuốc kháng sinh", MedicalProfileId = suTranMedicalProfile.MedicalProfileId, AllergyTypeId = allergyTypeThuoc.AllergyTypeId, Reaction = "Đau bụng nhẹ", DateLastOccurred = new DateTime(2013,1,1) } }; allergies.ForEach(s => _db.Allergies.AddOrUpdate(p => (p.Name), s)); _db.SaveChanges(); #endregion Allergy }