public async Task <RsProductTransactions> SearchProductTransactions(RqProductTransactionsSearch request)
        {
            var userlogin = UserLogin;

            request.UserLogin = userlogin;
            var response = await businessProvider.SearchProductTransactions(request);

            response.UserLogin    = userlogin;
            response.WebAPIName   = "Search product transactions";
            response.Url          = "api/search/product/transactions";
            response.pageIndex    = request.pageIndex;
            response.pageSize     = request.pageSize;
            response.isDescending = request.isDescending;
            return(response);
        }
        public HttpResponseMessage ExportToExcelProductTransactions()
        {
            var request = new RqProductTransactionsSearch();

            if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["productid"]))
            {
                request.productID = Convert.ToInt64(HttpContext.Current.Request.QueryString["productid"]);
            }
            if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["subproductid"]))
            {
                request.subProductID = Convert.ToInt64(HttpContext.Current.Request.QueryString["subproductid"]);
            }
            if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["startdate"]))
            {
                request.startDate = HttpContext.Current.Request.QueryString["startdate"];
            }
            if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["enddate"]))
            {
                request.endDate = HttpContext.Current.Request.QueryString["enddate"];
            }
            var response = businessProvider.ExportToExcel(request);

            return(response);
        }