/// <summary>
/// Consulta de los articulos por una referencia talla y color
/// </summary>
/// <param name="Referencia"></param>
/// <param name="CodigoTalla"></param>
/// <param name="CodigoColor"></param>
/// <returns></returns>
public List <KardexInfo> ListxArticuloxRefxTalxCol(string Referencia, string CodigoTalla, string CodigoColor, string Catalogo)
{
db.SetParameterValue(commandKardex, "i_operation", 'S');
db.SetParameterValue(commandKardex, "i_option", 'E');
db.SetParameterValue(commandKardex, "i_referencia", Referencia);
db.SetParameterValue(commandKardex, "i_codigotalla", CodigoTalla);
db.SetParameterValue(commandKardex, "i_codigocolor", CodigoColor);
db.SetParameterValue(commandKardex, "i_catalogo", Catalogo);
List <KardexInfo> col = new List <KardexInfo>();
IDataReader dr = null;
KardexInfo m = null;
try
{
dr = db.ExecuteReader(commandKardex);
while (dr.Read())
{
m = Factory.GetKardexSearch(dr);
col.Add(m);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("NIVI Error: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
bool rethrow = ExceptionPolicy.HandleException(ex, "DataAccess Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(col);
}
/// <summary>
/// Lista todos los kardex (referencias) del catalogo actual para el Outlet
/// </summary>
/// <returns></returns>
public List <KardexInfo> ListxCatalogoActualOutlet()
{
db.SetParameterValue(commandKardex, "i_operation", 'S');
db.SetParameterValue(commandKardex, "i_option", 'H');
List <KardexInfo> col = new List <KardexInfo>();
IDataReader dr = null;
KardexInfo m = null;
try
{
dr = db.ExecuteReader(commandKardex);
while (dr.Read())
{
m = Factory.GetKardexCatalogo(dr);
col.Add(m);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("NIVI Error: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
bool rethrow = ExceptionPolicy.HandleException(ex, "DataAccess Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(col);
}
/// <summary>
/// Buscador de Articulos de Premios.
/// </summary>
/// <param Name="filter">parametros de filtro para la busqueda de premios.</param>
/// <returns>Lista de Articulos.</returns>
public List <KardexInfo> ListSearchPremios(string lstItem)
{
List <KardexInfo> res = new List <KardexInfo>();
KardexInfo item = null;
IDataReader dr = null;
db.SetParameterValue(commandKardex, "i_operation", 'S');
db.SetParameterValue(commandKardex, "i_option", 'G');
db.SetParameterValue(commandKardex, "i_str_query", lstItem);
try
{
dr = db.ExecuteReader(commandKardex);
while (dr.Read())
{
item = Factory.GetKardexPremiosSearch(dr);
res.Add(item);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("NIVI Error: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
bool rethrow = ExceptionPolicy.HandleException(ex, "DataAccess Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(res);
}
/// <summary>
/// Consulta de los articulos por una PLU
/// </summary>
/// <param name="PLU"></param>
/// <returns></returns>
public KardexInfo ListxArticuloxPLUExtensiones(int PLU)
{
db.SetParameterValue(commandKardex, "i_operation", 'S');
db.SetParameterValue(commandKardex, "i_option", 'P');
db.SetParameterValue(commandKardex, "i_plu", PLU);
IDataReader dr = null;
KardexInfo m = null;
try
{
dr = db.ExecuteReader(commandKardex);
while (dr.Read())
{
m = Factory.GetKardexSearchExtensiones(dr);
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("NIVI Error: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
bool rethrow = ExceptionPolicy.HandleException(ex, "DataAccess Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(m);
}
