예제 #1
0
        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;
                    }
                }
            }
        }
예제 #2
0
 public IActionResult MarkAssignmentAsComplete([FromBody] MvCompleteAssignment completeAssignment)
 {
     try
     {
         dynamic jsonString = _assignmentService.MarkAssignmentAsComplete(completeAssignment);
         return(Ok(jsonString));
     }
     catch (Exception e)
     {
         throw e;
     }
 }