public ActionResult DeleteConfirmed(int id)
{
AdminApprovalTbl adminApprovalTbl = db.AdminApprovalTbls.Find(id);
db.AdminApprovalTbls.Remove(adminApprovalTbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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);
}
// GET: AdminApproval/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminApprovalTbl adminApprovalTbl = db.AdminApprovalTbls.Find(id);
if (adminApprovalTbl == null)
{
return(HttpNotFound());
}
return(View(adminApprovalTbl));
}
public ActionResult Create([Bind(Include = "Id,Title,Image,Type,Category,SubCategory,Location,SubLocation,DateOfFound,DateOfLost,Details,OwnerName,CellNo,CategoryId,SubCategoryId,LocationId,SubLocationId")] AdminApprovalTbl adminApprovalTbl)
{
if (ModelState.IsValid)
{
db.AdminApprovalTbls.Add(adminApprovalTbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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);
return(View(adminApprovalTbl));
}
// GET: AdminApproval/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminApprovalTbl adminApprovalTbl = db.AdminApprovalTbls.Find(id);
if (adminApprovalTbl == null)
{
return(HttpNotFound());
}
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);
return(View(adminApprovalTbl));
}
public ActionResult Create(AdminApprovalTbl approve)
{
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);
// 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));
}
