public IReadOnlyCollection <Notification> Atualizar(AssistenciaReuniao updatemodel)
{
if (updatemodel.Valid)
{
using (RepositorySession dalSession = new RepositorySession(Runtime.JWInstance))
{
IUnitOfWork unitOfWork = dalSession.UnitOfWork;
unitOfWork.Begin();
try
{
var model = _repository.FindByData(ref unitOfWork, updatemodel.CongregacaoId, updatemodel.Data);
if (model == null)
{
_repository.Inserir(ref unitOfWork, updatemodel);
}
else
{
_repository.Atualizar(ref unitOfWork, updatemodel);
}
unitOfWork.Commit();
return(updatemodel.Notifications);
}
catch
{
unitOfWork.Rollback();
throw;
}
}
}
return(updatemodel.Notifications);
}
public void Atualizar(ref IUnitOfWork unitOfWork, AssistenciaReuniao model)
{
unitOfWork.Connection.Execute(@" UPDATE [dbo].[AssistenciasReunioes]
SET [AssistenciaParte1] = @AssistenciaParte1 ,[AssistenciaParte2] = @AssistenciaParte2
WHERE CongregacaoId = @CongregacaoId and [Data] = @Data",
param: new
{
@CongregacaoId = model.CongregacaoId,
@AssistenciaParte1 = model.AssistenciaParte1,
@AssistenciaParte2 = model.AssistenciaParte2,
@Data = model.Data
}, transaction: unitOfWork.Transaction
);
}
public void Inserir(ref IUnitOfWork unitOfWork, AssistenciaReuniao model)
{
unitOfWork.Connection.Execute(@" INSERT INTO [dbo].[AssistenciasReunioes]
([Data], [CongregacaoId], [AssistenciaParte1], [AssistenciaParte2])
VALUES
(@Data, @CongregacaoId, @AssistenciaParte1,@AssistenciaParte2)",
param: new
{
@CongregacaoId = model.CongregacaoId,
@AssistenciaParte1 = model.AssistenciaParte1,
@AssistenciaParte2 = model.AssistenciaParte2,
@Data = model.Data
}, transaction: unitOfWork.Transaction
);
}
public async Task <IActionResult> Post([FromBody] AssistenciaReuniao model)
{
try
{
var result = _service.Atualizar(new AssistenciaReuniao(model.Data, model.CongregacaoId, model.AssistenciaParte1, model.AssistenciaParte2));
return(await Response(model, result));
}
catch (Exception ex)
{
return(BadRequest(new
{
success = false,
errors = new[] { ex }
}));
}
}
