public async Task <IActionResult> PutSpecializationDB(Guid id, SpecializationDB specializationDB)
{
if (id != specializationDB.id)
{
return(BadRequest());
}
_context.Entry(specializationDB).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SpecializationDBExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <SpecializationDB> > PostSpecializationDB(SpecializationDB specializationDB)
{
_context.Specialization.Add(specializationDB);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSpecializationDB", new { id = specializationDB.id }, specializationDB));
}
public async Task <GroupDTO> UpdateGroupAsync(Guid id, GroupDTO groupDTO)
{
var grups = await _context.Group.Where(c => c.id == id)
.Include(c => c.ProfessionDB)
.Include(c => c.SpecializationDB)
.FirstOrDefaultAsync();
if (grups == null || grups.id != id)
{
return(null);
}
grups.id = grups.id;
grups.numberOfGroup = groupDTO.numberOfGroup;
grups.info = groupDTO.info;
grups.CountCadets = groupDTO.CountCadets;
if (groupDTO.nameOfSpecialization != grups.SpecializationDB.SpecializationCode)
{
SpecializationDB spec = _context.Specialization.Where(c => c.nameOfSpecialization == groupDTO.nameOfSpecialization).FirstOrDefault();
grups.SpecializationDB = spec;
grups.ProfessionDBid = spec.id;
}
if (groupDTO.ProfessionLastName != grups.ProfessionDB.nameOfProffession)
{
ProfessionDB prof = _context.Profession.Where(c => c.nameOfProffession == groupDTO.ProfessionLastName).FirstOrDefault();
grups.ProfessionDB = prof;
grups.ProfessionDBid = prof.id;
}
_context.Entry(grups).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
return(groupDTO);
}
catch (DbUpdateConcurrencyException)
{
if (!GroupDBExists(id))
{
return(null);
}
else
{
throw;
}
}
}
public async Task <GroupDTO> AddGroupAsync(GroupDTO groupDTO)
{
SpecializationDB spec = _context.Specialization.Where(c => c.nameOfSpecialization == groupDTO.nameOfSpecialization)
.FirstOrDefault();
ProfessionDB prof = _context.Profession.Where(c => c.nameOfProffession == groupDTO.ProfessionLastName)
.FirstOrDefault();
if (spec == null || prof == null)
{
return(null);
}
GroupDB group = new GroupDB
{
id = groupDTO.id,
info = groupDTO.info,
SpecializationDB = spec,
ProfessionDB = prof,
CountCadets = groupDTO.CountCadets,
numberOfGroup = groupDTO.numberOfGroup,
ProfessionDBid = prof.id,
SpecializationDBid = spec.id
};
try
{
_context.Group.Add(group);
await _context.SaveChangesAsync();
return(groupDTO);
}
catch (DbUpdateConcurrencyException)
{
if (!GroupDBExists(group.id))
{
return(null);
}
else
{
throw;
}
}
}
public DisciplineDB(DisciplineDTOTimetable discipline, SpecializationDB specializationDB)
{
name = discipline.name;
fullName = discipline.fullName;
countHours = discipline.countHours;
fullName = discipline.fullName;
countHours = discipline.countHours;
countHoursGZ = discipline.countHoursGZ;
countHoursPZ = discipline.countHoursPZ;
countHoursLeck = discipline.countHoursLeck;
countHoursSEM = discipline.countHoursSEM;
countHoursLR = discipline.countHoursLR;
countHoursMZ = discipline.countHoursMZ;
countHoursTest = discipline.countHoursTest;
countHoursСontrolWork = discipline.countHoursСontrolWork;
countHoursSWZ = discipline.countHoursSWZ;
SpecializationDB = specializationDB;
isExam = discipline.isExam;
dateOfPlan = discipline.dateOfPlan;
countNorm = discipline.countNorm;
Semester = discipline.Semester;
}
