public ActionResult viewProfile() { if (Session["drlogin"] != null) { int id = int.Parse(Session["drid"].ToString()); var q = (from m in dc.Doctor_tbl from n in dc.Doctor_Type_tbl where m.Doctor_Id == id && m.Doctor_Type_Id == n.Doctor_Type_Id select new { m.Doctor_Id, n.Doctor_Type_Id, m.Doctor_fname, m.Doctor_mname, m.Doctor_lname, m.Doctor_Email_Id, m.Doctor_gender, m.Doctor_Mobile_No, m.Doctor_Address, m.Doctor_Status, m.Doctor_Image, n.Doctor_Type_Name, m.Doctor_Experience }); List <DrDetails> list = new List <DrDetails>(); foreach (var item in q) { DrDetails obj = new DrDetails(); obj.Doctor_Id = item.Doctor_Id; obj.Doctor_Type_Id = item.Doctor_Type_Id; obj.Doctor_fname = item.Doctor_fname; obj.Doctor_mname = item.Doctor_mname; obj.Doctor_lname = item.Doctor_mname; obj.Doctor_gender = item.Doctor_gender; obj.Doctor_Email_Id = item.Doctor_Email_Id; obj.Doctor_Mobile_No = item.Doctor_Mobile_No.ToString(); obj.Doctor_Status = item.Doctor_Status; obj.Doctor_Type_Name = item.Doctor_Type_Name; obj.Doctor_Address = item.Doctor_Address; obj.Doctor_Experience = item.Doctor_Experience; obj.Doctor_Image = item.Doctor_Image; list.Add(obj); } var prf = (dc.Certificate_tbl.Where(c => c.Doctor_Id == id)).ToList(); ViewData["vp"] = list; ViewData["prf"] = prf; return(View()); } else { return(RedirectToAction("DoctorLogin", "UserHome")); } }
public ActionResult DoctorDetailsAdmin() { if (Session["adminname"] != null) { int did = Convert.ToInt16(Request.QueryString["dtid"]); int cid = Convert.ToInt16(Request.QueryString["cid"]); var q = (from n in dc.Doctor_tbl from l in dc.Doctor_Type_tbl where n.Doctor_Id == cid && l.Doctor_Type_Id == did select new { n.Doctor_Id, l.Doctor_Type_Id, n.Doctor_Image, n.Doctor_fname, n.Doctor_mname, n.Doctor_lname, n.Doctor_Email_Id, n.Doctor_Mobile_No, n.Doctor_Status, n.Doctor_gender, n.Doctor_city, n.Doctor_Address, l.Doctor_Type_Name, n.Doctor_Experience }); List <DrDetails> list = new List <DrDetails>(); foreach (var item in q) { DrDetails obj = new DrDetails(); obj.Doctor_fname = item.Doctor_fname; obj.Doctor_mname = item.Doctor_mname; obj.Doctor_lname = item.Doctor_lname; obj.Doctor_Image = item.Doctor_Image; obj.Doctor_gender = item.Doctor_gender; obj.Doctor_Status = item.Doctor_Status; obj.Doctor_Address = item.Doctor_Address; obj.Doctor_city = item.Doctor_city; obj.Doctor_Mobile_No = item.Doctor_Mobile_No.ToString(); obj.Doctor_Email_Id = item.Doctor_Email_Id; obj.Doctor_Id = item.Doctor_Id; obj.Doctor_Type_Id = item.Doctor_Type_Id; obj.Doctor_Type_Name = item.Doctor_Type_Name; obj.Doctor_Experience = item.Doctor_Experience; list.Add(obj); } ViewData["usdfd"] = list; return(View()); } else { return(RedirectToAction("Login", "Admin")); } }
public ActionResult DrMoreDetails() { if (Session["Hoslogin"] != null) { int did = Convert.ToInt16(Request.QueryString["dtid"]); int cid = Convert.ToInt16(Request.QueryString["cid"]); var c = (from n in dc.Certificate_tbl where n.Doctor_Id == cid select n).ToList(); var q = (from n in dc.Doctor_tbl from l in dc.Doctor_Type_tbl where n.Doctor_Id == cid && l.Doctor_Type_Id == did select new { n.Doctor_Address, n.Doctor_Image, n.Doctor_fname, n.Doctor_mname, n.Doctor_lname, n.Doctor_Email_Id, n.Doctor_Mobile_No, n.Doctor_Status, n.Doctor_gender, l.Doctor_Type_Name, n.Doctor_Experience }); List <DrDetails> list = new List <DrDetails>(); foreach (var item in q) { DrDetails obj = new DrDetails(); obj.Doctor_fname = item.Doctor_fname; obj.Doctor_mname = item.Doctor_mname; obj.Doctor_lname = item.Doctor_lname; obj.Doctor_Image = item.Doctor_Image; obj.Doctor_gender = item.Doctor_gender; obj.Doctor_Status = item.Doctor_Status; obj.Doctor_Mobile_No = item.Doctor_Mobile_No.ToString(); obj.Doctor_Email_Id = item.Doctor_Email_Id; obj.Doctor_Type_Name = item.Doctor_Type_Name; obj.Doctor_Experience = item.Doctor_Experience; obj.Doctor_Address = item.Doctor_Address; list.Add(obj); } ViewData["vcrt"] = c; ViewData["drmoreDetails"] = list; return(View()); } else { return(RedirectToAction("HospitalLogin", "Hospital")); } }
public DrDetails ViewUpdateDoctorDetails(int did, int dt) {//no have a view DrDetails dd = new DrDetails(); var p = (from n in dc.Doctor_tbl from l in dc.Doctor_Type_tbl where n.Doctor_Id == did && l.Doctor_Type_Id == dt select new { n.Doctor_Address, n.Doctor_Image, n.Doctor_fname, n.Doctor_mname, n.Doctor_lname, n.Doctor_Email_Id, n.Doctor_Mobile_No, n.Doctor_Status, n.Doctor_gender, n.Doctor_city, l.Doctor_Type_Name, n.Doctor_Experience, n.Doctor_Id, l.Doctor_Type_Id }); foreach (var item in p) { dd.Doctor_Address = item.Doctor_Address; dd.Doctor_city = item.Doctor_city; dd.Doctor_Email_Id = item.Doctor_Email_Id; dd.Doctor_Experience = item.Doctor_Experience; dd.Doctor_fname = item.Doctor_fname; dd.Doctor_mname = item.Doctor_mname; dd.Doctor_lname = item.Doctor_lname; dd.Doctor_Mobile_No = item.Doctor_Mobile_No.ToString(); dd.Doctor_Type_Name = item.Doctor_Type_Name; dd.Doctor_gender = item.Doctor_gender; dd.Doctor_Image = item.Doctor_Image; dd.Doctor_Id = item.Doctor_Id; dd.Doctor_Type_Id = item.Doctor_Type_Id; } return(dd); }