private async Task Binding()
{
var users = await _context.Users.ToListAsync();
userBindingSource.DataSource = new BindingListView <UI.Models.User>(list: users);
UsersGridView.Refresh();
SoftwareGridView.Refresh();
}
private async void AddDatabaseToSoftwareBtn_Click(object sender, EventArgs e)
{
var form = new AddDatabase();
if (form.ShowDialog() == DialogResult.OK)
{
await Binding();
SoftwareGridView.Refresh();
dataGridView1.Refresh();
}
}
private void FillSoftwareTable(int configId)
{
var software = ConfigurationDAL.GetSoftwareByConfigId(configId);
List <Tuple <string, string, string, string> > softwareList = new List <Tuple <string, string, string, string> >();
foreach (var soft in software)
{
softwareList.Add(new Tuple <string, string, string, string>(soft.id.ToString(), soft.name, soft.type, soft.producer));
}
SoftwareGridView.DataSource = softwareList;
SoftwareGridView.DataBind();
}
/// <summary>
/// Use case: приложению больше не нужна данная база её нужно удалить
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void RemoveDatabaseFromSoftwareBtn_Click(object sender, EventArgs e)
{
UI.Models.Software software = ((ObjectView <UI.Models.Software>)softwareBindingSource.Current).Object;
DataBase dataBase = ((ObjectView <DataBase>)dataBaseBindingSource.Current).Object;
SoftwareDataBase firstOrDefaultAsync =
await context.SoftwareDatabases.FirstOrDefaultAsync(predicate : it => it.IdDataBase == dataBase.Id &&
it.IdSoftware == software.Id);
context.Remove(entity: firstOrDefaultAsync);
await context.SaveChangesAsync();
await Binding();
SoftwareGridView.Refresh();
}
