public async Task <bool> Create(University university)
{
UniversityDAO universityDAO = new UniversityDAO
{
Id = university.Id,
Code = university.Code,
Name = university.Name,
Address = university.Address,
Website = university.Website
};
context.University.Add(universityDAO);
await context.SaveChangesAsync();
return(true);
}
private List <UniversityDAO> LoadFromExcel(string path)
{
List <UniversityDAO> excelTemplates = new List <UniversityDAO>();
using (var package = new ExcelPackage(new FileInfo(path)))
{
var worksheet = package.Workbook.Worksheets[2];
for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
{
UniversityDAO excelTemplate = new UniversityDAO()
{
Id = CreateGuid("University" + worksheet.Cells[i, 1].Value?.ToString()),
Code = worksheet.Cells[i, 1].Value?.ToString(),
Name = worksheet.Cells[i, 2].Value?.ToString(),
Website = worksheet.Cells[i, 3].Value?.ToString()
};
excelTemplates.Add(excelTemplate);
}
}
return(excelTemplates);
}
public UniversityBLO(string dbFolder)
{
this.dbFolder = dbFolder;
universityRepo = new UniversityDAO(dbFolder);
}
