private async Task CreateModelThanSave(string base_code, DTECore dteCore, ISettings settings, string database, Table table)
{
var model_code = await dteCore.CreateModelAsync(database, table.TableName);
var modelname = GetModelName(settings, table);
modelname = Regex.Replace(modelname, "[^a-zA-Z0-9_.]+", "");
string cs_file_code = base_code.Replace("[code]", model_code);
SaveFile(cs_file_code, modelname);
CreatedTablesCount += 1;
}
public Peasy(string projectName, string businessProjectPath, string dalProjectPath, IEnumerable <Table> tables, DTECore dTECore)
{
_businessProjectPath = Path.GetDirectoryName(businessProjectPath);
_dataLayerProjectPath = Path.GetDirectoryName(dalProjectPath);
Tables = tables;
DTECore = dTECore;
_projectName = projectName;
_businessProject = Microsoft.Build.Evaluation.ProjectCollection.GlobalProjectCollection.LoadedProjects.FirstOrDefault(pr => pr.FullPath == businessProjectPath);
_dalProject = Microsoft.Build.Evaluation.ProjectCollection.GlobalProjectCollection.LoadedProjects.FirstOrDefault(pr => pr.FullPath == dalProjectPath);
if (_businessProject is null)
{
_businessProject = new Project(businessProjectPath);
}
if (_dalProject is null)
{
_dalProject = new Project(dalProjectPath);
}
_businessProjectName = Path.GetFileNameWithoutExtension(_businessProjectPath);
_dataLayerProjectName = Path.GetFileNameWithoutExtension(dalProjectPath);
}
public async Task LoadTablesAsync()
{
LoadConnection = true;
var connectionBuilder = ParentTreeBase.ConnectionBuilder;
var dteCore = new DTECore(connectionBuilder.ConnectionType, connectionBuilder.ConnectionString, new DTESettings().Settings);
Tables.Clear();
var tables = await dteCore.GetTablesAsync(DatabaseName);
foreach (var tableName in tables)
{
Tables.Add(new Table()
{
TableName = tableName, ParentTreeBase = ParentTreeBase, DataBaseName = DatabaseName
});
}
LoadConnection = false;
}
public async Task LoadDatabasesAsync()
{
try
{
Databases.Clear();
LoadConnection = true;
var dteCore = new DTECore(_connectionBuilder.ConnectionType, _connectionBuilder.ConnectionString, new DTESettings().Settings);
var databases = await dteCore.GetDatabasesAsync();
foreach (var dbName in databases)
{
var db = new Database
{
DatabaseName = dbName,
ParentTreeBase = this,
Tables = new ObservableCollection <Table>()
};
var tables = await dteCore.GetTablesAsync(dbName);
foreach (var tableName in tables)
{
db.Tables.Add(new Table()
{
TableName = tableName, ParentTreeBase = this, DataBaseName = db.DatabaseName
});
}
Databases.Add(db);
}
LoadConnection = false;
}
catch (Exception ex)
{
LoadConnection = false;
throw ex;
}
}
public PeasyVM(List <Table> tables, DTECore dTECore)
{
Tables = new ObservableCollection <Table>(tables);
AllTablesCount = Tables.Count;
this.dTECore = dTECore;
}
public CreateIntoFileWindow(List <Table> tables, DTECore dTECore)
{
InitializeComponent();
DataContext = new CreateIntoFilesVM(tables, dTECore);
}
public CreateIntoFilesVM(List <Table> tables, DTECore dTECore)
{
Tables = new ObservableCollection <Table>(tables);
AllTablesCount = Tables.Count;
_dTECore = dTECore;
}
