private void Button_Click(object sender, RoutedEventArgs e)
{
int state_p = 0;
if (state.SelectedValue.ToString() == "Продажа")
{
state_p = 1;
}
if (state.SelectedValue.ToString() == "Здача в аренду")
{
state_p = 2;
}
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
db.Add_apartment(Convert.ToDouble(area.Text), Convert.ToInt32(rooms.Text), Convert.ToDouble(price.Text), full_name.Text, adress.Text, Convert.ToInt32(balc.Text), Convert.ToInt32(globalTrash.rand.Next(100000000, 999999999)), state_p);
db.SaveChanges();
MessageBox.Show("квартира добавленна");
area.Text = "";
rooms.Text = "";
price.Text = "";
adress.Text = "";
balc.Text = "";
full_name.Text = "";
}
state_p = 0;
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
int state_ho = 0;
if (state_h.SelectedValue.ToString() == "Продажа")
{
state_ho = 1;
}
if (state_h.SelectedValue.ToString() == "Здача в аренду")
{
state_ho = 2;
}
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
db.Add_house(Convert.ToInt32(room.Text), Convert.ToInt32(floor.Text), Convert.ToInt32(area_h.Text), Convert.ToDouble(area_pl.Text), name.Text, addre.Text, Convert.ToInt32(globalTrash.rand.Next(100000000, 999999999)), state_ho, Convert.ToDouble(price.Text));
db.SaveChanges();
MessageBox.Show("Дом успешно добавлен");
room.Text = "";
floor.Text = "";
area_h.Text = "";
area_pl.Text = "";
name.Text = "";
addre.Text = "";
price.Text = "";
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
db.Add_worker(pos.SelectedValue.ToString(), Convert.ToInt32(passw.Text), Name.Text);
db.SaveChanges();
MessageBox.Show("рабочий добавлен");
passw.Text = "";
Name.Text = "";
}
}
private void Button_Click_8(object sender, RoutedEventArgs e)
{
string[] or = worker.SelectedItem.ToString().Split('\t');
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
db.Delete_worker(Convert.ToInt32(or[1]));
db.SaveChanges();
MessageBox.Show("Объект удалён");
fill_worker();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
db.Add_client(name.Text, ps_n.Text, is_by.Text, Convert.ToInt32(year.Text), Convert.ToInt32(day.Text), Convert.ToInt32(mouth.Text), pl_of_res.Text);
db.SaveChanges();
MessageBox.Show("Клиент добавлен");
name.Text = "";
ps_n.Text = "";
year.Text = "";
day.Text = "";
mouth.Text = "";
pl_of_res.Text = "";
}
}
private void Del_Click(object sender, RoutedEventArgs e)
{
if (type.SelectedValue.ToString() == "Квартира")
{
string[] ord = list.SelectedValue.ToString().Split('\t');
string key = client.SelectedValue.ToString();
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
var client_ID = db.client.Where(p => p.Full_name == key.ToString()).FirstOrDefault().ID_client;
int id = Convert.ToInt32(client_ID);
db.Add_deal_with_appartent(Convert.ToInt32(ord[13]), Convert.ToDouble(ord[1]), Convert.ToInt32(ord[5]), Convert.ToInt32(3), client.SelectedValue.ToString(), ord[9], Convert.ToDouble(ord[7]));
db.Delete_client(id);
db.Delete_apaetament(Convert.ToInt32(ord[13]));
db.SaveChanges();
MessageBox.Show("add");
}
fill_apartaments();
}
if (type.SelectedValue.ToString() == "Дом")
{
string[] ord = list.SelectedValue.ToString().Split('\t');
string key = client.SelectedValue.ToString();
using (Estate_agancyEntities1 db = new Estate_agancyEntities1())
{
var client_ID = db.client.Where(p => p.Full_name == key.ToString()).FirstOrDefault().ID_client;
int id = Convert.ToInt32(client_ID);
db.Add_deal_with_house(Convert.ToInt32(ord[15]), Convert.ToInt32(ord[5]), Convert.ToInt32(ord[7]), Convert.ToDouble(ord[3]), client.SelectedValue.ToString(), ord[11], Convert.ToDouble(ord[9]));
db.Delete_client(id);
db.Delete_house(Convert.ToInt32(ord[17]));
db.SaveChanges();
MessageBox.Show("add");
}
fill_house();
}
}
