public ObservableCollection <Liquidation_Hdr> getViewGuiaforAdd(int idAgencia, String varFilterGuia, int varSECUENCIALTRANSPORTISTA)
{
try
{
///
DataSet dsLiqHdr = Liquidation_Hdr.getViewGuiaforAddDB(idAgencia, varFilterGuia, varSECUENCIALTRANSPORTISTA);
///
if (dsLiqHdr != null)
{
foreach (DataRow dr in dsLiqHdr.Tables[0].Rows)
{
///
_LiquidationHdrOC.Add(new Liquidation_Hdr
{
_pdv_co = dr["IHV_CO"].ToString(),
_IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(),
_PREFIJO = Convert.ToInt32(dr["PREFIJO"]),
_RangoGuia = dr["rangoGuia"].ToString(),
_SECUENCIALTRANSPORTISTA = Convert.ToInt32(dr["SECUENCIALTRANSPORTISTA"]),
_nombre = dr["NOMBRE_TRANSPORTISTA"].ToString()
});
}
}
///
return(_LiquidationHdrOC);
}
catch
{
return(_LiquidationHdrOC);
}
}
public ObservableCollection <Liquidation_Hdr> getViewGuiaEdit(int idAgencia, DateTime fecInvoice)
{
try
{
///
DataSet dsLiqHdr = Liquidation_Hdr.getViewGuiaEditDB(idAgencia, fecInvoice);
///
if (dsLiqHdr != null)
{
foreach (DataRow dr in dsLiqHdr.Tables[0].Rows)
{
///
_LiquidationHdrOC.Add(new Liquidation_Hdr
{
_pdv_co = dr["LHV_CO"].ToString(),
_Ag_transporte = dr["TRV_NAME"].ToString(),
_SECUENCIALTRANSPORTISTA = Convert.ToInt32(dr["SECUENCIALTRANSPORTISTA"]),
_nombre = dr["NOMBRE_TRANSPORTISTA"].ToString(),
_cantidad = Convert.ToInt32(dr["CANT_GUIAS"]),
_varCheck = 1
});
}
}
///
return(_LiquidationHdrOC);
}
catch
{
return(_LiquidationHdrOC);
}
}
public ObservableCollection <Liquidation_Hdr> getGuiaSecuencial(int idAgencia, DateTime fecInvoice)
{
try
{
///
DataSet dsLiqHdr = Liquidation_Hdr.getGuiaSecuencialDB(idAgencia, fecInvoice);
///
if (dsLiqHdr != null)
{
foreach (DataRow dr in dsLiqHdr.Tables[0].Rows)
{
///
_LiquidationHdrOC.Add(new Liquidation_Hdr
{
_pdv_co = dr["IHV_CO"].ToString(),
_BDN_ID = Convert.ToInt32(dr["BDN_ID"]),
_nombre = dr["nombre"].ToString(),
_IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(),
_PREFIJO = Convert.ToInt32(dr["PREFIJO"]),
_cantidad = Convert.ToInt32(dr["cantidad"]),
_RangoGuia = dr["rangoGuia"].ToString(),
_varCheck = 1
});
}
}
///
return(_LiquidationHdrOC);
}
catch
{
return(_LiquidationHdrOC);
}
}
public ObservableCollection <Liquidation_Hdr> getTransportistaGuia(DateTime fechIni, DateTime fechFin)
{
try
{
///
DataSet dsLiqHdr = Liquidation_Hdr.getTransportistaGuiaDB(fechIni, fechFin);
///
if (dsLiqHdr != null)
{
foreach (DataRow dr in dsLiqHdr.Tables[0].Rows)
{
///
_LiquidationHdrOC.Add(new Liquidation_Hdr
{
_idAgencia = Convert.ToInt32(dr["IDAGENCIA"]),
_AGENCIA_TRANSP = dr["AGENCIA_TRANSP"].ToString(),
_CANT_GUIAS = Convert.ToInt32(dr["CANT_GUIAS"]),
_fecInvoice = Convert.ToDateTime(dr["fecInvoice"])
});
}
}
///
return(_LiquidationHdrOC);
}
catch
{
return(_LiquidationHdrOC);
}
}
public ObservableCollection <Liquidation_Hdr> getChooiseEditGuia(int varSECUENCIALTRANSPORTISTA)
{
try
{
///
DataSet dsLiqHdr = Liquidation_Hdr.getChooiseEditGuiaDB(varSECUENCIALTRANSPORTISTA);
///
if (dsLiqHdr != null)
{
foreach (DataRow dr in dsLiqHdr.Tables[0].Rows)
{
///
_LiquidationHdrOC.Add(new Liquidation_Hdr
{
_pdv_co = dr["IHV_CO"].ToString(),
_BDN_ID = Convert.ToInt32(dr["BDN_ID"]),
_nombre = dr["nombre"].ToString(),
// _LHV_LIQUIDATION_NO = dr["LHV_LIQUIDATION_NO"].ToString(),
_IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(),
_PREFIJO = Convert.ToInt32(dr["PREFIJO"]),
// _NUMGUIA = Convert.ToInt32(dr["NUMGUIA"]),
_cantidad = Convert.ToInt32(dr["cantidad"]),
// _NUMCOMPLETO = dr["NUMCOMPLETO"].ToString(),
_RangoGuia = dr["rangoGuia"].ToString(),
_varCheck = 1
});
}
}
///
return(_LiquidationHdrOC);
}
catch
{
return(_LiquidationHdrOC);
}
}
/// <summary>
/// Actualizar el numero de guia de una liquidacion
/// </summary>
/// <param name="lhv_co"></param>
/// <param name="lhv_liquidation_no"></param>
/// <param name="tgn_guide_id"></param>
/// <returns></returns>
public String updateGuideLiquidation(String lhv_liquidation_no,
String tgn_guide_id)
{
return(Liquidation_Hdr.updateGuideLiquidation(lhv_liquidation_no, tgn_guide_id));
}