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; }