private void FillEditS(Status status) { status = db.Status.Find(status.status_id); status.name = StTB.Text; db.Entry(status).State = EntityState.Modified; db.SaveChanges(); 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(); }
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 ButtonEditObject(object sender, RoutedEventArgs e) { objectestate = db.ObjectEstates.Find(objectestate.object_id); objectestate.address = AddressObject.Text; objectestate.cadastral_number = CadastralNumber.Text; objectestate.price = int.Parse(PriceObjectEstate.Text); objectestate.square = int.Parse(Square.Text); Client c = (Client)OwnerCB.SelectedItem; objectestate.owner_id = c.client_id; Status s = (Status)StatusCB.SelectedItem; objectestate.status_id = s.status_id; db.Entry(objectestate).State = EntityState.Modified; if (db.Flats.Find(objectestate.object_id) != null) { flat.flat_number = int.Parse(NumberFlat.Text); flat.flat_id = objectestate.object_id; flat.number_floor = int.Parse(NumberFlat.Text); flat.quantity_rooms = int.Parse(QuantityRooms.Text); db.Entry(flat).State = EntityState.Modified; } else { house.house_id = objectestate.object_id; house.plot_size = int.Parse(PlotSize.Text); house.quantity_floors = int.Parse(QuantityFloors.Text); db.Entry(house).State = EntityState.Modified; } db.SaveChanges(); this.Close(); }
private void ButtonEdit_Click(object sender, RoutedEventArgs e) { agent = db.Agents.Find(agent.agent_id); agent.full_name = FIOagent.Text; agent.birthday = (DateTime)BirthDate.SelectedDate; agent.address = Address.Text; agent.passport_series_number = PassportSeriesNumber.Text; agent.passport_issued_by = PassportIssuedBy.Text; agent.passport_date = (DateTime)PassportDate.SelectedDate; agent.phone_number = Phone.Text; agent.INN = INN.Text; db.Entry(agent).State = EntityState.Modified; db.SaveChanges(); this.Close(); }
private void ButtonEditClient(object sender, RoutedEventArgs e) { client = db.Clients.Find(client.client_id); client.full_name = FIOclient.Text; client.birthday = (DateTime)BirthDate.SelectedDate; client.address = Address.Text; client.passport_series_number = PassportSeriesNumber.Text; client.passport_issued_by = PassportIssuedBy.Text; client.passport_date = (DateTime)PassportDate.SelectedDate; client.phone_number = Phone.Text; Role r = (Role)RoleCB.SelectedItem; client.role_id = r.role_id; db.Entry(client).State = EntityState.Modified; db.SaveChanges(); this.Close(); }