private List <University_MajorsDAO> LoadFromExcel(string path)
{
List <University_MajorsDAO> excelTemplates = new List <University_MajorsDAO>();
using (var package = new ExcelPackage(new FileInfo(path)))
{
var worksheet = package.Workbook.Worksheets[4];
for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
{
string universityCode = worksheet.Cells[i, 1].Value?.ToString();
string majorsCode = worksheet.Cells[i, 2].Value?.ToString();
string year = worksheet.Cells[i, 3].Value?.ToString();
University_MajorsDAO excelTemplate = new University_MajorsDAO()
{
Id = CreateGuid(universityCode + majorsCode + year),
UniversityId = CreateGuid("University" + universityCode),
MajorsId = CreateGuid("Majors" + majorsCode),
Year = year
};
excelTemplates.Add(excelTemplate);
}
}
return(excelTemplates);
}
public async Task <bool> Create(University_Majors university_Majors)
{
University_MajorsDAO university_MajorsDAO = new University_MajorsDAO
{
Id = university_Majors.Id,
MajorsId = university_Majors.MajorsId,
UniversityId = university_Majors.UniversityId,
Year = university_Majors.Year
};
tFContext.University_Majors.Add(university_MajorsDAO);
await tFContext.SaveChangesAsync();
return(true);
}
