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(); }
private void btnAdd_Click(object sender, EventArgs e) { fOwnersAdd add = new fOwnersAdd(); DialogResult result = add.ShowDialog(); if (result == DialogResult.Cancel) { return; } Owners owner = new Owners(); owner.FIO = add.tbFIO.Text; owner.Passport = add.tbPassport.Text; context.Owners.Add(owner); context.SaveChanges(); MessageBox.Show("Запись выполнена"); LoadData(); }
private void AddOld() { HousingCooperativeEntities context = new HousingCooperativeEntities(); Rates oldRate = context.Rates.Find(dgvData.SelectedCells[0].Value); oldRate.StatusRate = 2; context.Rates.Add(oldRate); context.SaveChanges(); }
private void btnAdd_Click(object sender, EventArgs e) { fOwnersOfHousesAdd f = new fOwnersOfHousesAdd(); var ownersList = from Owners in context.Owners select Owners; f.cbOwner.DataSource = ownersList.ToList(); f.cbOwner.ValueMember = "IdOwner"; f.cbOwner.DisplayMember = "FIO"; f.cbOwner.SelectedIndex = -1; var housesList = from Houses in context.Houses select Houses; f.cbHouse.DataSource = housesList.ToList(); f.cbHouse.ValueMember = "IdHouse"; f.cbHouse.DisplayMember = "NumberHouse"; f.cbHouse.SelectedIndex = -1; var statusesList = from Statuses in context.Statuses select Statuses; f.cbStatus.DataSource = statusesList.ToList(); f.cbStatus.ValueMember = "IdStatus"; f.cbStatus.DisplayMember = "Description"; DialogResult result = f.ShowDialog(); if (result == DialogResult.Cancel) { return; } OwnersOfHouses ooh = new OwnersOfHouses(); ooh.Owner = (int)f.cbOwner.SelectedValue; ooh.House = (int)f.cbHouse.SelectedValue; ooh.DatePayment = f.dtDate.Value.Date; ooh.StatusOwner = (int)f.cbStatus.SelectedValue; context.OwnersOfHouses.Add(ooh); context.SaveChanges(); MessageBox.Show("Успешное добавление"); LoadData(); }
private void btnEdit_Click(object sender, EventArgs e) { HousingCooperativeEntities context = new HousingCooperativeEntities(); fRatesAdd add = new fRatesAdd(); Rates newRate = context.Rates.Find(dgvData.SelectedCells[0].Value); add.lbRate.Text = dgvData.SelectedCells[1].Value.ToString(); add.nudRate.Value = newRate.Rate; add.tbUnit.Text = newRate.Unit; add.dtMonthYear.Value = new DateTime(newRate.YearBegin, newRate.MonthBegin, 1); DialogResult result = add.ShowDialog(); if (result == DialogResult.Cancel) { return; } AddOld(); newRate.Rate = add.nudRate.Value; newRate.Unit = add.tbUnit.Text; newRate.MonthBegin = add.dtMonthYear.Value.Month; newRate.YearBegin = add.dtMonthYear.Value.Year; context.SaveChanges(); LoadData(); }