/*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
{
}
}
