public void CreateEntrys(string connection, string outputPath, string database)
{
TargetDir = outputPath;
Manager = new DbAccessLayer(DbAccessType.MsSql, connection);
bool checkDatabase;
try
{
checkDatabase = Manager.CheckDatabase();
}
catch (Exception)
{
checkDatabase = false;
}
if (!checkDatabase)
{
throw new Exception("Database not accessible. Maybe wrong Connection or no Selected Database?");
}
var databaseName = string.IsNullOrEmpty(Manager.Database.DatabaseName) ? database : Manager.Database.DatabaseName;
if (string.IsNullOrEmpty(databaseName))
{
throw new Exception("Database not exists. Maybe wrong Connection or no Selected Database?");
}
WinConsole.WriteLine("Connection OK ... Reading Server Version ...");
SqlVersion = Manager.RunSelect <string>(Manager.Database.CreateCommand("SELECT SERVERPROPERTY('productversion')")).FirstOrDefault();
WinConsole.WriteLine("Server version is {0}", SqlVersion);
WinConsole.WriteLine("Reading Tables from {0} ...", databaseName);
Tables = Manager.Select <TableInformations>()
.ToArray()
.AsParallel()
.Select(s => new TableInfoModel(s, databaseName, new DbAccessLayer(DbAccessType.MsSql, connection)))
.ToList();
Views = Manager.Select <ViewInformation>()
.ToArray()
.AsParallel()
.Select(s => new TableInfoModel(s, databaseName, new DbAccessLayer(DbAccessType.MsSql, connection)))
.ToList();
StoredProcs = Manager.Select <StoredProcedureInformation>()
.Select(s => new StoredPrcInfoModel(s))
.ToList();
WinConsole.WriteLine(
"Found {0} Tables, {1} Views, {2} Procedures ... select a Table to see Options or start an Action", Tables.Count(),
Views.Count(), StoredProcs.Count());
Enums = new List <Dictionary <int, string> >();
RenderMenu();
}
public void InsertView(int index, IMXView view)
{
if (index > Views.Count() - 1)
{
PushView(view);
}
else
{
_views.Insert(index, view);
}
}
private void RenderMenu()
{
WinConsole.WriteLine("Tables:");
var i = 0;
for (; i < Tables.Count(); i++)
{
WinConsole.WriteLine("{0} \t {1}", i, Tables.ToArray()[i].Info.TableName);
}
WinConsole.WriteLine("Views:");
var j = i;
for (; j < Views.Count() + i; j++)
{
WinConsole.WriteLine("{0} \t {1}", j, Views.ToArray()[j - i].Info.TableName);
}
WinConsole.WriteLine("Procedures:");
var k = j;
for (; k < StoredProcs.Count() + j; k++)
{
WinConsole.WriteLine("{0} \t {1}", k, StoredProcs.ToArray()[k - j].Parameter.TableName);
}
WinConsole.WriteLine("Actions: ");
WinConsole.WriteLine(@"[Name | Number]");
WinConsole.WriteLine(" Edit table");
WinConsole.WriteLine(@"\compile");
WinConsole.WriteLine(" Starts the Compiling of all Tables");
WinConsole.WriteLine(@"\ns");
WinConsole.WriteLine(" Defines a default Namespace");
WinConsole.WriteLine(@"\fkGen");
WinConsole.WriteLine(" Generates ForgeinKeyDeclarations");
WinConsole.WriteLine(@"\addConfigMethod");
WinConsole.WriteLine(" Moves all attributes from Propertys and Methods into a single ConfigMethod");
WinConsole.WriteLine(@"\withAutoCtor");
WinConsole.WriteLine(" Generates Loader Constructors");
WinConsole.WriteLine(@"\withNotification");
WinConsole.WriteLine($" Adds the '{nameof(INotifyPropertyChanged)}' interface to all Pocos");
WinConsole.WriteLine(@"\autoGenNames");
WinConsole.WriteLine(" Defines all names after a common naming convention");
WinConsole.WriteLine(@"\addCompilerHeader ");
WinConsole.WriteLine(" Adds a Timestamp and a created user on each POCO");
WinConsole.WriteLine(@"\withValidators ");
WinConsole.WriteLine(" Adds Validator attributes from the System.ComponentModel.DataAnnotations");
WinConsole.WriteLine(@"\exit");
WinConsole.WriteLine(" Stops the execution of the program");
RenderMenuAction();
}
public void PushView(IMXView view)
{
var controller = TouchFactory.GetNativeObject <UIViewController>(view, "view");
if (Views.Count() < 1)
{
NavigationController.PushViewController(this, false);
NavigationController.PushViewController(controller, true);
controller.NavigationItem.HidesBackButton = false;
}
else
{
NavigationController.PushViewController(controller, true);
}
}
public override IMXView PopView()
{
if (Views.Count() < 2)
{
var views = CurrentView;
if (PopoverWindow.IsVisible)
{
PopoverWindow.Close();
}
return(views);
}
else
{
return(base.PopView());
}
}
public void CreateEntrys(string connection, string outputPath, string database)
{
TargetDir = outputPath;
bool checkDatabase = false;
if (connection.StartsWith("file:\\\\"))
{
MsSqlStructure = new DacpacMsSqlStructure(connection.Replace("file:\\\\", ""));
checkDatabase = true;
}
else
{
var dbAccessLayer = new DbAccessLayer(DbAccessType.MsSql, connection);
MsSqlStructure = new DatabaseMsSqlStructure(dbAccessLayer);
try
{
checkDatabase = dbAccessLayer.CheckDatabase();
}
catch (Exception)
{
checkDatabase = false;
}
var databaseName = string.IsNullOrEmpty(dbAccessLayer.Database.DatabaseName) ? database : dbAccessLayer.Database.DatabaseName;
if (string.IsNullOrEmpty(databaseName))
{
throw new Exception("Database not exists. Maybe wrong Connection or no Selected Database?");
}
}
if (!checkDatabase)
{
throw new Exception("Database not accessible. Maybe wrong Connection or no Selected Database?");
}
WinConsole.WriteLine("Connection OK ... Reading Server Version ...");
SqlVersion = MsSqlStructure.GetVersion().ToString();
WinConsole.WriteLine("Server version is {0}", SqlVersion);
WinConsole.WriteLine("Reading Tables from {0} ...", MsSqlStructure.GetDatabaseName());
Tables = MsSqlStructure.GetTables()
//.AsParallel()
.Select(s => new TableInfoModel(s, MsSqlStructure.GetDatabaseName(), MsSqlStructure))
.ToList();
Views = MsSqlStructure.GetViews()
//.AsParallel()
.Select(s => new TableInfoModel(s, MsSqlStructure.GetDatabaseName(), MsSqlStructure))
.ToList();
StoredProcs = MsSqlStructure.GetStoredProcedures()
.Select(s => new StoredPrcInfoModel(s))
.ToList();
WinConsole.WriteLine(
"Found {0} Tables, {1} Views, {2} Procedures ... select a Table to see Options or start an Action", Tables.Count(),
Views.Count(), StoredProcs.Count());
Enums = new List <Dictionary <int, string> >();
RenderMenu();
}
