public async Task <HistoryShopCart> GetLstHistoryShoppingCart([FromQuery] HistoryShoppingCart model)
{
var output = new HistoryShopCart();
output.Data = await _repoWrapper.ShoppingCart.GetHistoryShopingCart(model);
CountHistoryShoppingCart countModel = new CountHistoryShoppingCart();
countModel.UserId = model.UserId;
countModel.ProductBrandId = model.ProductBrandId;
countModel.ShopingCartCode = model.ShopingCartCode;
countModel.FromDate = model.FromDate;
countModel.ToDate = model.ToDate;
output.HistoryCount = await _repoWrapper.ShoppingCart.GetCountHistoryShopingCart(countModel);
return(output);
}
public async Task <CountHistoryShopingCart_Result> GetCountHistoryShopingCart(CountHistoryShoppingCart model)
{
var pUserId = new SqlParameter("@UserId", model.UserId ?? (object)DBNull.Value);
var pProductBrandId = new SqlParameter("@ProductBrandId", model.ProductBrandId ?? (object)DBNull.Value);
var pFromDate = new SqlParameter("@FromDate", model.FromDate ?? (object)DBNull.Value);
var pToDate = new SqlParameter("@ToDate", model.ToDate ?? (object)DBNull.Value);
var pShopingCartCode = new SqlParameter("@ShopingCartCode", model.ShopingCartCode ?? (object)DBNull.Value);
try
{
var output = await HanomaContext.Set <CountHistoryShopingCart_Result>()
.FromSqlRaw($"EXECUTE dbo.CountHistoryShopingCart " +
$"@UserId = @UserId, " +
$"@ProductBrandId = @ProductBrandId, " +
$"@ShopingCartCode = @ShopingCartCode, " +
$"@FromDate = @FromDate, " +
$"@ToDate = @ToDate ",
pUserId, pProductBrandId, pShopingCartCode, pFromDate, pToDate
)
.AsNoTracking()
.ToListAsync();
return(output.FirstOrDefault());
}
catch (Exception ex)
{
}
return(new CountHistoryShopingCart_Result());
}
