public static List <KnowledgeRecord> GetKnowledge()
        {
            var knowledgeRecords = new List <KnowledgeRecord>(); KnowledgeRecord knowledgeRec;
            var dbPath = Directory.GetCurrentDirectory() + @"\wwwroot\Data\websiteDB.xlsx";

            if (File.Exists(dbPath))
            {
                ExcelPackage.LicenseContext = LicenseContext.Commercial;
                FileInfo fi = new FileInfo(dbPath);

                using (ExcelPackage excelPack = new ExcelPackage(fi))
                {
                    var knowledgeWs = excelPack.Workbook.Worksheets["Knowledge"];
                    var lastRow     = GetLastRow(knowledgeWs);
                    for (int i = 2; i <= lastRow; i++)
                    {
                        knowledgeRec                    = new KnowledgeRecord();
                        knowledgeRec.KnowledgeId        = Convert.ToInt32(knowledgeWs.Cells[i, 1].Text);
                        knowledgeRec.Person_Institution = knowledgeWs.Cells[i, 2].Text;
                        knowledgeRec.Description        = knowledgeWs.Cells[i, 3].Text;
                        knowledgeRec.Source             = knowledgeWs.Cells[i, 4].Text;
                        knowledgeRec.Keywords           = knowledgeWs.Cells[i, 5].Text;
                        knowledgeRecords.Add(knowledgeRec);
                    }
                }
            }
            return(knowledgeRecords);
        }
 public static void KnowledgeDelete(KnowledgeRecord newKnowledgeRecord)
 {
     throw new NotImplementedException();
     //return newKnowledgeRecord;
 }
 public static KnowledgeRecord KnowledgeAdd(KnowledgeRecord newKnowledgeRecord)
 {
     throw new NotImplementedException();
     //return newKnowledgeRecord;
 }