public ActionResult Search(string keyword) { ViewCategoryModel viewCategories; var LastestArticle = getLastestArticle(); var articles = db.Articles.AsQueryable(); if (!string.IsNullOrEmpty(keyword)) { articles = articles.Where(a => (int)a.Status == 2 && a.Img != null && a.Img != " ").Where(a => a.Content.Contains(keyword) || a.Title.Contains(keyword) || a.Description.Contains(keyword)); viewCategories = new ViewCategoryModel() { Categories = db.Categories.ToList(), Articles = articles.ToList(), SameArticles = db.Articles.Where(a => (int)a.Status == 2 && a.Img != null && a.Img != " ").OrderBy(a => a.CreatedAt).OrderByDescending(a => a.Count).Take(12).ToList(), LastestArticle = LastestArticle }; ViewBag.CategoryId = 0; } else { viewCategories = new ViewCategoryModel() { Categories = db.Categories.ToList(), SameArticles = db.Articles.Where(a => (int)a.Status == 2 && a.Img != null && a.Img != " ").OrderBy(a => a.CreatedAt).OrderByDescending(a => a.Count).Take(12).ToList(), LastestArticle = LastestArticle }; } return(View(viewCategories)); }
/// <summary> /// Delete Category /// </summary> /// <param name="objViewCategoryModel"></param> /// <returns></returns> public ViewCategoryModel DeleteCategory(ViewCategoryModel objViewCategoryModel) { try { SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewCategoryModel.ErrorCode); pErrorCode.Direction = ParameterDirection.Output; SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewCategoryModel.Message); pErrorMessage.Direction = ParameterDirection.Output; SqlParameter[] parmList = { new SqlParameter("@CategoryID", objViewCategoryModel.DeletedCategoryID) , new SqlParameter("@CreatedBy", objViewCategoryModel.DeletedBy) , pErrorCode , pErrorMessage }; //Call delete stored procedure to delete category SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteCategory, parmList); //set output parameter error code and error message objViewCategoryModel.ErrorCode = Convert.ToInt32(pErrorCode.Value); objViewCategoryModel.Message = Convert.ToString(pErrorMessage.Value); return(objViewCategoryModel); } catch (Exception ex) { throw ex; } }
public ActionResult ViewCategory() { ViewCategoryModel ObjViewCategoryModel = new ViewCategoryModel(); try { //initial set of current page, pageSize , Total pages ObjViewCategoryModel.CurrentPage = 1; ObjViewCategoryModel.PageSize = CommonUtils.PageSize; ObjViewCategoryModel.TotalPages = 0; //Get Category List serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Category + "/GetCategoryList", ObjViewCategoryModel); ObjViewCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewCategoryModel>().Result : null; //ObjViewCategoryModel = objBLCategory.GetCategoryList(ObjViewCategoryModel); //Set Success Message if comes from save page after click on save button if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"]))) { ObjViewCategoryModel.Message = Convert.ToString(TempData["SucessMessage"]); ObjViewCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); TempData["SucessMessage"] = null; } } catch (Exception ex) { ErrorLog(ex, "Category", "View GET"); } return(View("ViewCategory", ObjViewCategoryModel)); }
/// <summary> /// Get Category List with paging, sorting and searching parameter /// </summary> /// <param name="objViewCategoryModel">object of Model ViewCategoryModel </param> /// <returns></returns> public DataTable GetCategoryList(ViewCategoryModel objViewCategoryModel) { try { SqlParameter[] parmList = { new SqlParameter("CategoryName", objViewCategoryModel.FilterCategoryName) , new SqlParameter("CurrentPage", objViewCategoryModel.CurrentPage) , new SqlParameter("PageSize", objViewCategoryModel.PageSize) , new SqlParameter("SortBy", objViewCategoryModel.SortBy) , new SqlParameter("SortOrder", objViewCategoryModel.SortOrder) }; DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetCategoryList, parmList); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get Category List based on paging, searching and sorting parameter /// </summary> /// <param name="objViewCategoryModel">object of Model ViewCategoryModel</param> /// <returns></returns> public ViewCategoryModel GetCategoryList(ViewCategoryModel objViewCategoryModel) { List <CategoryModel> lstCategoryModel = new List <CategoryModel>(); //if FilterCategoryName is NULL than set to empty objViewCategoryModel.FilterCategoryName = objViewCategoryModel.FilterCategoryName ?? String.Empty; //if SortBy is NULL than set to empty objViewCategoryModel.SortBy = objViewCategoryModel.SortBy ?? String.Empty; //call GetCategoryList Method which will retrun datatable of Category DataTable dtCategory = objDLCategory.GetCategoryList(objViewCategoryModel); //fetch each row of datable foreach (DataRow dr in dtCategory.Rows) { //Convert datarow into Model object and set Model object property CategoryModel itemCategoryModel = GetDataRowToEntity <CategoryModel>(dr); //Add Category in List lstCategoryModel.Add(itemCategoryModel); } //set Category List of Model ViewCategoryModel objViewCategoryModel.CategoryList = lstCategoryModel; //if Category List count is not null and greater than 0 Than set Total Pages for Paging. if (objViewCategoryModel != null && objViewCategoryModel.CategoryList != null && objViewCategoryModel.CategoryList.Count > 0) { objViewCategoryModel.CurrentPage = objViewCategoryModel.CategoryList[0].CurrentPage; int totalRecord = objViewCategoryModel.CategoryList[0].TotalCount; if (decimal.Remainder(totalRecord, objViewCategoryModel.PageSize) > 0) { objViewCategoryModel.TotalPages = (totalRecord / objViewCategoryModel.PageSize + 1); } else { objViewCategoryModel.TotalPages = totalRecord / objViewCategoryModel.PageSize; } } else { objViewCategoryModel.TotalPages = 0; objViewCategoryModel.CurrentPage = 1; } return(objViewCategoryModel); }
public ActionResult CategoriesIndex(int?id) { ViewCategoryModel viewCategories; List <Article> articles = null; var LastestArticle = getLastestArticle(); if (id != null && id != 0) { var Categories = db.Categories.ToList(); for (int i = 0; i < Categories.Count; i++) { if (Categories[i].Id == id) { var tmp = Categories[i]; Categories[i] = Categories[0]; Categories[0] = tmp; } } articles = db.Articles.Where(a => a.CategoryID == id && (int)a.Status == 2 && a.Img != null && a.Img != " ").Take(25).ToList(); viewCategories = new ViewCategoryModel() { Categories = Categories, Articles = articles, SameArticles = db.Articles.Where(a => a.CategoryID == id && (int)a.Status == 2 && a.Img != null && a.Img != " ").OrderBy(a => a.CreatedAt).OrderByDescending(a => a.Count).Take(12).ToList(), LastestArticle = LastestArticle }; ViewBag.CategoryId = id; } else { articles = db.Articles.Where(a => (int)a.Status == 2 && a.Img != null && a.Img != " ").Take(25).ToList(); viewCategories = new ViewCategoryModel() { Categories = db.Categories.ToList(), Articles = articles, SameArticles = db.Articles.Where(a => (int)a.Status == 2 && a.Img != null && a.Img != " ").OrderBy(a => a.CreatedAt).OrderByDescending(a => a.Count).Take(12).ToList(), LastestArticle = LastestArticle }; ViewBag.CategoryId = 0; } ViewBag.MenuHeaderActive = "Categories"; return(View("~/Views/Client/Category.cshtml", viewCategories)); }
public HomeLayOutModel GetLayOutData() { HomeLayOutModel objHomeLayOutModel = new HomeLayOutModel(); BLCategory objBLCategory = new BLCategory(); BLDocument objBLDocument = new BLDocument(); BLSubCategory objBLSubCategory = new BLSubCategory(); ViewCategoryModel objViewCategoryModel = new ViewCategoryModel(); objViewCategoryModel.CurrentPage = 1; objViewCategoryModel.PageSize = int.MaxValue - 1; objHomeLayOutModel.objViewCategoryModel = new ViewCategoryModel(); objHomeLayOutModel.objViewCategoryModel = objBLCategory.GetCategoryList(objViewCategoryModel); if (objHomeLayOutModel != null && objHomeLayOutModel.objViewCategoryModel != null && objHomeLayOutModel.objViewCategoryModel.CategoryList != null && objHomeLayOutModel.objViewCategoryModel.CategoryList.Count > 0) { for (int i = 0; i < objHomeLayOutModel.objViewCategoryModel.CategoryList.Count; i++) { //string[] DocumentIds = objHomeLayOutModel.objViewCategoryModel.CategoryList[i].QuickLinks.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); //if (DocumentIds != null && DocumentIds.Length > 0) //{ // objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList = new List<DocumentModel>(); // for (int j = 0; j < DocumentIds.Length; j++) // { // objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList.Add(objBLDocument.GetDocumentById(Convert.ToInt32(DocumentIds[j]))); // } //} } } ViewSubCategoryModel objViewSubCategoryModel = new ViewSubCategoryModel(); objViewSubCategoryModel.CurrentPage = 1; objViewSubCategoryModel.PageSize = int.MaxValue - 1; objHomeLayOutModel.objSubViewCategoryModel = new ViewSubCategoryModel(); objHomeLayOutModel.objSubViewCategoryModel = objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel); return(objHomeLayOutModel); }
public ActionResult ViewCategory(ViewCategoryModel objViewCategoryModel) { try { int ErrorCode = 0; String ErrorMessage = ""; objViewCategoryModel.Message = objViewCategoryModel.MessageType = String.Empty; if (objViewCategoryModel.ActionType == "delete") { //delete serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Category + "/DeleteCategory", objViewCategoryModel); objViewCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewCategoryModel>().Result : null; if (Convert.ToInt32(ErrorCode).Equals(0)) { //if error code 0 means delete successfully than set Delete success message. objViewCategoryModel.Message = "Category Deleted Successfully"; objViewCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); } else { //if error code is not 0 means delete error than set Delete error message. objViewCategoryModel.Message = "Error while deleting record"; objViewCategoryModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();; } } //Get Category List based on searching , sorting and paging parameter. serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Category + "/GetCategoryList", objViewCategoryModel); objViewCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewCategoryModel>().Result : null; } catch (Exception ex) { ErrorLog(ex, "Category", "View POST"); } return(PartialView("_CategoryList", objViewCategoryModel)); }
/// <summary> /// Delete Category by Category ID /// </summary> /// <param name="objViewCategoryModel"></param> /// <param name="createdBy"></param> /// <param name="errorCode"></param> /// <param name="errorMessage"></param> public ViewCategoryModel DeleteCategory(ViewCategoryModel objViewCategoryModel) { return(objDLCategory.DeleteCategory(objViewCategoryModel)); }
public ViewCategoryModel GetCategoryList(ViewCategoryModel objViewCategoryModel) { return(objBLCategory.GetCategoryList(objViewCategoryModel)); }