/*Delete*/ public string DelVentas(BEVentas BE) { string respuesta = string.Empty; try { using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_MANT_VENTAS_DEL")) { dbSQL.AddInParameter(dbCmd, "@idVentas", DbType.String, BE.idVentas); dbSQL.AddInParameter(dbCmd, "@correlativo", DbType.String, BE.numero); using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { int index1 = dataReader.GetOrdinal("respuesta"); object[] values = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(values); respuesta = values[index1] == DBNull.Value ? string.Empty : values[index1].ToString(); } } return(respuesta.Substring(0, 1)); } } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false); return("0"); } finally { } }
protected void applyRules() { IVentas IService = new IVentas(); List <BEVentas> lstBE = new List <BEVentas>(); BEVentas BEVenta = new BEVentas(); BEVenta.codLocal = ddlLocales.SelectedValue; BEVenta.codPeriodo = ddlPeriodos.SelectedValue; /**/ BEVenta.tipoPrmSearch = Convert.ToInt32(ddlTipoPrm.SelectedValue); BEVenta.textPrmSearch = txtPrmSearch.Text.Trim(); if (chkRangeDate.Checked) { BEVenta.prmDesde = txtDesde.Text; BEVenta.prmHasta = txtHasta.Text; } /**/ lstBE = IService.IGetVentas(BEVenta); List <BEVentas> lstBE2 = new List <BEVentas>(); lstBE2 = IService.IaplicarReglas(lstBE); IService.IUpdListHotels(lstBE2); gvHotels.DataSource = lstBE2; gvHotels.DataBind(); /*List<BEHotel> lstBE2 = (List<BEHotel>)this.gvHotels.DataSource; * gvHotels.DataSource = IService.IInsListHotels(lstBE2); * gvHotels.DataBind();*/ }
protected void loadGridHotel(int npageIndex = 0) { IHotels IServiceHotel = new IHotels(); BEHotel BEHotel = new BEHotel(); IVentas IService = new IVentas(); BEVentas BE = new BEVentas(); BE.codLocal = ddlLocales.SelectedValue; BE.codPeriodo = ddlPeriodos.SelectedValue; BEHotel.codLocal = ddlLocales.SelectedValue; BEHotel.codPeriodo = ddlPeriodos.SelectedValue; /**/ BE.tipoPrmSearch = Convert.ToInt32(ddlTipoPrm.SelectedValue); //if (rdoNombre.Checked) // BE.tipoPrmSearch = 1; //if (rdoApellido.Checked) // BE.tipoPrmSearch = 2; //if (rdoFicha.Checked) // BE.tipoPrmSearch = 3; //if (rdoSerie.Checked) // BE.tipoPrmSearch = 4; //if (rdoCorrelativo.Checked) // BE.tipoPrmSearch = 5; BE.textPrmSearch = txtPrmSearch.Text.Trim(); if (chkRangeDate.Checked) { BE.prmDesde = txtDesde.Text; BE.prmHasta = txtHasta.Text; } /**/ gvHotels.DataSource = IService.IGetVentas(BE); gvHotels.PageIndex = npageIndex; gvHotels.DataBind(); txtBaseImponible.Text = IServiceHotel.IGetImponible(BEHotel, "1"); txtCantDoc.Text = IServiceHotel.IGeNumeroDocumentos(BEHotel, "V"); txtIGVTot.Text = IServiceHotel.IGeIGVVentas(BEHotel); }
protected void loadListErrors() { IVentas IService = new IVentas(); List <BEVentas> lstBE = new List <BEVentas>(); BEVentas BEVentas = new BEVentas(); BEVentas.codLocal = ddlLocales.SelectedValue; BEVentas.codPeriodo = ddlPeriodos.SelectedValue; /**/ BEVentas.tipoPrmSearch = Convert.ToInt32(ddlTipoPrm.SelectedValue); BEVentas.textPrmSearch = txtPrmSearch.Text.Trim(); if (chkRangeDate.Checked) { BEVentas.prmDesde = txtDesde.Text; BEVentas.prmHasta = txtHasta.Text; } /**/ lstBE = IService.IGetVentas(BEVentas); lstErrorList.DataSource = IService.IvalidarCaracteres(lstBE); lstErrorList.DataBind(); }
/*Insert*/ public string InsVentasBL(BEVentas BE) { return(DA.InsVentas(BE)); }
/*Select*/ public List <BEVentas> GetVentasBL(BEVentas BE) { return(DA.GetVentas(BE)); }
/*Delete*/ public string IDelVentas(BEVentas BEVenta) { return(BL.DelVentasBL(BEVenta)); }
/*Update*/ public string IUpdVentas(BEVentas BEVenta) { return(BL.UpdVentasBL(BEVenta)); }
/*Insert*/ public string IInsVentas(BEVentas BEVenta) { return(BL.InsVentasBL(BEVenta)); }
/*Select*/ public List <BEVentas> IGetVentas(BEVentas BEVenta) { return(BL.GetVentasBL(BEVenta)); }
/*Update*/ public string UpdVentas(BEVentas BE) { string respuesta = string.Empty; try { BEHotel User = new BEHotel(); using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_MANT_VENTAS_UPD")) { dbSQL.AddInParameter(dbCmd, "@idVentas", DbType.String, BE.idVentas.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipoVenta", DbType.String, BE.tipoVenta.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipo", DbType.String, BE.tipo.ToUpper()); dbSQL.AddInParameter(dbCmd, "@fechaEmision", DbType.String, BE.fechaEmision.ToUpper()); dbSQL.AddInParameter(dbCmd, "@serie", DbType.String, BE.serie.ToUpper()); dbSQL.AddInParameter(dbCmd, "@numero", DbType.String, BE.numero.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipoPersona", DbType.String, BE.tipoPersona.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipoDocPersona", DbType.String, BE.tipoDocPersona.ToUpper()); dbSQL.AddInParameter(dbCmd, "@numDocumento", DbType.String, BE.numDocumento.ToUpper()); dbSQL.AddInParameter(dbCmd, "@razonSocialCliente", DbType.String, BE.razonSocialCliente.ToUpper()); dbSQL.AddInParameter(dbCmd, "@apePaterno", DbType.String, BE.apePaterno.ToUpper()); dbSQL.AddInParameter(dbCmd, "@apeMaterno", DbType.String, BE.apeMaterno.ToUpper()); dbSQL.AddInParameter(dbCmd, "@nombre1", DbType.String, BE.nombre1.ToUpper()); dbSQL.AddInParameter(dbCmd, "@nombre2", DbType.String, BE.nombre2.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipoMoneda", DbType.String, BE.tipoMoneda.ToUpper()); dbSQL.AddInParameter(dbCmd, "@codDestino", DbType.String, BE.codDestino.ToUpper()); dbSQL.AddInParameter(dbCmd, "@numeroDestino", DbType.String, BE.numeroDestino.ToUpper()); dbSQL.AddInParameter(dbCmd, "@baseImponibleOperGravada", DbType.String, BE.baseImponibleOperGravada.ToUpper()); dbSQL.AddInParameter(dbCmd, "@isc", DbType.String, BE.isc.ToUpper()); dbSQL.AddInParameter(dbCmd, "@igv", DbType.String, BE.igv.ToUpper()); dbSQL.AddInParameter(dbCmd, "@otros", DbType.String, BE.otros.ToUpper()); dbSQL.AddInParameter(dbCmd, "@indicePercepcion", DbType.String, BE.indicePercepcion.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tasaPercepcion", DbType.String, BE.tasaPercepcion.ToUpper()); dbSQL.AddInParameter(dbCmd, "@seriePercepcion", DbType.String, BE.seriePercepcion.ToUpper()); dbSQL.AddInParameter(dbCmd, "@numDocPercepcion", DbType.String, BE.numDocPercepcion.ToUpper()); dbSQL.AddInParameter(dbCmd, "@tipoTabla10", DbType.String, BE.tipoTabla10.ToUpper()); dbSQL.AddInParameter(dbCmd, "@serieDocOriginal", DbType.String, BE.serieDocOriginal.ToUpper()); dbSQL.AddInParameter(dbCmd, "@numDocOriginal", DbType.String, BE.numDocOriginal.ToUpper()); dbSQL.AddInParameter(dbCmd, "@fechaDocOriginal", DbType.String, BE.fechaDocOriginal.ToUpper()); dbSQL.AddInParameter(dbCmd, "@baseImponibleOperGravadaNC", DbType.String, BE.baseImponibleOperGravadaNC.ToUpper()); dbSQL.AddInParameter(dbCmd, "@IGVNC", DbType.String, BE.IGVNC.ToUpper()); dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, BE.codLocal.ToUpper()); //dbSQL.AddInParameter(dbCmd, "@Num_SAP", DbType.String, BE.Num_SAP.ToUpper()); //dbSQL.AddInParameter(dbCmd, "@Fec_Contabilizacion", DbType.String, BE.Fec_Contabilizacion.ToUpper()); //dbSQL.AddInParameter(dbCmd, "@Uni_Negocio", DbType.String, BE.Uni_Negocio.ToUpper()); using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { int index1 = dataReader.GetOrdinal("respuesta"); object[] values = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(values); respuesta = values[index1] == DBNull.Value ? string.Empty : values[index1].ToString(); } } return(respuesta); } } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false); return("0|" + ex.Message); } finally { } }
public static string DelVentas(BEVentas obj) { IVentas IService = new IVentas(); return(IService.IDelVentas(obj)); }
public static string InsUpdVentas(BEVentas obj) { IVentas IService = new IVentas(); return(obj.idVentas == "0" ? IService.IInsVentas(obj) : IService.IUpdVentas(obj)); }
public string VentasImportBL(string filename, string delimiter, BEUser userLocal) { // Create the new table HotelsDA DA = new HotelsDA(); string[] nombreArchivo = filename.Split('\\'); int index = nombreArchivo.Length - 1; string resp; string idarchivo = ""; try { if (DA.ValidarArchivosCargados(nombreArchivo[index]) == "0") { //if (DA.InsArchivoCaragado(filename) == "1") resp = DA.InsArchivoCaragado(nombreArchivo[index], ref idarchivo); if (resp == "1") { List <BELocal> lstLocales = new List <BELocal>(); lstLocales = DA.GetLocales(); List <BEVentas> lstVentas = new List <BEVentas>(); BEVentas beVenta = new BEVentas(); List <string> lista = new List <string>(); //obtengo los datos del fichero. using (StreamReader fic = new StreamReader(filename)) { string linea = null; linea = fic.ReadLine(); while ((linea != null)) { lista.Add(linea); linea = fic.ReadLine(); } fic.Close(); } foreach (string registro in lista) { string[] columnNames = null; beVenta = new BEVentas(); columnNames = registro.Split('|'); if (columnNames.Length <= 1) { throw new Exception("Existe una linea no valida"); } beVenta.Num_SAP = columnNames[0].Trim().ToUpper(); beVenta.Fec_Contabilizacion = columnNames[1].Trim().ToUpper(); beVenta.Uni_Negocio = columnNames[2].Trim().ToUpper(); beVenta.tipoVenta = columnNames[3].Trim().ToUpper(); beVenta.fechaEmision = columnNames[5].Trim().ToUpper(); beVenta.tipo = columnNames[4].Trim().ToUpper(); beVenta.serie = columnNames[6].Trim().ToUpper(); beVenta.numero = columnNames[7].Trim().ToUpper(); beVenta.tipoPersona = columnNames[8].Trim().ToUpper(); beVenta.tipoDocPersona = columnNames[9].Trim().ToUpper(); beVenta.numDocumento = columnNames[10].Trim().ToUpper(); beVenta.razonSocialCliente = columnNames[11].Trim().ToUpper(); beVenta.apePaterno = columnNames[12].Trim().ToUpper(); beVenta.apeMaterno = columnNames[13].Trim().ToUpper(); beVenta.nombre1 = columnNames[14].Trim().ToUpper(); beVenta.nombre2 = columnNames[15].Trim().ToUpper(); beVenta.tipoMoneda = columnNames[16].Trim().ToUpper(); beVenta.codDestino = columnNames[17].Trim().ToUpper(); beVenta.numeroDestino = columnNames[18].Trim().ToUpper(); beVenta.baseImponibleOperGravada = columnNames[19].Trim().ToUpper(); beVenta.isc = columnNames[20].Trim().ToUpper(); beVenta.igv = columnNames[21].Trim().ToUpper(); beVenta.otros = columnNames[22].Trim().ToUpper(); beVenta.indicePercepcion = columnNames[23].Trim().ToUpper(); beVenta.tasaPercepcion = columnNames[24].Trim().ToUpper(); beVenta.seriePercepcion = columnNames[25].Trim().ToUpper(); beVenta.numDocPercepcion = columnNames[26].Trim().ToUpper(); beVenta.tipoTabla10 = columnNames[27].Trim().ToUpper(); beVenta.serieDocOriginal = columnNames[28].Trim().ToUpper(); beVenta.numDocOriginal = columnNames[29].Trim().ToUpper(); beVenta.fechaDocOriginal = columnNames[30].Trim().ToUpper(); beVenta.baseImponibleOperGravadaNC = columnNames[31].Trim().ToUpper(); beVenta.IGVNC = columnNames[32].Trim().ToUpper(); lstVentas.Add(beVenta); } VentasBL BL = new VentasBL(); lstVentas = BL.aplicarReglas(lstVentas); //Log_ImportarDA LOGIDA = new Log_ImportarDA(); //LOGIDA.Limpiar_Log(); VentasDA DAVenta = new VentasDA(); return(DAVenta.INSListVentas(lstVentas, userLocal, idarchivo)); } else { throw new Exception(resp); } } else { throw new Exception("El archivo ya se cargo anteriormente"); } } catch (Exception ex) { return("0| " + ex.Message); } }
public string UpdListVentas(List <BEVentas> lstVentas) { string respuesta = string.Empty; try { BEVentas User = new BEVentas(); using (TransactionScope scope = new TransactionScope()) { foreach (BEVentas users in lstVentas) { using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_MANT_VENTAS_UPD")) { dbSQL.AddInParameter(dbCmd, "@idVentas", DbType.String, users.idVentas); dbSQL.AddInParameter(dbCmd, "@tipoVenta", DbType.String, users.tipoVenta); dbSQL.AddInParameter(dbCmd, "@tipo", DbType.String, users.tipo); dbSQL.AddInParameter(dbCmd, "@fechaEmision", DbType.String, users.fechaEmision); dbSQL.AddInParameter(dbCmd, "@serie", DbType.String, users.serie); dbSQL.AddInParameter(dbCmd, "@numero", DbType.String, users.numero); dbSQL.AddInParameter(dbCmd, "@tipoPersona", DbType.String, users.tipoPersona); dbSQL.AddInParameter(dbCmd, "@tipoDocPersona", DbType.String, users.tipoDocPersona); dbSQL.AddInParameter(dbCmd, "@numDocumento", DbType.String, users.numDocumento); dbSQL.AddInParameter(dbCmd, "@razonSocialCliente", DbType.String, users.razonSocialCliente); dbSQL.AddInParameter(dbCmd, "@apePaterno", DbType.String, users.apePaterno); dbSQL.AddInParameter(dbCmd, "@apeMaterno", DbType.String, users.apeMaterno); dbSQL.AddInParameter(dbCmd, "@nombre1", DbType.String, users.nombre1); dbSQL.AddInParameter(dbCmd, "@nombre2", DbType.String, users.nombre2); dbSQL.AddInParameter(dbCmd, "@tipoMoneda", DbType.String, users.tipoMoneda); dbSQL.AddInParameter(dbCmd, "@codDestino", DbType.String, users.codDestino); dbSQL.AddInParameter(dbCmd, "@numeroDestino", DbType.String, users.numeroDestino); dbSQL.AddInParameter(dbCmd, "@baseImponibleOperGravada", DbType.String, users.baseImponibleOperGravada); dbSQL.AddInParameter(dbCmd, "@isc", DbType.String, users.isc); dbSQL.AddInParameter(dbCmd, "@igv", DbType.String, users.igv); dbSQL.AddInParameter(dbCmd, "@otros", DbType.String, users.otros); dbSQL.AddInParameter(dbCmd, "@indicePercepcion", DbType.String, users.indicePercepcion); dbSQL.AddInParameter(dbCmd, "@tasaPercepcion", DbType.String, users.tasaPercepcion); dbSQL.AddInParameter(dbCmd, "@seriePercepcion", DbType.String, users.seriePercepcion); dbSQL.AddInParameter(dbCmd, "@numDocPercepcion", DbType.String, users.numDocPercepcion); dbSQL.AddInParameter(dbCmd, "@tipoTabla10", DbType.String, users.tipoTabla10); dbSQL.AddInParameter(dbCmd, "@serieDocOriginal", DbType.String, users.serieDocOriginal); dbSQL.AddInParameter(dbCmd, "@numDocOriginal", DbType.String, users.numDocOriginal); dbSQL.AddInParameter(dbCmd, "@fechaDocOriginal", DbType.String, users.fechaDocOriginal); dbSQL.AddInParameter(dbCmd, "@baseImponibleOperGravadaNC", DbType.String, users.baseImponibleOperGravadaNC); dbSQL.AddInParameter(dbCmd, "@IGVNC", DbType.String, users.IGVNC); dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, users.codLocal); //dbSQL.AddInParameter(dbCmd, "@Num_SAP", DbType.String, users.Num_SAP); //dbSQL.AddInParameter(dbCmd, "@Fec_Contabilizacion", DbType.String, users.Fec_Contabilizacion); //dbSQL.AddInParameter(dbCmd, "@Uni_Negocio", DbType.String, users.Uni_Negocio); using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { int index1 = dataReader.GetOrdinal("respuesta"); object[] values = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(values); respuesta = values[index1] == DBNull.Value ? string.Empty : values[index1].ToString(); } } } } scope.Complete(); } return(respuesta.Substring(0, 1)); } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false); return("0"); } finally { } }
/*Update*/ public string UpdVentasBL(BEVentas BE) { return(DA.UpdVentas(BE)); }
/*Delete*/ public string DelVentasBL(BEVentas BE) { return(DA.DelVentas(BE)); }
/*Select*/ public List <BEVentas> GetVentas(BEVentas prmBE) { string respuesta = string.Empty; try { List <BEVentas> lstBE = new List <BEVentas>(); BEVentas BE = new BEVentas(); using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_GET_VENTAS_PERIODO")) { if (string.IsNullOrEmpty(prmBE.codLocal)) { dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, DBNull.Value); } else { dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, prmBE.codLocal); } dbSQL.AddInParameter(dbCmd, "@codPeriodo", DbType.String, prmBE.codPeriodo); dbSQL.AddInParameter(dbCmd, "@tipo", DbType.String, prmBE.tipoPrmSearch); if (string.IsNullOrEmpty(prmBE.textPrmSearch)) { dbSQL.AddInParameter(dbCmd, "@PrmBuscado", DbType.String, DBNull.Value); } else { dbSQL.AddInParameter(dbCmd, "@PrmBuscado", DbType.String, prmBE.textPrmSearch); } if (string.IsNullOrEmpty(prmBE.prmDesde)) { dbSQL.AddInParameter(dbCmd, "@fDesde", DbType.String, DBNull.Value); } else { dbSQL.AddInParameter(dbCmd, "@fDesde", DbType.String, prmBE.prmDesde); } if (string.IsNullOrEmpty(prmBE.prmHasta)) { dbSQL.AddInParameter(dbCmd, "@fHasta", DbType.String, DBNull.Value); } else { dbSQL.AddInParameter(dbCmd, "@fHasta", DbType.String, prmBE.prmHasta); } using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { int tipoVenta = dataReader.GetOrdinal("tipoVenta"); int tipo = dataReader.GetOrdinal("tipo"); int fechaEmision = dataReader.GetOrdinal("fechaEmision"); int serie = dataReader.GetOrdinal("serie"); int numero = dataReader.GetOrdinal("numero"); int tipoPersona = dataReader.GetOrdinal("tipoPersona"); int tipoDocPersona = dataReader.GetOrdinal("tipoDocPersona"); int numDocumento = dataReader.GetOrdinal("numDocumento"); int razonSocialCliente = dataReader.GetOrdinal("razonSocialCliente"); int apePaterno = dataReader.GetOrdinal("apePaterno"); int apeMaterno = dataReader.GetOrdinal("apeMaterno"); int nombre1 = dataReader.GetOrdinal("nombre1"); int nombre2 = dataReader.GetOrdinal("nombre2"); int tipoMoneda = dataReader.GetOrdinal("tipoMoneda"); int codDestino = dataReader.GetOrdinal("codDestino"); int numeroDestino = dataReader.GetOrdinal("numeroDestino"); int baseImponibleOperGravada = dataReader.GetOrdinal("baseImponibleOperGravada"); int isc = dataReader.GetOrdinal("isc"); int igv = dataReader.GetOrdinal("igv"); int otros = dataReader.GetOrdinal("otros"); int indicePercepcion = dataReader.GetOrdinal("indicePercepcion"); int tasaPercepcion = dataReader.GetOrdinal("tasaPercepcion"); int seriePercepcion = dataReader.GetOrdinal("seriePercepcion"); int numDocPercepcion = dataReader.GetOrdinal("numDocPercepcion"); int tipoTabla10 = dataReader.GetOrdinal("tipoTabla10"); int serieDocOriginal = dataReader.GetOrdinal("serieDocOriginal"); int numDocOriginal = dataReader.GetOrdinal("numDocOriginal"); int fechaDocOriginal = dataReader.GetOrdinal("fechaDocOriginal"); int baseImponibleOperGravadaNC = dataReader.GetOrdinal("baseImponibleOperGravadaNC"); int IGVNC = dataReader.GetOrdinal("IGVNC"); int idVentas = dataReader.GetOrdinal("idVentas"); int codLocal = dataReader.GetOrdinal("codLocal"); int Num_SAP = dataReader.GetOrdinal("Num_SAP"); int Fec_Contabilizacion = dataReader.GetOrdinal("Fec_Contabilizacion"); int Uni_Negocio = dataReader.GetOrdinal("Uni_Negocio"); object[] values = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(values); BE = new BEVentas(); BE.tipoVenta = values[tipoVenta] == DBNull.Value ? string.Empty : values[tipoVenta].ToString(); BE.tipo = values[tipo] == DBNull.Value ? string.Empty : values[tipo].ToString(); BE.fechaEmision = values[fechaEmision] == DBNull.Value ? string.Empty : values[fechaEmision].ToString(); BE.serie = values[serie] == DBNull.Value ? string.Empty : values[serie].ToString(); BE.numero = values[numero] == DBNull.Value ? string.Empty : values[numero].ToString(); BE.tipoPersona = values[tipoPersona] == DBNull.Value ? string.Empty : values[tipoPersona].ToString(); BE.tipoDocPersona = values[tipoDocPersona] == DBNull.Value ? string.Empty : values[tipoDocPersona].ToString(); BE.numDocumento = values[numDocumento] == DBNull.Value ? string.Empty : values[numDocumento].ToString(); BE.razonSocialCliente = values[razonSocialCliente] == DBNull.Value ? string.Empty : values[razonSocialCliente].ToString(); BE.apePaterno = values[apePaterno] == DBNull.Value ? string.Empty : values[apePaterno].ToString(); BE.apeMaterno = values[apeMaterno] == DBNull.Value ? string.Empty : values[apeMaterno].ToString(); BE.nombre1 = values[nombre1] == DBNull.Value ? string.Empty : values[nombre1].ToString(); BE.nombre2 = values[nombre2] == DBNull.Value ? string.Empty : values[nombre2].ToString(); BE.tipoMoneda = values[tipoMoneda] == DBNull.Value ? string.Empty : values[tipoMoneda].ToString(); BE.codDestino = values[codDestino] == DBNull.Value ? string.Empty : values[codDestino].ToString(); BE.numeroDestino = values[numeroDestino] == DBNull.Value ? string.Empty : values[numeroDestino].ToString(); BE.baseImponibleOperGravada = values[baseImponibleOperGravada] == DBNull.Value ? string.Empty : values[baseImponibleOperGravada].ToString(); BE.isc = values[isc] == DBNull.Value ? string.Empty : values[isc].ToString(); BE.igv = values[igv] == DBNull.Value ? string.Empty : values[igv].ToString(); BE.otros = values[otros] == DBNull.Value ? string.Empty : values[otros].ToString(); BE.indicePercepcion = values[indicePercepcion] == DBNull.Value ? string.Empty : values[indicePercepcion].ToString(); BE.tasaPercepcion = values[tasaPercepcion] == DBNull.Value ? string.Empty : values[tasaPercepcion].ToString(); BE.seriePercepcion = values[seriePercepcion] == DBNull.Value ? string.Empty : values[seriePercepcion].ToString(); BE.numDocPercepcion = values[numDocPercepcion] == DBNull.Value ? string.Empty : values[numDocPercepcion].ToString(); BE.tipoTabla10 = values[tipoTabla10] == DBNull.Value ? string.Empty : values[tipoTabla10].ToString(); BE.serieDocOriginal = values[serieDocOriginal] == DBNull.Value ? string.Empty : values[serieDocOriginal].ToString(); BE.numDocOriginal = values[numDocOriginal] == DBNull.Value ? string.Empty : values[numDocOriginal].ToString(); BE.fechaDocOriginal = values[fechaDocOriginal] == DBNull.Value ? string.Empty : values[fechaDocOriginal].ToString(); BE.baseImponibleOperGravadaNC = values[baseImponibleOperGravadaNC] == DBNull.Value ? string.Empty : values[baseImponibleOperGravadaNC].ToString(); BE.IGVNC = values[IGVNC] == DBNull.Value ? string.Empty : values[IGVNC].ToString(); BE.idVentas = values[idVentas] == DBNull.Value ? string.Empty : values[idVentas].ToString(); BE.codLocal = values[codLocal] == DBNull.Value ? string.Empty : values[codLocal].ToString(); BE.Num_SAP = values[Num_SAP] == DBNull.Value ? string.Empty : values[Num_SAP].ToString(); BE.Fec_Contabilizacion = values[Fec_Contabilizacion] == DBNull.Value ? string.Empty : values[Fec_Contabilizacion].ToString(); BE.Uni_Negocio = values[Uni_Negocio] == DBNull.Value ? string.Empty : values[Uni_Negocio].ToString(); lstBE.Add(BE); } } return(lstBE); } } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false); return(null); } finally { } }