private async void ClientAuthorization()
{
while (true)
{
var dialres = await this.ShowLoginAsync("Авторизация", "Введите учетные данные для входа",
new LoginDialogSettings
{
ColorScheme = MetroDialogOptions.ColorScheme,
EnablePasswordPreview = true,
UsernameWatermark = "Имя пользователя",
PasswordWatermark = "Пароль",
NegativeButtonVisibility = Visibility.Visible,
NegativeButtonText = "Close",
DialogResultOnCancel = MessageDialogResult.Canceled
});
if (dialres is null)
{
this.Close();
return;
}
var acc = DBBSContext.GetInstance().Accounts
.FirstOrDefault(a => a.Login == dialres.Username && a.Password == dialres.Password);
if (acc is null)
{
var msg = await this.ShowMessageAsync("Ошибка", "Неверные имя пользователя или пароль", MessageDialogStyle.Affirmative);
}
else
{
_clientControl.CurrentAccount = acc;
return;
}
}
}
private async void ListUsers_OnCellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
MetroDialogSettings settings = new MetroDialogSettings
{
AffirmativeButtonText = "OK",
};
DBBSContext ctx = DBBSContext.GetInstance();
int row = ctx.SaveChanges();
var msg = await this.ShowMessageAsync("Изменение данных", $"Изменения успешно сохранены {row} row aff",
MessageDialogStyle.Affirmative, settings);
}
}
private async void BlockBankAccount_OnClick(object sender, RoutedEventArgs e)
{
BankAccount bankAccount = BankAccountList.SelectedItem as BankAccount;
if (bankAccount.CreditFunds == 0)
{
bankAccount.IsClosed = true;
DBBSContext.GetInstance().SaveChanges();
}
else
{
var msg = await this.ShowMessageAsync("Ошибка", "Кредит полностью не погашен");
}
}
private ClientControl()
{
_connStr = ConfigurationManager.ConnectionStrings["defaultConnection"].ConnectionString;
_dbBankSystemControl = DBBSContext.GetInstance(_connStr);
_dbBankSystemControl.Database.Initialize(true);
}
void SetDBData()
{
BankAccount bankAccount1 = new BankAccount
{
Created = DateTime.Now.AddMonths(-2),
Number = "1234567898765432",
CreditFunds = 0m,
PersonalFunds = -3000m,
IsClosed = false
};
BankAccount bankAccount5 = new BankAccount
{
Created = DateTime.Now.AddMonths(-1),
Number = "1234567898765433",
CreditFunds = 501000m,
PersonalFunds = 0m,
IsClosed = false
};
Account acc1 = new Account
{
Created = DateTime.Now.AddMonths(-2),
IsBlocked = false,
Login = "******",
Password = "******",
BankAccounts = new[] { bankAccount1, bankAccount5 },
AccountLimit = new AccountLimit()
};
User user1 = new User
{
BirthDate = new DateTime(1993, 8, 12),
FirstName = "Valentin",
LastName = "Popov",
Account = acc1
};
personell.AddUser(user1, acc1, bankAccount1);
BankAccount bankAccount2 = new BankAccount
{
Created = DateTime.Now.AddMonths(-3),
Number = "1234567898765434",
CreditFunds = 5000m,
PersonalFunds = 30000m,
IsClosed = false
};
BankAccount bankAccount3 = new BankAccount
{
Created = DateTime.Now.AddMonths(-1),
Number = "1234567898765435",
CreditFunds = 1000m,
PersonalFunds = 1000m,
IsClosed = false
};
BankAccount bankAccount4 = new BankAccount
{
Created = DateTime.Now.AddMonths(-1),
Number = "1234567898765436",
CreditFunds = -1000m,
PersonalFunds = 1000m,
IsClosed = false
};
Account acc2 = new Account
{
Created = DateTime.Now.AddMonths(-2),
IsBlocked = false,
Login = "******",
Password = "******",
BankAccounts = new[] { bankAccount2, bankAccount3, bankAccount4 },
AccountLimit = new AccountLimit()
};
User user2 = new User
{
BirthDate = new DateTime(1990, 5, 20),
FirstName = "Yuri",
LastName = "Ivanov",
Account = acc2
};
personell.AddUser(user2, acc2, bankAccount2);
DBBSContext.GetInstance().CreditRequests.Add(new CreditRequest
{
BankAccount = bankAccount4,
Created = DateTime.Now,
CreditSize = 500m
});
PersonnelAccount pAcc = new PersonnelAccount
{
Created = DateTime.Now,
Login = "******",
Password = "******"
};
DBBSContext.GetInstance().PersonnelAccounts.Add(pAcc);
DBBSContext.GetInstance().SaveChanges();
}
