public FormBuildings() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Budynki .Select(x => new BuildingsData { identyfikator_budynku = x.id_budynku, adres_budynku = x.adres_budynku }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormFirms() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Firmy .Select(x => new FirmsData { identyfikator_firmy = x.id_firmy, NIP = x.NIP, numer_telefonu = x.nr_telefonu, nazwa_firmy = x.nazwa_firmy }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormSurveillances() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Dozorowania .Select(x => new SurveillancesData { identyfikator_dozorcy = x.id_dozorcy, identyfikator_budynku = x.id_budynku, data_rozpoczecia = x.data_rozpoczecia ?? new DateTime(), data_zakonczenia = x.data_zakonczenia ?? new DateTime() }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormFaults() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Usterki .Select(x => new FaultsData { identyfikator_usterki = x.id_usterki, identyfikator_mieszkania = x.id_mieszkania ?? 0, opis = x.opis, stan = x.stan }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormPayments() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Platnosci .Select(x => new PaymentsData { identyfikator_platnosci = x.id_platnosci, identyfikator_wynajmnu = x.id_wynajmu ?? 0, data_platnosci = x.data_platnosci ?? new DateTime(), cena = x.cena, tytul = x.tytul }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormCaretakers() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Dozorcy .Select(x => new CaretakersData { identyfikator_dozorcy = x.id_dozorcy, numer_telefonu = x.nr_telefonu, imie = x.Imie, nazwisko = x.Nazwisko, PESEL = x.PESEL }) .ToList()); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }
public FormRepaireFactures() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .FakturyNapraw .Select(x => new RepairFacturesData { identyfikator_faktury = x.id_faktury, identyfikator_naprawy = x.id_naprawy ?? 0, cena = x.cena, numer_faktury = x.numer_faktury, data_platnosci = x.data_platnosci ?? new DateTime(), }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormFlats() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Mieszkania .Select(x => new FlatsData { identyfikator_mieszkania = x.id_mieszkania, identyfikator_budynku = x.id_budynku ?? 0, numer = x.numer, metraz = x.metraz ?? 0, opis = x.opis }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormRentals() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Wynajmy .Select(x => new RentalsData { identyfikator_wynajmnu = x.id_wynajmu, identyfikator_mieszkania = x.id_najemcy ?? 0, data_rozpoczecia = x.data_rozpoczecia ?? new DateTime(), data_zakończenia = x.data_zakonczenia ?? new DateTime(), identyfikator_najemcy = x.id_najemcy ?? 0, cena_miesieczna = x.cena_miesieczna ?? 0 }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
public FormRepairs() { InitializeComponent(); using (var DBContext = new CommunitySystemEntities()) { Dataset = (DBContext .Naprawy .Select(x => new RepairesData { identyfikator_naprawy = x.id_naprawy, identyfikator_usterki = x.id_usterki ?? 0, identyfikator_firmy = x.id_firmy ?? 0, stan = x.stan, data_zlecenia = x.data_zlecenia ?? new DateTime(), data_rozpoczecia = x.data_rozpoczecia ?? new DateTime(), data_zakonczenia = x.data_ukonczenia ?? new DateTime() }) .ToList()); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = Dataset; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }