public async Task <IActionResult> PutTeachersDisciplines(int id, TeachersDisciplines teachersDisciplines)
{
if (id != teachersDisciplines.DisciplineId)
{
return(BadRequest());
}
_context.Entry(teachersDisciplines).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeachersDisciplinesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static async Task AddTeachers(IFormFileCollection excelFiles, string rootPath, UniAPI _api)
{
SaveOnServer(excelFiles, rootPath);
foreach (var file in excelFiles)
{
var package = new ExcelPackage(new FileInfo($"{ rootPath }\\{ file.FileName }"));
var sheets = package.Workbook.Worksheets;
foreach (var sheet in sheets)
{
for (int i = 1; i < sheet.Dimension.Rows + 1; i++)
{
var fullName = sheet.Cells[i, 1].Value.ToString().Split(" ");
var lastName = fullName[0];
var firstName = fullName[1];
var middleName = fullName[2];
var password = sheet.Cells[i, 2].Value.ToString();
var disciplinesString = sheet.Cells[i, 3].Value.ToString().Split(",");
var disciplines = new List <Discipline>();
// Add disciplines to db if they don't exist
// If exist, add to disciplines list
foreach (var discipline in disciplinesString)
{
var dip = await _api.Post <Discipline, Discipline>($"Disciplines/Get", new Discipline(discipline));
if (!(dip.Result is EmptyResult))
{
disciplines.Add(dip.Value);
}
else
{
var addingResponse = await _api.Post <Discipline, Discipline>("Disciplines/Add", new Discipline(discipline));
if (addingResponse.Value != null && addingResponse.Value.Id != 0)
{
disciplines.Add(addingResponse.Value);
}
}
}
// Find teacher. If not found, add
var teacher = new TeacherCred(firstName, lastName, middleName, password, new List <TeachersDisciplines>(), new List <Grade>());
var teacherResponse = await _api.Post <Teacher, Teacher>("Teachers/Get", teacher);
TeacherCred teacherdb = null;
if (teacherResponse.Result is EmptyResult)
{
var teacherAdding = await _api.Post <Teacher, Teacher>("Teachers/Add", teacher);
if (!(teacherAdding.Result is EmptyResult))
{
var teacherAdded = teacherAdding.Value;
teacherdb = new TeacherCred
{
Id = teacherAdded.Id,
FirstName = teacherAdded.FirstName,
LastName = teacherAdded.LastName,
MiddleName = teacherAdded.MiddleName,
Role = teacherAdded.Role
};
}
else
{
continue;
}
}
else
{
var teacherFind = teacherResponse.Value;
teacherdb = new TeacherCred
{
FirstName = teacherFind.FirstName,
LastName = teacherFind.LastName,
MiddleName = teacherFind.MiddleName,
Id = teacherFind.Id
};
}
var teacherDiscip = new List <TeachersDisciplines>();
foreach (var discipline in disciplines)
{
try
{
var td = new TeachersDisciplines(teacherdb, discipline);
await _api.Post <TeachersDisciplines, TeachersDisciplines>("TeachersDisciplines", td);
}
catch (Exception)
{
}
}
}
}
File.Delete(rootPath + file.FileName);
}
}
public async Task <ActionResult <TeachersDisciplines> > PostTeachersDisciplines(TeachersDisciplines teachersDisciplines)
{
var teacher = _context.Teachers.Single(t => t.Id == teachersDisciplines.Teacher.Id);
var discipline = _context.Disciplines.Single(d => d.Id == teachersDisciplines.Discipline.Id);
_context.TeachersDisciplines.Add(teachersDisciplines);
_context.Entry(teacher).State = EntityState.Modified;
_context.Entry(discipline).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (TeachersDisciplinesExists(teachersDisciplines.DisciplineId))
{
return(Conflict());
}
else
{
throw;
}
}
return(teachersDisciplines);
}
