private async void InitializeDB()
{
ErrorText = "Установка связи с БД...";
await Task.Run(() =>
{
SQLDb = new AgencySQLDb();
if (DBPath != string.Empty)
DBConnected = SQLDb.TryOpen(DBPath);
else DBConnected = SQLDb.TryConnect();
});
if (!DBConnected)
{
ErrorText = "База данных не найдена или не распознана, выберите расположение базы";
while (DBConnected == false)
if (dialogService.OpenFileDialog())
{
DBConnected = SQLDb.TryOpen(dialogService.FilePath);
windowFactory.SetDBPath(dialogService.FilePath);
}
else
{
windowFactory.CloseApp();
break;
}
}
if (DBConnected)
{
ErrorText = "Загрузка данных...";
UserData = SQLDb.GetLoginData();
UserData.RowChanged += UserData_RowChanged;
Login = "******";
Password = "******";
ErrorText = null;
}
}
public SupplyViewModel(IWindowController controller, AgencySQLDb sql, User user, string UserName)
{
CurrentUser = user;
this.UserName = UserName;
windowController = controller;
db = sql;
searchSet = new SearchSet();
UpdateTransactionTable();
searchSet.SearchSetChanged += SearchSet_SearchSetChanged;
}
public EditViewModel(IWindowController controller, AgencySQLDb DataBase)
{
dialog = new DefaultDialogService();
windowController = controller;
SqlDataBase = DataBase;
TransactionsEdit = new List <DataRow>();
OfficeEmployeeEdit = new List <DataRow>();
OfficeEdit = new List <DataRow>();
SeekerEdit = new List <DataRow>();
SaleEdit = new List <DataRow>();
EmployeeEdit = new List <DataRow>();
RefreshData();
}
