public ActionResult DetailsToplost(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TopLosttbl foundtbl = obj.TopLosttbls.Find(id); if (foundtbl == null) { return(HttpNotFound()); } TempData["Titletl"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.Title) .FirstOrDefault(); TempData["Locationtl"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.Location1.LocationName) .FirstOrDefault(); TempData["SubLocationtl"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.SubLocation1.SubLocationName) .FirstOrDefault(); TempData["Detailstl"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.Details) .FirstOrDefault(); TempData["SubCategorytl"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.SubCategory1.SubCategoryName) .FirstOrDefault(); if (foundtbl.UniqueKey != null) { TempData["Uniuekey"] = obj.TopLosttbls .Where(x => x.Id == id) .Select(x => x.UniqueKey) .FirstOrDefault(); } return(View(foundtbl)); }
public ActionResult Edit([Bind(Include = "Id,Title,Image,Type,Category,SubCategory,Location,SubLocation,DateOfFound,DateOfLost,FoundId,LostId,Details,OwnerName,CellNo,CategoryId,SubCategoryId,LocationId,SubLocationId,OwnerAddress,UniqueKey")] AdminApprovalTbl appoval, AllProductsTbl adminApprovalTbl, Foundtbl foundtbl, Losttbl losttbl, Topfoundtbl topfoundtbl, TopLosttbl toplosttbl) { if (ModelState.IsValid) { if (appoval.Type == "LOSTED") { db.AllProductsTbls.Add(adminApprovalTbl); db.Losttbls.Add(losttbl); } else if (appoval.Type == "TOP LOSTED") { db.AllProductsTbls.Add(adminApprovalTbl); db.Losttbls.Add(losttbl); db.TopLosttbls.Add(toplosttbl); } else if (appoval.Type == "FOUNDED") { db.AllProductsTbls.Add(adminApprovalTbl); db.Foundtbls.Add(foundtbl); } else if (appoval.Type == "TOP FOUNDED") { db.AllProductsTbls.Add(adminApprovalTbl); db.Foundtbls.Add(foundtbl); db.Topfoundtbls.Add(topfoundtbl); } // db.AllProductsTbls.Add(adminApprovalTbl); // db.Entry(adminApprovalTbl).State = EntityState.Modified; } ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName", adminApprovalTbl.CategoryId); ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", adminApprovalTbl.LocationId); ViewBag.SubCategoryId = new SelectList(db.SubCategories, "SubCategoryId", "SubCategoryName", adminApprovalTbl.SubCategoryId); ViewBag.SubLocationId = new SelectList(db.SubLocations, "SubLocationId", "SubLocationName", adminApprovalTbl.SubLocationId); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } return(RedirectToAction("CreateConfirm")); // return View(appoval); }