Esempio n. 1
0
        public ActionResult AddPetLostInfo(LostFound petLost)
        {
            ViewBag.citylist = getCities();
            var cityId = Request.Form["citylist"];

            var cUser = (Customer)Session["currentUser"];
            petLost.CustomerId = cUser.CustomerId;
            petLost.City = Convert.ToInt16(cityId);

            if (petLost.Description == null)
            {
                petLost.Description = "";
            }

            db.LostFounds.Add(petLost);
            db.SaveChanges();
            ViewBag.Message = "Your lost pet information has been posted. Your lost report ID is " + petLost.LostFoundId + ".";
            ViewBag.Message2 = "Please do not lose your report ID. You need it to keep track your lost report.";
            ViewBag.Message3 = "Thank you for using our service.";
            return View();
        }
Esempio n. 2
0
        public ActionResult TrackReportResult(LostFound petLost)
        {
            LostFound thePetLost = db.LostFounds.Find(petLost.LostFoundId);
            var cUser = (Customer)Session["currentUser"];

            // Check whether the user is a valid and authorized user
            if (thePetLost != null && (Session["currentUser"] != null))
            {
                if (thePetLost.CustomerId == cUser.CustomerId)
                {
                    ViewBag.ReportId = thePetLost.LostFoundId;
                    ViewBag.PetCategory = thePetLost.PetCategory;
                    ViewBag.Description = thePetLost.Description;
                    var comment = (from theComment in db.LF_Comment
                                   join theOwner in db.Customers on theComment.CommenterId equals theOwner.CustomerId
                                   where theComment.InfoId.Equals(petLost.LostFoundId)
                                   select new SearchLostPetResult
                                   {
                                       lostInfoId = theComment.InfoId,
                                       pet_owner_name = theOwner.FirstName + " " + theOwner.LastName,
                                       pet_category = "",
                                       city = "",
                                       pet_desc = theComment.Comment
                                   }).Distinct();

                    return View(comment.AsEnumerable());
                }
                else
                {
                    ViewBag.error = "You are not authorized to view this Report";
                }
            }
            else
            {
                ViewBag.error = "No such report exists.";
            }
            return View();
        }
Esempio n. 3
0
        public ActionResult PetLostHelpInfoResult(LostFound petLost)
        {
            ViewBag.citylist = getCities();
            var cityId = Convert.ToInt32(Request.Form["citylist"]);

            var petLostQuery = (from theOwner in db.Customers
                                join theLostInfo in db.LostFounds on theOwner.CustomerId equals theLostInfo.CustomerId
                                join theCity in db.Cities on theLostInfo.City equals theCity.CityId
                                where theLostInfo.PetCategory.Equals(petLost.PetCategory)
                                where theLostInfo.City.Equals(cityId)
                                select new SearchLostPetResult
                                {
                                    lostInfoId = theLostInfo.LostFoundId,
                                    pet_owner_name = theOwner.FirstName + " " + theOwner.LastName,
                                    pet_category = theLostInfo.PetCategory,
                                    city = theCity.Name,
                                    pet_desc = theLostInfo.Description
                                }).Distinct();

            //int abc = petLostQuery.Count();
            return View(petLostQuery.AsEnumerable());
        }