public ActionResult Index(string alias)
{
int categoryId = 0;
if (!string.IsNullOrEmpty(alias))//Trả về true khi alias rỗng
{
DBM.GetOne("sp_Category_FillByAlias", new { Alias = alias }, out CategoryModel categoryModel);
if (categoryModel != null)
{
categoryId = categoryModel.CategoryId;
}
}
DBM.ExecStore("sp_Ask_Count", new { CategoryId = categoryId }, out int totalRow);
//Đếm xem có bao nhiêu trang
int totalPage = (int)Math.Ceiling((double)totalRow / pageSize);
DBM.GetList("sp_Ask_GetPaging", new { CategoryId = categoryId, Page = 1, PageSize = pageSize }, out List <AskModel> askViewModels);
PaginationObject <List <AskModel> > pagination = new PaginationObject <List <AskModel> >
{
Page = 1,
TotalPages = totalPage,
TotalRow = totalRow,
PageSize = pageSize,
ObjectFilter = askViewModels
};
return(View("Index", pagination));
}
public ActionResult Get(PaginationObject pagination, string name)
{
var response = Business.Ocorrencia.Instance.GetAllOcorrencias(ref pagination, name);
var rlResponse = new ResponseObject
{
Messages = response.Messages,
Status = response.Status,
Pagination = response.Pagination,
Objects = Mapper.Map<List<OcorrenciaViewModel>>(response.Objects).Select(a=>(object)a).ToList()
};
return Json(rlResponse);
}
/// <summary>
/// Trả ra đoạn HTML phân trang
/// Thuộc trang Index
/// </summary>
public ActionResult GetPagination(int pageSize, string userName)
{
DBM.ExecStore("sp_User_Count", new { UserName = userName }, out int totalRow);
//Đếm xem có bao nhiêu trang
int totalPage = (int)Math.Ceiling((double)totalRow / pageSize);
PaginationObject <UserModel> pagination = new PaginationObject <UserModel>
{
TotalPages = totalPage,
TotalRow = totalRow,
PageSize = pageSize
};
return(View(pagination));
}
public ActionResult Get(PaginationObject pagination, string name)
{
var response = Business.Log.Instance.GetAllLogs(ref pagination, name);
var rlResponse = new ResponseObject
{
Messages = response.Messages,
Status = response.Status,
Pagination = response.Pagination,
Objects = response.Objects
};
return Json(rlResponse);
}
/// <summary>
/// Trả ra đoạn HTML phân trang
/// Thuộc trang Index
/// </summary>
public ActionResult GetPagination(int pageSize, int categoryId)
{
DBM.ExecStore("sp_Ask_Count", new { CategoryId = categoryId }, out int totalRow);
//Đếm xem có bao nhiêu trang
int totalPage = (int)Math.Ceiling((double)totalRow / pageSize);
PaginationObject <AskModel> pagination = new PaginationObject <AskModel>
{
TotalPages = totalPage,
TotalRow = totalRow,
PageSize = pageSize
};
return(View(pagination));
}
public ActionResult Index(int page)
{
DBM.ExecStore("sp_Ask_Count", new { CategoryId = 0 }, out int totalRow);
//Đếm xem có bao nhiêu trang
int totalPage = (int)Math.Ceiling((double)totalRow / pageSize);
DBM.GetList("sp_Ask_GetPaging", new { CategoryId = 0, Page = page, PageSize = pageSize }, out List <AskModel> askViewModels);
PaginationObject <List <AskModel> > pagination = new PaginationObject <List <AskModel> >
{
Page = page,
TotalPages = totalPage,
TotalRow = totalRow,
PageSize = pageSize,
ObjectFilter = askViewModels
};
return(View("Index", pagination));
}
public ActionResult SearchContent(string searchContent)
{
DBM.ExecStore("sp_Ask_CountSearchContent", new { SearchContent = searchContent.Trim() }, out int totalRow);
//Đếm xem có bao nhiêu trang
int totalPage = (int)Math.Ceiling((double)totalRow / pageSize);
DBM.GetList("sp_Ask_GetPagingSearchContent", new { SearchContent = searchContent.Trim(), Page = 1, PageSize = pageSize }, out List <AskModel> askViewModels);
PaginationObject <List <AskModel> > pagination = new PaginationObject <List <AskModel> >
{
Page = 1,
TotalPages = totalPage,
TotalRow = totalRow,
PageSize = pageSize,
ObjectFilter = askViewModels
};
return(View("Index", pagination));
}
public ActionResult GetUsers(PaginationObject pagination, string name)
{
return Json(BO.User.Instance.GetAllActiveUsers(ref pagination, name));
}
public ActionResult Pager(PaginationObject <List <AskModel> > paginationObject)
{
return(PartialView(paginationObject));
}
public ActionResult Get(PaginationObject pagination, string name)
{
return Json(EmailConfiguration.Instance.GetAllEmailConfiguration(ref pagination, name));
}
public ActionResult Get(PaginationObject pagination, string name)
{
return Json(BO.Document.Instance.GetAllDocuments(ref pagination, name));
}
