public ProjectOtherBodyModel PostProjectOtherBody([FromBody] ProjectOtherBodyModel projectOtherBody)
        {
            Response.StatusCode = 201;
            string result = ProjectOtherBodyService.AddProjectOtherBody(projectOtherBody, dbConn);

            projectOtherBody.Id = Convert.ToInt32(result);
            return(projectOtherBody);
        }
 public static string AddProjectOtherBody(ProjectOtherBodyModel projectOtherBody, string connstring)
 {
     try
     {
         Dictionary <string, object> spParams = new Dictionary <string, object>();
         spParams.Add("@ProjectId", projectOtherBody.ProjectId);
         spParams.Add("@OtherBodyId", projectOtherBody.OtherBodyId);
         return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddOtherBodyToProject(@ProjectId, @OtherBodyId)", spParams));
     }
     catch (Exception)
     {
         return("An error occurred");
     }
 }