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