public async Task <SpecializationGroup> Create(SpecializationGroup g) { logger.LogInformation("Creating SpecializationGroup:{@SpecializationGroup}", g); using (var cn = new SqlConnection(opts.ConnectionString)) { await cn.OpenAsync(); try { var grid = await cn.QueryMultipleAsync( Sql.Create, new { sqlSetId = g.SqlSetId, uiDefaultText = g.UiDefaultText, specs = SpecializationTable.From(g), user = user.UUID }, commandType : CommandType.StoredProcedure, commandTimeout : opts.DefaultTimeout); return(HydratedSpecializationGroupReader.ReadSingle(grid)); } catch (SqlException se) { logger.LogError("Could not create SpecializationGroup. SpecializationGroup:{@SpecializationGroup} Code:{Code} Error:{Error}", g, se.ErrorCode, se.Message); se.MapThrow(); throw; } } }
public async Task <ActionResult <SpecializationTable> > PostSpecialization(SpecializationTable specialization) { _log4net.Info("Specilization post method is initialized"); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var addedSpecilization = await _context.PostSpecialization(specialization); return(Ok(addedSpecilization)); }
public async Task <SpecializationTable> RemoveSpecialization(string id) { SpecializationTable sp = await _context.Specializations.FindAsync(id); if (sp == null) { throw new NullReferenceException(); } else { _context.Specializations.Remove(sp); await _context.SaveChangesAsync(); } return(sp); }
public async Task <SpecializationTable> PostSpecialization(SpecializationTable item) { SpecializationTable Sp = null; if (item == null) { throw new NullReferenceException(); } else { Sp = new SpecializationTable() { Name = item.Name }; await _context.Specializations.AddAsync(Sp); await _context.SaveChangesAsync(); } return(Sp); }
public async Task <SpecializationGroup> CreateAsync(SpecializationGroup g) { using (var cn = new SqlConnection(opts.ConnectionString)) { await cn.OpenAsync(); var grid = await cn.QueryMultipleAsync( Sql.Create, new { sqlSetId = g.SqlSetId, uiDefaultText = g.UiDefaultText, specs = SpecializationTable.From(g), user = user.UUID }, commandType : CommandType.StoredProcedure, commandTimeout : opts.DefaultTimeout); return(HydratedSpecializationGroupReader.ReadSingle(grid)); } }