public JsonResult GetMainCategoryInfo(int id)
{
NewsMainCategory mainCategory = _uow.NewsMainCategoryRepo.Find(id);
string result = "Name:" + mainCategory.MainCategoryName + ",Order:" + mainCategory.MainCategoryOrder;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int CheckOrderExists(int order, int?id)
{
NewsMainCategory group =
_context.Set <NewsMainCategory>()
.FirstOrDefault(
b => b.MainCategoryOrder == order && (id == null || b.ID != id));
return(group == null ? 0 : 1);
}
public int CheckNameExists(string MainCategoryName, int?id)
{
NewsMainCategory group =
_context.Set <NewsMainCategory>()
.FirstOrDefault(
b => b.MainCategoryName == MainCategoryName.Trim() && (id == null || b.ID != id));
return(group == null ? 0 : 1);
}
public NewsMainCategory FindNewsMainCategoryByName(string name)
{
NewsMainCategory newsMainCategory =
_context.Set <NewsMainCategory>()
.FirstOrDefault(
b => b.MainCategoryName == name.Trim());
return(newsMainCategory);
}
public int AddNewMainCategory()
{
NewsMainCategory newMainCategory = new NewsMainCategory()
{
MainCategoryName = "NewMainCategory",
MainCategoryOrder = 1,
};
_uow.NewsMainCategoryRepo.AddNewsMainCategory(newMainCategory);
_uow.SaveChanges();
return(newMainCategory.ID);
}
public void CanUpdateNewMainCategory()
{
_uow.NewsMainCategoryRepo.DeleteAllMainCategories();
_uow.SaveChanges();
int ID = AddNewMainCategory();
NewsMainCategory mainCategory = _uow.NewsMainCategoryRepo.Find(ID);
mainCategory.MainCategoryName = "UpdatedMainCategory";
_uow.NewsMainCategoryRepo.Update(mainCategory);
_uow.SaveChanges();
Assert.AreEqual("UpdatedMainCategory", _uow.NewsMainCategoryRepo.Find(ID).MainCategoryName);
}
public int AddNewCategory(string mainCategoryName, string categoryName)
{
NewsMainCategory newMainCategory = new NewsMainCategory()
{
MainCategoryName = mainCategoryName,
MainCategoryOrder = 1,
};
_uow.NewsMainCategoryRepo.AddNewsMainCategory(newMainCategory);
_uow.SaveChanges();
NewsCategory category = new NewsCategory()
{
CategoryName = categoryName,
CategoryOrder = 1,
MainCategoryId = newMainCategory.ID,
};
_uow.NewsCategoryRepo.AddNewsCategory(category);
_uow.SaveChanges();
return(category.Id);
}
public ActionResult _Save(NewsMainCategory _mainCategory)
{
try
{
if (_mainCategory.ID == 0)
{
if (_uow.NewsMainCategoryRepo.CanAddMainCategory(System.Configuration.ConfigurationManager.AppSettings["MainCategoriesNumber"]))
{
if (_uow.NewsMainCategoryRepo.CheckNameExists(_mainCategory.MainCategoryName, null) == 1)
{
return(new HttpStatusCodeResult(1));
}
if (_uow.NewsMainCategoryRepo.CheckOrderExists(_mainCategory.MainCategoryOrder, null) == 1)
{
return(new HttpStatusCodeResult(4));
}
if (_uow.NewsMainCategoryRepo.IsValidOrder(System.Configuration.ConfigurationManager.AppSettings["MainCategoriesNumber"], _mainCategory.MainCategoryOrder))
{
_uow.NewsMainCategoryRepo.AddNewsMainCategory(_mainCategory);
_uow.SaveChanges();
}
else
{
return(new HttpStatusCodeResult(3));
}
}
else
{
return(new HttpStatusCodeResult(2));
}
}
else
{
if (_uow.NewsMainCategoryRepo.CheckNameExists(_mainCategory.MainCategoryName, _mainCategory.ID) == 1)
{
return(new HttpStatusCodeResult(1));
}
if (_uow.NewsMainCategoryRepo.CheckOrderExists(_mainCategory.MainCategoryOrder, _mainCategory.ID) == 1)
{
return(new HttpStatusCodeResult(4));
}
if (_uow.NewsMainCategoryRepo.IsValidOrder(System.Configuration.ConfigurationManager.AppSettings["MainCategoriesNumber"], _mainCategory.MainCategoryOrder))
{
_uow.NewsMainCategoryRepo.UpdateNewsMainCategory(_mainCategory);
_uow.SaveChanges();
}
else
{
return(new HttpStatusCodeResult(3));
}
}
return(PartialView("_List", _uow.NewsMainCategoryRepo.GetAll()));
}
catch
{
return(View());
}
}
public ActionResult _Save()
{
NewsMainCategory newObj = new NewsMainCategory();
return(PartialView("_Save", newObj));
}
public void DeleteByID(int id)
{
NewsMainCategory deleted = _context.NewsMainCategory.Find(id);
_context.NewsMainCategory.Remove(deleted);
}
public void UpdateNewsMainCategory(NewsMainCategory oldNewsMainCategory)
{
_context.Entry(oldNewsMainCategory).State = EntityState.Modified;
}
public void AddNewsMainCategory(NewsMainCategory newNewsMainCategory)
{
_context.NewsMainCategory.Add(newNewsMainCategory);
}
