public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AllProductsTbl allproductstbl = db.AllProductsTbls.Find(id);
if (allproductstbl == null)
{
return(HttpNotFound());
}
TempData["Title"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.Title)
.FirstOrDefault();
TempData["Location"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.Location1.LocationName)
.FirstOrDefault();
TempData["SubLocation"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.SubLocation1.SubLocationName)
.FirstOrDefault();
TempData["Details"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.Details)
.FirstOrDefault();
TempData["SubCategory"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.SubCategory1.SubCategoryName)
.FirstOrDefault();
if (allproductstbl.UniqueKey != null)
{
TempData["Uniquekey"] = db.AllProductsTbls
.Where(x => x.Id == id)
.Select(x => x.UniqueKey)
.FirstOrDefault();
}
return(View(allproductstbl));
}
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);
}
