title: Importing Files Using Angular.js and C#
body: <p>I am building an Umbraco7 Package and I'm at a bit of a standstill. I have very little experience with Angular and C# and what I'm trying to do is add an import option where a backoffice user can import an xls file and populate an existing database table with the xls contents.</p>
  
  <p>This is what I have so far, I'm not sure how to get it to save the file in the firs place, let alone extract the values from the xls file.</p>
  
  <p>HTML</p>
  
  <pre><code>// This is the view (table.html)
  // Excluding the export blank xls file table.
  
  &lt;div class="import-div"&gt;
      &lt;input type="file" name="MyFile" /&gt;
      &lt;input type="submit" class="btn btn-danger" ng-click="ButtonClickHandler()" /&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>Angular.Js Controller file</p>
  
  <pre><code>// Here is my js controller file:
  
      angular.module("umbraco")
          .controller("ImportCtrl", function ($scope, keyResource) {
              $scope.ButtonClickHandler = function () {
                  console.log("I was clicked!");
              };
          });
  </code></pre>
  
  <p>C# Controller</p>
  
  <pre><code>    //This is the C# controller.
  
          using AngularUmbracoPackage.Models;
          using System;
          using System.Collections.Generic;
          using System.Linq;
          using System.Web.Mvc;
          using System.Web.Security;
          using umbraco.cms.businesslogic.member;
          using Umbraco.Web.Mvc;
          using Umbraco.Core.Persistence;
          using System.Configuration;
          using Umbraco.Core.Logging;
          using System.Data;
          using System.Text;
          using System.IO;
          using System.Web;
          using System.Net.Http;
  
          namespace AngularUmbracoPackage.App_Code
  {
  
      [HttpPost]
      public class ImportNewDictionaryController
      {
          [HttpPost]
          public ActionResult importFile()
          {
               public string fileName;
          public string DictionaryKey;
  
          var db = UmbracoContext.Application.DatabaseContext.Database;
          var insert = new Sql("INSERT INTO cmsDictionary VALUES('" + DictionaryKey + "'");
  
          }
  
  
      }
  }
  </code></pre>
  
  <p>Can anyone give me any links which may help or guide me through this?</p>