public ActionResult Create([Bind(Include = "intPetID,strPetNumber,strMicrochipID,strPetName,intPetTypeID,intGenderID,intBreedID,dtmDateofBirth,dblWeight,isBlind,isDeaf,isAggressive,isDeceased,isAllergic,strColor,strNotes,isDeceased,intOwnerID")] TPet tPet, HttpPostedFileBase upload) { try { if (ModelState.IsValid) { //Other Pet Profile info SqlParameter[] param = new SqlParameter[] { new SqlParameter("@strPetName", tPet.strPetName), new SqlParameter("@strPetNumber", tPet.strPetNumber), new SqlParameter("@strMicrochipID", tPet.strMicrochipID), new SqlParameter("@intPetTypeID", tPet.TPetType.intPetTypeID), //.intPetTypeID), new SqlParameter("@intGenderID", tPet.intGenderID), new SqlParameter("@intBreedID", tPet.intBreedID), new SqlParameter("@dtmDateofBirth", tPet.dtmDateofBirth), new SqlParameter("@dblWeight", tPet.dblWeight), new SqlParameter("@isBlind", tPet.isBlind), new SqlParameter("@isDeaf", tPet.isDeaf), new SqlParameter("@isAggressive", tPet.isAggressive), new SqlParameter("@isDeceased", tPet.isDeceased), new SqlParameter("@isAllergic", tPet.isAllergic), new SqlParameter("@strColor", tPet.strColor), new SqlParameter("@strNotes", tPet.strNotes), new SqlParameter("@intOwnerID", tPet.intOwnerID) }; db.Database.ExecuteSqlCommand("uspAddPets @strPetName, @strPetNumber, @strMicrochipID, @intPetTypeID, @intGenderID, @intBreedID, @dtmDateofBirth, @dblWeight, @isBlind, @isDeaf, @isAggressive, @isDeceased, @isAllergic, @strColor, @strNotes, @intOwnerID", param); //PetImage if (upload != null && upload.ContentLength > 0) { var image = new TPetImage { strFileName = Path.GetFileName(upload.FileName), strFileType = Path.GetExtension(upload.FileName), strContentType = upload.ContentType, intPetID = tPet.intPetID }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { image.imgContent = reader.ReadBytes(upload.ContentLength); } tPet.TPetImages = new List <TPetImage> { image }; } db.TPetImages.Add((TPetImage)tPet.TPetImage); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType", tPet.intPetTypeID); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tPet.intGenderID); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strLastName", tPet.intOwnerID); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName", tPet.intBreedID); ViewBag.intPetID = new SelectList(db.TPets, "intPetID", "strPetNumber", tPet.intPetID); return(View(tPet.TPetImage)); }
// GET: TPets/Details/5 public ActionResult Details(int?id) { TPet pet = new TPet(); ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType"); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender"); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strFullName"); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName"); ViewBag.intPetImageID = new SelectList(db.TPetImages, "intPetImageID", "imgContent"); ViewBag.intVisitID = new SelectList(db.TVisits, "intVisitID", "dtmDateOfVist"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TPet tPet = db.TPets.Include(s => s.TPetImages).SingleOrDefault(s => s.intPetID == id); //Get List of Visits and put in PetProfile View if (tPet == null) { return(HttpNotFound()); } return(View(tPet)); }
// GET: TPets/Details/5 public ActionResult PetProfile(int?id) { TPet pet = new TPet(); if (Session["intUserID"] == null) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login", "Home")); } else { var oInfo = (from o in db.TOwners join p in db.TPets on o.intOwnerID equals p.intOwnerID join u in db.TUsers on o.intUserID equals u.intUserID where p.intPetID == (int)id select new { intOwnerID = o.intOwnerID, strFirstName = o.strFirstName, strLastName = o.strLastName, intUserID = u.intUserID }).FirstOrDefault(); if (Session["intUserID"].ToString() != oInfo.intUserID.ToString()) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login", "Home")); } else { ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType"); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender"); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strFullName"); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName"); ViewBag.intPetImageID = new SelectList(db.TPetImages, "intPetImageID", "imgContent"); ViewBag.intVisitID = new SelectList(db.TVisits, "intVisitID", "dtmDateOfVist"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TPet tPet = db.TPets.Include(s => s.TPetImages).SingleOrDefault(s => s.intPetID == id); //Get List of Visits and put in PetProfile View if (tPet == null) { return(HttpNotFound()); } return(View(tPet)); } } }
public ActionResult DeleteConfirmed(int id) { TPet tPet = db.TPets.Find(id); db.TPets.Remove(tPet); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: TPets/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TPet tPet = db.TPets.Find(id); if (tPet == null) { return(HttpNotFound()); } return(View(tPet)); }
// GET: TPets/Edit/5 public ActionResult PetProfileEdit(int?id) { if (Session["intUserID"] == null) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { var oInfo = (from o in db.TOwners join p in db.TPets on o.intOwnerID equals p.intOwnerID join u in db.TUsers on o.intUserID equals u.intUserID where p.intPetID == (int)id select new { intOwnerID = o.intOwnerID, strFirstName = o.strFirstName, strLastName = o.strLastName, intUserID = u.intUserID }).FirstOrDefault(); if (Session["intUserID"].ToString() != oInfo.intUserID.ToString()) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login", "Home")); } else { TPet tPet = db.TPets.Find(id); if (tPet == null) { return(HttpNotFound()); } ViewBag.intStateID = new SelectList(db.TStates, "intStateID", "strStateName", tPet.TOwner.TState.intStateID); ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType", tPet.intPetTypeID); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tPet.intGenderID); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strFullName", tPet.intOwnerID); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName", tPet.intBreedID); return(View(tPet)); } } }
public ActionResult EditPost(TPet tPet, int?id, HttpPostedFileBase upload) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var petToUpdate = db.TPets.Find(id); if (TryUpdateModel(petToUpdate, "", new string[] { "intPetID", "strPetNumber", "strMicrochipID", "strPetName", "intPetTypeID", "intGenderID", "intBreedID", "dtmDateofBirth", "dblWeight", "isBlind", "isDeaf", "isAggressive", "isDeceased", "isAllergic", "strColor", "strNotes", "isDeceased", "intOwnerID" })) { try { if (upload != null && upload.ContentLength > 0) { if (petToUpdate.TPetImages.Any(f => f.strFileType == ".jpg")) { db.TPetImages.Remove(petToUpdate.TPetImages.First(f => f.strFileType == ".jpg")); } var avatar = new TPetImage { strFileName = System.IO.Path.GetFileName(upload.FileName), strFileType = System.IO.Path.GetExtension(upload.FileName), strContentType = upload.ContentType }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { avatar.imgContent = reader.ReadBytes(upload.ContentLength); } petToUpdate.TPetImages = new List <TPetImage> { avatar }; } db.Entry(petToUpdate).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = tPet.intPetID })); } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator."); } } return(View(petToUpdate)); }
// GET: TPets/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TPet tPet = db.TPets.Find(id); if (tPet == null) { return(HttpNotFound()); } ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType", tPet.intPetTypeID); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tPet.intGenderID); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strFullName", tPet.intOwnerID); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName", tPet.intBreedID); return(View(tPet)); }
public ActionResult Create([Bind(Include = "intPetID,strPetNumber,strMicrochipID,strPetName,intPetTypeID,intGenderID,intBreedID,dtmDateofBirth,dblWeight,isBlind,isDeaf,isAggressive,isDeceased,isAllergic,strColor,strNotes,isDeceased,intOwnerID")] TPet tPet, HttpPostedFileBase upload) { try { if (ModelState.IsValid) { if (upload != null && upload.ContentLength > 0) { var image = new TPetImage { strFileName = Path.GetFileName(upload.FileName), strFileType = Path.GetExtension(upload.FileName), strContentType = upload.ContentType }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { image.imgContent = reader.ReadBytes(upload.ContentLength); } tPet.TPetImages = new List <TPetImage> { image }; } db.TPets.Add(tPet); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } ViewBag.intPetTypeID = new SelectList(db.TPetTypes, "intPetTypeID", "strPetType", tPet.intPetTypeID); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tPet.intGenderID); ViewBag.intOwnerID = new SelectList(db.TOwners, "intOwnerID", "strFullName", tPet.intOwnerID); ViewBag.intBreedID = new SelectList(db.TBreeds, "intBreedID", "strBreedName", tPet.intBreedID); return(View(tPet)); }
public ActionResult PetProfileEditPost(TPet tPet, int?id, HttpPostedFileBase upload) { if (Session["intUserID"] == null) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { var oInfo = (from o in db.TOwners join p in db.TPets on o.intOwnerID equals p.intOwnerID join u in db.TUsers on o.intUserID equals u.intUserID where p.intPetID == (int)id select new { intOwnerID = o.intOwnerID, strFirstName = o.strFirstName, strLastName = o.strLastName, intUserID = u.intUserID }).FirstOrDefault(); if (Session["intUserID"].ToString() != oInfo.intUserID.ToString()) { //ViewBag.ErrorMessage = "Authorized Users Only"; return(RedirectToAction("Login", "Home")); } else { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var petToUpdate = db.TPets.Find(id); var ownerToUpdate = db.TOwners.Find(petToUpdate.intOwnerID); if (TryUpdateModel(petToUpdate, "", new string[] { "intPetID", "strPetNumber", "strMicrochipID", "strPetName", "intPetTypeID", "intGenderID", "intBreedID", "dtmDateofBirth", "dblWeight", "isBlind", "isDeaf", "isAggressive", "isDeceased", "isAllergic", "strColor", "strNotes", "isDeceased", "intOwnerID" })) { try { if (upload != null && upload.ContentLength > 0) { if (petToUpdate.TPetImages.Any(f => f.strFileType == ".jpg")) { db.TPetImages.Remove(petToUpdate.TPetImages.First(f => f.strFileType == ".jpg")); } var avatar = new TPetImage { strFileName = System.IO.Path.GetFileName(upload.FileName), strFileType = System.IO.Path.GetExtension(upload.FileName), strContentType = upload.ContentType }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { avatar.imgContent = reader.ReadBytes(upload.ContentLength); } petToUpdate.TPetImages = new List <TPetImage> { avatar }; } db.Entry(petToUpdate).State = EntityState.Modified; // db.Entry(ownerToUpdate).State = EntityState.Modified; db.SaveChanges(); // return RedirectToAction("PetProfile", new { id = tPet.intPetID }); } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator."); } if (TryUpdateModel(ownerToUpdate, "", new string[] { "intOwnerID", "strFirstName", "strLastName", "intGenderID", "intPetTypeID", "intGenderID", "strAddress", "strCity", "intStateID", "strZip", "isDeaf", "strPhoneNumber", "strEmail", "strOwner2Name", "strOwner2PhoneNumber", "strOwner2Email", "strNotes", "intUserID" })) { ownerToUpdate.strAddress = tPet.TOwner.strAddress; ownerToUpdate.strCity = tPet.TOwner.strCity; ownerToUpdate.intStateID = petToUpdate.TOwner.intStateID; ownerToUpdate.strZip = tPet.TOwner.strZip; ownerToUpdate.strPhoneNumber = tPet.TOwner.strPhoneNumber; if (ModelState.IsValid) { db.Entry(ownerToUpdate).State = EntityState.Modified; db.SaveChanges(); } ViewBag.intStateID = new SelectList(db.TStates, "intStateID", "strStateCode", ownerToUpdate.intStateID); ViewBag.intUserID = new SelectList(db.TUsers, "intUserID", "strUserName", ownerToUpdate.intUserID); ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", ownerToUpdate.intGenderID); } return(RedirectToAction("PetProfile", new { id = tPet.intPetID })); } return(View(petToUpdate)); } } }