public static void FileUploadComplete(object sender, DevExpress.Web.FileUploadCompleteEventArgs e) { #region Variables ct_plancta_Bus bus_ctacble = new ct_plancta_Bus(); ct_cbtecble_det_List ListaDet = new ct_cbtecble_det_List(); List <ct_cbtecble_det_Info> Lista_Det = new List <ct_cbtecble_det_Info>(); int cont = 0; decimal IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual); int IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa); #endregion Stream stream = new MemoryStream(e.UploadedFile.FileBytes); if (stream.Length > 0) { IExcelDataReader reader = null; reader = ExcelReaderFactory.CreateOpenXmlReader(stream); var SecDet = 1; #region Presupuesto while (reader.Read()) { if (!reader.IsDBNull(0) && cont > 0) { var IdCtaCble = Convert.ToString(reader.GetValue(1)); ct_plancta_Info infoCtaCble = bus_ctacble.get_info(IdEmpresa, IdCtaCble); if (infoCtaCble != null) { ct_cbtecble_det_Info info = new ct_cbtecble_det_Info { IdEmpresa = IdEmpresa, secuencia = SecDet++, IdCtaCble = IdCtaCble, Descripcion = infoCtaCble.pc_Cuenta, dc_Valor = Convert.ToDouble(reader.GetValue(2)) > 0 ? Convert.ToDouble(reader.GetValue(2)) : (Convert.ToDouble(reader.GetValue(3)) * -1), dc_Valor_debe = Convert.ToDouble(reader.GetValue(2)), dc_Valor_haber = Convert.ToDouble(reader.GetValue(3)) }; Lista_Det.Add(info); } } else { cont++; } } ListaDet.set_list(Lista_Det, IdTransaccionSession); #endregion } }