public ActionResult DeleteConfirmed(int id)
{
//new ArticleCategoryDAL().Delete(id);
var aCate = new ArticleCategoryDAL().ViewDetail(id);
aCate.IsActive = false;
var _dal = new ArticleCategoryDAL();
var _result = _dal.Update(aCate);
return(RedirectToAction("Index"));
}
// GET: Admin/ArticleCategories/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var articleCategory = new ArticleCategoryDAL().ViewDetail(id);
if (articleCategory == null)
{
return(HttpNotFound());
}
return(View(articleCategory));
}
public List <ArticleCategoryEntity> GetArticleCategoryEntitiesByPId(int PId, string orderBy)
{
List <SqlDbParameter> parmsCategory = new List <SqlDbParameter>();
SqlDbParameter parm = new SqlDbParameter();
parm.ColumnName = "PId";
parm.ParameterName = "PId";
parm.ColumnType = DbType.Int32;
parm.QualificationType = SqlDbParameter.QualificationSymbol.Equal;
parm.ParameterValue = PId; //3表示业务类别
parmsCategory.Add(parm);
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.GetAll(parmsCategory, orderBy));
}
public DataTable GetArticleDataTablePage(List <SqlDbParameter> parms, string OrderBy, int PageSize, int PageIndex, out int RecordCount)
{
ArticleDAL articleDAL = new ArticleDAL();
DataTable dataTable = articleDAL.GetArticleDataTablePage(parms, OrderBy, PageSize, PageIndex, out RecordCount);
//TO DO Cache
ArticleCategoryDAL articleCategoryDAL = new ArticleCategoryDAL();
parms = new List <SqlDbParameter>();
List <ArticleCategoryEntity> articleCategory = articleCategoryDAL.GetAll(parms, "Id");
for (int i = 0; i < dataTable.Rows.Count; i++)
{
int _categoryId = 0;
if (int.TryParse(dataTable.Rows[i]["CategoryId"].ToString(), out _categoryId))
{
ArticleCategoryEntity articleCategoryEntity = articleCategory.Find(t => t.Id == _categoryId);
dataTable.Rows[i]["CategoryName"] = articleCategoryEntity == null ? "" : articleCategoryEntity.CategoryName;
}
}
return(dataTable);
}
public ActionResult Edit([Bind(Include = "ArticleCategoryID,ArticleCategoryName,Description,Image,MetaTitle,ParentID,DisplayOrder,SeoTitle,MetaDescription,MetaKeywords,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] ArticleCategory articleCategory)
{
var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION];
if (ModelState.IsValid)
{
var _dal = new ArticleCategoryDAL();
articleCategory.ModifiedUser = UserSession.UserID;
var _result = _dal.Update(articleCategory);
if (_result)
{
return(RedirectToAction("Index", "ArticleCategories"));
}
else
{
ModelState.AddModelError("", "Cập nhật danh muc bài viết ko thành công");
}
}
return(View(articleCategory));
}
public PartialViewResult ArticleCategory()
{
var model = new ArticleCategoryDAL().ListAll();
return(PartialView(model));
}
public DataTable GetArticleCategoryDataTablePage(List <SqlDbParameter> parms, string OrderBy, int PageSize, int PageIndex, out int RecordCount)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.GetArticleCategoryDataTablePage(parms, OrderBy, PageSize, PageIndex, out RecordCount));
}
public List <ArticleCategoryEntity> GetArticleCategoryPaged(List <SqlDbParameter> parms, string OrderBy, int PageSize, int PageIndex, out int RecordCount)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.GetAll(parms, OrderBy, PageSize, PageIndex, out RecordCount));
}
public DataTable GetArticleCategoryDataTable(List <SqlDbParameter> parms, string OrderBy)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.GetArticleCategoryDataTable(parms, OrderBy));
}
//返回单实体对象
public ArticleCategoryEntity GetArticleCategoryEntity(List <SqlDbParameter> parms)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.Get(parms));
}
public List <ArticleCategoryEntity> GetAllArticleCategory(List <SqlDbParameter> parms, string orderBy)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.GetAll(parms, orderBy));
}
public ArticleCategoryEntity GetArticleCategoryEntityById(object Id)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
return(dal.Get(Id));
}
public void DeleteArticleCategoryEntityById(ArticleCategoryEntity entity)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
dal.Delete(entity);
}
public void DisableArticleCategoryEntityById(object Id)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
dal.Disabled(Id);
}
public void UpdateArticleCategoryEntity(ArticleCategoryEntity entity)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
dal.Update(entity);
}
public void AddArticleCategoryEntity(ArticleCategoryEntity entity)
{
ArticleCategoryDAL dal = new ArticleCategoryDAL();
dal.Insert(entity);
}
