public async Task <Result <NoteTypeDto> > UpdateAsync(NoteTypeDto entity)
{
var result = new Result <NoteTypeDto>();
try
{
var db = GetOpenConnection();
var sql = @"UPDATE NoteTypes SET
Name = @Name
, Description = @Description
, ParenNoteTypeId = @ParenNoteTypeId
WHERE NoteTypeId = @NoteTypeId";
var r = await db.ExecuteAsync(sql.ToString(),
new { entity.NoteTypeId, entity.Name, entity.Description, entity.ParenNoteTypeId });
if (r == 0)
{
result.ErrorList.Add("Entity not updated");
}
result.Entity = entity;
await CloseIsTempConnection(db);
}
catch (Exception ex)
{
AddExecptionsMessagesToErrorsList(ex, result.ErrorList);
}
return(ResultDomainAction(result));
}
public async Task <Result <NoteTypeDto> > AddAsync(NoteTypeDto entity)
{
var response = new Result <NoteTypeDto>();
try
{
var ctx = GetOpenConnection();
var noteTypes = new GenericRepositoryEF <KntDbContext, NoteType>(ctx);
var newEntity = new NoteType();
newEntity.SetSimpleDto(entity);
var resGenRep = await noteTypes.AddAsync(newEntity);
response.Entity = resGenRep.Entity?.GetSimpleDto <NoteTypeDto>();
response.ErrorList = resGenRep.ErrorList;
await CloseIsTempConnection(ctx);
}
catch (Exception ex)
{
AddExecptionsMessagesToErrorsList(ex, response.ErrorList);
}
return(ResultDomainAction(response));
}
public async Task <Result <NoteTypeDto> > AddAsync(NoteTypeDto entity)
{
var result = new Result <NoteTypeDto>();
try
{
var db = GetOpenConnection();
var sql = @"INSERT INTO NoteTypes (NoteTypeId, Name, Description, ParenNoteTypeId)
VALUES (@NoteTypeId, @Name, @Description, @ParenNoteTypeId)";
var r = await db.ExecuteAsync(sql.ToString(),
new { entity.NoteTypeId, entity.Name, entity.Description, entity.ParenNoteTypeId });
if (r == 0)
{
result.ErrorList.Add("Entity not inserted");
}
result.Entity = entity;
await CloseIsTempConnection(db);
}
catch (Exception ex)
{
AddExecptionsMessagesToErrorsList(ex, result.ErrorList);
}
return(ResultDomainAction(result));
}
public async Task <bool> AplyChangeNoteType(NoteTypeDto newType)
{
try
{
Model.NoteTypeId = newType?.NoteTypeId;
Model.NoteTypeDto = newType;
// Delete old attributes
Model.KAttributesDto.RemoveAll(_ => _.KAttributeNoteTypeId != null);
if (newType == null)
{
return(await Task.FromResult(true));
}
// Add new attributes
Model.KAttributesDto = await Service.Notes.CompleteNoteAttributes(Model.KAttributesDto, Model.NoteId, newType.NoteTypeId);
return(await Task.FromResult(true));
}
catch (Exception)
{
return(await Task.FromResult(false));
}
}
public async Task <Result <NoteTypeDto> > SaveAsync(NoteTypeDto entity)
{
if (entity.NoteTypeId == Guid.Empty)
{
entity.NoteTypeId = Guid.NewGuid();
return(await _repository.NoteTypes.AddAsync(entity));
}
else
{
return(await _repository.NoteTypes.UpdateAsync(entity));
}
}
public async Task <Result <NoteTypeDto> > SaveAsync(NoteTypeDto noteType)
{
HttpResponseMessage httpRes;
if (noteType.NoteTypeId == Guid.Empty)
{
httpRes = await _httpClient.PostAsJsonAsync <NoteTypeDto>($"api/notetypes", noteType);
}
else
{
httpRes = await _httpClient.PutAsJsonAsync <NoteTypeDto>($"api/notetypes", noteType);
}
var res = await httpRes.Content.ReadFromJsonAsync <Result <NoteTypeDto> >();
return(res);
}
public async Task <IActionResult> Post([FromBody] NoteTypeDto noteType)
{
try
{
var kresApi = await _service.NoteTypes.SaveAsync(noteType);
if (kresApi.IsValid)
{
return(Ok(kresApi));
}
else
{
return(BadRequest(kresApi));
}
}
catch (Exception ex)
{
var kresApi = new Result <NoteTypeDto>();
kresApi.AddErrorMessage("Generic error: " + ex.Message);
return(BadRequest(kresApi));
}
}
public async Task <Result <NoteTypeDto> > UpdateAsync(NoteTypeDto entity)
{
var resGenRep = new Result <NoteType>();
var response = new Result <NoteTypeDto>();
try
{
var ctx = GetOpenConnection();
var noteTypes = new GenericRepositoryEF <KntDbContext, NoteType>(ctx);
var resGenRepGet = await noteTypes.GetAsync(entity.NoteTypeId);
NoteType entityForUpdate;
if (resGenRepGet.IsValid)
{
entityForUpdate = resGenRepGet.Entity;
entityForUpdate.SetSimpleDto(entity);
resGenRep = await noteTypes.UpdateAsync(entityForUpdate);
}
else
{
resGenRep.Entity = null;
resGenRep.AddErrorMessage("Can't find entity for update.");
}
response.Entity = resGenRep.Entity?.GetSimpleDto <NoteTypeDto>();
response.ErrorList = resGenRep.ErrorList;
await CloseIsTempConnection(ctx);
}
catch (Exception ex)
{
AddExecptionsMessagesToErrorsList(ex, response.ErrorList);
}
return(ResultDomainAction(response));
}
