C#

I created an excel user defined function using excel dna Add-In, My function should return a two dimentional array but when i call it from a cell (=mainView(2018-04-10) ) it displays only the first column name (FundName), below is my code:

<pre> public static object[,] mainView(DateTime dt)
    {
        int rows = 0;
        int columns = 0;
        const int columnsArrayIndex = 0;
        DataTable dt = new DataTable();
        object[,] allRecords = new object[0,0];           
        try
        {
            SqlConnection cnx = new SqlConnection("data source=...;initial catalog=...;integrated security=True");
            cnx.Open();
            string query = @"select FundName,...";
            SqlCommand cmd = new SqlCommand(query, cnx);
            using (SqlDataAdapter a = new SqlDataAdapter(cmd))
            {
                a.Fill(dt);
                rows = dt.Rows.Count;
                columns = dt.Columns.Count;
                if (columns > 0 && rows > 0)
                {
                    allRecords = new object[rows + 1, columns];
                    for (int i = 0; i <= columns - 1; i++)
                    {
                        allRecords[columnsArrayIndex, i] = dt.Columns[i].ColumnName;
                    }
                    for (int j = 0; j <= rows - 1; j++)
                    {
                        var rowItem = dt.Rows[j].ItemArray;
                        for (int k = 0; k <= rowItem.Length - 1; k++)
                        {
                            allRecords[j + 1, k] = rowItem[k];
                        }
                    }
                }
            }
        }
        catch
        {

        }

        return allRecords; 
    }

<script type="text/javascript">
    function GetPrice(_this) {

        var x = document.getElementById("productID"), selectedValue = x.value;
        alert("_this" + _this.SelectedValue);
        var pid = selectedValue;
        alert(pid);
        var url = '@Url.Action("GetPrice","Sales")';
        alert(url);
              $.ajax({
                type:"POST",
                url: 'Sales/GetPrice',
                contentType: "application/json; charset=utf-8",
                data:  {ProductId: pid },
                cache:false,
                dataType: json,
                async: true,
                processData:false,
                success: function (data)
                {
                    alert("yay1");
                },
                failure: function (response) {
                    alert("Fail");
                }

        });

    };
</script>

@using (Html.BeginForm())
{
    @Html.ValidationSummary(true)
   <fieldset>
  <div class="editor-field">
<div class="editor-label">
            @Html.LabelFor(model => model.ProductId)
        </div>
  @Html.DropDownListFor(model => model.ProductId, new SelectList(ViewBag.ProductList, "ProductId", "ProductName" ), "Select Product", new { id = "productID", onchange="GetPrice(this);"})                       
            @Html.ValidationMessageFor(model => model.ProductId, "", new { @class = "text-danger" })
            <span class="glyphicon glyphicon-asterisk"></span>
        </div>


   <div class="editor-label">
            @Html.LabelFor(model => model.Rate)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Rate, new { id = "idRate"})
            @Html.ValidationMessageFor(model => model.Rate)
        </div>\
   </fieldset>
}

[HttpPost]
      public JsonResult GetPrice(int ProductId)
      {
          return Json("");
      }

<pre>Mat eulerAnglesToRotationMatrix(Vec3f &theta)
{
    // Calculate rotation about x axis
    Mat R_x = (Mat_<double>(3,3) <<
               1,       0,              0,
               0,       cos(theta[0]),   -sin(theta[0]),
               0,       sin(theta[0]),   cos(theta[0])
               );
    
    // Calculate rotation about y axis
    Mat R_y = (Mat_<double>(3,3) <<
               cos(theta[1]),    0,      sin(theta[1]),
               0,               1,      0,
               -sin(theta[1]),   0,      cos(theta[1])
               );
    
    // Calculate rotation about z axis
    Mat R_z = (Mat_<double>(3,3) <<
               cos(theta[2]),    -sin(theta[2]),      0,
               sin(theta[2]),    cos(theta[2]),       0,
               0,               0,                  1);
    
    
    // Combined rotation matrix
    Mat R = R_z * R_y * R_x;
    
    return R;

}

