public async Task <ActionResult> Index(int?page, string keyword)
{
var vm = new CategoryListVM()
{
Keyword = keyword,
PageIndex = page ?? 1,
PageSize = SettingsManager.Category.PageSize
};
var query = _db.ProductCategories.Include(d => d.ProductCategories).Where(d => d.ParentId == null).AsQueryable();
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(d => d.Title.Contains(keyword));
}
var list = await query.OrderByDescending(d => d.Importance).ThenByDescending(d => d.CreatedDate)
.Skip((vm.PageIndex - 1) * vm.PageSize).Take(vm.PageSize).ToListAsync();
vm.TotalCount = await query.CountAsync();
vm.Categories = new StaticPagedList <ProductCategory>(list, vm.PageIndex, vm.PageSize, vm.TotalCount);;
ViewBag.PageSizes = new SelectList(Site.PageSizes());
return(View(vm));
}
public ActionResult Index()
{
CategoryListVM model = new CategoryListVM();
model.Categories = CategoryRepository.GetAll();
return(View(model));
}
public ViewViewComponentResult Invoke()
{
var model = new CategoryListVM
{
Categories = _categoryService.GetAll()
};
return(View(model));
}
public ActionResult <ResponseVM> Create
([FromBody] CategoryListVM categorylistVM)
{
if (!ModelState.IsValid)
{
return(BadRequest("something went wrong"));
}
return(categorylistService.Create(categorylistVM));
}
public ViewViewComponentResult Invoke()
{
var model = new CategoryListVM
{
Categories = _categoryService.GetAll(),
CurrentCategory = Convert.ToInt16(HttpContext.Request.Query["category"])
};
return(View(model));
}
public string Search(CategoryListVM vm)
{
if (ModelState.IsValid)
{
return(vm.GetJson(false));
}
else
{
return(vm.GetError());
}
}
public List<CategoryListVM> GetAllCategoryList()
{
string connection = Constants.Connection;
using (SqlConnection sqlConn = new SqlConnection(connection))
{
sqlConn.Open();
List<CategoryListVM> dt = new List<CategoryListVM>();
using (SqlCommand sqlComm = new SqlCommand("USP_LIST_CATEGORY", sqlConn))
{
sqlComm.CommandType = System.Data.CommandType.StoredProcedure;
sqlComm.Parameters.AddWithValue("@CAT_TYPE_ID",1);
using (SqlDataReader sdr = sqlComm.ExecuteReader())
{
while (sdr.Read())
{
try
{
CategoryListVM dtc = new CategoryListVM();
dtc.CAT_ID = (Int32)sdr["CAT_ID"];
dtc.CAT_DESC = sdr["CAT_DESC"].ToString();
dtc.CAT_IMG = sdr["CAT_IMG"].ToString();
dt.Add(dtc);
}
catch (Exception ex)
{
throw;
}
}
sdr.Close();
}
}
return dt;
}
}
public async Task <IActionResult> Index(int productPage = 1, string searchByCategory = null)
{
var(categories, categoriesCount) = await _categoryService.GetFiltered(searchByCategory, PageSize, productPage);
var categoryListVM = new CategoryListVM()
{
Categories = categories
};
const string Url = "/Admin/Category/Index?productPage=:";
categoryListVM.PagingInfo = new PagingInfo
{
CurrentPage = productPage,
ItemsPerPage = PageSize,
TotalItem = categoriesCount,
UrlParam = Url
};
return(View(categoryListVM));
}
public HttpResponseMessage DefaultPageLoad(HttpRequestMessage request)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No items found");
var model = new CategoryListVM();
model.AvailableStores.Add(new System.Web.Mvc.SelectListItem {
Text = _localizationService.GetResource("Admin.Common.All"), Value = "0"
});
foreach (var s in _storeService.GetAllStores())
{
model.AvailableStores.Add(new System.Web.Mvc.SelectListItem {
Text = s.Name, Value = s.Id.ToString()
});
}
response = request.CreateResponse <CategoryListVM>(HttpStatusCode.OK, model);
return response;
}));
}
public IActionResult ExportExcel(CategoryListVM vm)
{
return(vm.GetExportData());
}
