public ActionResult Edit(int id, HttpPostedFileBase image, tbl_Categories obj) { try { string imgPath = string.Empty; // Check the image file if (image != null) { string filename = Path.GetFileName(image.FileName); // Get the location of image path imgPath = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(image.FileName)); // Save the image image.SaveAs(imgPath); imgPath = filename; } // Assign path to category obj.Categoriesimage = imgPath; // Assign message to viewbag ViewBag.FileStatus = "File uploaded successfully."; db.Sp_Categories_update(obj.CategoriesID, obj.CategoriesName, obj.Categoriesimage); return(RedirectToAction("List")); } catch { return(View()); } }
public ActionResult Create([Bind(Include = "Category_ID,Category_Name,Category_ImageName")] tbl_Categories tbl_Categories, HttpPostedFileBase file) { using (Store_DB db = new Store_DB()) { if (file != null) { string pathToSave = Server.MapPath(@"~/Content/Uploads/Categories/"); //tbl_Categories.Category_ImageName = file.FileName; var createCategory = new tbl_Categories() { Category_Name = tbl_Categories.Category_Name, Category_ImagePath = pathToSave }; string NewFileName = String.Format("{0}.png", createCategory.Category_Name); createCategory.Category_ImageName = NewFileName; file.SaveAs(Path.Combine(pathToSave, NewFileName)); db.tbl_Categories.Add(createCategory); db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(tbl_Categories)); }
public async Task <IHttpActionResult> Puttbl_Categories(int id, tbl_Categories tbl_Categories) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_Categories.CategoryId) { return(BadRequest()); } db.Entry(tbl_Categories).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tbl_CategoriesExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit([Bind(Include = "Category_ID,Category_Name,Category_ImageName")] tbl_Categories tbl_Categories, HttpPostedFileBase CategoryEdit) { if (ModelState.IsValid) { if (CategoryEdit != null) { string pathToSave = Server.MapPath(@"~/Content/Uploads/Categories/"); //tbl_Categories.Category_ImageName = file.FileName; var replaceCategoryPhoto = new tbl_Categories() { Category_Name = tbl_Categories.Category_Name, Category_ImagePath = pathToSave }; string NewFileName = String.Format("{0}.png", replaceCategoryPhoto.Category_Name); replaceCategoryPhoto.Category_ImageName = NewFileName; CategoryEdit.SaveAs(Path.Combine(pathToSave, NewFileName)); } db.Entry(tbl_Categories).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_Categories)); }
public ActionResult DeleteConfirmed(int id) { tbl_Categories tbl_Categories = db.tbl_Categories.Find(id); db.tbl_Categories.Remove(tbl_Categories); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IHttpActionResult> Gettbl_Categories(int id) { tbl_Categories tbl_Categories = await db.tbl_Categories.FindAsync(id); if (tbl_Categories == null) { return(NotFound()); } return(Ok(tbl_Categories)); }
public async Task <IHttpActionResult> Posttbl_Categories(tbl_Categories tbl_Categories) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_Categories.Add(tbl_Categories); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = tbl_Categories.CategoryId }, tbl_Categories)); }
public async Task <IHttpActionResult> Deletetbl_Categories(int id) { tbl_Categories tbl_Categories = await db.tbl_Categories.FindAsync(id); if (tbl_Categories == null) { return(NotFound()); } db.tbl_Categories.Remove(tbl_Categories); await db.SaveChangesAsync(); return(Ok(tbl_Categories)); }
// GET: Categories/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Categories tbl_Categories = db.tbl_Categories.Find(id); if (tbl_Categories == null) { return(HttpNotFound()); } return(View(tbl_Categories)); }
public static bool SaveCategory(string id, string name, string status) { InventoryBL bl = new InventoryBL(); tbl_Categories Category = new tbl_Categories() { Category_Id = Convert.ToInt32(id), Category_Name = name, Category_Status = status == "1" ? true : false }; if (!bl.ValidateCategory(Category)) { bool result = bl.SaveCategory(Category); return(result); } return(false); }
public List <tbl_Content> GetContentByCategoryUrl(string url, int domainID) { tbl_Categories category = CategoriesRepository.GetByURL(url); if (category == null) { return(null); } var sitemaps = SitemapRepository.GetByCategoryID(category.CategoryID, domainID).Where(c => c.SM_Live).OrderByDescending(b => b.SM_Date); if (sitemaps == null || sitemaps.Count() == 0) { return(null); } return(sitemaps.Select(s => s.tbl_Content.Where(c => c.C_Approved && !c.C_Deleted).OrderByDescending(c => c.C_ModificationDate).FirstOrDefault()).Where(b => b != null).ToList()); }
// GET: Categories public ActionResult Index() { tbl_Categories Category = new tbl_Categories(); tbl_SubCategories SubCategory = new tbl_SubCategories(); Store_DB db = new Store_DB(); foreach (var item in db.tbl_Categories) { //item.Category_ImagePath = "~/Content/Uploads/Categories/" + item.Category_ImageName; item.Category_ImagePath = "~/Content/Uploads/Categories/" + item.Category_ImageName; } //if (Category.Category_ImageName == db.tbl_Categories.FirstOrDefault().Category_ImageName) //{ // Category.Category_ImageName = "~/Content/Uploads/Categories/" + Category.Category_ID.ToString() + ".png"; //} return(View(db.tbl_Categories.ToList())); }