public DecisionMessage UpdateDecision(Guid meetingId, MinutzDecision decision, AuthRestModel user)
{
var instanceConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, user.InstanceId, _applicationSetting.GetInstancePassword(user.InstanceId));
return(_decisionRepository.UpdateDecision(meetingId, decision, user.InstanceId, instanceConnectionString));
}
public bool Update
(MinutzDecision decision, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
string updateQuery = $@"UPDATE [{schema}].[MinutzDecision]
SET
[ReferanceId] = @ReferanceId,
[DecisionText] = @DecisionText,
[DecisionComment] = @DecisionComment,
[AgendaId] = @AgendaId,
[PersonId] = @PersonId,
[CreatedDate] = @CreatedDate,
[IsOverturned] = @IsOverturned
WHERE Id = @Id";
var instance = dbConnection.Execute(updateQuery, new
{
decision.ReferanceId,
decision.DescisionText,
decision.Descisioncomment,
decision.AgendaId,
decision.PersonId,
decision.CreatedDate,
decision.IsOverturned
});
return(instance == 1);
}
}
public IActionResult Post([FromBody] MinutzDecision decision)
{
var userInfo = Request.ExtractAuth(User, _authenticationService);
var result =
_meetingDecisionService.UpdateMinutzDecision(decision.ReferanceId.ToString(), decision, userInfo.InfoResponse);
return(result.condition ? Ok(result.value) : StatusCode(500, result.message));
}
public IActionResult UpdateDecisionResult([FromBody] MinutzDecision request)
{
if (!ModelState.IsValid)
{
return(StatusCode(401, "Request is missing values for the request"));
}
var result = _minutzDecisionService.UpdateDecision
(request.Id, request, User.ToRest());
return(result.Condition ? Ok(result.Decision) : StatusCode(result.Code, result.Message));
}
public DecisionMessage UpdateDecision(Guid meetingId, MinutzDecision decision, string schema, string connectionString)
{
if (meetingId == Guid.Empty || string.IsNullOrEmpty(schema) || string.IsNullOrEmpty(connectionString))
{
throw new ArgumentException("Please provide a valid meeting identifier, schema or connection string.");
}
try
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
var overturned = Convert.ToByte(decision.IsOverturned);
var sql = string.Empty;
if (string.IsNullOrEmpty(decision.PersonId))
{
sql = $@"UPDATE [{schema}].[MinutzDecision] SET
[DescisionText] = '{decision.DescisionText}',
[Descisioncomment] = '{decision.Descisioncomment}',
[AgendaId] = '{decision.AgendaId}',
[CreatedDate] = '{decision.CreatedDate}',
[IsOverturned] = {overturned},
[Order] = {decision.Order}
WHERE Id = '{meetingId}'";
}
else
{
sql = $@"UPDATE [{schema}].[MinutzDecision] SET
[DescisionText] = '{decision.DescisionText}',
[Descisioncomment] = '{decision.Descisioncomment}',
[AgendaId] = '{decision.AgendaId}',
[PersonId] = '{decision.PersonId}',
[CreatedDate] = '{decision.CreatedDate}',
[IsOverturned] = {overturned},
[Order] = {decision.Order}
WHERE Id = '{meetingId}'";
}
var data = dbConnection.Execute(sql);
return(data == 1
? new DecisionMessage {
Code = 200, Condition = true, Message = "Success"
}
: new DecisionMessage {
Code = 404, Condition = false, Message = "Could not update meeting."
});
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(new DecisionMessage {
Code = 500, Condition = false, Message = e.Message
});
}
}
public bool Add
(MinutzDecision decision, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
try
{
dbConnection.Open();
string insertSql = $@"insert into [{schema}].[MinutzDecision](
[Id]
,[ReferanceId]
,[DescisionText]
,[Descisioncomment]
,[AgendaId]
,[PersonId]
,[CreatedDate]
,[IsOverturned]
)
values(
@Id
,@ReferanceId
,@DescisionText
,@Descisioncomment
,@AgendaId
,@PersonId
,@CreatedDate
,@IsOverturned)";
var instance = dbConnection.Execute(insertSql, new
{
decision.Id,
decision.ReferanceId,
decision.DescisionText,
decision.Descisioncomment,
decision.AgendaId,
decision.PersonId,
decision.CreatedDate,
decision.IsOverturned
});
return(instance == 1);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
}
public (bool condition, string message, MinutzDecision value) UpdateMinutzDecision
(string referenceId, MinutzDecision decision, AuthRestModel user)
{
if (string.IsNullOrEmpty(referenceId))
{
throw new ArgumentNullException(nameof(referenceId), "Please provide a valid reference id.");
}
var instanceConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, user.InstanceId,
_applicationSetting.GetInstancePassword(user.InstanceId));
var masterConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, _applicationSetting.Username, _applicationSetting.Password);
var result = _decisionRepository.Update(decision, user.InstanceId, instanceConnectionString);
return(result, result ? "Success" : "Failed", decision);
}
