public ActionResult AddHospital(HttpPostedFileBase filename, HospitalViewModel model)
{
if (ModelState.IsValid)
{
if (filename != null)
{
string pic = System.IO.Path.GetExtension(filename.FileName);
string name = Guid.NewGuid().ToString() + pic;
string path = System.IO.Path.Combine(
Server.MapPath("~/Contents/upload/Hospital"), name);
// file is uploaded
filename.SaveAs(path);
model.HOSPITAL_IMAGE = name;
}
else
{
model.HOSPITAL_IMAGE = "default.jpg";
}
//var result = db.TBL_DISEASE.Create(model)
TBL_HOSPITAL tbl = new TBL_HOSPITAL();
tbl.HOSPITAL_NAME = model.HOSPITAL_NAME;
tbl.HOSPITAL_ADDRESS = model.HOSPITAL_ADDRESS;
tbl.HOSPITAL_IMAGE = model.HOSPITAL_IMAGE;
tbl.SPECIALIZATION = model.SPECIALIZATION;
tbl.CONTACT = model.CONTACT;
tbl.EMAIL = model.EMAIL;
tbl.HOSPITAL_ID = db.TBL_HOSPITAL.Add(tbl).HOSPITAL_ID;
db.SaveChanges();
TBL_HOSPITAL_DETAILS mdl = new TBL_HOSPITAL_DETAILS();
mdl.DESCRIPTION = model.DESCRIPTION;
mdl.MORE_INFO = model.MORE_INFO;
mdl.REMARKS = model.REMARKS;
mdl.HOSPITAL_ID = tbl.HOSPITAL_ID;
mdl.DETAIL_ID = db.TBL_HOSPITAL_DETAILS.Add(mdl).DETAIL_ID;
db.SaveChanges();
if (tbl.HOSPITAL_ID > 0)
{
return(Json(new { successMessage = "Successfully Registered!" }));
}
else
{
Response.StatusCode = (int)HttpStatusCode.SeeOther;
return(Json(new { errorMessage = "Something went wrong!" }));
}
}
else
{
return(PartialView(model));
}
}
public ActionResult listHospital(int?page, string query)
{
//List<DoctorViewModel> dc = new List<DoctorViewModel>();
int pageIndex = 1;
int pageSize = 5;
pageIndex = page.HasValue ? Convert.ToInt16(page) : 1;
if (query != null)
{
var result = (from p in db.TBL_HOSPITAL
where p.HOSPITAL_ADDRESS.Contains(query) || p.HOSPITAL_NAME.Contains(query) || p.EMAIL.Contains(query) || p.SPECIALIZATION.Contains(query)
select new { p }
).ToList();
List <TBL_HOSPITAL> list = new List <TBL_HOSPITAL>();
foreach (var item in result)
{
TBL_HOSPITAL doc = new TBL_HOSPITAL();
doc.HOSPITAL_NAME = item.p.HOSPITAL_NAME;
doc.HOSPITAL_ADDRESS = item.p.HOSPITAL_ADDRESS;
doc.HOSPITAL_IMAGE = item.p.HOSPITAL_IMAGE;
doc.HOSPITAL_ID = item.p.HOSPITAL_ID;
doc.CONTACT = item.p.CONTACT;
doc.SPECIALIZATION = item.p.SPECIALIZATION;
doc.EMAIL = item.p.EMAIL;
list.Add(doc);
}
return(View(list.ToPagedList(pageIndex, pageSize)));
// return View(db.TBL_DOCTOR.Where(X => X.ADDRESS.Contains(query) || ).ToList().ToPagedList(pageIndex, pageSize));
}
else
{
return(View(db.TBL_HOSPITAL.ToList().ToPagedList(pageIndex, pageSize)));
}
}
public ActionResult searchList(int?page, string searchKey, string searchfor)
{
int pageIndex = 1;
int pageSize = 4;
pageIndex = page.HasValue ? Convert.ToInt16(page) : 1;
if (searchfor == "doctor")
{
var result = (from p in db.TBL_DOCTOR
where p.ADDRESS.Contains(searchKey) || p.DOCTOR_NAME.Contains(searchKey) || p.EMAIL.Contains(searchKey) || p.SPECIALIZATION.Contains(searchKey) || p.WORK_HOSPITAL.Contains(searchKey)
select new { p }
).ToList();
List <TBL_DOCTOR> list = new List <TBL_DOCTOR>();
foreach (var item in result)
{
TBL_DOCTOR doc = new TBL_DOCTOR();
doc.ADDRESS = item.p.ADDRESS;
doc.DOCTOR_ID = item.p.DOCTOR_ID;
doc.SPECIALIZATION = item.p.SPECIALIZATION;
doc.DOCTOR_NAME = item.p.DOCTOR_NAME;
doc.DOCTOR_IMAGE = item.p.DOCTOR_IMAGE;
doc.DOCUMENT = item.p.DOCUMENT;
doc.WORK_HOSPITAL = item.p.WORK_HOSPITAL;
doc.CONTACT = item.p.CONTACT;
doc.EMAIL = item.p.EMAIL;
doc.GENDER = item.p.GENDER;
list.Add(doc);
}
return(View("~/Views/User/listDoctors.cshtml", list.ToPagedList(pageIndex, pageSize)));
}
else if (searchfor == "Disease")
{
var result = (from p in db.TBL_DISEASE
join q in db.TBL_DISEASE_DETAILS on p.DISEASE_ID equals q.DISEASE_ID
where p.DISEASE_NAME.Contains(searchKey) || p.CATEGORY.Contains(searchKey) || p.SYMPTOMS.Contains(searchKey)
select new
{
p,
q
}
).ToList();
List <DiseaseViewModel> list = new List <DiseaseViewModel>();
foreach (var item in result)
{
DiseaseViewModel doc = new DiseaseViewModel();
doc.DISEASE_ID = item.p.DISEASE_ID;
doc.DISEASE_NAME = item.p.DISEASE_NAME;
doc.CATEGORY = item.p.CATEGORY;
doc.SYMPTOMS = item.p.SYMPTOMS;
//doc.WORK_HOSPITAL = item.p.WORK_HOSPITAL;
//doc.CONTACT = item.p.CONTACT;
//doc.EMAIL = item.p.EMAIL;
//doc.GENDER = item.p.GENDER;
list.Add(doc);
}
return(View("~/Views/DIsease/listAll.cshtml", list.ToPagedList(pageIndex, pageSize)));
}
else if (searchfor == "hospital")
{
var result = (from p in db.TBL_HOSPITAL
where p.HOSPITAL_ADDRESS.Contains(searchKey) || p.HOSPITAL_NAME.Contains(searchKey) || p.SPECIALIZATION.Contains(searchKey)
select new { p }
).ToList();
List <TBL_HOSPITAL> list = new List <TBL_HOSPITAL>();
foreach (var item in result)
{
TBL_HOSPITAL doc = new TBL_HOSPITAL();
doc.HOSPITAL_NAME = item.p.HOSPITAL_NAME;
doc.HOSPITAL_ADDRESS = item.p.HOSPITAL_ADDRESS;
doc.SPECIALIZATION = item.p.SPECIALIZATION;
doc.HOSPITAL_ID = item.p.HOSPITAL_ID;
doc.HOSPITAL_IMAGE = item.p.HOSPITAL_IMAGE;
list.Add(doc);
}
return(View("~/Views/User/listHospital.cshtml", list.ToPagedList(pageIndex, pageSize)));
}
return(View());
}
