private void CargaArchivo() { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "xlsx files (*.xlsx)|*.xlsx"; if (openFileDialog.ShowDialog() == DialogResult.OK) { pathFile = openFileDialog.FileName; //lblFile.Text = pathFile; } if (pathFile != "") { datos = FuncionesExcel.GetEntryListFile(pathFile); var resumen = (from EntryList in datos group EntryList by new { EntryList.Year, EntryList.Country, EntryList.Location, EntryList.ExpName, EntryList.Client, EntryList.Crop } into g select new { g.Key.Year, g.Key.Country, N_Euid = g.Count(p => p.Euid != null), g.Key.Location, g.Key.ExpName, g.Key.Client, g.Key.Crop }).ToList(); grdResumen.AutoGenerateColumns = false; grdResumen.DataSource = resumen; grdResumen.ClearSelection(); grdResumen.Text = "N° Filas : " + grdResumen.RowCount.ToString(); if (resumen.Count == 1) { var existe = InfoLocBusiness.GetLocByCuartel(resumen[0].Location.ToString()).FirstOrDefault(); if (existe != null) { grdeuids.AutoGenerateColumns = false; grdeuids.DataSource = datos; grdeuids.ClearSelection(); btnProcesar.Enabled = true; } } else { btnProcesar.Enabled = false; grpSplit.Enabled = false; } } }
private void LlenaComboLocation() { var data = new List <InfoLocDto>(); data = InfoLocBusiness.GetLocsByEmpresa(usuarioValido.id_empresa); cboLocation.ValueMember = "Id"; cboLocation.DisplayMember = "LocationCuartel"; cboLocation.DataSource = data; cboLocation.Refresh(); }
private void ActualizaLocalidades() { FrmTemplateEntryList frm = (FrmTemplateEntryList)Application.OpenForms["FrmTemplateEntryList"]; GroupBox grp = (GroupBox)frm.Controls["grpLocation"]; ComboBox cb = (ComboBox)grp.Controls["cboLocation"]; var data = InfoLocBusiness.GetLocs(); cb.ValueMember = "Id"; cb.DisplayMember = "LocationCuartel"; cb.DataSource = data; }
public void LlenaComboLocation() { cboLocation.DataSource = null; cboLocation.Refresh(); var data = new List <InfoLocDto>(); data = InfoLocBusiness.GetLocs(); cboLocation.ValueMember = "Id"; cboLocation.DisplayMember = "LocationCuartel"; cboLocation.DataSource = data; cboLocation.Refresh(); }
private void CreaEntidad() { InfoLoc NewLoc = new InfoLoc { CaudalGoterosLtsSeg = txtCaudalGoteros.Text, CodigoPoligono = txtCodigoPoligono.Text, DireccionGd = txtDireccionGd.Text, DistEntreHileraM = decimal.Parse(txtDistEntreHileras.Text), DistGoterosM = txtDistGoteros.Text, DistSobreHileraM = decimal.Parse(txtDistSobreHilera.Text), FechaCarga = DateTime.Now, FechaEstCosecha = dtpCosecha.Value, id_crop = (int)cboCrop.SelectedValue, id_estado = (int)cboCrop.SelectedValue, id_farm = SubFarmSelected.Id, id_tipo_agro = (int)cboTipo.SelectedValue, Jaula = txtJaula.Text.ToUpper(), Latitud = txtLatitud.Text, LineaRiego = txtLineaRiego.Text, LocationCuartel = txtLocation.Text.ToUpper(), Longitud = txtLongitud.Text, Owner = 5, SuperficieHa = decimal.Parse(txtSuperficie.Text), TotLineaRiegoM = txtTotalLineaRiego.Text, Year = int.Parse(txtAnio.Text), Gmo = chkGmo.Checked }; if (txtSemillero.Text == "") { NewLoc.CodSemillero = null; } else { NewLoc.CodSemillero = txtSemillero.Text.ToUpper(); } if (cboTipo.Text == "FRUT") { NewLoc.FechaPlantacion = dtpPlantacion.Value; NewLoc.FechaSiembra = null; NewLoc.FechaTransplante = null; } else { NewLoc.FechaPlantacion = null; NewLoc.FechaSiembra = dtpSiembra.Value; NewLoc.FechaTransplante = dtpTransplante.Value; } try { InfoLocBusiness.Insert(NewLoc); MessageBox.Show("Localidad Creada ", "Módulo Nueva Localidad", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); ActualizaLocalidades(); Thread.Sleep(1500); this.Close(); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Módulo Nueva Localidad", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }