public IActionResult Post([FromBody] MinutzAction action)
{
var userInfo = Request.ExtractAuth(User, _authenticationService);
var result = _meetingActionService.UpdateMinutzAction(action.referanceId.ToString(), action, userInfo.InfoResponse);
return(result.condition ? Ok(action) : StatusCode(500, result.message));
}
public IActionResult Create([FromBody] MinutzAction action)
{
_logger.LogInformation(Core.LogProvider.LoggingEvents.ListItems, "GetMeetings {ID}", 1);
_logService.Log(Minutz.Models.LogLevel.Info, "GetMeetings called.");
var userInfo = Request.ExtractAuth(User, _authenticationService);
var result = _meetingActionService.CreateMinutzAction
(action.referanceId.ToString(), action, userInfo.InfoResponse);
return(result.condition ? Ok(action) : StatusCode(500, result.message));
}
public (bool condition, string message, MinutzAction value) UpdateMinutzAction
(string referenceId, MinutzAction action, AuthRestModel user)
{
var instanceConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, user.InstanceId,
_applicationSetting.GetInstancePassword(user.InstanceId));
var result = _actionRepository.Update(action, user.InstanceId, instanceConnectionString);
return(result, result ? "Success": "Failed", action);
}
public (bool condition, string message, MinutzAction value) CreateMinutzAction
(string referenceId, MinutzAction action, AuthRestModel user)
{
if (action.Id == Guid.Parse("e38b69b3-8f2a-4979-9323-1819db4331f8"))
{
action.Id = Guid.NewGuid();
}
var instanceConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, user.InstanceId,
_applicationSetting.GetInstancePassword(user.InstanceId));
var result = _actionRepository.Add(action, user.InstanceId, instanceConnectionString);
return(result, result ? "Success": "Failed", action);
}
public bool Add
(MinutzAction action, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
try
{
dbConnection.Open();
string insertSql = $@"insert into [{schema}].[MinutzAction](
[Id]
,[ReferanceId]
,[ActionText]
,[PersonId]
,[DueDate]
,[IsComplete]
)
values(
@Id
,@ReferanceId
,@ActionText
,@PersonId
,@DueDate
,@IsComplete)";
var instance = dbConnection.Execute(insertSql, new
{
action.Id,
action.referanceId,
action.ActionText,
action.PersonId,
action.DueDate,
action.IsComplete
});
return(instance == 1);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
}
public bool Update
(MinutzAction action, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
string updateQuery = $@"UPDATE [{schema}].[MinutzAction]
SET ActionText = @ActionText,
PersonId = @PersonId,
DueDate = @DueDate,
IsComplete = @IsComplete
WHERE Id = @Id";
var instance = dbConnection.Execute(updateQuery, new
{
action.Id,
action.ActionText,
action.PersonId,
action.DueDate,
action.IsComplete
});
return(instance == 1);
}
}
