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