Exception thrown: 'System.ArgumentException' in System.Web.Extensions.dll

    /// <param name="wUrl">The web service URL to call</param>
    /// <returns>An array of Card composed of the de-serialized JSON</returns>
    private Card[] GetWebServiceResult(string wUrl)
    {
        HttpWebRequest httpWReq = (HttpWebRequest)WebRequest.Create(wUrl);
        HttpWebResponse httpWResp = (HttpWebResponse)httpWReq.GetResponse();
        Card[] jsonResponse = null;

        try
        {
            //Test the connection
            if (httpWResp.StatusCode == HttpStatusCode.OK)
            {

                Stream responseStream = httpWResp.GetResponseStream();
                string jsonString = null;

                //Set jsonString using a stream reader
                using (StreamReader reader = new StreamReader(responseStream))
                {
                    jsonString = reader.ReadToEnd().Replace("\\", "");
                    reader.Close();
                }

                //Deserialize our JSON
                JavaScriptSerializer sr = new JavaScriptSerializer();
                
                /*CODE FAILS HERE*/
                jsonResponse = sr.Deserialize<Card[]>(jsonString);

            }
            //Output connection error message
            else
            {
                FailComponent(httpWResp.StatusCode.ToString());

            }
        }
        //Output JSON parsing error
        catch (Exception e)
        {
            FailComponent(e.ToString());
        }
        return jsonResponse;

    }

    /// <summary>
    /// Outputs error message
    /// </summary>
    /// <param name="errorMsg">Full error text</param>
    private void FailComponent(string errorMsg)
    {
        bool fail = false;
        IDTSComponentMetaData100 compMetadata = this.ComponentMetaData;
        compMetadata.FireError(1, "Error Getting Data From Webservice!", errorMsg, "", 0, out fail);

    }

}
#endregion

#region JSON Class

public class ImageUris
{
    public string small { get; set; }
    public string normal { get; set; }
    public string large { get; set; }
    public string png { get; set; }
    public string art_crop { get; set; }
    public string border_crop { get; set; }
}

public class Legalities
{
    public string standard { get; set; }
    public string future { get; set; }
    public string frontier { get; set; }
    public string modern { get; set; }
    public string legacy { get; set; }
    public string pauper { get; set; }
    public string vintage { get; set; }
    public string penny { get; set; }
    public string commander { get; set; }
    public string __invalid_name__1v1 { get; set; }
    public string duel { get; set; }
    public string brawl { get; set; }
}

public class RelatedUris
{
    public string tcgplayer_decks { get; set; }
    public string edhrec { get; set; }
    public string mtgtop8 { get; set; }
}

public class PurchaseUris
{
    public string amazon { get; set; }
    public string ebay { get; set; }
    public string tcgplayer { get; set; }
    public string magiccardmarket { get; set; }
    public string cardhoarder { get; set; }
    public string card_kingdom { get; set; }
    public string mtgo_traders { get; set; }
    public string coolstuffinc { get; set; }
}

public class AllPart
{
    public string @object { get; set; }
    public string id { get; set; }
    public string name { get; set; }
    public string uri { get; set; }
}

public class Datum
{
    public string @object { get; set; }
    public string id { get; set; }
    public string oracle_id { get; set; }
    public List<object> multiverse_ids { get; set; }
    [JsonProperty("name")]
    public string Name { get; set; }
    [JsonProperty("uri")]
    public string Uri { get; set; }
    public string scryfall_uri { get; set; }
    public string layout { get; set; }
    public bool highres_image { get; set; }
    public ImageUris image_uris { get; set; }
    public double cmc { get; set; }
    public string type_line { get; set; }
    public string oracle_text { get; set; }
    public string mana_cost { get; set; }
    public string loyalty { get; set; }
    public List<object> colors { get; set; }
    public List<object> color_identity { get; set; }
    public Legalities legalities { get; set; }
    public bool reserved { get; set; }
    public bool reprint { get; set; }
    public string set { get; set; }
    public string set_name { get; set; }
    public string set_uri { get; set; }
    public string set_search_uri { get; set; }
    public string scryfall_set_uri { get; set; }
    public string rulings_uri { get; set; }
    public string prints_search_uri { get; set; }
    public string collector_number { get; set; }
    public bool digital { get; set; }
    public string rarity { get; set; }
    public string illustration_id { get; set; }
    public string artist { get; set; }
    public string frame { get; set; }
    public bool full_art { get; set; }
    public string border_color { get; set; }
    public bool timeshifted { get; set; }
    public bool colorshifted { get; set; }
    public bool futureshifted { get; set; }
    public int edhrec_rank { get; set; }
    public RelatedUris related_uris { get; set; }
    public PurchaseUris purchase_uris { get; set; }
    public string flavor_text { get; set; }
    public string usd { get; set; }
    public int? story_spotlight_number { get; set; }
    public string power { get; set; }
    public string toughness { get; set; }
    public List<AllPart> all_parts { get; set; }
    public string eur { get; set; }
    public string watermark { get; set; }
}

public class Card
{
    public string @object { get; set; }
    public int total_cards { get; set; }
    public bool has_more { get; set; }
    public string next_page { get; set; }
    public List<Datum> data { get; set; }
}

#endregion