private void Add_Click(object sender, RoutedEventArgs e)
        {
            float number;
            int num;

            if (Name.Text.Trim() == "")
                MessageBox.Show("Missing name");
            if (Fee.Text.Trim() == "")
                MessageBox.Show("Missing fee");
            if (float.TryParse(Fee.Text, out number) == false)
                MessageBox.Show("You must enter a number");
            else
            {
                Estate estate = new Estate();
                estate.Name = Name.Text.Trim();
                estate.Description = Description.Text.Trim();
                estate.Fee = number;

                num = Convert.ToInt32(comboBox1.SelectedValue);
                if (Convert.ToString(File_Path.Text).Length > 0)
                {
                    FileStream photo = File.Open(Convert.ToString(File_Path.Text), FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
                    BinaryReader photoBinary = new BinaryReader(photo);
                    estate.Photo = photoBinary.ReadBytes((int)photo.Length);
                }
                estate.Owner = num;

                Admin.AddEstate(estate);
                MessageBox.Show(estate.Name + " was added");
                DialogResult = true;

            }
        }
 public static void AddEstate(Estate estate)
 {
     using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
     {
         conn.Estates.InsertOnSubmit(estate);
         conn.SubmitChanges();
     }
 }
        public static void DeleteEstate(Estate estate)
        {
            using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
            {
                Estate est = (from e1 in conn.Estates
                             where e1.Id == estate.Id
                             select e1).FirstOrDefault();
                conn.Estates.DeleteOnSubmit(est);
                conn.SubmitChanges();

            }
        }
        public UpdateEstate(Estate estate)
        {
            InitializeComponent();

            RealEstateDataDataContext con = new RealEstateDataDataContext();
            List<Client> client = (from e1 in con.Clients
                                   select e1).ToList();

            comboBox1.ItemsSource = client;
            comboBox1.DisplayMemberPath = "FirstName";
            comboBox1.SelectedValuePath = "Id";

            this.estate = estate;
        }
        public static void UpdateEstate(Estate estate)
        {
            using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
            {
                Estate est = (from e1 in conn.Estates
                              where e1.Id == estate.Id
                              select e1).FirstOrDefault();
                est.Name = estate.Name;
                est.Description = estate.Description;
                est.Fee = estate.Fee;
                est.Owner = estate.Owner;

                conn.SubmitChanges();
            }
        }
 public DetailsEstate(Estate estate)
 {
     InitializeComponent();
     this.estate = estate;
 }
 partial void DeleteEstate(Estate instance);
 partial void UpdateEstate(Estate instance);
 partial void InsertEstate(Estate instance);
		private void detach_Estates(Estate entity)
		{
			this.SendPropertyChanging();
			entity.Client = null;
		}
		private void attach_Estates(Estate entity)
		{
			this.SendPropertyChanging();
			entity.Client = this;
		}