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