private void btnEdit_Click(object sender, EventArgs e) { if (dgvData.SelectedCells.Count > 0) { fCountersAdd add = new fCountersAdd(); Counters counter = context.Counters.Find(dgvData.SelectedCells[0].Value); var typeContersList = from TypesOfCounters in context.TypesOfCounters select TypesOfCounters; add.cbTypeCounter.DataSource = typeContersList.ToList(); add.cbTypeCounter.ValueMember = "IdType"; add.cbTypeCounter.DisplayMember = "Description"; add.cbTypeCounter.SelectedValue = counter.TypeCounter; var housesList = from Houses in context.Houses select Houses; add.cbNumberHouse.DataSource = housesList.ToList(); add.cbNumberHouse.ValueMember = "IdHouse"; add.cbNumberHouse.DisplayMember = "NumberHouse"; add.cbNumberHouse.SelectedIndex = counter.House; add.nudInformation.Value = counter.Information; DialogResult result = add.ShowDialog(); if (result == DialogResult.Cancel) { return; } counter.TypeCounter = (int)add.cbTypeCounter.SelectedValue; counter.House = (int)add.cbNumberHouse.SelectedValue; counter.Information = (int)add.nudInformation.Value; context.SaveChanges(); MessageBox.Show("Изменения сохранены"); LoadData(); } }
private void btnAdd_Click(object sender, EventArgs e) { fCountersAdd add = new fCountersAdd(); var typeContersList = from TypesOfCounters in context.TypesOfCounters select TypesOfCounters; add.cbTypeCounter.DataSource = typeContersList.ToList(); add.cbTypeCounter.ValueMember = "IdType"; add.cbTypeCounter.DisplayMember = "Description"; add.cbTypeCounter.SelectedIndex = -1; var housesList = from Houses in context.Houses select Houses; add.cbNumberHouse.DataSource = housesList.ToList(); add.cbNumberHouse.ValueMember = "IdHouse"; add.cbNumberHouse.DisplayMember = "NumberHouse"; add.cbNumberHouse.SelectedIndex = -1; DialogResult result = add.ShowDialog(); if (result == DialogResult.Cancel) { return; } Counters counter = new Counters(); counter.TypeCounter = (int)add.cbTypeCounter.SelectedValue; counter.House = (int)add.cbNumberHouse.SelectedValue; counter.Information = (int)add.nudInformation.Value; context.Counters.Add(counter); context.SaveChanges(); MessageBox.Show("Успешное добавление"); LoadData(); }