public async Task <SeedParameterJawabanResponse> Handle(SeedParameterJawabanRequest request, CancellationToken cancellationToken)
        {
            var result = new SeedParameterJawabanResponse();

            var listOfData = new List <ParameterJawabanExcel>();

            // read excel files then add to List
            var bin = System.IO.File.ReadAllBytes(FilePath.ParameterJawabanExcel);

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            using (MemoryStream stream = new MemoryStream(bin))
                using (ExcelPackage excelPackage = new ExcelPackage(stream))
                {
                    //loop all worksheets
                    foreach (ExcelWorksheet worksheet in excelPackage.Workbook.Worksheets)
                    {
                        //loop all rows
                        for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
                        {
                            string id_indikator, jawaban, skor = "";

                            id_indikator = worksheet.Cells[i, 1].Value.ToString();
                            jawaban      = worksheet.Cells[i, 2].Value.ToString();
                            skor         = worksheet.Cells[i, 3].Value.ToString();

                            listOfData.Add(new ParameterJawabanExcel()
                            {
                                id_indikator = id_indikator,
                                jawaban      = jawaban,
                                skor         = skor
                            });
                        }
                    }
                }

            // collect provinsi's data from db to temporary List
            var parentData = await _context.ParameterIndikators
                             .ToListAsync(cancellationToken);

            foreach (var data in listOfData)
            {
                ParameterJawaban ParameterJawaban = new ParameterJawaban();

                string parentID = parentData.Where(x => x.id_indikator == data.id_indikator).FirstOrDefault().ParameterIndikatorID ?? "";

                ParameterJawaban = new ParameterJawaban
                {
                    ParameterIndikatorID = parentID,
                    Name = data.jawaban,
                    Skor = data.skor
                };

                _context.ParameterJawabans.Add(ParameterJawaban);
            }

            await _context.SaveChangesAsync(cancellationToken);

            return(result);
        }
        private ParameterJawaban getJawaban(string indikatorName)
        {
            ParameterJawaban jawaban = null;

            if (!string.IsNullOrEmpty(indikatorName))
            {
                jawaban = _context.ParameterJawabans
                          .AsNoTracking()
                          .Where(x => x.Name == indikatorName.ToLower())
                          .FirstOrDefault();
            }

            return(jawaban);
        }