/// <summary>
        /// Create new company
        /// </summary>
        /// <param name="NewCompany"></param>
        /// <returns></returns>
        public string CreateCompany(Company NewCompany, string UserID)
        {
            //string newCompanyID = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
            //NewCompany.CompanyID = newCompanyID;

            string queryInsertCompany = @"INSERT INTO [dbo].[Company]
               ([CompanyName]
               ,[CompanyEmail]
               ,[CompanyWebSite]
               ,[CompanyDetails]
               ,[CompanyDesc])
             VALUES
               (@CompanyName, @CompanyEmail, @CompanyWebSite, @CompanyDetails, @CompanyDesc)";

            //creates new company
            this._con.Query<int>(queryInsertCompany, NewCompany);

            //string queryUpdateUser = @"update [dbo].[AspNetUsers] set [CompanyID] = '" + newCompanyID +
            //             @"' where [Id] = '" + UserID + "'";

            ////associates new company with logged in user
            //this._con.Query<int>(queryUpdateUser, null);

            return "success";
        }
        public ActionResult Create(Company NewCompany)
        {
            this._companyRepository.CreateCompany(NewCompany, User.Identity.GetUserId());

            return RedirectToAction("List", "Company");
        }