private void btnGenerateLists_Click(object sender, EventArgs e) { string databaseName = txtDatabaseName.Text; string dataSource = txtDataSource.Text; string initialCatalog = txtInitialCatalog.Text; string userId = txtUserId.Text; string password = txtPassword.Text; bool trustedConnection = chkTrustedConnection.Checked; string schema = txtSchema.Text; SprocDataLayerGenerator.PredicateFunctions predicateFunctions = new SprocDataLayerGenerator.PredicateFunctions(); MetaInformationSchemaManager metaInformationSchemaManager = //_metaInformationSchemaManager; new MetaInformationSchemaManager(databaseName, dataSource, initialCatalog, userId, password, trustedConnection, schema); DataLayerGenerator dataLayerGenerator = //_sprocDataLayerGenerator; new DataLayerGenerator(metaInformationSchemaManager, this.GetType().Namespace); dataLayerGenerator.AssembliesGeneratedInMemory = _sprocDataLayerGenerator.AssembliesGeneratedInMemory; bool overwriteExisting = chkOverwriteExistingDtos.Checked; if (dataLayerGenerator.AssembliesGeneratedInMemory.Count == 0) { MessageBox.Show("you must create dtos before generating lists based upon dtos, check the app.config file for the settings named CommonLibraryDllLocation and CurrentAppRunningExeLocation and set the path appropriately to your environment"); btnGenerateLists.Enabled = false; } else { List <string> tablesToGen = new List <string>(); List <MetaInformationSchema> schemasToGen = new List <MetaInformationSchema>(); if (this.treeAvailableTables.Nodes.Count > 0) { foreach (TreeNode node in treeAvailableTables.Nodes) { if (node.Checked) { tablesToGen.Add(node.Text); } } } if (tablesToGen.Count > 0) { foreach (string tableName in tablesToGen) { predicateFunctions.TableNameHolder = tableName; schemasToGen.AddRange(metaInformationSchemaManager.MetaDataList.FindAll(predicateFunctions.FindMetaInformationSchemaByTableName)); } } dataLayerGenerator.GenerateListClasses(schemasToGen, overwriteExisting); MessageBox.Show("List Generation Complete"); } btnTestDataAccess.Enabled = true; }
private void btnGetCustomSprocs_Click(object sender, EventArgs e) { _customSprocs.Clear(); treeCustomSprocs.Nodes.Clear(); string databaseName = txtDatabaseName.Text; string dataSource = txtDataSource.Text; string initialCatalog = txtInitialCatalog.Text; string userId = txtUserId.Text; string password = txtPassword.Text; bool trustedConnection = chkTrustedConnection.Checked; string schema = txtSchema.Text; _databaseSmoObjectsAndSettings = new CommonLibrary.DatabaseSmoObjectsAndSettings(databaseName, dataSource, initialCatalog, userId, password, trustedConnection); _dataLayerGenerator = new DataLayerGenerator(_databaseSmoObjectsAndSettings, this.GetType().Namespace); SprocDataLayerGenerator.PredicateFunctions predicateFunctions = new SprocDataLayerGenerator.PredicateFunctions(); List <StoredProcedure> customSprocsNotGenerated = new List <StoredProcedure>(); CommonLibrary.DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings = new CommonLibrary.DatabaseSmoObjectsAndSettings(databaseName, dataSource, initialCatalog, userId, password, trustedConnection, schema); SprocGenerator sprocGenerator = new SprocGenerator(databaseName, dataSource, initialCatalog, userId, password, trustedConnection, schema); _sprocGenerator = sprocGenerator; List <StoredProcedure> sprocsGenerated = _sprocGenerator.GetStoredProcedures(); if (sprocsGenerated != null) { foreach (StoredProcedure sproc in databaseSmoObjectsAndSettings.Database_Property.StoredProcedures) { predicateFunctions.SprocNameHolder = sproc.Name; if (!(sprocsGenerated.FindAll(predicateFunctions.FindSprocGeneratedBySprocName).Count > 0)) { customSprocsNotGenerated.Add(sproc); } } } if (customSprocsNotGenerated.Count > 0) { foreach (StoredProcedure customSproc in customSprocsNotGenerated) { if (!customSproc.IsSystemObject) { treeCustomSprocs.Nodes.Add(customSproc.Name); _customSprocs.Add(customSproc); } } } btnGenerateCustomSprocDtos.Enabled = true; chkSelectAll.Enabled = true; }
private void btnGenerateDtos_Click(object sender, EventArgs e) { SprocDataLayerGenerator.PredicateFunctions predicateFunctions = new SprocDataLayerGenerator.PredicateFunctions(); string databaseName = txtDatabaseName.Text; string dataSource = txtDataSource.Text; string initialCatalog = txtInitialCatalog.Text; string userId = txtUserId.Text; string password = txtPassword.Text; bool trustedConnection = chkTrustedConnection.Checked; string schema = txtSchema.Text; MetaInformationSchemaManager metaInformationSchemaManager = new MetaInformationSchemaManager(databaseName, dataSource, initialCatalog, userId, password, trustedConnection, schema); _metaInformationSchemaManager = metaInformationSchemaManager; DataLayerGenerator dataLayerGenerator = new DataLayerGenerator(metaInformationSchemaManager, this.GetType().Namespace); _sprocDataLayerGenerator = dataLayerGenerator; bool overwriteExisting = chkOverwriteExistingDtos.Checked; List <string> tablesToGen = new List <string>(); List <MetaInformationSchema> schemasToGen = new List <MetaInformationSchema>(); if (this.treeAvailableTables.Nodes.Count > 0) { foreach (TreeNode node in treeAvailableTables.Nodes) { if (node.Checked) { tablesToGen.Add(node.Text); } } } if (tablesToGen.Count > 0) { foreach (string tableName in tablesToGen) { predicateFunctions.TableNameHolder = tableName; schemasToGen.AddRange(metaInformationSchemaManager.MetaDataList.FindAll(predicateFunctions.FindMetaInformationSchemaByTableName)); } } dataLayerGenerator.GenerateDtoClasses(schemasToGen, overwriteExisting); //predicateFunctions.TableNameHolder = "TblGrid"; //MetaInformationSchema metaInformationSchema = // metaInformationSchemaManager.MetaDataList.Find(predicateFunctions.FindMetaInformationSchemaByTableName); //dataLayerGenerator.GenerateOneDtoClass(metaInformationSchema, overwriteExisting); MessageBox.Show("Dto Generation Complete"); btnGenerateLists.Enabled = true; }