public ActionResult DeleteConfirmed(int id) { Foundtbl foundtbl = db.Foundtbls.Find(id); db.Foundtbls.Remove(foundtbl); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Title,Image,Category,Location,Details,SubLocation,DateOfFound")] Foundtbl foundtbl) { if (ModelState.IsValid) { db.Entry(foundtbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(foundtbl)); }
// GET: FoundProducts/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Foundtbl foundtbl = db.Foundtbls.Find(id); if (foundtbl == null) { return(HttpNotFound()); } return(View(foundtbl)); }
// GET: FoundProducts/Details/5 public ActionResult Details(int?id) { var foundproducts = db.Foundtbls.Include(m => m.Category1).Include(m => m.SubCategory1).SingleOrDefault(x => x.Id == id); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Foundtbl foundtbl = db.Foundtbls.Find(id); if (foundproducts == null) { return(HttpNotFound()); } TempData["Title"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.Title) .FirstOrDefault(); TempData["Location"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.Location1.LocationName) .FirstOrDefault(); TempData["SubLocation"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.SubLocation1.SubLocationName) .FirstOrDefault(); TempData["Details"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.Details) .FirstOrDefault(); TempData["SubCategory"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.SubCategory1.SubCategoryName) .FirstOrDefault(); if (foundtbl.UniqueKey != null) { TempData["Uniquekey"] = db.Foundtbls .Where(x => x.Id == id) .Select(x => x.UniqueKey) .FirstOrDefault(); } return(View(foundproducts)); }
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); }
public ActionResult Create(AdminApprovalTbl approve, Foundtbl found) { string fileName = Path.GetFileNameWithoutExtension(approve.ImageFile.FileName); // string fileName = Path.GetFileNameWithoutExtension(loststbl.ImageFile.FileName); // string fileNames = Path.GetFileNameWithoutExtension(losttbl.ImageFile.FileName); string extension = Path.GetExtension(approve.ImageFile.FileName); // string extension = Path.GetExtension(loststbl.ImageFile.FileName); // string extensions = Path.GetExtension(losttbl.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; // fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; // fileNames = fileNames + DateTime.Now.ToString("yymmssfff") + extensions; approve.Image = "~/Image/" + fileName; // loststbl.Image = "~/Image/" + fileName; // losttbl.Image = "~/Image/" + fileNames; fileName = Path.Combine(Server.MapPath("~/Image/"), fileName); // fileName = Path.Combine(Server.MapPath("~/Image/"), fileName); // fileNames = Path.Combine(Server.MapPath("~/Image/"), fileNames); approve.ImageFile.SaveAs(fileName); // loststbl.ImageFile.SaveAs(fileName); // losttbl.ImageFile.SaveAs(fileNames); if (ModelState.IsValid) { approve.CategoryId = Int32.Parse(approve.Category); approve.SubCategoryId = Int32.Parse(approve.SubCategory); approve.LocationId = Int32.Parse(approve.Location); approve.SubLocationId = Int32.Parse(approve.SubLocation); // loststbl.CategoryId = Int32.Parse(loststbl.Category); // loststbl.SubCategoryId = Int32.Parse(loststbl.SubCategory); // loststbl.LocationId = Int32.Parse(loststbl.Location); // loststbl.SubLocationId = Int32.Parse(loststbl.SubLocation); // losttbl.CategoryId = Int32.Parse(losttbl.Category); // losttbl.SubCategoryId = Int32.Parse(losttbl.SubCategory); // losttbl.LocationId = Int32.Parse(loststbl.Location); // losttbl.SubLocationId = Int32.Parse(losttbl.Sublocation); db.AdminApprovalTbls.Add(approve); // ViewBag.cellno = db.LoginTbls.Max(item => item.RegisterTbl.ContactNo); // ViewBag.cellno = found.CellNo; // db.Foundtbls.Add(loststbl); // db.AllProductsTbls.Add(losttbl); 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("Success")); } return(View(approve)); }