public ActionResult Uploadify() { var file = Request.Files["Filedata"]; string savePath = Server.MapPath(@"~\Content\Image\Logo\" + file.FileName); file.SaveAs(savePath); int hospitalId = _db.HospitalInformations.Where(h => h.HospitalInformationId != 0).AsNoTracking().SingleOrDefault().HospitalInformationId; string name = _db.HospitalInformations.Where(h => h.HospitalInformationId == hospitalId).AsNoTracking().FirstOrDefault().Name; string address = _db.HospitalInformations.Where(h => h.HospitalInformationId == hospitalId).AsNoTracking().FirstOrDefault().Address; string email = _db.HospitalInformations.Where(h => h.HospitalInformationId == hospitalId).AsNoTracking().FirstOrDefault().Email; string phone = _db.HospitalInformations.Where(h => h.HospitalInformationId == hospitalId).AsNoTracking().FirstOrDefault().Phone; string fax = _db.HospitalInformations.Where(h => h.HospitalInformationId == hospitalId).AsNoTracking().FirstOrDefault().Fax; HospitalInformation hospital = new HospitalInformation(); hospital.HospitalInformationId = hospitalId; hospital.Logo = file.FileName; hospital.Name = name; hospital.Email = email; hospital.Address = address; hospital.Phone = phone; hospital.Fax = fax; _db.Entry(hospital).State = EntityState.Modified; _db.SaveChanges(); return Content(Url.Content(@"~\Content\Image\Logo\" + file.FileName)); }
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 }