private void RefreshDataGrid(string findtext = "") { try { dtgMasters.DataSource = (from Masters in General.context.Masters where Masters.Name.Contains(findtext) || Masters.SurName.Contains(findtext) || Masters.Patronymic.Contains(findtext) || Masters.Phone.Contains(findtext) select new { Masters.ID, Masters.SurName, Masters.Name, Masters.Patronymic, Masters.Birthday, Masters.Phone, Masters.imagename }).ToList(); if (dtgMasters.RowCount > 0) { dtgMasters.Rows[0].Selected = true; } images = SettingsMasters.GetPicture(dtgMasters, out nameimages); }catch (Exception exp) { MessageBox.Show(exp.Message.ToString()); } }
private void btnFindDate_Click(object sender, EventArgs e) { var result = General.context.Masters.Select (x => new { x.ID, x.SurName, x.Name, x.Patronymic, x.Birthday, x.Phone, x.imagename }); DateTime Birthday = new DateTime(dtpClient.Value.Year, dtpClient.Value.Month, dtpClient.Value.Day); foreach (RadioButton rdb in this.Controls.OfType <RadioButton>()) { if (rdb.Checked) { switch (rdb.Text.ToString().Trim()) { case "≥": { dtgMasters.DataSource = result.Where(x => x.Birthday >= Birthday).Select (x => new { x.ID, x.SurName, x.Name, x.Patronymic, x.Birthday, x.Phone, x.imagename }).ToList(); break; } case "≤": { dtgMasters.DataSource = result.Where(x => x.Birthday <= Birthday).Select (x => new { x.ID, x.SurName, x.Name, x.Patronymic, x.Birthday, x.Phone, x.imagename }).ToList(); break; } case "=": { dtgMasters.DataSource = result.Where(x => x.Birthday == Birthday).Select (x => new { x.ID, x.SurName, x.Name, x.Patronymic, x.Birthday, x.Phone, x.imagename }).ToList(); break; } case "∀": RefreshDataGrid(); break; } } } images = SettingsMasters.GetPicture(dtgMasters, out nameimages); if (dtgMasters.RowCount != 0) { picBox.Image = SettingsMasters.CrutchImage(dtgMasters.Rows[0].Cells[6].FormattedValue.ToString().Trim()); } GetInfoCount(); }