public DataSet SearchGroup(SearchGroupProductRequest model, ref int pTotal)
{
try
{
var spParameter = new SqlParameter[5];
#region Set param
var parameter = new SqlParameter("@P_ORDER_BY", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = model.OrderBy
};
spParameter[0] = parameter;
parameter = new SqlParameter("@P_ORDER_TYPE", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = model.OrderByType
};
spParameter[1] = parameter;
parameter = new SqlParameter("@P_START", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = model.Start
};
spParameter[2] = parameter;
parameter = new SqlParameter("@P_END", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = model.End
};
spParameter[3] = parameter;
parameter = new SqlParameter("@P_TOTAL", SqlDbType.Int)
{
Direction = ParameterDirection.Output,
Value = -1
};
spParameter[4] = parameter;
#endregion
var ds = SqlHelper.ExecuteDataset(ConfigInfo.ConnectString, CommandType.StoredProcedure,
"PROC_GROUP_PRO_SEARCH", spParameter);
pTotal = Convert.ToInt32(spParameter[4].Value);
return(ds);
}
catch (Exception ex)
{
Logger.Log.Error(ex.ToString());
return(new DataSet());
}
}
public ActionResult GroupList()
{
if (DataMemory.CurrentUser == null)
{
return(RedirectToAction("Logout", "Admin"));
}
var request = new SearchGroupProductRequest
{
CurrentPage = 1,
Start = 1,
End = ConfigInfo.RecordOnPage,
OrderBy = "GroupName",
OrderByType = "Asc"
};
return(View(SearchGroupProduct(request)));
}
private ListGroupProducts SearchGroupProduct(SearchGroupProductRequest request)
{
var total = 0;
var ds = _productDa.SearchGroup(request, ref total);
var lstGroupProduct = CBO.Fill2ListFromDataSet <GroupProducts>(ds, typeof(GroupProducts));
decimal totalPage = Math.Ceiling(((decimal)total / ConfigInfo.RecordOnPage));
var paging = HtmlControllHelpers.WritePaging(totalPage, request.CurrentPage, total, ConfigInfo.RecordOnPage,
"nhóm sản phẩm");
var listGroupProducts = new ListGroupProducts
{
Start = request.Start,
Collection = lstGroupProduct,
Paging = paging,
TotalRecord = total,
TotalPage = totalPage,
CurrentPage = request.CurrentPage
};
return(listGroupProducts);
}
public ActionResult SearchGroup(SearchGroupProductRequest request)
{
return(PartialView("~/Areas/Admin/Views/Product/_listGroupProduct.cshtml", SearchGroupProduct(request)));
}
