Пример #1
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            fOwnersOfHousesAdd f   = new fOwnersOfHousesAdd();
            OwnersOfHouses     ooh = new OwnersOfHouses();

            ooh = context.OwnersOfHouses.Find(dgvData.SelectedCells[0].Value);
            var ownersList = from Owners in context.Owners select Owners;

            f.cbOwner.DataSource    = ownersList.ToList();
            f.cbOwner.ValueMember   = "IdOwner";
            f.cbOwner.DisplayMember = "FIO";
            f.cbOwner.SelectedValue = ooh.Owner;
            var housesList = from Houses in context.Houses select Houses;

            f.cbHouse.DataSource    = housesList.ToList();
            f.cbHouse.ValueMember   = "IdHouse";
            f.cbHouse.DisplayMember = "NumberHouse";
            f.cbHouse.SelectedValue = ooh.House;
            var statusesList = from Statuses in context.Statuses select Statuses;

            f.cbStatus.DataSource    = statusesList.ToList();
            f.cbStatus.ValueMember   = "IdStatus";
            f.cbStatus.DisplayMember = "Description";
            f.cbStatus.SelectedValue = ooh.StatusOwner;
            f.dtDate.Value           = ooh.DatePayment;
            DialogResult result = f.ShowDialog();

            if (result == DialogResult.Cancel)
            {
                return;
            }

            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.SaveChanges();
            MessageBox.Show("Изменения сохранены");
            LoadData();
        }
Пример #2
0
        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();
        }