private void Window_Loaded(object sender, RoutedEventArgs e) { RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Client> client = (from e1 in con.Clients select e1).ToList(); ClientGrid.ItemsSource = client; }
private void Window_Loaded(object sender, RoutedEventArgs e) { RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Estate> estates = (from e1 in con.Estates select e1).ToList(); EstateGrid.ItemsSource = estates; }
public static void AddEstate(Estate estate) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { conn.Estates.InsertOnSubmit(estate); conn.SubmitChanges(); } }
public static void AddClient(Client client) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { conn.Clients.InsertOnSubmit(client); conn.SubmitChanges(); } }
public static void AddAd(Ad ad) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { conn.Ads.InsertOnSubmit(ad); conn.SubmitChanges(); } }
public static void AddTransaction(Transaction transaction) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { conn.Transactions.InsertOnSubmit(transaction); conn.SubmitChanges(); } }
public ViewAds() { InitializeComponent(); RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Ad> transaction = (from e1 in con.Ads select e1).ToList(); AdGrid.ItemsSource = transaction; }
public ViewTransaction() { InitializeComponent(); RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Transaction> transaction = (from e1 in con.Transactions select e1).ToList(); TransactionGrid.ItemsSource = transaction; }
public static void DeleteClient(Client client) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { Client cli = (from c in conn.Clients where c.Id == client.Id select c).FirstOrDefault(); conn.Clients.DeleteOnSubmit(cli); conn.SubmitChanges(); } }
public AddAd() { InitializeComponent(); RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Estate> client = (from e1 in con.Estates select e1).ToList(); comboBox1.ItemsSource = client; comboBox1.DisplayMemberPath = "Name"; comboBox1.SelectedValuePath = "Id"; }
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 static void UpdateClient(Client client) { using (RealEstateDataDataContext conn = new RealEstateDataDataContext()) { Client cli = (from c in conn.Clients where c.Id == client.Id select c).FirstOrDefault(); cli.FirstName = client.FirstName; cli.LastName = client.LastName; 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; }
private void Window_Loaded(object sender, RoutedEventArgs e) { RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Client> client = (from e1 in con.Clients select e1).ToList(); EditClientt.ItemsSource = client; EditClientt.SelectionChanged += new SelectionChangedEventHandler(EditClienttSelectionChanged); EditClientt.IsReadOnly = true; show.IsEnabled = false; delete.IsEnabled = false; update.IsEnabled = false; }
public AddTransaction() { 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"; comboBox2.ItemsSource = client; comboBox2.DisplayMemberPath = "FirstName"; comboBox2.SelectedValuePath = "Id"; }
private void Window_Loaded(object sender, RoutedEventArgs e) { nameLabel.Content = client.FirstName.Trim() + " " + client.LastName.Trim(); RealEstateDataDataContext con = new RealEstateDataDataContext(); List<Estate> estates = (from e1 in con.Estates where e1.Owner == client.Id select e1).ToList(); EstateGrid.ItemsSource = estates; EstateGrid.IsReadOnly = true; int cl; cl = Convert.ToInt32(client.Id); count_moneyResult result = new count_moneyResult(); var a = (count_moneyResult)con.count_money(cl).SingleOrDefault(); nameLabe2.Content = a.Column1; }
private void findFilteredEstates() { float fee; float.TryParse(Fee.Text, out fee); RealEstateDataDataContext con = new RealEstateDataDataContext(); estates = (from e1 in con.Estates where e1.Fee >= fee select e1).ToList(); EditEstatee.ItemsSource = estates; }
private void Window_Loaded(object sender, RoutedEventArgs e) { con = new RealEstateDataDataContext(); estates = (from e1 in con.Estates select e1).ToList(); EditEstatee.ItemsSource = estates; EditEstatee.SelectionChanged += new SelectionChangedEventHandler(EditEstateeSelectionChanged); EditEstatee.IsManipulationEnabled = false; EditEstatee.IsReadOnly = true; show.IsEnabled = false; delete.IsEnabled = false; update.IsEnabled = false; //export.IsEnabled = false; }
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(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { RealEstateDataDataContext con = new RealEstateDataDataContext(); titleLabel.Content = estate.Name; nameField.Text = estate.Name; descriptionField.Text = estate.Description; feeField.Text = estate.Fee.ToString(); owner = con.Clients.Single(c => c.Id == estate.Owner); ownerField.Text = (owner.FirstName+" "+owner.LastName); byte[] barrImg = (byte[])estate.Photo.ToArray(); string strfn = Convert.ToString(DateTime.Now.ToFileTime()); FileStream fs1 = new FileStream(strfn, FileMode.CreateNew, FileAccess.Write); fs1.Write(barrImg, 0, barrImg.Length); fs1.Flush(); fs1.Close(); ImageSourceConverter imgs = new ImageSourceConverter(); image1.SetValue(System.Windows.Controls.Image.SourceProperty, imgs.ConvertFromString(strfn)); }