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; }