public ActionResult Category_add(ETCategory Category) { TempData["messagealert"] = string.Empty; ViewBag.messagealert = string.Empty; if (ModelState.IsValid) { if (Category != null) { if (repCategory.CategoryIsExist(Category.CategoryName, 0)) { ViewBag.messagealert = "Category already exist"; ViewBag.Source = repCategory.getSourceType(); return(View(Category)); } else { Category.UserID = Convert.ToInt64(Session["UserID"]); Category.CreatedBy = Convert.ToInt64(Session["UserID"]); Category.CreatedDate = DateTime.Now; Category.ModifiedBy = Convert.ToInt64(Session["UserID"]); Category.ModifiedDate = DateTime.Now; dbEntities.ETCategories.Add(Category); dbEntities.SaveChanges(); if (Category.CategoryID != 0) { TempData["messagealert"] = Status.Save; } } } return(RedirectToAction("Index", "Category")); } return(View()); }
public bool CategoryUpdateStatus(bool status, long Categoryid) { Category = new ETCategory(); Category = repCategory.GetCategory(Categoryid); if (Category != null) { if (status) { Category.IsActive = false; Category.ModifiedBy = Convert.ToInt64(Session["UserID"]); Category.ModifiedDate = DateTime.Now; } else { Category.IsActive = true; Category.ModifiedBy = Convert.ToInt64(Session["UserID"]); Category.ModifiedDate = DateTime.Now; } dbEntities.Entry(Category).State = EntityState.Modified; dbEntities.SaveChanges(); return(true); } return(false); }
public bool CategoryDelete(long id) { if (!dbEntities.ETUsers.Where(x => x.UserID == 1).Any()) // Need to change { TempData["messagealert"] = Status.Delete; Category = new ETCategory(); Category = dbEntities.ETCategories.Where(x => x.CategoryID == id).SingleOrDefault(); if (Category != null) { dbEntities.ETCategories.Remove(Category); dbEntities.SaveChanges(); return(true); } } return(false); //if (!dbEntities.TBL_ADMIN_USER.Where(x => x.ROLE_ID == id).Any()) //{ // TempData["messagealert"] = Status.Delete; // role = new TBL_ROLE(); // role = dbEntities.TBL_ROLE.Where(x => x.ROLE_ID == id && x.ROLE_NAME != "superadmin").SingleOrDefault(); // if (role != null) // { // dbEntities.TBL_ROLE.Remove(role); // dbEntities.SaveChanges(); // return true; // } //} //return false; }
public ActionResult Category_edit(long id, ETCategory updateCategory) { TempData["messagealert"] = string.Empty; if (ModelState.IsValid) { Category = new ETCategory(); Category = repCategory.GetCategory(id); if (repCategory.CategoryIsExist(updateCategory.CategoryName, id)) { ViewBag.messagealert = "Category already exist"; ViewBag.Source = repCategory.getSourceType(); return(View(Category)); } else { Category.CategoryName = updateCategory.CategoryName; Category.SourceID = updateCategory.SourceID; Category.IsActive = updateCategory.IsActive; Category.ModifiedBy = Convert.ToInt64(Session["UserID"]); Category.ModifiedDate = DateTime.Now; dbEntities.Entry(Category).State = EntityState.Modified; dbEntities.SaveChanges(); if (Category.CategoryID != 0) { TempData["messagealert"] = Status.Update; } } return(RedirectToAction("Index", "Category")); } return(View()); }
public ActionResult Category_edit(long Id) { ViewBag.messagealert = string.Empty; Category = new ETCategory(); Category = repCategory.GetCategory(Id); ViewBag.Source = repCategory.getSourceType(); return(View(Category)); }
public ActionResult Category_view(long Id) { Category = repCategory.GetCategory(Id); ETSource SourceNames = dbEntities.ETSources.Where(x => x.SourceID == Category.SourceID).Single(); Category.SourceName = SourceNames.SourceName; return(View(Category)); }