public ActionResult SearchProducts(string type, int index) { var key = 0; var groupName = ""; switch (type) { case "son-noi-that": key = 6; groupName = "Sơn trang trí nội thất"; break; case "son-ngoai-that": key = 7; groupName = "Sơn trang trí ngoại thất"; break; case "san-pham-khac": key = 8; groupName = "Hệ sản phẩm khác"; break; default: key = 0; break; } var request = new SearchProductPortalRequest() { CurrentPage = index, Start = (index - 1) * ConfigInfo.RecordOnPageIndex + 1, End = index * ConfigInfo.RecordOnPageIndex, GroupId = key, OrderBy = "Id", OrderByType = "Desc", GroupName = groupName }; var list = GetProductPortal(request); list.Router = type; return(View("Products", list)); }
public ActionResult OthersPaint() { var key = 8; var request = new SearchProductPortalRequest() { CurrentPage = 1, Start = 1, End = ConfigInfo.RecordOnPageIndex, GroupId = key, OrderBy = "Id", OrderByType = "Desc", GroupName = "Hệ sản phẩm khác" }; var list = GetProductPortal(request); list.Router = "san-pham-khac"; return(View("Products", list)); }
public ActionResult ProtectivePaint() { var key = 7; var request = new SearchProductPortalRequest() { CurrentPage = 1, Start = 1, End = ConfigInfo.RecordOnPageIndex, GroupId = key, OrderBy = "Id", OrderByType = "Desc", GroupName = "Sơn trang trí ngoại thất" }; var list = GetProductPortal(request); list.Router = "son-ngoai-that"; return(View("Products", list)); }
private ListProductsPortal GetProductPortal(SearchProductPortalRequest productPortalRequest) { var total = 0; var ds = _productDa.GetProductPortal(productPortalRequest, ref total); var list = CBO.Fill2ListFromDataSet <Products>(ds, typeof(Products)); var totalPage = Math.Ceiling((decimal)total / ConfigInfo.RecordOnPageIndex); var paging = HtmlControllHelpers.WritePagingPortal(totalPage, productPortalRequest.CurrentPage, total, ConfigInfo.RecordOnPageIndex); var listNews = new ListProductsPortal { Start = productPortalRequest.Start, Collection = list, Paging = paging, TotalRecord = total, TotalPage = totalPage, CurrentPage = productPortalRequest.CurrentPage, PageName = productPortalRequest.GroupName }; return(listNews); }
private ListProductsPortal GetProductPortal(SearchProductPortalRequest productPortalRequest) { var total = 0; var ds = _productDa.GetProductPortal(productPortalRequest, ref total); List <Products> list = CBO <Products> .FillCollectionFromDataSet(ds); list = list.OrderByDescending(m => m.Price).ThenByDescending(m => m.Id).ToList(); var totalPage = Math.Ceiling((decimal)total / ConfigInfo.RecordOnPageIndex); var paging = HtmlControllHelpers.WritePagingPortal(totalPage, productPortalRequest.CurrentPage, total, ConfigInfo.RecordOnPageIndex); var listNews = new ListProductsPortal { Start = productPortalRequest.Start, Collection = list, Paging = paging, TotalRecord = total, TotalPage = totalPage, CurrentPage = productPortalRequest.CurrentPage, PageName = productPortalRequest.GroupName }; return(listNews); }
public DataSet GetProductPortal(SearchProductPortalRequest model, ref int pTotal) { try { var spParameter = new SqlParameter[6]; #region Set param var parameter = new SqlParameter("@P_GROUP_ID", SqlDbType.Int) { Direction = ParameterDirection.Input, Value = model.GroupId }; spParameter[0] = parameter; parameter = new SqlParameter("@P_ORDER_BY", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderBy }; spParameter[1] = parameter; parameter = new SqlParameter("@P_ORDER_TYPE", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderByType }; spParameter[2] = parameter; parameter = new SqlParameter("@P_START", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.Start }; spParameter[3] = parameter; parameter = new SqlParameter("@P_END", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.End }; spParameter[4] = parameter; parameter = new SqlParameter("@P_TOTAL", SqlDbType.Int) { Direction = ParameterDirection.Output, Value = -1 }; spParameter[5] = parameter; #endregion var ds = SqlHelper.ExecuteDataset(ConfigInfo.ConnectString, CommandType.StoredProcedure, "GET_PRODUCT_PORTAL", spParameter); pTotal = Convert.ToInt32(spParameter[5].Value); return(ds); } catch (Exception ex) { Logger.Log.Error(ex.ToString()); return(new DataSet()); } }