private void btnSalvarCaixa_Click(object sender, EventArgs e) { var items = lbLoadAll.Items; if (items.Count == 0) { return; } var register = new CaixaRegister(); var amostraRegister = new AmostraRegister(); foreach (var item in items) { Caixa caixa = new Caixa(); Amostra amostra = (Amostra)item; amostra.Status = "Em analise"; caixa.IdAmostra = amostra.Id; register.Insert(caixa); amostraRegister.Edit(amostra); } FolhaForm form = new FolhaForm(); form.Owner = this; form.ShowDialog(); }
public FolhaForm() { InitializeComponent(); bindingSource1.CurrentChanged += new System.EventHandler(bindingSource1_CurrentChanged); var register = new CaixaRegister(); var records = register.SelectAll(); var amostra = records.Select(x => new Amostra { Id = Convert.ToInt32(x.Where(y => y.Key == "Id").FirstOrDefault().Value), Complemento = (string)x.Where(y => y.Key == "Complemento").FirstOrDefault().Value, GeoReferencia = (string)x.Where(y => y.Key == "GeoReferencia").FirstOrDefault().Value, IdCliente = (int)x.Where(y => y.Key == "IdCliente").FirstOrDefault().Value, IdSolicitante = Convert.ToInt32(x.Where(y => y.Key == "IdSolicitante").FirstOrDefault().Value), Status = (string)(x.Where(y => y.Key == "Status").FirstOrDefault().Value), TipoAnalise = (string)(x.Where(y => y.Key == "TipoAnalise").FirstOrDefault().Value), }); List <FolhaBase> folhaList = new List <FolhaBase>(); var count = 1; foreach (var item in amostra) { FolhaBase folha = new FolhaBase(); folha.Numero = count; folha.IdTipo = item.Id + "/" + item.TipoAnalise; folhaList.Add(folha); count++; } var dataTable = CreateDataTable(folhaList); foreach (DataColumn dc in dataTable.Columns) { AddColumns(dc); } foreach (DataRow dc in dataTable.Rows) { AddRows(dc); } count = 0; count = DisableCell(count, dataTable); dataGridView1.Refresh(); }