Exemple #1
0
        public async Task <IActionResult> HurdaMaliyetRaporuGetir(HurdaMaliyetSearchRequest request)
        {
            //string serialNo = HttpContext.Request.Query["serialNo"].ToString();
            //string userId = _httpContextAccessor.HttpContext.Request.Cookies["UserId"];
            HurdaMaliyetRaporuResponse response = _scrapService.HurdaMaliyetRaporuGetir(request);

            return(Ok(response));
        }
        public HurdaMaliyetRaporuResponse HurdaMaliyetRaporuGetir(HurdaMaliyetSearchRequest request)
        {
            HurdaMaliyetRaporuResponse resp = new HurdaMaliyetRaporuResponse();

            List <sp_Mes_V2_HurdaMaliyetRaporuGetir> hurdaMaliyet = _dbContext.sp_Mes_V2_HurdaMaliyetRaporuGetir.FromSqlInterpolated($"EXECUTE dbo.sp_Mes_V2_HurdaMaliyetRaporuGetir {request.BaslangicTarihi},{request.BitisTarihi} ,{request.SelectedMakineListesi}, {request.SelectedMudurlukListesi}").ToList();

            //{request.BaslangicTarihi},{request.BitisTarihi} ,

            if (hurdaMaliyet != null)
            {
                resp.HurdaMaliyetRaporList = hurdaMaliyet;
                resp.isSuccess             = true;
            }
            else
            {
                resp.isSuccess    = false;
                resp.ErrorMessage = "Bir Hata Oluştu! Lütfen Daha Sonra Tekrar Deneyiniz.";
            }
            return(resp);
        }