private void ButtonEditObject_Click(object sender, RoutedEventArgs e) { // если ни одного объекта не выделено, выходим if (EstateObjectsGrid.SelectedItem == null) { CallPopup("Не выбран объект"); return; } // редактирование dynamic tempO = EstateObjectsGrid.SelectedItem; ObjectEstate objectestate = new ObjectEstate(); objectestate.address = tempO.AddressToDispley; objectestate.cadastral_number = tempO.CadastralNumber; objectestate.object_id = tempO.IDObject; objectestate.owner_id = tempO.FIOowner_id; objectestate.price = int.Parse(tempO.PriceToDispley); objectestate.square = int.Parse(tempO.SquareToDispley); objectestate.status_id = tempO.Status_id; EditObjectEstateWindow edo = new EditObjectEstateWindow(objectestate); edo.ShowDialog(); FillDataGrid(); }
private void ButtonAddObjectEstate_Click(object sender, RoutedEventArgs e) { newTrade = new Trade(); dynamic b = BuyerCB.SelectedItem; dynamic a = AddressCB.SelectedItem; dynamic ag = AgentCB.SelectedItem; newTrade.date = (DateTime)DateTrade.SelectedDate; newTrade.object_id = a.id; newTrade.buyer_id = b.id; newTrade.agent_id = ag.id; db.Trades.Add(newTrade); if (TBRent.IsChecked == false) { newSale = new Sale(); newSale.sale_id = newTrade.trade_id; newSale.price = int.Parse(Price.Text); db.Sales.Add(newSale); ob = db.ObjectEstates.Find(a.id); ob.status_id = 2; db.Entry(ob).State = EntityState.Modified; } else { newRent = new Rent(); newRent.rent_id = newTrade.trade_id; newRent.date_start = (DateTime)DateStartRent.SelectedDate; newRent.date_end = (DateTime)DateEndRent.SelectedDate; newRent.rent_price = int.Parse(PriceRent.Text); db.Rents.Add(newRent); ob = db.ObjectEstates.Find(a.id); ob.status_id = 6; db.Entry(ob).State = EntityState.Modified; } db.SaveChanges(); this.Close(); }
public EditObjectEstateWindow(ObjectEstate o) { db = new DBcontext(); db.Clients.Load(); db.Status.Load(); db.Flats.Load(); db.Houses.Load(); objectestate = o; InitializeComponent(); AddressObject.Text = o.address; CadastralNumber.Text = o.cadastral_number; Square.Text = o.square.ToString(); PriceObjectEstate.Text = o.price.ToString(); OwnerCB.ItemsSource = db.Clients.Local; OwnerCB.SelectedItem = db.Clients.Find(objectestate.owner_id); StatusCB.ItemsSource = db.Status.Local; StatusCB.SelectedItem = db.Status.Find(objectestate.status_id); if (db.Flats.Find(o.object_id) != null) { flat = db.Flats.Find(o.object_id); FlatGrid.Visibility = Visibility.Visible; HouseGrid.Visibility = Visibility.Collapsed; NumberFlat.Text = flat.flat_number.ToString(); NumberFloor.Text = flat.number_floor.ToString(); QuantityRooms.Text = flat.quantity_rooms.ToString(); } else { house = db.Houses.Find(o.object_id); FlatGrid.Visibility = Visibility.Collapsed; HouseGrid.Visibility = Visibility.Visible; PlotSize.Text = house.plot_size.ToString(); QuantityFloors.Text = house.quantity_floors.ToString(); } }
private void ButtonEditTrade_Click(object sender, RoutedEventArgs e) { trade = db.Trades.Find(trade.trade_id); trade.date = (DateTime)DateTrade.SelectedDate; Agent a = (Agent)AgentCB.SelectedItem; trade.agent_id = a.agent_id; Client c = (Client)BuyerCB.SelectedItem; trade.buyer_id = c.client_id; ObjectEstate o = (ObjectEstate)AddressCB.SelectedItem; trade.object_id = o.object_id; db.Entry(trade).State = EntityState.Modified; if (db.Sales.Find(trade.trade_id) != null) { sale.sale_id = trade.trade_id; sale.price = int.Parse(Price.Text); db.Entry(sale).State = EntityState.Modified; } else { rent.rent_id = trade.trade_id; rent.date_start = (DateTime)DateStartRent.SelectedDate; rent.date_end = (DateTime)DateEndRent.SelectedDate; rent.rent_price = int.Parse(PriceRent.Text); db.Entry(rent).State = EntityState.Modified; } db.SaveChanges(); this.Close(); }
private void ButtonDeleteObject_Click(object sender, RoutedEventArgs e) { // если ни одного объекта не выделено, выходим if (EstateObjectsGrid.SelectedItem == null) { CallPopup("Не выбран объект"); return; } // получаем выделенный объект dynamic deleteObject = EstateObjectsGrid.SelectedItem; int IDObject = deleteObject.IDObject; ObjectEstate c = db.ObjectEstates.Find(IDObject); if (c != null) { db.ObjectEstates.Remove(c); db.SaveChanges(); } FillDataGrid(); }
private void ButtonAddObjectEstate_Click(object sender, RoutedEventArgs e) { newObjectEstate = new ObjectEstate(); dynamic st = StatusCB.SelectedItem; dynamic ow = OwnerCB.SelectedItem; newObjectEstate.address = AddressObject.Text; newObjectEstate.cadastral_number = CadastralNumber.Text; newObjectEstate.square = int.Parse(Square.Text); newObjectEstate.price = int.Parse(PriceObjectEstate.Text); newObjectEstate.status_id = st.id; newObjectEstate.owner_id = ow.id; db.ObjectEstates.Add(newObjectEstate); if (TBHouse.IsChecked == false) { newFlat = new Flat(); newFlat.flat_id = newObjectEstate.object_id; newFlat.flat_number = int.Parse(NumberFlat.Text); newFlat.number_floor = int.Parse(NumberFloor.Text); newFlat.quantity_rooms = int.Parse(QuantityRooms.Text); db.Flats.Add(newFlat); } else { newHouse = new House(); newHouse.house_id = newObjectEstate.object_id; newHouse.plot_size = int.Parse(PlotSize.Text); newHouse.quantity_floors = int.Parse(QuantityFloors.Text); db.Houses.Add(newHouse); } db.SaveChanges(); this.Close(); }