public async Task <IActionResult> Edit(int id, [Bind("Id,LinkId,Details")] PUD pUD)
{
if (id != pUD.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(pUD);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PUDExists(pUD.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(pUD));
}
public async Task <IActionResult> Create([Bind("Id,LinkId,Details")] PUD pUD)
{
if (ModelState.IsValid)
{
_context.Add(pUD);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(pUD));
}
public async Task <bool> UploadPUDToDatabase(IFormFile file)
{
_context.Database.SetCommandTimeout(100000);
List <PUDInfoViewModel> pudModels = this.ReadPUD(file);
bool success = true;
var all_puds = await _context.PUDs.Include(i => i.EduProgram).Include(i => i.Department).ToListAsync();
var all_eduprog = await _context.EduPrograms.Include(i => i.Faculty).ToListAsync();
var all_depart = await _context.Departments.ToListAsync();
var all_faculty = await _context.Faculties.Include(i => i.Campus).ToListAsync();
var all_campus = await _context.Campuses.ToListAsync();
foreach (PUDInfoViewModel model in pudModels)
{
PUD pud = new PUD()
{
LinkId = model.LinkID,
EducationStage = model.EducationStage,
CourseName = model.Name,
Language = model.Language,
Details = model.Details
};
var campus = all_campus.Find(item => item.Name == model.Campus);
if (campus == null)
{
campus = new Campus {
Name = model.Campus
};
_context.Add(campus);
}
var falulty = all_faculty.Find(item => item.Name == model.Faculty);
if (falulty == null)
{
falulty = new Faculty {
Name = model.Faculty, Campus = campus
};
_context.Add(falulty);
}
var edu_prog = all_eduprog.Find(item => item.Name == model.OP);
if (edu_prog == null)
{
edu_prog = new EduProgram {
Name = model.OP, Faculty = falulty
};
_context.Add(edu_prog);
}
pud.EduProgram = edu_prog;
var department = all_depart.Find(item => item.Name == model.Department);
if (department == null)
{
department = new Department {
Name = model.Department
};
_context.Add(department);
}
pud.Department = department;
var db_pud = all_puds.Find(item =>
{
return(item.CourseName == pud.CourseName &&
item.EduProgram.Name == pud.EduProgram.Name &&
item.EducationStage == pud.EducationStage &&
item.EduProgram.Faculty.Name == pud.EduProgram.Faculty.Name &&
item.EduProgram.Faculty.Campus.Name == pud.EduProgram.Faculty.Campus.Name);
});
if (db_pud == null)
{
_context.Add(pud);
}
}
await _context.SaveChangesAsync();
return(success);
}
