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