private List <Client> RefreshGrid() { var register = new ClientRegister(); var records = register.SelectAll(); var clients = records.Select(x => new Client { Id = Convert.ToInt32(x.Where(y => y.Key == "Id").FirstOrDefault().Value), CellPhone = (string)x.Where(y => y.Key == "CellPhone").FirstOrDefault().Value, City = (string)x.Where(y => y.Key == "City").FirstOrDefault().Value, Name = (string)x.Where(y => y.Key == "Name").FirstOrDefault().Value, Registration = Convert.ToInt32(x.Where(y => y.Key == "Registration").FirstOrDefault().Value), State = (string)(x.Where(y => y.Key == "State").FirstOrDefault().Value), }); return(clients.ToList()); }
public AnalysisForm() { InitializeComponent(); bindingSource1.CurrentChanged += new System.EventHandler(cbQtdAmostra_DropDownClosed); //bindingSource1.DataSource = new List<Analise>(); var register = new ClientRegister(); var records = register.SelectAll(); var clients = records.Select(x => new Client { Id = Convert.ToInt32(x.Where(y => y.Key == "Id").FirstOrDefault().Value), CellPhone = (string)x.Where(y => y.Key == "CellPhone").FirstOrDefault().Value, City = (string)x.Where(y => y.Key == "City").FirstOrDefault().Value, Name = (string)x.Where(y => y.Key == "Name").FirstOrDefault().Value, Registration = Convert.ToInt32(x.Where(y => y.Key == "Registration").FirstOrDefault().Value), State = (string)(x.Where(y => y.Key == "State").FirstOrDefault().Value), }); cbCliente.DataSource = clients.ToList(); cbSolicitante.DataSource = clients.ToList(); cbSolicitante.SelectedIndex = -1; cbCliente.SelectedIndex = -1; var tipoAnalise = new TipoAnalise(); cbTipoAnalise.DataSource = tipoAnalise.Tipos; cbTipoAnalise.SelectedIndex = -1; var qtdAmostra = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 // total de vinte amostras pode ser alterado. }; cbQtdAmostra.DataSource = qtdAmostra; cbQtdAmostra.SelectedIndex = -1; }