public IActionResult CreatePDF(int id)
        {
            var filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "pdfs",
                                        "CareGiverTestList" + DateTime.Now.ToString("dd/MM/yyyy-hh-mm-ss") + ".pdf");

            var globalSettings = new GlobalSettings
            {
                ColorMode   = ColorMode.Color,
                Orientation = Orientation.Landscape,
                PaperSize   = PaperKind.A4Plus,
                Margins     = new MarginSettings {
                    Top = 10
                },
                DocumentTitle = "PDF Report",
                // Out = filePath
            };
            TestUtility _testUtility = new TestUtility(_appSettings, _dbContext);
            var         userTests    = _testUtility.GetEmployeeTests(id);
            TemplateGeneratorUtility _templateGeneratorUtility = new TemplateGeneratorUtility(_appSettings, _dbContext);

            var objectSettings = new ObjectSettings
            {
                PagesCount     = true,
                HtmlContent    = _templateGeneratorUtility.GetHTMLString(userTests),
                WebSettings    = { DefaultEncoding = "utf-8", UserStyleSheet = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "css", "pdfstyles.css") },
                HeaderSettings = { FontName = "Arial", FontSize = 9, Right = "Page [page] of [toPage]", Line = true },
                FooterSettings = { FontName = "Arial", FontSize = 9, Line = true, Center = "" }
            };

            var pdf = new HtmlToPdfDocument()
            {
                GlobalSettings = globalSettings,
                Objects        = { objectSettings }
            };
            var file = _converter.Convert(pdf);

            return(File(file, "application/pdf", "EmployeeReport.pdf"));
        }
        public IActionResult CareGiversTest(string id)
        {
            var globalSettings = new GlobalSettings
            {
                ColorMode   = ColorMode.Color,
                Orientation = Orientation.Landscape,
                PaperSize   = PaperKind.A4Plus,
                Margins     = new MarginSettings {
                    Top = 10
                },
                DocumentTitle = "CareGiver Test  Report",
                // Out = filePath
            };

            var userIdList = id.Split(",").ToList();

            userIdList = userIdList.Select(s => "/" + s + "/").ToList();
            var         userIds      = String.Join(',', userIdList);
            TestUtility _testUtility = new TestUtility(_appSettings, _dbContext);
            TemplateGeneratorUtility _templateGeneratorUtility = new TemplateGeneratorUtility(_appSettings, _dbContext);

            DbfunctionUtility dbfunction     = new DbfunctionUtility(_appSettings);
            DataSet           ds             = dbfunction.GetDataset(@"call get_careGiverTest('" + userIds + "')");
            CommanUtility     _commanUtility = new CommanUtility(_appSettings);
            var list = (from row in ds.Tables[0].AsEnumerable()
                        select new PrintPDFViewModel
            {
                FirstName = Convert.ToString(row["FirstName"]),
                MiddleName = Convert.ToString(row["MiddleName"]),
                LastName = Convert.ToString(row["LastName"]),
                UserId = Convert.ToInt32(row["UserId"]),
                Question = Convert.ToString(row["Question"]),
                Choice1 = Convert.ToString(row["Choice1"]),
                Choice2 = Convert.ToString(row["Choice2"]),
                Choice3 = Convert.ToString(row["Choice3"]),
                Choice4 = Convert.ToString(row["Choice4"]),
                Choice5 = Convert.ToString(row["Choice5"]),
                Answer = Convert.ToInt32(row["Answer"]),
                TestId = Convert.ToInt32(row["testId"]),
                TestName = Convert.ToString(row["Name"]),
                UserAnswer = Convert.ToInt16(row["UserSelected"]),
                EndDate = Convert.ToDateTime(row["EndDate"]),
                Pass = Convert.ToInt32(row["status"]),
            }).ToList();


            var objectSettings = new ObjectSettings
            {
                PagesCount     = true,
                HtmlContent    = _templateGeneratorUtility.GetHTMLStringForAll(list),
                WebSettings    = { DefaultEncoding = "utf-8", UserStyleSheet = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "css", "pdfstyles.css") },
                HeaderSettings = { FontName = "Arial", FontSize = 9, Center = "StandardPrecautions HIPPA Emergency Preparedness Home Safety", Left = "Print Date: " + DateTime.Now.ToString("MM/dd/yyyy") + "", Right = "Page [page] of [toPage]", Line = false },
                FooterSettings = { FontName = "Arial", FontSize = 9, Line = false, Center = "" },
            };

            var pdf = new HtmlToPdfDocument()
            {
                GlobalSettings = globalSettings,
                Objects        = { objectSettings }
            };
            var file = _converter.Convert(pdf);

            return(File(file, "application/pdf", "CareGiverTestReport.pdf"));
        }