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