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
}
