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));
}
