public async Task <ActionResult <ProfessionDB> > PostProfessionDB(ProfessionDB professionDB) { _context.Profession.Add(professionDB); await _context.SaveChangesAsync(); return(CreatedAtAction("GetProfessionDB", new { id = professionDB.id }, professionDB)); }
public async Task <IActionResult> PutProfessionDB(Guid id, ProfessionDB professionDB) { if (id != professionDB.id) { return(BadRequest()); } _context.Entry(professionDB).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProfessionDBExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// constructor no. 1 builds a profession by its ID. /// </summary> public Profession(int profID) { DataRow prof = ProfessionDB.RetProfession(profID); if (prof != null) { this.ProfessionID = (int)prof["ProfessionID"]; this.ProfName = (string)prof["ProfName"].ToString(); this.ProfPath = (string)prof["ProfPath"].ToString(); } }
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; } } }
/// <summary> /// the method builds a profession list from a datatable(the table in the db) and returns it /// </summary> public static List <Profession> GetProfessionList() { DataTable profTable = ProfessionDB.RetProfessionTable(); List <Profession> profList = new List <Profession>(); if (profTable == null) { return(null); } foreach (DataRow row in profTable.Rows) { Profession obj = new Profession((int)row["ProfessionID"], (string)row["ProfName"].ToString(), (string)row["ProfPath"].ToString()); profList.Add(obj); } return(profList); }
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; } } }