public TableStructChangeViewModel(IDataBaseServiceProvider provider, string tableName)
{
_oldName = tableName;
_provider = provider;
_tableName = tableName;
Columns = new ObservableCollection <Column>();
TableList = new List <string>();
TypeList = new BindableCollection <string>
{
"binary_double",
"binary_float",
"char",
"date",
"number",
"varchar(255)",
"varchar2(255)"
};
DisplayName = string.Format("Change table {0}", TableName);
#region gettingData
using (var dataReader = _provider.GetInfoOfTable(TableName))
{
var names = from DbDataRecord row in dataReader
select new Column()
{
Name = row["column_name"].ToString(),
Type = row["data_type"].ToString(),
ForeignKeyColumn = row["source_column"].ToString(),
ForeignKeyTable = row["source_table"].ToString(),
IsNotifying = true,
IsNotNull = !row["nullable"].ToString().Equals("Y"),
IsPrimaryKey = row["primary_key"].ToString().Equals("P"),
ForeignKey = row["foreign_key"].ToString().Equals("R"),
ForKeyName = row["fk_symbol"].ToString()
};
var collection = names as Column[] ?? names.ToArray();
_wasColumnsLength = collection.Length;
for (int i = 0; i < _wasColumnsLength; i++)
{
collection[i].Id = i;
}
_wasColumns = new bool[_wasColumnsLength];
Columns = new ObservableCollection <Column>(collection);
_oldColumns = new ObservableCollection <Column>();
foreach (var c in collection)
{
_oldColumns.Add(new Column(c));
}
}
#endregion
}
public TableDataChangeViewModel(IDataBaseServiceProvider provider, String tableName)
{
_provider = provider;
_tableName = tableName;
DisplayName = string.Concat("Change table: ", tableName);
try
{
Content = _provider.GetContentOfTable(_tableName);
}
catch (Exception e)
{
MessageBox.Show(e.Message, Resources.ErrorMessage);
TryClose();
}
}
public TableCreationViewModel(IDataBaseServiceProvider provider)
{
_provider = provider;
Columns = new ObservableCollection <Column>();
TableList = new List <string>();
TypeList = new BindableCollection <string>
{
"binary_double",
"binary_float",
"char",
"date",
"number",
"varchar(255)",
"varchar2(255)"
};
DisplayName = "Create your table!";
}
public void LogIn()
{
//try to connect to database
IDataBaseServiceProvider provider = null;
try
{
provider = new OracleDataBaseServiceProvider(IpAddress, Tablespace, Name, Password);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Ошибка входа");
return;
}
_manager.ShowWindow(new MainWindowViewModel(_manager, provider, Name, Tablespace));
TryClose();
}
public MainWindowViewModel(IWindowManager manager, IDataBaseServiceProvider provider, string name, string tablespace)
{
_manager = manager;
_provider = provider;
DisplayName = string.Concat("User: "******" ", "Tablespace: ", tablespace);
}
public CommandExecutionViewModel(IWindowManager manager, IDataBaseServiceProvider provider)
{
_provider = provider;
_manager = manager;
DisplayName = "Execute command:";
}
public TableChangeViewModel(IWindowManager manager, IDataBaseServiceProvider provider, String tableName)
{
_manager = manager;
_provider = provider;
_tableName = tableName;
}
