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