public ActionResult OwnerHome(int?id)
{
TOwner owner = new TOwner();
if (Session["intUserID"] == null)
{
//ViewBag.ErrorMessage = "Authorized Users Only";
return(RedirectToAction("Login"));
}
else
{
int intOwnerID = (int)id;
//int? intOwnerID = db.uspGetOwnerID(id).FirstOrDefault();
OwnerHome ownerHome = new OwnerHome();
owner = db.TOwners.Include(s => s.TPets).SingleOrDefault(s => s.intOwnerID == id);
if (Session["intUserID"].ToString() != owner.intUserID.ToString())
{
//ViewBag.ErrorMessage = "Authorized Users Only";
return(RedirectToAction("Login"));
}
else
{
if (owner.TUser.intRoleID != 1)
{
ViewBag.ErrorMessage = "Authorized Users Only";
Logout();
}
List <PetOwnerImage> list = (from o in db.TOwners
join p in db.TPets
on o.intOwnerID equals p.intOwnerID
join i in db.TPetImages
on p.intPetID equals i.intPetID
join s in db.TStates
on o.intStateID equals s.intStateID
where o.intOwnerID == owner.intOwnerID
select new PetOwnerImage
{
intOwnerID = owner.intOwnerID,
strFirstName = o.strFirstName,
strLastName = o.strLastName,
intPetID = p.intPetID,
strPetName = p.strPetName,
intPetImageID = i.intPetImageID,
}).ToList();
ownerHome.PetImageData = list;
ownerHome.strFirstName = owner.strFirstName;
ownerHome.strLastName = owner.strLastName;
return(View(ownerHome));
}
}
}
public ActionResult Index(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OwnerHome myModel = new OwnerHome();
int intOwnerID = (int)Session["intOwnerID"];
//int intPetImageID = (int)Session["intPetImageID"];
//General Information
var ownerPetImage = (from i in db.TPetImages
join p in db.TPets
on i.intPetID equals p.intPetID
join o in db.TOwners
on p.intOwnerID equals o.intOwnerID
where p.intOwnerID == o.intOwnerID
select new {
ownerName = o.strFirstName + " " + o.strLastName,
phoneNumber = o.strPhoneNumber,
petName = p.strPetName,
intPetID = p.intPetID,
intPetImageID = i.intPetImageID, //Could be from TPets, not images
strFileName = i.strFileName,
imgContent = i.imgContent,
strContentType = i.strContentType,
strFileType = i.strFileType
}).FirstOrDefault();
//var doctor = (from e in db.TEmployees
// join ve in db.TVisitEmployees
// on e.intEmployeeID equals ve.intEmployeeID
// join j in db.TJobTitles
// on e.intJobTitleID equals j.intJobTitleID
// where ve.intVisitID == intVisitId
// where j.intJobTitleID == 4
// select new {
// doctorName = "Dr. " + e.strFirstName + " " + e.strLastName
// }).FirstOrDefault();
//Save to model
//myModel.strOwnerName = ownerPetImage.ownerName;
//myModel.strPhoneNumber = ownerPetImage.phoneNumber;
////myModel.intOwnerNumber = ownerPetImage.clientNumber;
//myModel.strPetName = ownerPetImage.petName;
//myModel.intPetID = ownerPetImage.intPetID;
//myModel.intPetImageID = ownerPetImage.intPetImageID;
//myModel.strFileName = ownerPetImage.strFileName;
//myModel.imgContent = ownerPetImage.imgContent;
//myModel.strContentType = ownerPetImage.strContentType;
//myModel.strFileType = ownerPetImage.strFileType;
//myModel.PetVisitServices = db.TVisitServices.Where(x => x.intVisitID == intVisitId).ToList();
//myModel.PetVisitMedications = db.TVisitMedications.Where(x => x.intVisitID == intVisitId).ToList();
//ViewBag.Name = informationPacket.petName;
//ViewBag.Total = db.TVisitServices
// .Where(x => x.intVisitID == intVisitId)
// .Select(z => z.TService.dblPrice)
// .DefaultIfEmpty()
// .Sum();
return(View(myModel));
////var pet = db.TPets.Include("TPetImages")
//// .Where(s => s.TOwner.intOwnerID == id)
//// .FirstOrDefault<TPet>();
//TOwner owner = db.TOwners.Include(s => s.TPets).SingleOrDefault(s => s.intOwnerID == id);
//return View(owner);
}
