//public SqlConnection sqlConnection { get; set; }
public ViewModelTables()
{
listTables = new ObservableCollection<ListTablesItem>();
TabItems = new ObservableCollection<TabItem>();
OpenTableUserCommand = new RelayCommand(OpenTable);
SetFilterUserCommand = new RelayCommand(SetFilter);
ClearFilterUserCommand = new RelayCommand(ClearFilter);
CloseUserCommand = new RelayCommand(CloseViewTables);
Export2PDFUserCommand = new RelayCommand(Export2Pdf);
Export2CSVUserCommand = new RelayCommand(Export2Csv);
CloseTableUserCommand = new RelayCommand(CloseTable);
Export2XLSUserCommand = new RelayCommand(Export2Xls);
//OpenTables();
}
public ViewModelSetFilter(List<string> listFields)
{
table = new ObservableCollection<RowFilterTable>();
foreach (string field in listFields)
table.Add(new RowFilterTable { fieldName = field, textValue = "", Operator = ""});
Operators = new ObservableCollection<string>();
Operators.Add("");
Operators.Add("=");
Operators.Add("!=");
Operators.Add(">");
Operators.Add("<");
Operators.Add(">=");
Operators.Add("<=");
SetFilterUserCommand = new RelayCommand(SetFilter);
CloseUserCommand = new RelayCommand(CloseWindow);
}
public ViewModelConnect()
{
listTables = new ObservableCollection<string>();
listDatabases = new ObservableCollection<string>();
LoadPlugins(AppDomain.CurrentDomain.BaseDirectory + "plugins");
connectPars = new ConnectPars
{
userName = "******",
password = "******",
serverName = @".\SQLEXPRESS"
};
ConnectUserCommand = new RelayCommand(ConnectToServer);
OpenTableUserCommand = new RelayCommand(OpenTable);
CloseConnectWindowUserCommand = new RelayCommand(CloseWindow);
}