public ActionResult Index()
        {
            var tableValueCounts = new DatabaseTableValueCountModel();

            //string entityConnectionString = HydroServerToolsUtils.GetConnectionNameByUserEmail(HttpContext.User.Identity.Name.ToString());

            //get connection name
            string connectionName = HydroServerToolsUtils.getConnectionName(HttpContext.User.Identity.Name.ToString());

            if (connectionName == Ressources.NOT_LINKED_TO_DATABASE)
            {
                return RedirectToAction("NoDBForm");
            }
            string entityConnectionString = HydroServerToolsUtils.BuildConnectionStringForUserName(HttpContext.User.Identity.Name.ToString());


            if (!String.IsNullOrEmpty(entityConnectionString))
            {
                //var entityConnectionString = HydroServerToolsUtils.GetDBEntityConnectionStringByName(connectionName);

                var databaseRepository = new DatabaseRepository();
                
                tableValueCounts = databaseRepository.GetDatabaseTableValueCount(entityConnectionString);
                
                return View(tableValueCounts);
                
            }
            else
            {
                return RedirectToAction("GoogleForm");
            }
            
        }
        public DatabaseTableValueCountModel GetDatabaseTableValueCount(string connectionString)
        {
            var databaseTableValueCountModel = new DatabaseTableValueCountModel();

            var context = new ODM_1_1_1EFModel.ODM_1_1_1Entities(connectionString);

            databaseTableValueCountModel.SiteCount = context.Sites.Count();
            databaseTableValueCountModel.VariablesCount = context.Variables.Count();
            databaseTableValueCountModel.OffsetTypesCount = context.OffsetTypes.Count();
            databaseTableValueCountModel.SourcesCount = context.Sources.Count();
            databaseTableValueCountModel.MethodsCount = context.Methods.Count();
            databaseTableValueCountModel.LabMethodsCount = context.LabMethods.Count();
            databaseTableValueCountModel.SamplesCount = context.Samples.Count();
            databaseTableValueCountModel.QualifiersCount = context.Qualifiers.Count();
            databaseTableValueCountModel.QualityControlLevelsCount = context.QualityControlLevels.Count();
            databaseTableValueCountModel.DataValuesCount = context.DataValues.Count();
            databaseTableValueCountModel.GroupDescriptionsCount = context.GroupDescriptions.Count();
            databaseTableValueCountModel.GroupsCount = context.Groups.Count();
            databaseTableValueCountModel.DerivedFromCount = context.DerivedFroms.Count();
            databaseTableValueCountModel.CategoriesCount = context.Categories.Count();
            databaseTableValueCountModel.SeriesCatalog = context.SeriesCatalogs.Count();

            return databaseTableValueCountModel;
        }