private void bg_DoWork(object sender, DoWorkEventArgs e) { totalEmpleadosProcesar = datos.Count; //Se debe crear lista de InfoFieldBook para cargarlas foreach (var item in datos) { itemInfoField.BreedersInstructions1 = item.Bi1; itemInfoField.BreedersInstructions2 = item.Bi2; itemInfoField.BreedersInstructions3 = item.Bi3; itemInfoField.BreedersInstructions4 = item.Bi4; itemInfoField.cc = item.Cc; itemInfoField.client = item.Client; itemInfoField.codInternacion = item.CodInternacion; itemInfoField.CodPermanencia = item.CodPermanencia; itemInfoField.codReception = item.CodReception; itemInfoField.country = item.Country; itemInfoField.crop = item.Crop; itemInfoField.ent = item.Ent; itemInfoField.EntName = item.EntName; itemInfoField.EntRole = item.EntRole; itemInfoField.euid = item.Euid; itemInfoField.fechaCarga = DateTime.Now; itemInfoField.gmoEvent = item.GmoEvent; itemInfoField.GranosHilera = int.Parse(item.GranosHilera); itemInfoField.indEuid = ""; itemInfoField.instructions = ""; itemInfoField.location = item.Location; itemInfoField.LotId = item.LotId; itemInfoField.obs = item.Obs; itemInfoField.opExpName = item.ExpName; itemInfoField.Owner = item.Owner; itemInfoField.plt = item.Plt; itemInfoField.projecLead = item.ProjectLead; itemInfoField.projectCode = item.ProjectCode; itemInfoField.ResImportation = item.ResImportacion; itemInfoField.rng = item.Rng; itemInfoField.sag = item.Sag; itemInfoField.year = item.Year; listaSplit.Add(itemInfoField); itemInfoField = new InfoFieldBook(); progreso++; //Aumentando el progreso porciento = Convert.ToInt16((((double)progreso / (double)totalEmpleadosProcesar) * 100.00)); //Calculo del porcentaje bg.ReportProgress(porciento); } EntryListBusiness.InsertBulk(datos); InfoFieldBookBusiness.InsertBulk(listaSplit); }
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 != "") { try { datos = FuncionesExcel.GetData(pathFile); var val = InfoFieldBookBusiness.ValidateIndEuids(datos); if (!val) { insertados = datos.Count; InfoFieldBookBusiness.InsertBulk(datos); } //Validación Inicial //foreach (var item in datos) //{ // infoF = InfoFieldBookBusiness.GetIndEuid(item.indEuid, item.euid); // if (infoF != null) // { // //infoF.Id = infoF.Id; // //infoF.cc = item.cc; // //infoF.client = item.client; // //infoF.codInternacion = item.codInternacion; // //infoF.CodPermanencia = item.CodPermanencia; // //infoF.codReception = item.codReception; // //infoF.country = item.country; // //infoF.crop = item.crop; // //infoF.ent = item.ent; // //infoF.EntName = item.EntName; // //infoF.EntRole = item.EntRole; // //infoF.gmoEvent = item.gmoEvent; // //infoF.GranosHilera = item.GranosHilera; // //infoF.instructions = item.instructions; // //infoF.location = item.location; // //infoF.LotId = item.LotId; // //infoF.opExpName = item.opExpName; // //infoF.order = item.order; // //infoF.Owner = item.Owner; // //infoF.plt = item.plt; // //infoF.ResImportation = item.ResImportation; // //infoF.rng = item.rng; // //infoF.sag = item.sag; // //infoF.year = item.year; // infoF.breedersCode1 = item.breedersCode1; // infoF.breedersCode2 = item.breedersCode2; // infoF.breedersCode3 = item.breedersCode3; // infoF.breedersCode4 = item.breedersCode4; // infoF.BreedersInstructions1 = item.BreedersInstructions1; // infoF.BreedersInstructions2 = item.BreedersInstructions2; // infoF.BreedersInstructions3 = item.BreedersInstructions3; // infoF.BreedersInstructions4 = item.BreedersInstructions4; // infoF.fechaModificacion = (DateTime?)DateTime.Now; // infoF.projecLead = item.projecLead; // infoF.projectCode = item.projectCode; // infoF.shelling = item.shelling; // infoF.shipTo = item.shipTo; // infoF.targears = item.targears; // infoF.targetKern = item.targetKern; // infoF.targetWg = item.targetWg; // infoF.obs = item.obs; // existentes.Add(infoF); // modificados++; // } // else // { // infoF = new InfoFieldBook(); // infoF = item; // infoF.fechaCarga = DateTime.Now; // nuevos.Add(infoF); // insertados++; // } //} grdDetalle.AutoGenerateColumns = false; grdDetalle.DataSource = datos; grdDetalle.ClearSelection(); lblEuids.Text = "N° Filas : " + grdDetalle.RowCount.ToString(); btnProcesar.Enabled = true; } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Módulo Carga Field Book", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } }