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()); }