public dynamic MarkAssignmentAsComplete(MvCompleteAssignment completeAssignment) { using (var dbConnection = _dah.GetConnection()) { var dbCommand = dbConnection.CreateCommand(); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "SpAssignmentStatusTsk"; dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar); dbCommand.Parameters["@Json"].Value = dbCommand.Parameters["@Json"].Value = "{\"assignmentId\":" + completeAssignment.AssignmentId + "," + "\"employeeId\":" + completeAssignment.EmployeeId + "," + "\"organizationId\":" + completeAssignment.OrganizationId + "," + "\"insertPersonId\":" + completeAssignment.InsertPersonId + "}"; using (SqlDataReader reader = dbCommand.ExecuteReader()) { try { if (reader.HasRows) { return(_dah.GetJson(reader)); } else { return(null); } } catch (Exception e) { throw e; } } } }
public IActionResult MarkAssignmentAsComplete([FromBody] MvCompleteAssignment completeAssignment) { try { dynamic jsonString = _assignmentService.MarkAssignmentAsComplete(completeAssignment); return(Ok(jsonString)); } catch (Exception e) { throw e; } }