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;
}