private static UserDashProduct MapUserDashProduct(IDataReader reader, out int startingIndex)
{
UserDashProduct aUserDashProduct = new UserDashProduct();
startingIndex = 0;
aUserDashProduct.Id = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.SKU = reader.GetSafeString(startingIndex++);
aUserDashProduct.Name = reader.GetSafeString(startingIndex++);
aUserDashProduct.IsVisible = reader.GetSafeBool(startingIndex++);
aUserDashProduct.IsActive = reader.GetSafeBool(startingIndex++);
aUserDashProduct.PrimaryImageId = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.Manufacturer = reader.GetSafeString(startingIndex++);
aUserDashProduct.Year = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.Description = reader.GetSafeString(startingIndex++);
aUserDashProduct.Specifications = reader.GetSafeString(startingIndex++);
aUserDashProduct.DateCreated = reader.GetSafeDateTime(startingIndex++);
aUserDashProduct.DateModified = reader.GetSafeDateTime(startingIndex++);
aUserDashProduct.CreatedBy = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.ProductStatus = reader.GetSafeString(startingIndex++);
aUserDashProduct.ProductTypeId = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.VendorId = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.BusinessId = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.VendorTypeId = reader.GetSafeInt32(startingIndex++);
aUserDashProduct.VendorName = reader.GetSafeString(startingIndex++);
aUserDashProduct.Url = reader.GetSafeString(startingIndex++);
aUserDashProduct.ProductImages = reader.GetSafeString(startingIndex++);
return(aUserDashProduct);
}
public List <UserDashProduct> GetTopProducts()
{
List <UserDashProduct> list = null;
string procName = "dbo.Products_SelectTopFiveByRandom";
_data.ExecuteCmd(procName, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
UserDashProduct aUserDashProduct = MapUserDashProduct(reader, out int index);
if (list == null)
{
list = new List <UserDashProduct>();
}
list.Add(aUserDashProduct);
}
);
return(list);
}
