private void Search() { var personList = new List <Person>(); var lokalizacje = LokalizacjaHelper.DajDozwoloneLokalizacje(_lokalizacja); using (var ctx = new MineContext()) { personList = ctx.Persons.Include(x => x.Binocles).Include(y => y.Binocles.Select(z => z.Doplaty)).Where(x => lokalizacje.Contains(x.Lokalizacja)).ToList(); } //TODO: refactor above query??? //https://stackoverflow.com/questions/7259567/linq-to-entities-does-not-recognize-the-method/7259649 var doWyswietlenia = personList.Where(x => x.Binocles.Any(y => _priceHelper.CzyZbalansowany(y))).ToList(); //zmienić jak w Nieodebrane...czyli przenieść logikę do pobrania wyżej zamiast pobierać wszystkich ludzi dataGridView1.DataSource = doWyswietlenia; dataGridView1.Columns["Binocles"].Visible = false; dataGridView1.Columns["PersonId"].Visible = false; dataGridView1.RowHeadersVisible = true; dataGridView1.RowHeadersWidth = 60; dataGridView1.Columns["FirstName"].HeaderText = "Imię"; dataGridView1.Columns["LastName"].HeaderText = "Nazwisko"; dataGridView1.Columns["Address"].HeaderText = "Adres"; dataGridView1.Columns["Address"].Width = 240; dataGridView1.Columns["BirthDate"].HeaderText = "Data urodzenia"; dataGridView1.Columns["Lokalizacja"].Width = 75; if (!dataGridView1.Columns.Contains("ZamowieniaNazwa")) { DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.UseColumnTextForButtonValue = true; col.Text = "Zamówienia"; col.Name = "ZamowieniaNazwa"; col.HeaderText = "Zamówienia"; dataGridView1.Columns.Add(col); } if (!dataGridView1.Columns.Contains("UsunCol")) { DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.UseColumnTextForButtonValue = true; col.Visible = true; col.Text = "Usuń"; col.Name = "UsunCol"; dataGridView1.Columns.Add(col); } dataGridView1.Columns["UsunCol"].Visible = true; dataGridView1.Columns["UsunCol"].HeaderText = "Usuń"; SetRowNumber(dataGridView1); }
private void Laduj() { var binocleList = new List <Binocle>(); //using (var ctx = new MineContext()) //{ binocleList = _context.Binocles.Include(x => x.Doplaty).Where(x => x.Person_PersonId == _personId).ToList(); //} dataGridView1.DataSource = binocleList; for (int i = 0; i < dataGridView1.Columns.Count; i++) { dataGridView1.Columns[i].Visible = false; } dataGridView1.Columns["BuyDate"].Visible = true; dataGridView1.Columns["BuyDate"].HeaderText = "Data zakupu"; if (!dataGridView1.Columns.Contains("ZakupCol")) { DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.UseColumnTextForButtonValue = true; col.Visible = true; col.Text = "Zakup"; col.Name = "ZakupCol"; dataGridView1.Columns.Add(col); } dataGridView1.Columns["ZakupCol"].Visible = true; dataGridView1.Columns["ZakupCol"].HeaderText = "Zakup"; if (!dataGridView1.Columns.Contains("UsunCol")) { DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.UseColumnTextForButtonValue = true; col.Visible = true; col.Text = "Usuń"; col.Name = "UsunCol"; dataGridView1.Columns.Add(col); } dataGridView1.Columns["UsunCol"].Visible = true; dataGridView1.Columns["UsunCol"].HeaderText = "Usuń"; foreach (var row in dataGridView1.Rows) { if (_fromWhereOpened == FromWhereConsts.ZBALANSOWANI) { if (_priceHelper.CzyZbalansowany((Binocle)((DataGridViewRow)row).DataBoundItem)) { ((DataGridViewRow)row).DefaultCellStyle.BackColor = Color.Crimson; } } if (_fromWhereOpened == FromWhereConsts.ODEBRANIE) { if (!_orderHelper.CzyOdebrany((Binocle)((DataGridViewRow)row).DataBoundItem)) { ((DataGridViewRow)row).DefaultCellStyle.BackColor = Color.DarkViolet; } } } }