private void ButtonAddAgent(object sender, RoutedEventArgs e)
{
if (FIOagent.Text.Length == 0 || PassportSeriesNumber.Text.Length == 0 || PassportIssuedBy.Text.Length == 0 || Address.Text.Length == 0 || Phone.Text.Length == 0 || INN.Text.Length == 0)
{
CallPopup("Не заполнены все поля");
return;
}
if (PassportSeriesNumber.Text.Length != 10)
{
CallPopup("Некорректные серия и номер");
return;
}
string patternPhone = @"^[8][9]\d{9}$";
Regex regexPh = new Regex(patternPhone);
if (regexPh.IsMatch(Phone.Text) == false)
{
CallPopup("Некорректный телефон");
return;
}
if (INN.Text.Length != 10)
{
CallPopup("Некорректный ИНН");
return;
}
newAgent = new Agent();
newAgent.full_name = FIOagent.Text;
newAgent.birthday = (DateTime)BirthDate.SelectedDate;
newAgent.passport_series_number = PassportSeriesNumber.Text;
newAgent.passport_issued_by = PassportIssuedBy.Text;
newAgent.passport_date = (DateTime)PassportDate.SelectedDate;
newAgent.address = Address.Text;
newAgent.phone_number = Phone.Text;
newAgent.INN = INN.Text;
db.Agents.Add(newAgent);
db.SaveChanges();
FIOagent.Clear();
BirthDate.SelectedDate = DateTime.Now;
PassportSeriesNumber.Clear();
PassportIssuedBy.Clear();
PassportDate.SelectedDate = DateTime.Now;
Address.Clear();
Phone.Clear();
INN.Clear();
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 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 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();
}
private void ButtonDeliteAgent_Click(object sender, RoutedEventArgs e)
{
// если ни одного объекта не выделено, выходим
if (AgentsGrid.SelectedItem == null)
{
CallPopup("Не выбран агент");
return;
}
// получаем выделенный объект
dynamic deleteAgent = AgentsGrid.SelectedItem;
int IDAgent = deleteAgent.IDAgent;
Agent c = db.Agents.Find(IDAgent);
if (c != null)
{
db.Agents.Remove(c);
db.SaveChanges();
}
FillDataGrid();
}
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 ButtonDeleteBuyer_Click(object sender, RoutedEventArgs e)
{
// если ни одного объекта не выделено, выходим
if (BuyersGrid.SelectedItem == null)
{
CallPopup("Не выбран покупатель");
return;
}
// получаем выделенный объект
dynamic deleteBuyer = BuyersGrid.SelectedItem;
int IDBuyer = deleteBuyer.IDBuyer;
Client c = db.Clients.Find(IDBuyer);
if (c != null)
{
db.Clients.Remove(c);
db.SaveChanges();
}
FillDataGrid();
}
private void ButtonDeleteLandlord_Click(object sender, RoutedEventArgs e)
{
// если ни одного объекта не выделено, выходим
if (LandlordsGrid.SelectedItem == null)
{
CallPopup("Не выбран арендодатель");
return;
}
// получаем выделенный объект
dynamic deleteLandlord = LandlordsGrid.SelectedItem;
int IDLandlord = deleteLandlord.IDLandlord;
Client c = db.Clients.Find(IDLandlord);
if (c != null)
{
db.Clients.Remove(c);
db.SaveChanges();
}
FillDataGrid();
}
private void ButtonDeleteTrade_Click(object sender, RoutedEventArgs e)
{
// если ни одного объекта не выделено, выходим
if (SaleTradeGrid.SelectedItem == null)
{
CallPopup("Не выбрана сделка");
return;
}
// получаем выделенный объект
dynamic deleteSale = SaleTradeGrid.SelectedItem;
int IDSale = deleteSale.IDSale;
Trade c = db.Trades.Find(IDSale);
if (c != null)
{
db.Trades.Remove(c);
db.SaveChanges();
}
FillDataGrid();
}
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 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();
}
private void ButtonDeliteStatus_Click(object sender, RoutedEventArgs e)
{
// если ни одного объекта не выделено, выходим
if (StatusGrid.SelectedItem == null)
{
return;
}
// получаем выделенный объект
dynamic deleteStatus = StatusGrid.SelectedItem;
int IDstatus = deleteStatus.IDstatus;
Status c = db.Status.Find(IDstatus);
if (c != null)
{
db.Status.Remove(c);
db.SaveChanges();
}
FillDataGrid();
}
