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));
}
}
